# Getting Next Calendar Event from Google Calendar

**URL:** <https://community.glideapps.com/t/getting-next-calendar-event-from-google-calendar/60736>\
**Category:** Ask for Help\
**Created:** [April 19, 2023, 5:55pm UTC](https://community.glideapps.com/t/getting-next-calendar-event-from-google-calendar/60736 "2023-04-19T17:55:27Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jonathan](https://avatars.discourse-cdn.com/v4/letter/j/aeb1de/32.png) [@Jonathan](https://community.glideapps.com/u/Jonathan)\
**Post date:** [April 19, 2023, 5:55pm UTC](https://community.glideapps.com/t/getting-next-calendar-event-from-google-calendar/60736/1 "2023-04-19T17:55:27Z")

</div>

Hi,

This is my first question on the Glide forum. I have a simple requirement on one of my Glide Pages where i want to pull in the next Calendar event from my Google Calendar (Event, Date/Time, Duration) as long as it is within the current day and in the future.

I have tried Zapier which almost seems to work and I probably just need to spend some more time on refining.

The App is using a Google Sheet to pull in the Event into the page, so I just need to get the next valid event into row 2, column A for example. (Row 1 contains headers).

Am I on the right track with Zapier here, or are there simpler (and cheaper) ways of achieving this?

I look forward to taking part in the Forum. Glide is great!

Jonathan

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [April 19, 2023, 7:14pm UTC](https://community.glideapps.com/t/getting-next-calendar-event-from-google-calendar/60736/2 "2023-04-19T19:14:53Z")

</div>

Use Google Scripts… almost unlimited, faster, and free

---

<div class="post-metadata">

**Author:** ![Jonathan](https://avatars.discourse-cdn.com/v4/letter/j/aeb1de/32.png) [@Jonathan](https://community.glideapps.com/u/Jonathan)\
**Post date:** [April 20, 2023, 7:13am UTC](https://community.glideapps.com/t/getting-next-calendar-event-from-google-calendar/60736/3 "2023-04-20T07:13:14Z")

</div>

Hi Uzo,

Ok that’s great advice. So basically I need to create an AppScript function in Google Sheets to pull in the date from my calendar right? Then the Glide App can just pick up the data from the sheet.

Is there a way to get the AppScript function to run automatically every 15 mins? I guess I will start researching it now.

Thanks for your input.

Jonathan

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [April 20, 2023, 12:12pm UTC](https://community.glideapps.com/t/getting-next-calendar-event-from-google-calendar/60736/4 "2023-04-20T12:12:20Z")

</div>

Yes, you can set script trigger to 15 min or any time, or if someone open your app…

> **[Google Calendar](https://google-calendar-demo.glideapp.io/)**
>
> Sync Google Calendar with Glide, and turn into inline list. Unlimited rows and updates. Fast sync... under 2 sec.

---

<div class="post-metadata">

**Author:** ![Jonathan](https://avatars.discourse-cdn.com/v4/letter/j/aeb1de/32.png) [@Jonathan](https://community.glideapps.com/u/Jonathan)\
**Post date:** [April 24, 2023, 9:28am UTC](https://community.glideapps.com/t/getting-next-calendar-event-from-google-calendar/60736/5 "2023-04-24T09:28:23Z")

</div>

Hi Uzo,

That’s great. I managed to set this up within the AppScript dashboard to run every 15 mins and now it is working great. Very useful! Thanks for your advice.

Jonathan