From Apollo Export to Sequencer: Cleaning a List Before It Hits Instantly, lemlist or Smartlead
Before an Apollo export goes into Instantly, lemlist or Smartlead, cut it to the columns you use, fix name casing, remove anyone you have already emailed, verify the remaining addresses, and split the result into confirmed and catch-all files. Upload the confirmed file to your main campaign and the catch-all file to a smaller, separate one.
This is the plumbing between "export" and "launch". Whether to re-verify at all is a separate question, covered in should you re-verify an Apollo export. This post assumes you will, and walks through the order that wastes the fewest credits.
Step 1: Export only what you need
Apollo lets you export selected contacts and choose whether to include only those with verified emails. The Apollo export page lists the clicks. Two things save time later:
- Export from a saved list or a tight search, not your whole database. Smaller files are easier to check by eye.
- Note how many rows you selected. After each step below, the count should only go down, and you should know why.
Step 2: Trim the columns
A raw Apollo CSV has far more columns than a sequencer needs. Extra columns are not harmless: every one becomes a candidate during column mapping, and a wrong mapping (a LinkedIn URL landing in "company name") ends up inside an email.
Keep:
| Column | Why |
|---|---|
| The address you send to | |
| First name, last name | Greeting and personalisation |
| Company name | Copy and reporting |
| Website or company domain | Dedupe by company, domain checks |
| Title | Segmenting, sometimes copy |
| One personalisation field | Whatever your first line uses |
| Apollo email status | Comparison only, drop before upload |
Everything else can live in your CRM or in the original export.
Step 3: Fix names and company names
Apollo data is mostly clean, but a few patterns break merge fields: all-caps names, names with job suffixes attached, and company names carrying "Inc.", "LLC" or "Ltd" that look odd in a sentence. Decide your rules once and apply them to the whole column. If the export has a full-name field instead of separate parts, the full-name splitter breaks it into first and last.
Check the first-name column for blanks. A blank first name with a "Hi {{firstName}}" opener sends "Hi ," unless your sequencer has a fallback. Fill a fallback value or move those rows to a variant of the copy that does not use the name.
Step 4: Dedupe against your history, not just the file
Duplicates inside one export are rare. The real problem is overlap with people you have already contacted: a previous campaign, a customer list, an unsubscribe list. Pull those into one suppression file and compare. The compare email lists tool returns the rows in your new export that are not in the old one.
Do this before verification. There is no reason to pay to verify someone you are not going to email. If you do not keep a suppression file yet, building a cold email suppression list explains what belongs in it.
Step 5: Verify what is left
Upload the trimmed, deduped file for a mailbox check. You get each row labelled, and the useful split for a cold campaign is:
- Valid: the mailbox was confirmed. Main campaign.
- Catch-all: the domain accepts everything, so the mailbox cannot be confirmed. Separate campaign.
- Invalid: the mailbox does not exist or the domain takes no mail. Remove.
- Unknown: the server did not give a clear answer. Hold back or retry later.
Role addresses (info@, sales@) are worth a look too. In a person-targeted campaign they rarely belong; filter them out or move them to a separate list.
Step 6: Upload two files, not one
Each sequencer handles the import differently, but all of them map CSV columns to their own fields and keep extra columns as custom variables. Upload the confirmed file into your main campaign. Upload the catch-all file into a copy of that campaign with a lower daily limit, and watch its bounces separately. If that segment bounces noticeably more than the main one, pause it and keep the main campaign running.
If you use Instantly or Smartlead, you can also verify leads that are already in a campaign through the Instantly integration and the Smartlead one, which is handy when someone uploaded first and asked questions later.
A quick order-of-operations check
- Export a tight list, note the row count
- Trim columns
- Fix names, fill or segment blanks
- Remove past contacts and suppressions
- Verify
- Split into confirmed and catch-all, drop invalid
- Upload, map columns, send a test to yourself
Get started
Sign in with Google and your first 100 email checks are free, no card, which is enough to run a sample of your next Apollo export through the full mailbox check. For whole exports every month, see pricing.
Picking a verifier for the export? Email verifiers for Apollo compared shows which list an Apollo integration and what 10,000 checks cost.
Common questions
Can I upload an Apollo CSV straight into Instantly, lemlist or Smartlead?
Technically yes, all three accept CSV uploads and let you map columns. In practice the raw export carries dozens of columns you will not use, names in inconsistent case, people you have already emailed and addresses that no longer work. A short cleanup pass before upload avoids personalisation errors and bounces in the first days of the campaign.
Apollo already marks emails as verified. Why check again?
Because the status reflects Apollo's last check, not today. People change jobs and mailboxes close between that check and your send. Our post on re-verifying Apollo exports covers how Apollo's statuses map to a fresh mailbox check.
Should catch-all addresses go into the same campaign?
Better not. A catch-all domain accepts every address at the SMTP stage, so a verifier cannot confirm the mailbox. Put those rows in their own campaign with lower daily volume, so any bounces they produce are easy to see and do not drag down the main campaign.
Which columns should I keep from an Apollo export?
Email, first name, last name, company name, company domain or website, title, and whatever single field your opening line depends on, such as industry or city. Keep the Apollo email status column during cleanup so you can compare, then drop it before upload unless your sequencer uses it.
Check your list before you send
Real mailbox checks over SMTP, and nothing is sent to the address. Sign in with Google and your first 100 email checks are free, no card. Plans for bigger lists are on the pricing page.