Airtable + Integromat Google calendar event updates

[Roman_Malynovsk]

Hi, community :slightly_smiling_face:
I’m using Airtable and already had set up a scenario, where changes from Google Calendar events are applied to specific rows in Airtable.

Now I would like to set up a similar scenario from the Airtable side.
So when something changes in the row it triggers scenario and Google Calendar event would be updated.

First I built scenario:
Airtable (watch records) -> Google calendar (Update an event).
But it doesn’t work because I cannot provide Google Calendar Event ID :frowning:

So then I created such a scenario:
Airtable (watch records) -> Google calendar (Get events) -> Google calendar (Update an event).
So now it is successfully triggered when I change time in the Airtable, successfully finds the event in Google Calendar, but then it doesn’t process by the last module.

Did somebody else here such scenarios to update an event from Airtable to Google Calendar?

[Marc_Chenut]

Hi Roman,

I am trying to do the exact same automation and I had the same issues as you.

Did you find a solution ?

Many thanks

[Roman_Malynovsk]

Hi Marc,

Well yes.

Here is how current working process looks like:

Here are details that I’m filling Google event with from Airtable:

That was a year ago. I don’t remember all the details of the error.
Probably it was because of the filter from Get event to Update event.
Here is how I’m filtering them:

I’ve created a field in Airtable which generated an auto number for every row in the table, and then I’ve connected it with Location field in calendar. As I’m not using this Location field - it serves for filtering those events from airtable which had changed.

[Adam_Workman]

Hi Roman! I know it was a while ago that you posted this response, but I’m wondering if it might be possible for you to share what you included in the other steps of this process? Specifically in the Iterator and Aggregator fields. I have gotten everything to process with no errors but the events are still not updating in Google Calendar.

[Roman_Malynovsk]

Hi Adam,

Here are screenshots of all steps and the fields I’ve used.