All workflows
Airtable logoApollo logoHunter logo

Airtable lead enrichment (waterfall)

Sales & Business Development

When a lead lands in Airtable, waterfall-enrich its work email (Apollo then Hunter) and write the result back to the row.

Add to WorkspaceBrowse all workflows
Every 15 minutes3 apps4 steps

Apps it connects

Authenticate each one once and the workflow is ready to run.

AirtableApolloHunter

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.

  1. 1AirtableList recordsLists the rows in your leads table not yet marked as enriched or needing review, so finished rows are never touched.

  2. For each record

    1. If recStatus is not “enriched” or “needs_review”

      1. If firstName, lastName and companyDomain

        1. 2ApolloEnrich personLooks the person up by name and company domain first, for a verified work email plus title, seniority and company details.

        2. If resolvedEmail is empty

          1. 3HunterEmail finderSearches by name and domain as the fallback, keeping only a high scoring email on a domain that is not catch all.
      2. 4AirtableUpdate recordWrites the email, its status and source, plus title, seniority, LinkedIn, industry and headcount, marking the row enriched or needing review.

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 enriched yet are picked up and run through a two-stage search for the person's work email. 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 domain is not a catch-all.

Each row is updated in place with the email, its status and source, plus title, seniority, LinkedIn, industry and headcount where found, and 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 enriched twice, and a run cut short by a rate limit leaves the rest for the next sweep. Rows missing a first name, last name or domain are marked for review and skipped rather than stopping the run.

You need a 'Leads' table with First Name, Last Name, Company and Domain columns, plus columns for the results.

enrichmentwaterfallairtableapollohunteremailprospectingscheduled

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.Waterfall email enrichmentChain Apollo then Hunter to find a work email, keeping the first confident match. The reusable core of any enrichment flow.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.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.

Start from a workflow that already works.

Add "Airtable lead enrichment (waterfall)" to your workspace, connect its apps, and make it yours. No credit card required.

Get StartedSee Pricing

Free plan available · No credit card required