Add your data to Google Sheets.
Ensure column names match across the lists you want to compare.
Free
Find Duplicates
Quickly clean your lists and remove duplicates.
Used by 31,000+ BD teams Updated
Try it for free →
How to use this feature
Get started in 3 simple steps.
Select Find Duplicates
Open the Derrick add-on, choose Find Duplicates, and select the columns to deduplicate.
Identify duplicates instantly
A new “duplicate” column appears to flag duplicate entries.
All the data you can extract
Enrich companies and leads with 1+ data points each.
| Field Name | Description | Example |
|---|---|---|
| 🧬 duplicate (new) | Indicates if this row is a duplicate of another | duplicate |
When to reach for it
Find Duplicates use cases
Find Duplicates is a Derrick workflow that runs natively inside Google Sheets (plus REST API + MCP server). It pulls the data class you need and writes it back into the sheet your team already lives in - no CSV exports, no separate web app.
- Daily account-research - pull find duplicates on every account in your morning queue.
- CRM hygiene - keep find duplicates fresh on existing records to avoid stale-data costs.
- Trigger-based automation - have find duplicates pulled the moment a new lead lands in the sheet.
- Bulk batch jobs - run find duplicates across thousands of rows in a single Sheets job.
Loved by sales teams worldwide
See what our customers say about Derrick.
"This app saved me so much time and effort. Great for anyone looking to build a contact list or network at scale quickly. As a start-up it's been invaluable."
Alex Clark
Director | SaaS GTM Leader
"Working pretty nifty compared to Snov.Io. Price wise it does give a fair shake, and IMO better interface since it's google sheets."
David Sire
Mortgage Broker at Zero Point Mortgage
"Derrick is a very simple and user-friendly app to enrich your contacts database. Best thing: you can test it for free. And then the price is so low, it's a no brainer."
Etienne Grange
CEO Form'actions
"Super easy to enrich linkedin urls using this tool. Both personal and company url data can be easily enriched with a click of a button."
Zaid Bilal
RevOps Professional
"Amazing Tool, I would like to advocate this to my colleagues. So that you can get more users. Keep it Up. 5 Stars!"
Asif Hanzala
Lead Generation Specialist at IdeaPeel
"This app is fantastic. Brilliantly created to help small and mid sized businesses."
Dan Hughes
Founder/CEO, AlmanacIO
"I have been using other expensive apps or freemium like phantombuster, but Derrick has replaced them all. I love the simplicity of the Google sheet add-in, but what is best is the efficiency it delivers."
Julien Walon Cohen
CEO & Co-founder @ Diffly | B2B Sales Advisor
"The LinkedIn scraping and email finder combo is incredibly powerful. I can build a complete prospect list with contact info in under an hour. Absolute must-have for outbound."
Michael Kim
SDR Team Lead at CloudScale
"Have tested over 10+ LI scraper apps, Derrick beats them all. Simple to use, accurate data, and affordable price."
AJ Alexander
Opportunity Prospector
Deduplicating lead lists is the unglamorous chore that decides whether your sequence runs clean or your CRM ends up with 3 versions of the same prospect. Native Google Sheets has UNIQUE() for the simple case, but it breaks on near-duplicates (same email different case, name with vs without accent, two different emails for the same person).
Derrick's Find Duplicates reads a column directly from Google Sheets and returns the duplicate signal — exact match, near-match by email, near-match by full name + company — in the next cell. Free, no credit consumed, no monthly cap. The bulk use case that drives adoption : pre-pass on every imported list (Sales Nav, conference attendees, webinar signups) before pushing into the CRM or outbound tool. Saves ~12 % of credits downstream on a typical mid-funnel B2B campaign. Where this fits in the wider Derrick plan grid.
Related : email verification in bulk for the validity dimension. Wider context : the full data-enrichment recipe hub.
Frequently asked questions
Do I need to install anything to use Find Duplicates?
Just the Derrick Google Sheets add-on (one click, no API keys, no developer setup). Once installed, Find Duplicates is one of the workflows available from the Derrick sidebar inside any Sheet. The same feature is also available via REST API and via the Derrick MCP server for Claude / ChatGPT.
Can I use Find Duplicates on a list of 1,000+ rows?
Yes - Find Duplicates runs as a batch job inside Google Sheets, with progress tracking and per-row credit accounting. The workflow scales linearly: 10 rows or 10,000 rows, the steps are identical and you can step away while it runs.
Where does the data behind Find Duplicates come from?
Derrick aggregates 10+ public-data sources (LinkedIn graph, company websites, registry data, web crawl, third-party providers) and runs them in a waterfall for Find Duplicates. The first source that returns a confident match wins; if no source is confident enough, the cell is left blank rather than guessed.
Is Find Duplicates GDPR-compliant?
Yes. Derrick only enriches public data, doesn't store personal records beyond the duration of the lookup, and supports full deletion on request. The Sheets add-on runs inside Google's OAuth-protected environment so your data stays private to your account.
Can I trigger Find Duplicates automatically when I add a row?
Yes - set up a Google Sheets onEdit trigger (Apps Script, takes 2 minutes) so a new row in column A automatically runs Find Duplicates into column B. Pair with Zapier / Make / n8n to push CRM contacts directly into the sheet for hands-free enrichment.
Start cleaning your lists today
Find Duplicates is completely free and unlimited feature
Try it for free → Unlimited
Free to use
No credit card required