Remove duplicates in Google Sheets, keeping the latest row
“clean up our google sheets customer list by matching trimmed lower-case email, or phone digits when email is blank, keep the latest updated row and on ties keep the first row, show ok or dropped duplicate with copies”
Clean up our Google Sheets customer list by matching trimmed lower-case email, or phone digits when email is blank, keep the latest updated row and on ties keep the first row, show ok or dropped duplicate with copies.
What the agent built
2 steps, each one an ordinary Mammoth step you can open and change.
- FileGoogle Sheets customer listCSV export · 43 rows
- StepNumber customer list rowsStep 1
- StepMark duplicate customer rowsStep 2
- ResultCustomer duplicate cleanup43 rows · 10 flagged
- ScheduleRuns when you sayProposed
On the sample files, every step runs and the result has 43 rows.
- Download Google Sheets customer list sample (43 rows)Google Sheets: File > Download > Comma-separated values (.csv)
What you get back
The result of that run, the rows to look at first.
| Customer Name | Status | Copies | Phone | City | Updated | |
|---|---|---|---|---|---|---|
| Frank Mills | Dropped duplicate | 2 | · | 212-555-0144 | Brooklyn | 2026-10-08 |
| Anna Perez | Dropped duplicate | 2 | anna.perez@homefix.com | (303) 555-0178 | Denver | 2026-10-02 |
| Eva Turner | Dropped duplicate | 2 | · | 415-555-0188 | Oakland | 2026-10-05 |
| Chloe Nguyen | Dropped duplicate | 2 | chloe.nguyen@homefix.com | (510) 555-0155 | San Jose | 2026-09-29 |
| David Ross | Dropped duplicate | 2 | david.ross@homefix.com | (206) 555-0181 | Seattle | 2026-10-20 |
| Brian Cole | Dropped duplicate | 2 | brian.cole@homefix.com | (214) 555-0133 | Dallas | 2026-10-11 |
| Grace Patel | Dropped duplicate | 5 | grace.patel@homefix.com | (312) 555-0166 | Chicago | 2026-11-10 |
| Grace Patel | Dropped duplicate | 5 | GRACE.PATEL@homefix.com | (312) 555-0166 | Chicago | 2026-10-22 |
| Grace Patel | Dropped duplicate | 5 | grace.patel@homefix.com | (312) 555-0166 | Chicago | 2026-09-30 |
| Grace Patel | Dropped duplicate | 5 | GRACE.patel@homefix.com | (312) 555-0166 | Chicago | 2026-09-30 |
| Frank Mills | Ok | 2 | · | (212) 555-0144 | Brooklyn | 2026-11-12 |
| Ivy Chen | Ok | 1 | ivy.chen@homefix.com | (314) 555-0174 | St Louis | 2026-10-27 |
How it works
How to use the Customer duplicate cleanup workflow
- 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and working on sample files.
- 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
- 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.
Customer duplicate cleanup: questions
How do you remove duplicate customers in Google Sheets and keep the latest row?
What export should you use?
What happens to rows that do not match a duplicate?
How do you change the duplicate rules?
Get early access to this workflow
It opens already built and working on sample files. Swap in your own exports to see your result.
Workflows like this
Remove duplicates, tidy names and addresses, fill the blanks, and merge files into one.
- Pivot table from raw dataTurn a raw sales export into a pivot table of revenue by region and month.See the workflow Built by the agent
- Merge Excel or CSV filesOne tidy table with every file's rows, re-sent rows dropped, and a Period columnSee the workflow Template
- Remove duplicatesOne row of each, with a Copies column saying how many there wereSee the workflow Template
- Remove blank rowsRemove rows that are empty or only contain spaces from an Excel export, while keeping the rest of the sheet unchanged.See the workflow Built by the agent
- Match names to a master listEach record with its master name (and ID), and how it matchedSee the workflow Template
- Multi-entity consolidationEvery entity's balances in one currency, by accountSee the workflow Template