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.
Best answer by DanversView original
@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:
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.