I can see that there is some notion integration in clay which is able to extract the page related to the title i have specified but nothing about extracting the actual contents. Is this something that is possible?
Yes, it's possible to extract the contents of a Notion page using our Notion integration. We offer an action called "Append content to page" which allows you to add content to existing Notion pages. While this action is primarily for adding content, you can use it in combination with the "Lookup object by title" action to first find the page you want and then retrieve its content. To do this: 1. Use "Lookup object by title" to find your Notion page 2. Use "Append content to page" to add a placeholder text 3. The response will include the existing page content This method allows you to effectively extract the page contents within our integration.
No i dont want to append more contents but just be able to retrieve whatever contents are already on the page
Hey — could you send over the table URL where you’ve tried to extract the content, along with an example of the Notion data you’re working with? In most cases, the lookup should be able to pull the actual content, not just the title. Happy to take a closer look.
https://app.clay.com/workspaces/459134/workbooks/wb_48QRZZCJmGxx/tables/t_QTNp9QX7VRbd/views/gv_BCMeUJuZbVfF I can only seem to get the title from clay
Hey got it now I see what you mean. Thanksk for the extra infos. I'd go about this like this: 1. Use an HTTP API enrichment: • Endpoint: https://api.notion.com/v1/pages/{page_id} (you’ll need to extract the page_id from the URL previously found). • Headers: • Authorization: Bearer <your_integration_token> • Notion-Version: 2022-06-28 • Content-Type: application/json
3. Optional: If you want full text or blocks, use: • https://api.notion.com/v1/blocks/{block_id}/children Clay doesn’t pull full Notion page content natively yet, so using the HTTP enrichment with your Notion API token is the most direct method.