How do Google Sheets to Google Calendar Zap create events on the actual date instead of the day the Zap runs?

Question

I am experiencing this issue on a Google Sheet to Google Calendar Zap:

“Is your detailed event appearing in the calendar for the same time the Zap ran?
This may happen if the start and end time/date are invalid. Events created with an invalid start or end date will be created for the time your Zap runs.”

I understand the explanation, but I’d like to know if there is a workaround to this. For instance, my zaps run according to the input of dates into the spreadsheet. However, sometimes, my team may not know the date as they enter the event on the spreadsheet. They may know the date a day or so later and then enter it. The Google Calendar sends an event for that date, but because the column was left blank previously, it records that event for the day the zap ran. Is there a way to not have it create an event for the day the zap ran and only once an actual date is inputted?

Thanks!

Troy Tessalone · Accepted Answer

@ekemp2Add a Filter as Step 2: https://zapier.com/apps/filter/helpReference this help article:https://help.zapier.com/hc/en-us/articles/21613239711117-Google-Sheets-triggers-unexpectedly-or-too-soon

Troy Tessalone · Answer

@ekemp2The mapped variable COL H has a value of “Reporting Date” which is not a valid date and likely contributing to the issue.I recommend removing the EST as the GCal Calendar time zone settings will determine the time zone used.Help article about using GSheets in Zaps:https://help.zapier.com/hc/en-us/articles/8496276985101-Work-with-Google-Sheets-in-Zaps

Reply

Useful links

Code of conduct

Using the Community

Community expectations

Reply

Useful links

Code of conduct

Using the Community

Community expectations

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded