Best answer

Google Calendar is being set to the wrong time even when my Google Sheet is set to the correct timezone.

  • 16 August 2022
  • 2 replies
  • 247 views

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

 

icon

Best answer by Troy Tessalone 17 August 2022, 02:50

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Userlevel 7
Badge +14

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

Userlevel 7
Badge +9

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!