Skip to main content
Best answer

Getting Original event data when updating event on google calendar

  • November 12, 2022
  • 2 replies
  • 188 views

When using the updated/new event trigger for google calendar, is there any way to get the original date and time for the event that changed? it seems that I can only access the new date and time.

Best answer by christina.dBest answer by christina.d

Hey there @Drex! Thanks for reaching out in the community! I did some digging and wanted to confirm what @subhash mentioned in that original date/time isn’t sent to Zapier for an updated event in Google Calendar. 

The created time of the event is sent but I’m not sure if that’s exactly what you needed.

@subhash also mentioned keeping a table of the event ID’s every time an event is created with the original start times and referencing those ID’s when it’s changed.
This would be a lookup table and I wanted to share some resources on that if you decided to go that route. 

https://community.zapier.com/featured-articles-65/don-t-be-afraid-of-the-lookup-table-6373https://community.zapier.com/featured-articles-65/advanced-lookup-table-tips-multiple-outputs-and-reusing-across-zaps-10560https://community.zapier.com/featured-articles-65/creating-a-lookup-table-with-google-sheets-7759

I hope some of this helps! 🙂

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.

subhash
Forum|alt.badge.img+1
  • New
  • November 12, 2022

I don’t think google pushes original date and time for an udpated event. But here is a work around you can try.

Google calendar sends a unique eid with every request, you can find it in html link field, this doesn’t change even if event is updated. Setup a zap to write it some where like SQL along with original event date and time. Retrieve these details back in the Zap when event is updated. 


christina.d
Forum|alt.badge.img+9

Hey there @Drex! Thanks for reaching out in the community! I did some digging and wanted to confirm what @subhash mentioned in that original date/time isn’t sent to Zapier for an updated event in Google Calendar. 

The created time of the event is sent but I’m not sure if that’s exactly what you needed.

@subhash also mentioned keeping a table of the event ID’s every time an event is created with the original start times and referencing those ID’s when it’s changed.
This would be a lookup table and I wanted to share some resources on that if you decided to go that route. 

https://community.zapier.com/featured-articles-65/don-t-be-afraid-of-the-lookup-table-6373https://community.zapier.com/featured-articles-65/advanced-lookup-table-tips-multiple-outputs-and-reusing-across-zaps-10560https://community.zapier.com/featured-articles-65/creating-a-lookup-table-with-google-sheets-7759

I hope some of this helps! 🙂