Updating an event in google Calendar

In your first Automation add an Update Record step that fills in the triggering record’s {Meeting ID} field with the ID of the event created in Google Calendar. If you don’t have a {Meeting ID} field, make one.

Now that you’re storing the event IDs you can update the correct event associated with your Airtable record. You will probably have to manually fill in the meeting IDs that have already been created.

As I am a new user, I am. not sure to understand how to do this, could you be more specific. Thanks so much I appreciate your support.

In the automation you already have:

1. Add a new Update record step after the Create Google Calendar step.
2. Select the same table as the trigger record’s. In the field ID box, click the blue plus symbol to select the trigger record’s record ID
3. Under Fields select Choose field and pick a single line text field that you’ll use to store Google Calendar Event IDs. Click the blue plus symbol to select the event id from the Create Google Calendar step.

Now in addition to creating a new Google Calendar event, your Automation will store the unique ID of the calendar event item as a field value for the relevant Airtable record. This means you can update the calendar event in the future by referencing this ID.

Create a new Automation that has these steps:

1. Set the trigger to be when the {Follow-up meeting} time is updated.
2. Add an Update Google Calendar Event step. For the Event ID click the blue plus symbol to select the trigger record’s {Calendar Event ID} field.

In the automation you already have:

1. Add a new Update record step after the Create Google Calendar step.
2. Select the same table as the trigger record’s. In the field ID box, click the blue plus symbol to select the trigger record’s record ID
3. Under Fields select Choose field and pick a single line text field that you’ll use to store Google Calendar Event IDs. Click the blue plus symbol to select the event id from the Create Google Calendar step.

Now in addition to creating a new Google Calendar event, your Automation will store the unique ID of the calendar event item as a field value for the relevant Airtable record. This means you can update the calendar event in the future by referencing this ID.

Create a new Automation that has these steps:

1. Set the trigger to be when the {Follow-up meeting} time is updated.
2. Add an Update Google Calendar Event step. For the Event ID click the blue plus symbol to select the trigger record’s {Calendar Event ID} field.

Hi
I tried this method but I’m facing a failed test
The test for the trigger is OK
The test for the action failed “Received invalid inputs”
These pictures will show you
Have you an idea to fix this ?

Your test shows that you passed in no event ID. Whichever record is being used to test your trigger didn’t have a value for that field, so you’re not going to test the action steps until your test record is updated (and the trigger is re-tested to pick up the change).

@Kamille_Parks – this was very helpful, thank you!

Can you advise on creating the reverse automation? One that will update the Airtable due date when the GCal event date is moved? I’m not sure where to put the single text field that I created to store the unique identifier from Google Cal, and also not sure if the issue is that the start and end date nature of the all-day event in Google Cal is incompatible with the “due date” field in AT.

This is very helpful. I think I’m closer but still missing something!
A little confused on the “Record ID” picklist of list/grid view. And should I make the next step conditional? THANK YOU!

Assuming Event ID is coming from your trigger, it will never be empty. Your condition should instead be “[Find Records → length] > 0”

In the first action (finding the record)? Or the second action (updating the record)?

The second. You cannot conditionally search for records if the search results in 0 results: how would Airtable know there are no results until it searches?

Ah, of course. Okay, hopefully last question. Is there another formula or something for the “Record ID” after the condition is met? Feels so close… thank you for your help.

You are still saying “use the Google Event ID as the Airtable Record ID”. You should be pulling the List of Airtable Record ID, not the List of ‘Google Calendar ID’.