Airtable lead enrichment (Prospeo + Hunter)
Free-tier waterfall: find each Airtable lead's work email with Prospeo, fall back to Hunter, and write it back to the row.
What it does
Each integration step this workflow runs, in order, what it is for, and the conditions and loops that decide when it runs.
- 1AirtableList recordsLists the rows in your leads table whose enrichment status is neither enriched nor marked for review.
For each
recordIf
recStatusis not “enriched” or “needs_review”If
firstName,lastNameandcompanyDomain- 2ProspeoEnrich personLooks up each lead by name and company, keeping the verified email plus job title and LinkedIn profile.
If
resolvedEmailis empty- 3HunterEmail finderFinds the email by name and domain when Prospeo misses, kept only with a high score and no catch all domain.
- 3
- 2
- 4AirtableUpdate recordWrites the email, its status and source, title and LinkedIn back to the row and marks it enriched or for review.
How it works
What happens on each run, in plain English.
Every 15 minutes, the rows in your Airtable leads table not yet enriched are picked up and each lead's work email is looked for: first through Prospeo, matching on name and company, and only if that finds nothing through Hunter. Both charge nothing on a miss, so credits are only spent where an email lands.
Each row gets the email, its status and source, the job title and LinkedIn profile written back, and is marked enriched. Only confident results are kept: a Prospeo email must come back verified, and a Hunter email must score highly and not sit on a catch-all domain. A lead with no confident email, or a row missing a first name, last name or domain, is marked for review rather than guessed at. Rows already enriched or marked for review are left alone afterwards, so nothing is looked up or paid for twice.
Before the first run you need a leads table with name, company and domain columns, plus columns for the email, its status and source, title, LinkedIn and enrichment status.
You May Also Be Interested In
Airtable lead enrichment (waterfall)When a lead lands in Airtable, waterfall-enrich its work email (Apollo then Hunter) and write the result back to the row.
Find people at the companies you name and send a first emailFinds people by job title at the companies you list, confirms a work address for each, records them, then sends a first email.
Text new enquiries a booking link, then chase onceTexts each new Airtable enquiry your Cal.com booking link, sends one reminder if they still have not booked, then stops.Waterfall email enrichmentChain Apollo then Hunter to find a work email, keeping the first confident match. The reusable core of any enrichment flow.
Start from a workflow that already works.
Add "Airtable lead enrichment (Prospeo + Hunter)" to your workspace, connect its apps, and make it yours. No credit card required.
Free plan available · No credit card required