About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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
  • How do I sync Google Sheets and Google Calendar to remove calendared events when rows are deleted?
Question

How do I sync Google Sheets and Google Calendar to remove calendared events when rows are deleted?

W

I have a simple automation to create a detailed google calendar event when I update or add to a row in google sheets. I am trying to essentially sync things so when I remove a row in sheets ( for a canceled event ) my calendar event in google cal also is removed. I’ve also run into only new calendar events being created when updated an original and not replacing an existing event. Any guidance much appreciated. 

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

11 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @Willventures 

Try these...

 

CREATE

You should also add a column to track the GCal Event ID when the GCal Event is originally created.

Steps

  1. Trigger: GSheets - New/Updated Row
  2. Action: Filter
  3. Action: GCal - Create Detailed Event
  4. Action: GSheets - Update Row
    1. Map the Row/ID from Step 1
    2. Map the GCal Event ID from Step 3

 

UPDATE

Steps

  1. Trigger: GSheets - New/Updated Row
  2. Action: Filter
    1. Make sure GCal Event ID exists and is NOT a delete (see more info below)
  3. Action: GCal - Update Event

 

DELETE

There is no GSheet Zap app trigger for deleted row.

Try these Zap steps:

  1. Trigger: GSheets - New/Updated Row
    1. Add a column to indicate you want to delete the row (e.g. Delete = NO/YES)
  2. Action: Filter
  3. Action: GCal - Delete Event
  4. Action: GSheets - Delete Row
⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
W

Thanks for the reply. Sorry pretty new to Zapier, so would these 3 (Create, Update, Delete) each be individual Zaps, all running to achieve the behavior? Thanks

Troy Tessalone
Userlevel 7
Badge +14

@Willventures 

Yes, 3 separate Zaps.

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

Can you specify in the steps when you say “Action: Filter” what you mean exactly. When I add I filter I need to choose a criteria for that filter correct?

Troy Tessalone
Userlevel 7
Badge +14

@Willventures 

Help with Filter: https://zapier.com/apps/filter/help

Help for using GSheets in Zaps: https://zapier.com/apps/google-sheets/help

 

You’ll want to configure the Filter conditions to make sure the following Zap action step required field values are populated and that the Zaps will only run for the desired conditions.

 

e.g. For Updates, you’ll want to make sure the column for DELETE is NO (or empty) [depends on how you have your GSheet configured].

 

When in doubt, test it out.

 

  1. Make sure GCal Event ID exists and is NOT a delete (see more info below)
⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
W

Got it, so when you have as the second step in the Create zap an Action: Filter what would need to be filtered there?

W

Also if I create a column for GCal Event ID. How do I get that ID populated into my sheet?

Troy Tessalone
Userlevel 7
Badge +14

@Willventures 

Also if I create a column for GCal Event ID. How do I get that ID populated into my sheet?

See step 4.

 

CREATE

Steps

  1. Trigger: GSheets - New/Updated Row
  2. Action: Filter
  3. Action: GCal - Create Detailed Event
  4. Action: GSheets - Update Row
    1. Map the Row/ID from step 1
    2. Map the GCal Event ID from step 3
⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Troy Tessalone
Userlevel 7
Badge +14

@Willventures 

Got it, so when you have as the second step in the Create zap an Action: Filter what would need to be filtered there?

Depends which Zap are you referring to.

For us to have context we would need to see screenshots with how your Zap steps are outlined and configured in the Zap EDIT mode, along with screenshots with how your GSheet top 3 rows are configured.

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

Providing additional screengrabs. 

 

Troy Tessalone
Userlevel 7
Badge +14

@Willventures 

What field in the GSheet are you using to indicate you want to DELETE a row?

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