Questions on updating events in Google Calendar

Question

Hi, new to zapier and had a few question about a flow where I update an event in google calendar after a new/updated row in Google sheets. Note, I have the eventIDs in my spreadsheet so I’m not planning to use the ‘Search’ action.

What happens if my EventID column is blank? Does it create a new event as mapped or does it produce an error and skips that row?
I have my ‘New or Updated Spreadsheet Row in Google Sheets’ trigger set to only trigger when there’s a change in a specific column. Is this only for updates to existing rows? My understanding from the guides is that any new row, regardless if there’s a value in my specified column will trigger it.

icon

Best answer by Troy Tessalone 6 September 2022, 02:21

View original

Troy Tessalone · Accepted Answer

Hi @shkGood question.What happens if my EventID column is blank? Does it create a new event as mapped or does it produce an error and skips that row?In Zap action steps, required fields or conditionally required fields will expect a value be populated, else the Zap step will fail.I have my ‘New or Updated Spreadsheet Row in Google Sheets’ trigger set to only trigger when there’s a change in a specific column. Is this only for updates to existing rows? My understanding from the guides is that any new row, regardless if there’s a value in my specified column will trigger it.Correct.New rows will trigger the Zap.Updated rows will trigger the Zap for all rows or for updates to the specified column.https://zapier.com/help/doc/common-problems-with-google-sheets-on-zapier#new-or-updated-spreadsheet-row-trigger-behavior

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded