Lead List Cleaner avatar

Lead List Cleaner

Pricing

Pay per usage

Go to Apify Store
Lead List Cleaner

Lead List Cleaner

Clean business lead lists in seconds: remove duplicates, personal emails (Gmail, Yahoo...), social media links and incomplete rows.

Pricing

Pay per usage

Rating

0.0

(0)

Developer

zako data

zako data

Maintained by Community

Actor stats

0

Bookmarked

2

Total users

1

Monthly active users

3 days ago

Last modified

Categories

Share

Turn a messy list of business leads into a clean, ready-to-use list. Paste your leads, upload a CSV link, or connect the output of another Apify Actor (for example a Google Maps scraper).

What it does

  • Removes duplicate leads (same email or same phone number)
  • Removes personal emails (Gmail, Yahoo, Hotmail, Outlook, iCloud...) and keeps business emails
  • Removes fake or broken emails (image file names, no-reply addresses, placeholder domains)
  • Drops social media links (Facebook, Instagram, LinkedIn...) used in place of a real website
  • Drops rows with no name, and optionally rows with no email, phone or website
  • Picks a primary email per lead and labels it generic (info@, contact@...) or named
  • Returns a tidy table with a short summary of what was removed

Input

Provide one data source:

FieldDescription
datasetIdID of an Apify dataset, for example from a Google Maps Scraper run
csvUrlPublic link to a CSV or JSON file. The first CSV row must contain column names
leadsLeads pasted directly as a JSON list

Options:

FieldDefaultDescription
requireEmailtrueRemove rows without a valid business email
requirePhonefalseRemove rows without a phone number
requireWebsitefalseRemove rows without a real website
removePersonalEmailstrueRemove free-mail addresses
removeDuplicatestrueRemove rows sharing an email or phone number

Recognized column names (case-insensitive): title / name / companyName, phone / phoneNumber, email / emails, website, address, city, state, categoryName / category.

Example input

{
"leads": [
{
"title": "Example Realty",
"phone": "(305) 555-0100",
"website": "https://www.example-realty.com/",
"emails": ["info@example-realty.com", "agent@gmail.com"]
}
],
"requireEmail": true,
"removePersonalEmails": true
}

Output

One row per cleaned lead:

{
"name": "Example Realty",
"phone": "(305) 555-0100",
"email": "info@example-realty.com",
"emailType": "generic",
"extraEmails": "",
"website": "https://www.example-realty.com/",
"address": "",
"city": "",
"state": "",
"category": ""
}

A SUMMARY record is also saved with the number of rows kept and removed, and why. Download the results as Excel, CSV or JSON from the Output tab.

Good to know

  • The Actor only cleans and reorganizes the data you give it. It does not collect new data and does not verify that an email address is actually deliverable.
  • Make sure you have the right to use the contact data you process, and that your use complies with the laws that apply to you and your recipients (for example email and phone marketing rules).