Library / Lead Generation & Enrichment
Lead Generation & Enrichment
Enrich outbound leads in Google Sheets with Hunter, Firecrawl and Dropcontact
Runs on demand over pending sheet rows, finds decision-makers with Hunter, scrapes company sites with Firecrawl, waterfalls email lookups and writes grounded cold openers back to the sheet.
What it does
# Clay Waterfall Enrichment Outbound list enrichment pipeline that researches company websites, waterfalls across email providers, and writes personalized, grounded cold openers. ## How it works The workflow reads pending leads from a Google Sheet and processes them one by one. A row only needs a company. If it has no person, one Hunter domain search finds the decision-maker for the role on the row (or the target roles in Table Settings) and writes their name and title back. First, company research scrapes the prospect company homepage and about page using Firecrawl. An LLM extracts core value propositions and facts grounded in verbatim quotes. An anti-hallucination code gate verifies every quote as an exact substring before keeping it. Second, the email waterfall checks free website emails first, then Hunter, then Dropcontact. Hunter verification gates every step and halts immediately upon finding a deliverable or qualified address. Third, an LLM drafts a concise opener citing exactly one verified fact. A verification gate rejects fluff, banned phrases, and ungrounded claims. Finally, row results and credit costs write back to Google Sheets, and an executive run summary emails via Gmail. ## Setup steps 1. Make a copy of the Lead Table Google Sheet template with columns matching the specification, including person_source. 2. Connect credentials for Google Sheets, Firecrawl, OpenRouter, Hunter, Dropcontact, and Gmail. 3. Configure Table Settings with your target ICP, value proposition, and replace REPORT_EMAIL with your recipient address. 4. Set max_credits_per_run to 10 for your initial test run to verify waterfall routing before scaling up.
The steps
- Run Table Now
- Every 30 Minutes
- Table Settings
- Read Pending Rows
- Pick Batch
- Loop Rows
- Check Run Budget
- Row Needs Work
- Has Website
- Pick Domain
- Normalize Website
- Domain Found
- Scrape Homepage
- Find About Page
55 steps in total.
Similar automations
MCP Servers & ToolsFind B2B Emails with Dropcontact via MCP Server3 stepsLead Generation & EnrichmentEnrich Google Sheets Contacts with Dropcontact and Lemlist4 stepsLead Generation & EnrichmentEnrich Contacts with Dropcontact and Add Them to Lemlist5 stepsLead Generation & EnrichmentEnrich Typeform Contacts with Dropcontact11 steps