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.

Best answer

How to Update / Delete events from Google Calendar based on Google Sheet?

  • 1 September 2022
  • 1 reply
  • 505 views
I

Hello All,

I have a google sheet with dates and titles, I need to create events on google calendar based on the title and date of the input.

My Sheet looks like this:

 

My goal

To sync inputs of google sheet with google calendar and create calendar events based on the dates on the sheet.

 

I have succeeded on doing the following:

  • Create a new event if the “Project/Talent” columns is not empty.
  • Create event on the date and time in “Publish Date” and “Publish time”
    • I have created a row with the following formula in order to have both date and time in a single row, I hid this col and pointed Zapier to get the date/time of the event out of this col. 
      =A2 + B2

       

However, I face the following issues:

  • When I edit an entry, it will be considered as a new event and I’ll have duplicated calendar events on the same date.
  • Deleting and entry wont delete the event from the calendar.

PS: I’m trying to make the Google Sheet very simple and user friendly as it shared between all the team members and the producer / manager has to enter the time, title, and platform.

 

I wonder if anyone can help me out on solving those issues.

 

 

Thanks in advance

 

icon

Best answer by rachael.silvano 1 September 2022, 17:01

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

1 reply

rachael.silvano
Userlevel 5
Badge +7

Hey there @iSoloGHM - sounds like you’re really close! 

 

To solve the problem of editing an entry and duplicate calendar invites, I’d suggest switching to “Find” Action step in Google Calendar. Once in there, you’ll see that if the Zap can’t find the event based on the specified list, it’ll create a new event- no more duplicates! 

 

 

For deleting events, you can do this with a Filter Step, however, I’d warn you that the better path here if you choose to do so is to delete contents of a row, not delete the row entirely- that can cause the Zap to go a bit into chaos. 

 

Let me know if either of those help, or if you need some more info in order to get your Zap where you want it to be :) 

 

Best,

Rachael

Terms & Conditions