Skip the built-in Remove Duplicates dialog and write an Apps Script that deduplicates any sheet in one read and one write, using a JS Set to track see
Originally written for bulldo.gs — republished here with the canonical link pointing home.
I have a Google Sheet with duplicate rows and I want to remove them programmatically, either on demand or on a schedule, without destroying the rest of my data.
// removeDuplicates.gs — dedup active sheet, keep first occurrence
// Run from Extensions > Apps Script, or bind to a trigger.
function removeDuplicateRows() {
Google Apps Script kills any execution that runs past 6 minutes. Learn how to checkpoint progress in PropertiesService and resume…
Set up a daily time-driven trigger in Google Apps Script that fires at a specific hour, and avoid the duplicate-trigger trap that…
Replace index-based for loops over getValues arrays with arrow-function map and filter in Apps Script, while keeping the 2D array…
Every SMB I've worked with treats a Google Sheet as their first real database — leads, deals,...
The standalone app era is ending — and the companies still building interfaces on top of databases are running out of time to…
Use Apps Script's replaceAllText() to swap {{token}} placeholders across every slide in a Google Slides deck — with matchCase set…
