Troubleshooting Zap not triggering from Google Sheets to Google Calendar

I am using Google Sheets to collect a list of marketing activities to then create or update an all-day calendar entry in a shared Google Calendar.

My trigger is New or Updated Spreadsheet Row. I did not specify a single column as I want the trigger to fire regardless of which column is updated.

I have a filter set to stop the creation of tentative events that don’t currently have dates from creating a calendar entry.

Next I used the Find Event action with the search term set to an Event Id which is a unique identifier. I also have indicated that if no event is found to create a new calendar entry.

Last, I have the Update Event action to update existing calendar entries.

I don’t think my unique identifier (Event_ID) is getting recognized by the Zap nor Google Calendar.

Page 1 / 1

Hi @NP2461

For us to have more info, post these screenshots:

the top 3 rows of your GSheet worksheet
how your Zap steps are outlined and configured in EDIT mode with the field mappings visible

@NP2461

Try this instead, when a GCal Event is first created it will return an ID.

Add a Zap step to update the GSheet row with a new column value to save the GCal Event ID.

Then if a GSheet row has a GCal Event ID, you never need to use a Zap step to find the Event, since you already know the ID of the GCal Event to update.

@Troy Tessalone - would you recommend that I setup a pathway after the initial trigger?

If the GCal Event Id field is blank then
- Create new GCal event then
- Add the GCal Event Id in the GSheet row
If the GCal Event ID is filled then
- Match the GCal Event ID and update the event??

@NP2461

If GSheet row GCal Event ID exists = false
- Action: GCal - Create Event
- Action: GSheet - Update Row
If GSheet row GCal Event ID exists = true
- Action: GCal - Update Event

@Troy Tessalone I set it up following your suggestion and for some reason the action ‘GSheet - Update Row’ only updates row 2.