# Meet with Me: A Booking App that Prevents Conflicts

**URL:** https://community.glideapps.com/t/meet-with-me-a-booking-app-that-prevents-conflicts/5916
**Category:** Project Showcase
**Created:** [March 26, 2020, 8:05pm UTC](https://community.glideapps.com/t/meet-with-me-a-booking-app-that-prevents-conflicts/5916 "2020-03-26T20:05:59Z")
**Posts on this page:** 1
**Showing post:** 25

<div class="post-metadata">

### Author: ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [April 4, 2020, 3:39am UTC](https://community.glideapps.com/t/meet-with-me-a-booking-app-that-prevents-conflicts/5916/25 "2020-04-04T03:39:30Z")

</div>

Had to try this out!

## The Zap:

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

> **[Import Google Calendar → Google Sheets (Glide)](https://zapier.com/shared/27c82cd9889d5724b4dc05e28b92e3a072e3a18c)**
>
> Anytime an event is created in Google Calendar, create spreadsheet row in Google Sheets.

## 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.

 ![ScreenFlow](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/d/dcb8e28743ff7465f73630f0afa1b4d99b5916af.gif)

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.

 ![Screenshot_4_3_20__11_44_PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/a/a874756997b3edd6c6cabd69a16d3e9c922043da.png)

## 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.

> **[Glide Meet with Me Google Calendar Sync (Delete)](https://zapier.com/shared/d1a641e6d955b8a7a7cf7d69e17bca21479e8606)**
>
> Anytime an event cancelled is created in Google Calendar, lookup spreadsheet row in Google Sheets and delete spreadsheet row in Google Sheets.

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.

---

_[View the full topic](https://community.glideapps.com/t/meet-with-me-a-booking-app-that-prevents-conflicts/5916)._