Using a Google Calendar trigger, each time a new event is added to a google calendar, I pull the information of the event and put it in a Google Sheet. But sometimes an event will be moved to another date/time and it's added to the spreadsheet again. It has the same Event ID but different Date/Time.
I need a way to find these duplicated events in the spreadsheet, and delete the old event and keep only the updated one.
I have created a webhook that triggers on New or Updated Spreadsheet Row and set the TriggerColumn to G, which is the Event ID. (workflow: find duplicated event)
From there on, how can I detect duplicate Event ID's and remove the old entry, and keep the new one? Or is there a better way to do this?
I need a way to find these duplicated events in the spreadsheet, and delete the old event and keep only the updated one.
I have created a webhook that triggers on New or Updated Spreadsheet Row and set the TriggerColumn to G, which is the Event ID. (workflow: find duplicated event)
From there on, how can I detect duplicate Event ID's and remove the old entry, and keep the new one? Or is there a better way to do this?