Deduplicate Your Contacts List
When you trigger a deduplication run, WebRun reads your contacts spreadsheet, groups rows by matching name and email, merges the richest data from each duplicate set, writes the cleaned list back to the sheet, and posts a summary to Slack flagging any merges it wasn't certain about.
How can I automatically deduplicate my contacts list?
WebRun deduplicates your contacts list on demand so your database stays clean and reliable. When you trigger a run, it reads your contacts spreadsheet, groups rows by matching name and email, merges the richest data from each duplicate set, writes the cleaned list back to the sheet, and posts a Slack summary flagging any merges it wasn't certain about for your review.
- Duplicate contacts merged with the richest data preserved from each record
- Uncertain merges flagged in Slack for human review before finalising
- Clean contacts list ready to re-import into your CRM
Built for marketing teams · sales operations · CRM administrators · small business owners
What does WebRun do on every run?
The exact actions WebRun takes, in order — in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
docs.google.com/spreadsheetsin a real browser with your saved login — no setup, no API keys. -
1
Google Sheets — scan for duplicate contacts
google.com
WebRun opens Google Sheets to scan for duplicate contacts. - Open the contacts sheet and scan all rows for matching email addresses, then for matching name+company combinations
- Group each set of duplicates and score confidence: High (exact email match), Medium (name+company match), Low (name only)
- For High-confidence groups, merge fields by taking the most complete value per column (e.g. use the row that has a phone number)
Done when All duplicate groups are identified with a confidence score and a proposed merged record.
-
2
Airtable — write the deduplicated records
airtable.com
WebRun opens Airtable to write the deduplicated records. - Open the Clean Contacts base in Airtable
- Import the merged High-confidence records as new rows, overwriting any existing entry for the same email
- Create a separate 'Needs Review' table for Medium and Low-confidence merges, listing both original records side by side
Done when Clean contacts are in Airtable; uncertain merges are in the Needs Review table.
-
3
Slack — flag uncertain merges for review
slack.com
WebRun opens Slack to flag uncertain merges for review. - Post a deduplication summary to #ops: total contacts before, total after, number of merges, and count of records needing review
- Include a link to the Airtable Needs Review table for the uncertain cases
Done when You have the full deduplication summary and a clear list of records to review manually.
How is each run configured?
Secure by default
Connect once, stays signed in
WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.
Every action is checked against this policy before it runs.
Questions, answered
What if it merges two contacts that are actually different people?
Only High-confidence merges (exact email match) are applied automatically. Everything else lands in the Needs Review table for you to approve or reject manually.
Will it delete any data from the original sheet?
No — it reads the sheet and writes clean records to Airtable. Your original spreadsheet is untouched. You can compare before deleting anything.
Can I run it on a schedule instead of manually?
Yes — change the trigger to 'Every Monday' and WebRun will run the deduplication weekly on any new contacts added since the last run.
Related templates
Put this on autopilot.
Turn it on in minutes — or have our team set it up for you.