I am trying to take the information I have from google sheets and move it into my notion CRM.
I am struggling with creating filters for my scenario. I want the flow to run like this:
if GSID exists - update page and date
if GSID does not exist create a new page
I know I’m missing something simple but any and all help is appreciated
Hi Mike,
You may use a “Search objects” Notion module before the Router, searching based on the GSID. Then filter for “Page id” exists or “Page id” doesn’t exist on the two routes after the Router.
wow this seems so much easier than I was making it! will try it out and let you know. thank you!!
So sorry for never following back up
I am struggling with this search object and then the filter. I keep getting errors when I go to add a filter or sort to the search object module
What errors do you get? How is the module configured?
In the last screenshot, you need to set up a filter condition. You can select the condition in the dropdown menu right below “GSID (Rich Text)”. Otherwise, you get an error message (because the filter is incomplete)
Ah strange - in this case, do you get an error message? Or just no results?
If you just get no results, that’s okay because it means that the page hasn’t been created in Notion yet. So, the scenario should continue through the second route. On the second route, you may change the filter to “Page ID” (mapped from the “Search objects” module) doesn’t exist
