Airtable lead enrichment (Prospeo + Hunter)

Free-tier sibling of the Apollo waterfall. Same productionized shape — on a schedule it enriches new rows in your Airtable "Leads" table — but tier 1 is Prospeo instead of Apollo, so the whole thing runs on free provider plans (Prospeo's free tier includes API access + 75 email credits/month; Hunter's free tier includes API access + 25 searches/month).

Flow: on a 15-minute schedule -> list the Leads table -> for each row that isn't already enriched, run the waterfall (Prospeo Enrich person first, matching on name + company, kept only when it returns a found, VERIFIED email; Hunter Email Finder as the fallback, kept only when score >= 90 and the domain isn't catch-all) -> write Email, Email Status, Email Source, Title, and LinkedIn back onto the row and set Enrichment Status to "enriched" (or "needs_review" when no confident email was found). Both providers charge nothing on a miss, so you only pay (in credits) where an email lands.

What it fills vs. the Apollo version: Prospeo returns the work email + job title + LinkedIn, so this template writes Email / Email Status / Email Source / Title / LinkedIn / Enrichment Status. It does NOT touch Seniority, Industry, or Employees — those are company-level firmographics the Apollo People Enrichment endpoint provides and Prospeo's person enrich does not. The Airtable table is identical to the Apollo version, so those three columns simply stay untouched here; use the Apollo template if you need them.

Setup: 1. Connect Prospeo, Hunter, and Airtable (all three work on their free plans). 2. Create a "Leads" table with columns: First Name, Last Name, Company, Domain (inputs); Email, Email Status, Email Source, Title, LinkedIn, Enrichment Status (filled by the workflow). Seniority / Industry / Employees are optional here. 3. Set your Base ID and Table name in the baseId / tableName variables at the top (and adjust the schedule interval in the first step if you like). 4. Tune minScore (Hunter strictness) if you like. Add a test row; the next scheduled run enriches it.

Rows missing First Name, Last Name, or Domain are flagged (Email Status "missing_input", Enrichment Status "needs_review") and skipped rather than aborting the run — Airtable omits empty cells from its API response, and Prospeo needs a first name plus a company, so a partial row can't be enriched.

Notes / limits: the list step uses a server-side filter (filter_formula) to fetch only rows not yet enriched, so it scales to tables far larger than 50 - max_records (50) just caps how many are processed per run, and the run skips already-done rows for free. Prospeo free is 75 credits/month and Hunter free is 25 searches/month, so keep test batches small — every row where Prospeo misses spends one Hunter search. To recover the missing firmographics for free you could add a Prospeo Enrich company call (headcount + industry) before the write-back; the waterfall logic stays the same.