remove duplicated event ID's from spreadsheet

[aristosv]

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?

 

[Supreme]

Hey @aristosv

You can validate the data which you are passing into your Google Sheets, you can filter the data first and on the basis of its presence, you can add the data.

To set the filter condition in your workflow, please refer to the following screenshot.