I would like to create a Zap, where the trigger is ONLY when a Google calendar event changes, not when a new event is created. Is this possible?
How to create a Zap, where in the trigger only works when a Google Calendar event changes?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
Userlevel 7
+14
- Certified Zapier Expert
- 23950 replies
-
30 March 2022
Hi
Good question.
Try using this Zap trigger: GCal New/Updated Event
Then the timestamps for the GCal Event created/updated have to be compared to determine if it’s a created event or an updated event.
This can be done using a Formatter > Date / Time > Compare Dates step.
That can be followed by a Filter step to determine if the Zap should continue.
- Beginner
- 3 replies
-
30 March 2022
Thanks Troy! This is a great start, but I am running into trouble…
When using the compare dates function, what if the event is both created and changed in the same day? Then the dates are the same. Is there some data I am not seeing in the Gcal event that note original date of event and new date of event?
Userlevel 7
+14
- Certified Zapier Expert
- 23950 replies
-
30 March 2022
These are the data points returned for the Formatter > Date / Time > Compare Dates step:
Alternatively, a more advanced approach would be to use a Code step to compare timestamps: https://zapier.com/apps/code/help
- Beginner
- 3 replies
-
31 March 2022
Hi again. I understand the outputs, but if the “same dates” comes back “false” because I switched the appointment the same day it was created, what am I filtering for?
Userlevel 7
+14
- Certified Zapier Expert
- 23950 replies
-
31 March 2022
You can do a combo of conditions in the Filter.
For example:
Days is 0
AND
Hours is less than 1
That would mean the Timestamps (Created/Updated) were the same day and the difference was under 1 hour.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.