Question

Eventbrite to Google Calendar Zap - Importing Incorrect Time

  • 25 July 2023
  • 2 replies
  • 318 views

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

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.

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