Meet with Me: A Booking App that Prevents Conflicts

Had to try this out!

The Zap:

Here’s the zap that imports to the Response tab of the Google Sheet:

Proof of concept:

Made a new 30-min Google Calendar Event on 4/6 at 7:00. You can see it generates a new row in the sheet which is recognized by Glide and results in the time slot being unavailable.

If you try this out for yourself, make sure you leave the end date_time tag empty. The sheet fills this in automatically based on the duration. Adding this tag will break the Arrayformula in the sheet.

The Other Zap:

Here’s the Zap that will delete the item from the Glide app sheet if deleted from the calendar. This one is not instant.

Only thing I haven’t figured out is if you edit the event (change date/time). My original Zap created a second row in the sheet with the new information rather than modifying the old one.

2 Likes