Skip to main content

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!

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

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.

Reply


Terms & Conditions