Update recurrence events in google Calendar by Google Sheets table

Question

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

icon

Best answer by Danvers 1 April 2020, 13:42

View original

Danvers · Accepted Answer

Hi @BKNofarThanks 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: Add a "Find Event" action to find the next instance of the recurring event 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 toAddpeople to an event, but it’s not possible toremovethem, 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.

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded