Create Calendar Invites for multiple records via A...

[Aidan_Feldman]

I am trying to send Google Calendar invites based on Airtable records. Will try and distill to a simplified version:

I have a table for Time Slots, and want the following:

• When “booked”, send a calendar invite
• When modified, update the calendar invite
• When un-booked or a booked Time Slot is deleted, delete the calendar invite

I’ve looked at a number of ways of doing this:

• iCal link - doesn’t support inviting folks, or setting a Location
• Automation - complicated to handle all of those cases, and no ability to delete events in Google Calendar
• Zapier - complicated to handle all of those cases, and there’s no trigger for deleted records (Time Slots)

I’ve seen some related questions on here, but nothing that quite covers the end-to-end like this. Curious if anyone has ideas, besides coding something custom. Thanks!

[Joe_Hewes]

It’s a tricky one for sure. We ended up using Calendly with only very minor integration with Airtable for a similar use case.

[ScottWorld]

My clients use Zapier or Make.com to handle this.

Deleting records is easily solved by using a single-select field or a checkbox field in Airtable that triggers the deletion. You can also lock the normal deletion process to prevent people from bypassing the single-select field or checkbox field.