Skip to main content

I'm trying to create a zap that takes lines out of a google sheet, and creates a calendar entry into google calendar.

It's working - to a point - except for one thing. It's putting the calendar entry into the wrong time/date.

 

My google sheet is set to the correct timezone, my calendar also, and my zap - yet it's still pushing to the wrong time

Saturday, 24 September 2022, 12:00:00  - is my google sheet entry

 

Zap response: 

start

dateTime

2022-09-25T06:00:00+13:00

timeZone

Pacific/Auckland

dateTime_pretty

Sep 25, 2022 06:00AM

date_pretty

Sep 25, 2022

time_pretty

06:00AM

 

Hi @NPYC 

Good question.

Have you reviewed the available help articles for using GCal in Zaps?

I believe the time zone issue is covered in one of the articles.

https://zapier.com/apps/google-calendar/help


Hey there, @NPYC! I wanted to mention some of the troubleshooting steps Troys mentioned can be found here:

It might be worth taking a gander through some of those but definitely keep us posted on your results!