Rowdate

Stop duplicate events when syncing Google Sheets to Calendar

Why it happens, how to clean up, and how to avoid it next time.

Why the duplicates appear

Most ways of getting rows into Google Calendar (CSV import, a quick script, simple add-ons) create events. They do not remember which event belongs to which row. So when you change a row and run the import again, the tool has no way to find the old event: it creates a new one, and the old one stays.

The same thing happens when the import runs on a schedule, when two people run it, or when a run fails halfway and you start it again.

Cleaning up the duplicates you already have

Syncing without duplicates

The reliable approach is to store the event ID next to each row. Then a re-run can do the right thing for every row:

This is how Rowdate works. It adds two columns to your sheet, Rowdate Event ID and Rowdate Status, and uses the ID to update the same event every time. Running Sync twice in a row changes nothing the second time; every row just says "Unchanged".

If you write your own script, the same idea applies: see the script in our Sheets to Calendar guide and extend it to read the event by ID with CalendarApp.getEventById() and update its time and title.

Other things that look like duplicates

Try Rowdate

100 events a month are free. Pro adds unlimited events and live sync for $5 a month, $39 a year or $79 once.

Install Rowdate free Setup guide Pricing

More guides