About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Question

Eventbrite to Google Calendar Zap - Importing Incorrect Time

  • 25 July 2023
  • 2 replies
  • 263 views
RebeccaM

I have setup a Zap that sends Eventbrite events to our Google Calendar. Each time I run the zap, the calendar event shows up one hour later than scheduled. I have checked both Zapier and Google to make sure we are on EST (America/New York) but nothing seems to fix it. For some reason, the code below has a line that says “dateTime_pretty Aug 12, 2023 05:00PM” but that is not the correct start time on the event. I’m not sure why it’s referencing that info instead of the

dateTime

2023-08-12T17:00:00-04:00

 

Any suggestions?

 

This is the Zap code

 

Search item data…

kind

calendar#event

etag

"3380612134068000"

id

uaomjrpldqlp6dft4n1tnbk99o

status

confirmed

htmlLink

https://www.google.com/calendar/event?eid=dWFvbWpycGxkcWxwNmRmdDRuMXRuYms5OW8gbWlja2xlcmNvQG0

created

2023-07-25T17:27:47.000Z

updated

2023-07-25T17:27:47.034Z

summary

Picking Paint Colors - Interior Design Workshop

creator

email

micklerco@gmail.com

self

true

organizer

email

micklerco@gmail.com

self

true

start

dateTime

2023-08-12T17:00:00-04:00

timeZone

America/New_York

dateTime_pretty

Aug 12, 2023 05:00PM

date_pretty

Aug 12, 2023

time_pretty

05:00PM

end

dateTime

2023-08-12T18:00:00-04:00

timeZone

America/New_York

dateTime_pretty

Aug 12, 2023 06:00PM

date_pretty

Aug 12, 2023

time_pretty

06:00PM

iCalUID

uaomjrpldqlp6dft4n1tnbk99o@google.com

sequence

0

reminders

useDefault

true

eventType

default

duration_hours

1

duration_minutes

60

duration_seconds

3600

attendee_emails

 

2 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @RebeccaM 

Good question.

You can use this Zap action: Formatter > Date & Time > Format

 

Is the event created on the wrong date, specifically with the month and day switched?

Regardless of the settings in your Google Calendar, data sent through their API (as Zapier does) must be in MM/DD/YYYY format. So, if you try to send an event for April 7, 2021 as 07/04/2021, Google Calendar will interpret that as July 4, 2021. The dates need to be in MM/DD/YYYY format to ensure Google Calendar adds the event to the correct date(s). If your trigger is sending the data in DD/MM format, you can use a Formatter step to reformat the date.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
shalgrim
Userlevel 6
Badge +8

Hi @RebeccaM 

First, regarding:

“dateTime_pretty Aug 12, 2023 05:00PM” but that is not the correct start time on the event. I’m not sure why it’s referencing that info instead of the

dateTime

2023-08-12T17:00:00-04:00

 

Maybe I’m misunderstanding, but those are the same times. But refer to 5 PM on August 12, 2023. The 17:00 is 5 PM. The “-04:00” at the end refers to the offset from UTC and this time of year New York/Eastern is four hours behind UTC.

Did this stop working when Daylight Savings Time started? The “one hour off” part smells like something wrong with Daylight Savings.

When you test the Zap, what happens? For example, if your Step 2 shows like so and you test the Zap, what ends up in Google Calendar? The times shown there or something one hour off?

If you can’t get it working, Troy’s suggestion to subtract an hour in the editor is sound, though I’d caution that that might stop working once we go off of Daylight Savings in October

Reply


Terms & Conditions