Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: Date / Time sync from Airtable to Google Cal

754 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Les_Platz
4 - Data Explorer
4 - Data Explorer

Having issues with time entry from Airtable base, changing when syncing to my Google Calendar. I’ve tried several different approaches for the sync (Sharing Airtable Calendar View, Zapier and Automation: sending an event). Each approach properly syncs the day, but the time from my Airtable base table is always 5 hours off from the synced event in my Google Calendar. Example: 7PM in my Airtable base table, synced to 2PM on my Google Calendar. This 5 hour difference leads me to believe it’s a time zone setting. I’m American/Chicago time zone.

Airtable Date Column Settings: Date Format: Friendly; Time Format: 12 hour; I’ve turned on “Use the same time zone (GMT) for all collaborators”

Any suggestions what setting I’ve overlooked?

User Level: Free Account

1 Reply 1
Dustin_Thacker
4 - Data Explorer
4 - Data Explorer

I’d been struggling with this one too. But I solved it.
Here is what I did.
I opened Google Calendar Settings and went to Time Zone. Chose GMT as the Primary. Clicked “Display secondary time zone”, then set the Secondary time zone to my time zone.

GC AT
But, once I swapped the label of GMT and EST It seems to read correctly on the Calendar.

GC2
GC2

Now it looks correct and the times on the events show up properly too.