Best answer

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

  • 30 January 2024
  • 4 replies
  • 40 views

Userlevel 1
Badge

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! 

icon

Best answer by Troy Tessalone 30 January 2024, 22:00

View original

4 replies

Userlevel 7
Badge +14

@ekemp2 

The 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

 

Userlevel 1
Badge

Hi @Troy Tessalone; thank you for your response. Column H is set to map the date inputted in each row. That actually works when a date is in there. When it’s left blank, the zap auto assumes the reporting date as the date the zap ran.

 

Also, I removed the EST and am still experiencing the issue.

Userlevel 7
Badge +14

@ekemp2 

Add a Filter as Step 2: https://zapier.com/apps/filter/help

Reference this help article:

https://help.zapier.com/hc/en-us/articles/21613239711117-Google-Sheets-triggers-unexpectedly-or-too-soon

Userlevel 1
Badge

Thank you @Troy Tessalone!

Reply