hi there, first time posting here, just fyi.
What am i doing:
I am trying to set up a full 2-way sync between my Google Calendars (all of them) and a single Notion database.
How do i do it:
In order for this to work, i need unique identifiers on both ends, so when one side has a new or updated item, the other side can properly be checked for pre-existing items before one is created.
I use the ID Fields from both Notion and Google Calendar for this.
- When an entry is created in Google Calendar, it will write its event ID into a property in Notion.
- When an Entry is created in Notion, it will write its Page ID into the description field in the Google Calendar event.
Important side info, so nobody gets alarmed:
i am already preventing an endless loop, by filtering out all “Database Item updated” triggers from Notion, that have been last edited by the Zapier Bot, and not by me.
Now my problem:
Whenever i try to use the Find Event Step for Google Calendar in Zapier, i get :
“Failed to find an event in Google Calendar
Error from halted execution: Nothing could be found for the search.”
i am using the last digits from the Notion page ID, which was previously written into the event description.
Fixes i tried:
at first, i tried writing the unique URL from Notion into the description. Thtat didnt work.
It would have been convenient, since i could go to the Notion event in one klick with that, but since the search function seems to be very picky, i figured, lets not do that.
Then i read, that underscores can be a problem, so i removed those from the description field too
Next i used the Notion Page ID, but this string contains multiple “-”, which apparently are interpreted as “without” in the search field. so i used a formatter step to split the Notion page ID at every “-” and wrote only the last digits into the description. At this point, i have a string of letters and numbers in my Google Calendar event description, that should be easy to look up, but i still get the error that nothing was found.
Oh, and i have nothing else defined in the “Find Event” step, so no start or end time or anything else. Just the search field, with the output from my formatter step:
Best answer by Troy Tessalone
View original
