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.

Question

Sync Canceled Google Calendar Events to Google Sheet

I

Hi - I hope someone here could help! :)

 

Goal - Sync Google Sheet with Google Calendar

  • Updates the Google Sheet automatically whenever a Google Calendar event is canceled
  • Automatically clear the row where the canceled event is located

Above is the current Zap I am working on. I am not sure if it is correct, I used this template from Zapier. However, I am not sure what the Filter Condition is supposed to be for this goal that I wanted to happen.

  • Notes - “Canceled” status does not seem to appear as an available information from a Google Calendar Event.

I am also having difficulties on setting up the Row to be cleared. The goal is to clear the row where the canceled event is.

 

If someone knows how to fix this, it would be very helpful! Thanks in advance! :)

 

-Isabel

Did this topic help you find an answer to your question?

6 replies

Troy Tessalone
Forum|alt.badge.img+14

Hi ​@isabel_diesta 

Try turning the Zap ON, then testing live.

Check your Zap Runs history details to see the DATA IN/OUT for each step to help you trace the data flow and troubleshoot: https://zapier.com/app/history/

 

NOTE: You may need to use an alternative spelling in the filter condition: cancelled

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
SamB
Community Manager
Forum|alt.badge.img+11
  • SamBCommunity Manager
  • Community Manager
  • 7733 replies
  • March 24, 2025

Hi there, ​@isabel_diesta, just checking in—were you able to get it working by updating the filter condition as Troy suggested?

Looking forward to hearing from you! 🙂

I

Hi ​@Troy Tessalone and ​@SamB - Thanks for checking and for your response. 

Was able to fix the issue and got this up and running.

 

Additional question tho:

How can I enable the “Transfer Data” in the Zap that I created? The Zap I created is working to automatically add new row in a Google Sheet when there are new Google Calendar Events created as well as updated ones.

 

Other than new events, another goal is to transfer past Google Calendar events to this Google Sheet.

 

I was able to do this before, but I cannot seem to figure out how. I hope you both can help. Thanks!

 

Best,

Isabel

Troy Tessalone
Forum|alt.badge.img+14

Hi ​@isabel_diesta 

Help link about Transfer Data: https://help.zapier.com/hc/en-us/articles/8496274335885-Transfer-existing-data-using-a-Zap

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

HI ​@Troy Tessalone,

I was able to check this article earlier before posting here.

I am using Google Calendar, which is a supported trigger. The Zap is also complete and has been published. However, “Transfer Data” option is still grayed out.

 

Troy Tessalone
Forum|alt.badge.img+14

​@isabel_diesta 

With the Transfer Data option disabled that means the Zap trigger event is not supported for Transfer Data.

 

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

Reply


Terms & Conditions