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.

Hey!

 

I’m trying to update a recurrence events in Google Calendar by changes in a table I have in Google Sheets.

 

The idea is -

I have a table of shifts in Google sheets, each shift is a week long. This table is updating when new employees arrive (only future shifts). I want to be able to first of all, create all shifts events by the table (and invite the employees to the relevant event) and update those events if employees changes future shifts (update the name of the event and the attendees). 

 

Will be happy to hear any suggestion, for now I only managed to create events or updates recurrence but it updates all futures events with the same data. 

 

Nofar

Hi @BKNofar Thanks for your question and I’m sorry in the delay for the reply!

 

You’re right that the standard ‘Update Event’ action wont update all future recurrences of an event. If you want to add an attendee to event (ie add an employee to that series of shifts) then you can do the following:

  1. Add a "Find Event" action to find the next instance of the recurring event
  2. Add a "Add Attendee/s to Event" action and map out the "Recurring Event ID" value from the "Find Event" action as a custom value for the "Event" field.

This means that it’s possible to Add people to an event, but it’s not possible to remove them, sorry about that. My recommendation would be to set up a Zap that tells you (eg a text/email, whichever you prefer) when someone cancels a shift, so that you can do that change manually. 

 

Alternatively, you could look in to a scheduling app (here’s a list of the ones that work with Zapier), to see if that would be a better fit for managing shifts. 

Terms & Conditions