Skip to main content
Solved

Using Zapier to transfer data to google sheet - Time transferred from calendly is 7 hours ahead

  • 17 May 2024
  • 1 reply
  • 15 views

I use Zapier to transfer the registration date to google sheet. All data transferred is correct except for the time. It is 7 hours ahead each scheduled event. How do I fix this to show the correct time.

Example of date/time transferred from Calendly to Google Sheet:

  • Thursday, May 16, 2024 at 6:00:00 PM
  • Correct time should show 11:00 AM instead of 6:00 PM

Please advise on how to fix this error. Thanks!

Hi @GFI28224!

I was ironically just troubleshooting a similar issue on a Zap I use here at Calendly.

So a few things to check:

  • Is your timezone set correctly in Calendly? You can set this by going to your Profile > Time Zone > Save Changes.
  • Is your timezone set correctly in Zapier? This is what just got me. Everything I was sending over was an hour off and it turned out I hadn’t set my profile to the correct timezone - despite my other apps having the right time zone set. You can set this by going into Zapier > Settings > Time Zone > Save Changes.

Hope this helps!

Terms & ConditionsCookie Settings