Skip to content
Workflow · Clean and combine · Opening soon

Remove duplicates in Google Sheets, keeping the latest row

Export your customer list from Google Sheets, then run the workflow on the file. It matches trimmed lower case email, or phone digits when email is blank, keeps the latest updated row for each person, and marks the rest as dropped duplicates with copies.

Early access opens shortly. Check back soon.

Someone typed

“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”

The agent read it as

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.

  1. File
    Google Sheets customer list
    CSV export · 43 rows
  2. Step
    Number customer list rows
    Step 1
  3. Step
    Mark duplicate customer rows
    Step 2
  4. Result
    Customer duplicate cleanup
    43 rows · 10 flagged
  5. Schedule
    Runs when you say
    Proposed

On the sample files, every step runs and the result has 43 rows.

What you get back

The result of that run, the rows to look at first.

Customer duplicate cleanupSample data43 rows
33 ok10 dropped duplicate
Customer NameStatusCopiesEmailPhoneCityUpdated
Frank MillsDropped duplicate2·212-555-0144Brooklyn2026-10-08
Anna PerezDropped duplicate2anna.perez@homefix.com(303) 555-0178Denver2026-10-02
Eva TurnerDropped duplicate2·415-555-0188Oakland2026-10-05
Chloe NguyenDropped duplicate2chloe.nguyen@homefix.com(510) 555-0155San Jose2026-09-29
David RossDropped duplicate2david.ross@homefix.com(206) 555-0181Seattle2026-10-20
Brian ColeDropped duplicate2brian.cole@homefix.com(214) 555-0133Dallas2026-10-11
Grace PatelDropped duplicate5grace.patel@homefix.com(312) 555-0166Chicago2026-11-10
Grace PatelDropped duplicate5GRACE.PATEL@homefix.com(312) 555-0166Chicago2026-10-22
Grace PatelDropped duplicate5grace.patel@homefix.com(312) 555-0166Chicago2026-09-30
Grace PatelDropped duplicate5GRACE.patel@homefix.com(312) 555-0166Chicago2026-09-30
Frank MillsOk2·(212) 555-0144Brooklyn2026-11-12
Ivy ChenOk1ivy.chen@homefix.com(314) 555-0174St Louis2026-10-27
43 rows in the result · 12 shown, problems first. Sample data: illustrative figures, not business results.

How it works

How to use the Customer duplicate cleanup workflow

  1. 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and working on sample files.
  2. 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
  3. 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?
Export your customer list from Google Sheets, then run the workflow on the file. It matches trimmed lower case email, or phone digits when email is blank, keeps the latest updated row for each person, and marks the rest as dropped duplicates with copies.
What export should you use?
Use a spreadsheet export from Google Sheets that includes the columns you want to check, such as email, phone, and last updated date or time.
What happens to rows that do not match a duplicate?
They stay marked as ok and are kept in the output. Only rows that match the duplicate rules are marked as dropped duplicate.
How do you change the duplicate rules?
Change the rules in plain words, for example by telling it which columns to compare, how to normalise text, and how to choose the row to keep when two rows match.

Get early access to this workflow

It opens already built and working on sample files. Swap in your own exports to see your result.

Early access opens shortly. Check back soon.