Get our *FREE AIRTABLE CRASH COURSE* here 👉👉 garethpronovost.com/airtable-crash-course ⚡⚡ Follow along in Airtable here 😍😍 airtable.com/invite/r/v0eI3ASY 🤓🤓
Do you have a video specifically about the automation where when an event is changed in Google, it changes the Airtable record? Got the first steps all working, but that one is a little confusing, and it's definitely important! Update record in Airtable from previous steps--> Record ID is what? I'd love to know about the deletion one too. Thanks!
Inside the automation, before the action Update record, you need to run a Find record with the same Event ID as the Google Calendar Event ID. Then you run Update record and the Record ID will be the one obtained from the previous Find Record action. I tried and it worked for me
Thank you so much! Was wracking my brain on how to turn this into something our team could use. Also, I will say that if you deal with a lot of recurring events (for example, shifts) you're better off using the native one-directional sync and adding some limited bi-directionality with automations. Google Calendar is just better at handling those and quickly updating instances. In fact, there's actually no way to get recurring GCal events into Airtable without this method, which is extremely annoying. On the plus side, less automations to set-up!
Hey, great video! How did you create the interface/screen at 7:35? Airtable doesn't let you create a new event within an interface powered by synced data. Thank you!
Very useful, I have a different task that I am struggling with related to the form. Building a form that will suggest available timeslot base on outlook calendar's availability and user can pick the available time slot and from there we are going to create an event base on pick time.
Love your tutorials! It's sad to see we skipped the All Day event option in the setup. It appears that Airtable supports creating All Day meetings in Google Calendar, but I'm having a heck of a time going the other way. New All Day events created in Google Calendar do not seem to have a way of telling Airtable that they are All Day - rather, Google sends dates, and somehow GMT time stamping gets added, which causes issues visualizing All Day events in Calendar view (interface specifically). Any workarounds?
Ah, that's rough. I haven't played with this just yet, but I suspect you might want to explore Zapier or Make automation to bring this data appropriately into Airtable. Sorry that the native integration doesn't hold up here!
Thank you Gareth! I have an issue with autonation. When I put the trigger When event created in Google Calendar and make action Create a New Record in Airtable the automation runs many times until I stop it manually. It creates the same event many times. What do I make wrong? Thanks.
Same issue. In my case am working on it and seems to be: one of my automation says When create new event in airtable then create same event in Google agenda. The other automation says When create new event in Agenda create same in airtable. So the problem is these two interact and recreates in loop. I will find a solution to this. lolll but besides this its amazingly more useful and powerful this approach versus the old one when syncing both sides.
I solved it! Go to the automation which creates a GCal event once an Airtable event is created -- add a condition that if the eventID field is empty, then you create a GCal event - this way, if there is already an eventID created (aka, if it already exists on GCal), then it won't create another one.
It typically updates in Airtable automatically, although it isn't instantaneous. If you need a faster integration, I'd suggest an automation built with Zapier or Make (we've done some videos on both of these)
Get our *FREE AIRTABLE CRASH COURSE* here 👉👉 garethpronovost.com/airtable-crash-course ⚡⚡
Follow along in Airtable here 😍😍 airtable.com/invite/r/v0eI3ASY 🤓🤓
Another great video. This is going to be really helpful and save me hours of time scheduling appointments for work. Thank you
Glad it was helpful! Thanks for watching
You are great! Trully love your courses. They are changing my life! Hugs from Argentina
Thank you!!!
Very clever, ty for sharing mate
Glad to help!
Do you have a video specifically about the automation where when an event is changed in Google, it changes the Airtable record? Got the first steps all working, but that one is a little confusing, and it's definitely important! Update record in Airtable from previous steps--> Record ID is what? I'd love to know about the deletion one too. Thanks!
Also, Deleting record in airtable should delete it in Gcal, but that doesn't work, and there is no trigger in automations for Deletion of record...
Inside the automation, before the action Update record, you need to run a Find record with the same Event ID as the Google Calendar Event ID. Then you run Update record and the Record ID will be the one obtained from the previous Find Record action. I tried and it worked for me
Thank you so much! Was wracking my brain on how to turn this into something our team could use.
Also, I will say that if you deal with a lot of recurring events (for example, shifts) you're better off using the native one-directional sync and adding some limited bi-directionality with automations. Google Calendar is just better at handling those and quickly updating instances. In fact, there's actually no way to get recurring GCal events into Airtable without this method, which is extremely annoying. On the plus side, less automations to set-up!
Awesome feedback, thank you! 🙏
Hey, great video! How did you create the interface/screen at 7:35? Airtable doesn't let you create a new event within an interface powered by synced data. Thank you!
The interface was built to demonstrate the automation with Google Calendar and didn't use the synced table
Very useful, I have a different task that I am struggling with related to the form.
Building a form that will suggest available timeslot base on outlook calendar's availability and user can pick the available time slot and from there we are going to create an event base on pick time.
We'll have a video on this completed soon!
9:45 ish, if you're on the free version, you can't do this, correct?
Love your tutorials! It's sad to see we skipped the All Day event option in the setup. It appears that Airtable supports creating All Day meetings in Google Calendar, but I'm having a heck of a time going the other way. New All Day events created in Google Calendar do not seem to have a way of telling Airtable that they are All Day - rather, Google sends dates, and somehow GMT time stamping gets added, which causes issues visualizing All Day events in Calendar view (interface specifically). Any workarounds?
Ah, that's rough. I haven't played with this just yet, but I suspect you might want to explore Zapier or Make automation to bring this data appropriately into Airtable.
Sorry that the native integration doesn't hold up here!
Does this work when my table has more rows than other things? or only the table has to have those fields and nothing more than those
Thank you Gareth! I have an issue with autonation. When I put the trigger When event created in Google Calendar and make action Create a New Record in Airtable the automation runs many times until I stop it manually. It creates the same event many times. What do I make wrong? Thanks.
I wish I could help, but that's hard to troubleshoot without seeing the problem - good luck!
Same issue. In my case am working on it and seems to be: one of my automation says When create new event in airtable then create same event in Google agenda. The other automation says When create new event in Agenda create same in airtable. So the problem is these two interact and recreates in loop. I will find a solution to this. lolll but besides this its amazingly more useful and powerful this approach versus the old one when syncing both sides.
I'm having the same problem! How to avoid this infinite new loop?
I solved it! Go to the automation which creates a GCal event once an Airtable event is created -- add a condition that if the eventID field is empty, then you create a GCal event - this way, if there is already an eventID created (aka, if it already exists on GCal), then it won't create another one.
How do you set up Calendar updates >> Change Airtable record?
Airtable doesnt seem to recognize the eventID, I dont know why
It typically updates in Airtable automatically, although it isn't instantaneous. If you need a faster integration, I'd suggest an automation built with Zapier or Make (we've done some videos on both of these)
I imported my Airtable URL into Google and it adds the information correctly, but it doesn't update in Google if I update it in Airtable. Help?
Commenting to follow the thread
It might take upto 24 hours for changes to show on Google Calendar.
Is this 2 way?
Not the first option I demo, but the automations can be built to be 2 way