All workflows
Airtable logoProspeo logoHunter logo

Find work emails for new Airtable leads with Prospeo and Hunter

Sales & Business Development

Finds a work email for each new lead in your Airtable table, trying Prospeo then Hunter, and writes it onto the row.

Add to WorkspaceBrowse all templates
Every 15 minutes3 apps4 steps

Apps it connects

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

AirtableProspeoHunter

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 whose enrichment status is neither enriched nor marked for review.

  2. For each record

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

      1. If firstName, lastName and companyDomain

        1. 2ProspeoEnrich personLooks up each lead by name and company, keeping the verified email plus job title and LinkedIn profile.

        2. If resolvedEmail is empty

          1. 3HunterEmail finderFinds the email by name and domain when Prospeo misses, kept only with a high score and no catch all domain.
      2. 4AirtableUpdate recordWrites the email, its status and source, plus title and LinkedIn 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 lead's work email is looked for: first through Prospeo, matching on name and company, and only if that finds nothing through Hunter. Both offer free plans with a small monthly allowance.

Each row gets the email, its status and source written back, plus the job title and LinkedIn profile when Prospeo finds them, and is marked done. 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. 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.

You need Prospeo, Hunter and Airtable connected, a leads table with name, company and domain columns plus columns for the email, its status and source, title, LinkedIn and enrichment status, and your Airtable base ID and table name filled in.

enrichmentwaterfallairtableprospeohunteremailprospectingscheduledfree

You may also be interested in

Find a work email for every new lead in AirtableEvery 15 minutes, finds a work email for each new lead in your Airtable table, trying Apollo then Hunter, and writes it on 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 in your texting hours, sends one reminder if they have not booked, then stops.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.

Start from a workflow that already works.

Add "Find work emails for new Airtable leads with Prospeo and Hunter" to your workspace, connect its apps, and make it yours.

Start FreeSee Pricing

Free plan, no credit card