Find a work email for every new lead in Airtable
Every 15 minutes, finds a work email for each new lead in your Airtable table, trying Apollo then Hunter, and writes it on 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 not yet marked as enriched or needing review, so finished rows are never touched.
For each
recordIf
recStatusis not “enriched” or “needs_review”If
firstName,lastNameandcompanyDomain- 2ApolloEnrich personLooks the person up by name and company domain first, for a verified work email plus title, seniority and company details.
If
resolvedEmailis empty- 3HunterEmail finderSearches by name and domain as the fallback, keeping only a high scoring email on a domain that is not catch all.
- 3
- 2
- 4AirtableUpdate recordWrites the email, its status and source, plus title, seniority, LinkedIn, industry and headcount where found, keeping the row's own values for anything not found.
How it works
What happens on each run, in plain English.
Every 15 minutes, the rows in your Airtable leads table that have not been processed yet are picked up and each person's work email is looked for. Apollo is tried first for a verified email and company details; if that finds nothing, Hunter is asked, and its answer is kept only when it scores highly and the company's mail server does not accept every address.
Each row is updated in place with the email, its status and source, plus title, seniority, LinkedIn, industry and headcount where found. Anything the search did not find leaves the row's own value alone, so a LinkedIn link or email you typed in is never wiped. The row is marked 'enriched', or as needing review when no confident email turned up. Only rows without a result are ever touched, so a row is never looked up twice, and a run cut short by a rate limit leaves the rest for the next run. Rows missing a first name, last name or domain are marked for review and skipped rather than stopping the run.
You need Apollo, Hunter and Airtable connected, a 'Leads' table with First Name, Last Name, Company and Domain columns plus columns for the results, and your Airtable base ID and table name filled in.
You may also be interested in
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.Find a lead's verified work emailGive it a name and a company: it asks Apollo, then Hunter, and returns a work email only when one is verified, never a guess.
Find work emails for new Airtable leads with Prospeo and HunterFinds a work email for each new lead in your Airtable table, trying Prospeo then Hunter, and writes it onto the row.
Text new enquiries a booking link, then chase onceTexts each new Airtable enquiry your Cal.com booking link in your texting hours, sends one reminder if they have not booked, then stops.Start from a workflow that already works.
Add "Find a work email for every new lead in Airtable" to your workspace, connect its apps, and make it yours.
Free plan, no credit card