Hi everyone,
I’m building a scenario that connects HubSpot → Notion to sync deal stages into each client’s Notion page. The flow works up until one point:
-
HubSpot Watch Updated Deals (filters for deals in the “Implementations” pipeline).
-
Search Client Database (Notion) using HubSpot ID to find the correct client page.
-
On that page, there is a child database called Phases (with the 5 implementation phases).
-
I need to update the correct phase row to “In Progress” and mark previous ones “Done.”
Here’s the problem:
-
My Notion → Search Objects (Databases) module (Module 48) is supposed to find the Phases database inside the correct client page.
-
When I hardcode a database ID, everything works — but that only updates my test page, not dynamic client pages.
-
When I switch to mapping dynamically (so it should find the Phases DB inside the client page found in the earlier module), the Search returns no values.
-
Because of that, later modules can’t map the Database ID dynamically, and the scenario either errors out or defaults to the old hardcoded DB.
What I’ve checked:
-
The Phases databases are created automatically when new client pages are made.
-
The integration has access to the parent client database and all pages.
-
I also tried switching the Search to
PagesandDatabase items, but those don’t expose the Database ID I need. -
The issue seems to be that “Search Objects” doesn’t return any results even though the database exists.
My question:
What’s the correct way to dynamically grab the Database ID of a child database (like Phases) inside each client page? PLEASE HELP ASAP I NEED IT FOR MY INTERN PROJECT