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