Skip to content
NEWMarketplace and the trig8n Agent: sell what you build, and get plans and changes that are tested before you see them. See what is new

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

  1. Run Table Now
  2. Every 30 Minutes
  3. Table Settings
  4. Read Pending Rows
  5. Pick Batch
  6. Loop Rows
  7. Check Run Budget
  8. Row Needs Work
  9. Has Website
  10. Pick Domain
  11. Normalize Website
  12. Domain Found
  13. Scrape Homepage
  14. Find About Page

55 steps in total.

Similar automations