Skip to main content

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

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions 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.

  • Home
  • Get Help
  • How Do I
  • Sending an email when events could overlap: less than 15min in-between the 2 (Google Calendar)
Best answer

Sending an email when events could overlap: less than 15min in-between the 2 (Google Calendar)

V

Hello Fellow automaters,

I’m currently trying to build a zap to send an email to my own email address whenever two events on google calendar are overlapping. 

By overlapping, I mean that they should at least be spaced by 15 minutes, so any two events with less than 15 minutes in-between should be used as a trigger, the action would simply be sending an email.

 

I don’t seem to find a way to do this. Any tips?

 

That would be appreciated!

 

Thank you,

 

 

Best answer by GetUWiredBest answer by GetUWired

@vicecaz 

You may be able to have some luck using the Find Event action with Google Calendar and a couple of formatters & filters. 

To get the wheels moving here is an example idea that checks if there is an event in front of the new event.

  • Trigger: New Event in Google Calendar (you could also do New or Updated Event)
  • Step 2: Formatter action to subtract 16 minutes from the Start Time of the event
  • Step 3: Find Event in Google Calendar. 
    • This search needs to be as nondescript as possible. I would search for a period and filter the time to the time from step 2 as the start time and use the end time of my event. See the screenshot below. Any event should match a period because there is one in the timestamp of any event.
    • You could also add a second formatter to add 16 minutes to the end time and use that as the end time to search for events. You are essentially giving Zapier a window to look for events in 
  • Step 4: Filter to make sure the returned event is not the same event as the trigger.
    • Check to make sure the id of the event returned in the search step is not the same as the id of the event that triggered Zapier. 
  • Step 5: Send email

 

  •  

View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

GetUWired
Forum|alt.badge.img+12
  • GetUWiredZapier Expert
  • Zapier Expert
  • 1030 replies
  • July 15, 2021

Hi @vicecaz 

I am assuming you would want to be notified when the events are created? 
This would be a tricky integration to set up in Zapier as there are no triggers that can watch for spacing between two events. Likely, you will need a complicated system that triggers from a New Event added to your calendar and with some database that can be referenced for other events. 

It would be difficult to do with a formula but a script could help. Feel free to shoot us a direct message if you want to hire out for this. Otherwise, I will help as much as I can here

GetUWired
Forum|alt.badge.img+12
  • GetUWiredZapier Expert
  • Zapier Expert
  • 1030 replies
  • Answer
  • July 15, 2021

@vicecaz 

You may be able to have some luck using the Find Event action with Google Calendar and a couple of formatters & filters. 

To get the wheels moving here is an example idea that checks if there is an event in front of the new event.

  • Trigger: New Event in Google Calendar (you could also do New or Updated Event)
  • Step 2: Formatter action to subtract 16 minutes from the Start Time of the event
  • Step 3: Find Event in Google Calendar. 
    • This search needs to be as nondescript as possible. I would search for a period and filter the time to the time from step 2 as the start time and use the end time of my event. See the screenshot below. Any event should match a period because there is one in the timestamp of any event.
    • You could also add a second formatter to add 16 minutes to the end time and use that as the end time to search for events. You are essentially giving Zapier a window to look for events in 
  • Step 4: Filter to make sure the returned event is not the same event as the trigger.
    • Check to make sure the id of the event returned in the search step is not the same as the id of the event that triggered Zapier. 
  • Step 5: Send email

 

  •  

Terms & Conditions