Hi, I have a Notion Form that should trigger a submission to Google Sheets once submitted. While I can easily transfer the text elements to Google, I struggle with the Notion Relations, which are part of the form.
In many places, I read about using the Notion-Get a Page module; however, when I insert the PageID (which refers to the part of the URL from the database), I get a 404 error. The database is not listed in the Page selection. Using Notion-Get a Database, the module works just fine. However, I can’t find the page title matching the Form submission. Using Notion-Search Objects, does lead to any results either.
The databases in question are authorized to be accessed by Make.
Quick update: Instead of using Notion-Watch Database Items, I tried using a webhook, which allowed me to get a page.id of the page I wanted to, but again, I struggled to convert it into the page name, which is what I need to automate the flow further.
Hi Dirk,
To get the page name, you may use the “Get database item” module - by passing the page id from the relation property. This is as intended. Alternatively, you could create a rollup property in the Notion database, include it in the webhook payload, and directly use the rollup value in your subsequent modules
That the relation property is populated in the Notion page that triggered the webhook request
That the Notion connection used in the last screenshot has access to the Related Database
If you are running the Notion module manually (“run this module once”), you need to insert a page id manually. Else, it’s expected you get the error message
Thanks, I got it to work with the rollups in my Notion Database. With this, it goes straight from the Webhook to Google Sheets! Thanks for your feedback!
