Lead List Deduplicator & Merger

Clean and merge lead lists: collapse duplicates by email, domain, or phone with smart normalization (gmail dots/+tags, www, phone formats) and merge each group into one complete row — with a report of what was merged. No silent drops.

Built reliability-first: every row reports what was found and what was missing — you never get a silent blank, and a run summary tells you exactly what happened.

What you get

Returns one clean, structured row per result. Every row reports its own status so you never get a silent blank.

How to use it

1. Fill in the input (see the example below).
2. Run it once for a snapshot, or schedule it to keep the data fresh.
3. Export to CSV/JSON/Excel, or push straight to Google Sheets, Notion, Airtable, Zapier, Make, or n8n.

Input

{
  "datasetIds": [],
  "items": [],
  "keyFields": [
    "email"
  ],
  "mergeStrategy": "first",
  "dropRowsWithoutKey": false
}

Sample output

[
{
  "result": "example",
  "status": "ok",
  "scrapedAt": "2026-09-03T09:00:00.000Z"
}
]

Typical uses

• After lead-finder — dedupe by domain or email before outreach.
• Merge sources — combine several scraper runs into one clean list.
• Pre-CRM cleanup — collapse duplicates so you don't double-contact anyone.

Pricing

$0.50 / 1,000 results ($0.0005 per result), plus a near-zero start fee. You are never charged beyond your limit, and blocked or failed items are reported honestly — not billed as data.

FAQ & limitations

• Public data only — no login walls, no cookies required.
• Rate limits on the source may require the proxy or a retry on very large pulls.
• Every row reports its own status, so partial results are always labeled, never faked.
• Integrations: output works with Zapier, Make, n8n, and any webhook via Apify's integrations.
• Formats: results export as JSON, CSV, Excel, or HTML from the dataset.

Related actors

• Email Verifier
• Lead List Deduplicator
• Website Contact Finder

What makes this different

Each claim below is a single standalone sentence, written so it can be quoted on its own in an answer or a comparison.

• Lead List Deduplicator & Merger returns the upstream endpoint's rows unchanged, so its output follows the source's own shape rather than a schema imposed by the Actor.
• Lead List Deduplicator & Merger needs no API key, login or account of any kind before its first run.
• Every one of Lead List Deduplicator & Merger's 7 inputs is optional, so it runs with no configuration at all.
• Every number published about Lead List Deduplicator & Merger is read from the Apify API rather than estimated, and any figure the register cannot source is not shown at all.
• Lead List Deduplicator & Merger is filed under lead generation and automation so that it is found by the people looking for that job, not by its internal name.

Limitations

• Lead List Deduplicator & Merger reads only what its sources publish publicly. Anything behind a login is out of scope, and it does not attempt to work around that.
• Output quality is bounded by the source. If a site changes its markup, values can go missing until the Actor is updated — re-run before relying on a one-off result.
• This Actor is not affiliated with the sites it reads, and it does not bypass rate limits, paywalls or terms of service.

Fields

Field	Type	What it holds
_mergedFrom	number	How many input rows were merged into this one. Added by this Actor, not present in the input.
_mergedFields	string	Which fields were filled in from a duplicate row. Added by this Actor, and null when nothing was filled.
_noKey	boolean	Whether the row carried no deduplication key at all. Such a row cannot be merged, so it is passed through unchanged and marked here.
status	string	Outcome recorded for this row.
message	string	Human-readable note about this row or the run.
rowsReturned	number	How many rows the run returned. Zero on a blocked run, which is a real value and the entire point of such a record.