Claude has me going round in circles for this tiny automation :')

:bullseye: What is your goal?

I’m building a Gmail → Notion → HTTP PATCH automation in Make. When a new email arrives in Gmail, I want to search my Notion CRM for a matching contact by email address, then use the HTTP module to PATCH that contact’s Status to “Replied” and update the Last Contacted date via the Notion API.

:thinking: What is the problem & what have you tried?

Gmail Watch Emails → Notion Search Objects → HTTP PATCH
Notion Search Objects returns green with ✓1 but Page ID comes through empty in HTTP URL
Using Notion Internal connection
Filter: Email (Email) Text: Equals, mapped to 1. From (email)

:clipboard: Error messages or input/output bundles

Gmail (Watch Emails) and Notion (Search Objects) both show green checkmarks with ✓1, meaning they’re executing successfully. However the HTTP PATCH module fails with “invalid_request_url” because the URL is https://api.notion.com/v1/pages/ with nothing after the slash - the Page ID from the Notion Search Objects module is coming through empty.
The filter in Search Objects is set to: Email (Email) / Text: Equals / mapped to 1. From (email) from the Gmail module. The emails match exactly (confirmed lowercase, same address in CRM and test email). Using a Notion Internal connection. The Search Objects module switched from Database Items (Legacy) to Data Source Items as recommended by Make. Despite the module showing ✓1, it appears to be returning no results, leaving the Page ID empty.
Any idea why the Page ID would be empty even when the module shows a successful execution?

Returning green with one means that the module ran successfully once, not that it found one. Click on the bubble to see the output, most likely it’s empty and it didn’t find anything.

That green tick only means a bundle was returned and the module ran. It could be an empty bundle.
It also seems like you’re using text filter type when Notion API property it uses email filter type. Gmail and notion don’t always match even if lowercase is used.

Also please recheck if you’ve even given make.com access to your notion because that too can cause the problem. If you can share neat Screenshots of the logs here you’ll obviously get help.

but the error says something about invalid request URL, so I’m guessing there’s a problem with the URL I’m using in the HTTP module?

Why are you calling notion API with a generic http module with no authentication setup? Just use the notion module instead. Also check if the previous module is returning a page id at all.