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?
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.
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?
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
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?
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 E-mail address. We'll send you an e-mail with instructions to reset your password.