About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Question

Can I use a time range for a google calendar search?

  • 3 March 2022
  • 6 replies
  • 187 views
W

Hello!

I’m writing a Zap which allows google form responses to be automatically added to my google calendar - however I do not want the response to be added if there is already an event occuring within the time provided on the new response.

For example - an event already occurs between 5PM and 10PM on 04/03/2022 and a new response comes in requesting a time between 3PM and 7PM on 04/03/2022. Obviously, thgere is an overlap here and I want this to be found by the search.

How would I do this within the google cal find function? Is there a way a time range can be used in the start / end times? I’ve done this but no luck

 

Any help is very much appriciated! Thanks!

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

6 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @Wizeguy11 

The GCal Find Event actions has fields for Start Time and End Time.

Are you not able to use those fields?

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
W

I want to be able to search for any overlap of an event. So not specifically between two times. Any time within two times

Troy Tessalone
Userlevel 7
Badge +14

@Wizeguy11 

Unlikely the GCal Zap app integration is going to support that type of searching.

You’d have to explore using the GCal API: https://developers.google.com/calendar/api

App APIs can be used in Zaps as actions steps with the Code app or Webhooks app.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
GetUWired
Userlevel 7
Badge +12

Hi @Wizeguy11 

Try to use the start & end times as Troy suggested populating the times using data from your trigger. i.e in the example you provided start time = 04/03/2022 3PM  & end time = 04/03/2022 7PM (you may need to use some formatting steps or code if the time comes across as “3PM and 7PM on 04/03/2022”.

Then for your search just put a single period which will match any event in Google Calendar. If there is another event within that timeframe it should be found which would indicate that there is some type of overlap. 

Hope that helps!
Tim @GetUWired

W

The formate doesn’t come across that way, that was just an example, sorry!

So just checking, if an event finishes in between the start and end time provided in the search will it still show this event? 

GetUWired
Userlevel 7
Badge +12

@Wizeguy11 , yes that is correct. You are just defining a window of time for Google Calendar to check for events in. 

Terms & Conditions