Sorzio
FeaturesPricingFAQCompareClaude & MCPMCP DocsUse casesBlogHelp
Sign inGet started free
Get started

Product

  • Install
  • Claude & MCP
  • MCP Developer Hub
  • Compare
  • Features
  • Pricing
  • Roadmap

Resources

  • Use cases
  • Blog
  • Glossary
  • Cost calculator

Support

  • Help Center
  • Contact Support
  • Getting Started
  • Billing & Plans

Company

  • Sorzio vs Clay
  • Sorzio vs Apollo

Legal

  • Privacy Policy
  • Terms of Service
  • Cookie list
  • Subprocessors

Empra Consultancy LTD
hello@sorzio.com

Sorzio|PrivacyTermsCookiesSubprocessors

© 2026 Empra Consultancy LTD. All rights reserved.

All articles
Blog/Lead enrichment

How to build a waterfall enrichment workflow in Google Sheets & MCP

Step-by-step guide to running a multi-source B2B enrichment waterfall in Google Sheets, Hosted Lists, or Claude MCP, with 1,000-row TCO math against credit tools.

By Hugo Dupont · 5 min read · June 8, 2026 · Updated November 3, 2026

On this page
  • Step-by-step: build a 5-stage waterfall in Google Sheets, Hosted Lists, or MCP
  • 1,000-row TCO math: credit waterfalls vs pay-on-success
  • When you still need a licensed contact broker
  • Common questions

To build a practical B2B enrichment waterfall without a $300-to-$800 monthly credit subscription, run your prospect rows through an ordered sequence of first-party web, LinkedIn, ICP scoring, and email verification steps where you pay only for rows that return data. Instead of burning credits on failed database attempts, you start with 6-page company website enrichment ($0.006 per succeeded URL), cascade unresolved firmographics to Company LinkedIn ($0.0075 per succeeded row) or Live Web Search, gate fit with Decision Mode ($1.00 per 1,000 rows base fee), and run SMTP verification ($0.01 per email) only on qualified accounts. If you just want the concise term definition, see the waterfall enrichment glossary entry.

Step-by-step: build a 5-stage waterfall in Google Sheets, Hosted Lists, or MCP

You can execute this exact pipeline from the Sorzio Google Sheets sidebar, inside a browser Hosted List, or from Claude and ChatGPT via the Sorzio MCP connector (https://www.sorzio.com/api/mcp).

Stage 1: Crawl 6 company subpages first ($0.006 per succeeded domain)

Start with the highest-signal, lowest-cost public source: the prospect's own domain. Run Website Enrich on Auto ($0.006 per succeeded URL, or $6.00 per 1,000 companies). A single Auto pass crawls up to 6 pages per domain (homepage, about, products, case_studies, pricing, and careers) at $0 extra charge, writing grounded markdown directly into your context column. Dead domains and failed fetches cost $0.

Stage 2: Cascade thin or missing rows to LinkedIn Enrich

Filter to rows where the website was parked, thin, or missing headcount and leadership context, and run LinkedIn enrichment only on the rows that need it:

  • Company LinkedIn (/company/): $0.0075 per succeeded row ($7.50 per 1,000 rows) for structured employee band, industry, headquarters, and company overview.
  • Personal LinkedIn (/in/): $0.01 per succeeded row ($10.00 per 1,000 rows) for prospect headline, current role tenure, and experience. Profiles that return #not_found cost $0.

Stage 3: Fill edge-case gaps with 5-provider Live Web Search

When 5 to 10 percent of accounts still lack a specific trigger (such as recent funding, SOC 2 compliance, or a new product launch), run Live Web Search exclusively on those remaining rows using perplexity/sonar (~$8.78 per 1,000 rows) or native search grounding across OpenAI, Anthropic, Google, or xAI (1.65x search fee).

Stage 4: Gate ICP fit with Decision Mode before spending on contacts

Before paying to verify emails or write outbound copy, score every enriched company with Decision Mode (typesafe-ai/jev-1.14.0 at $1.00 per 1,000 rows base fee + 1.25x input tokens, ~$1.01 per 1,000 rows total). Decision Mode evaluates up to 12 weighted criteria in one pass and routes rows three ways (keep, reject, or unsure), cutting downstream verification and AI spend on poor-fit accounts.

Stage 5: Verify emails and draft openers only on keep rows

On rows marked keep, run Email Verification ($0.01 per verified address, $10.00 per 1,000) so invalid and disposable addresses are filtered out before sending, then run Generative AI (1.65x provider token cost + $0.0035 per succeeded row, ~$3.90 per 1,000 rows on budget models like GPT-4o-mini, or 0% markup with BYOK on Pro at $39/mo) referencing {{Website Context}} and {{LinkedIn Summary}}.

1,000-row TCO math: credit waterfalls vs pay-on-success

Traditional credit-based enrichment platforms bundle a mandatory monthly subscription ($149 to $800/mo) with multi-credit lookups that often bill per attempt, pushing effective cost to roughly $140 to $670 per 1,000 prospects. Here is what the 5-stage workflow above costs on 1,000 raw B2B companies in Sorzio when 850 domains resolve on Stage 1, 200 thin rows cascade to Company LinkedIn, 600 companies pass the ICP gate, and 600 contacts are verified and personalized:

  • Stage 1 (Website Enrich, 850 succeeded of 1,000): 850 x $0.006 = $5.10 (150 dead URLs = $0)
  • Stage 2 (Company LinkedIn cascade on 200 rows): 200 x $0.0075 = $1.50
  • Stage 4 (Decision Mode ICP gate on 1,000 rows): 1,000 x ~$0.00101 = $1.01
  • Stage 5a (Email Verification on 600 keep leads): 600 x $0.01 = $6.00
  • Stage 5b (Generative AI opener on 540 valid emails, GPT-4o-mini): 540 x ~$0.0039 = $2.11

Total 1,000-company pipeline spend: $15.72 with $0 mandatory monthly subscription on the Free plan, and new workspaces receive up to $20 in welcome credit ($5 instant on sign-up + $15 when you enable Auto-Reload with a verified card). Model your own funnel ratios in the AI cost calculator, or see the full feature breakdown in Sorzio vs Clay.

When you still need a licensed contact broker

This workflow excels at company-level firmographics, live buying signals, LinkedIn profile context, ICP qualification, and email verification on contacts you already sourced. It does not broker licensed cell-phone databases across 15 third-party contact vendors: if your SDR team cold-calls direct mobile numbers, pair a dedicated dial-data source with Sorzio for web enrichment, ICP scoring, and personalization. See lead enrichment in Google Sheets and enrich URLs in Google Sheets for deeper column templates.

Common questions

How do I run a waterfall automatically without filtering rows by hand?

Save the sequence as a Flow in Sorzio. Flows chain Enrich, Decision Mode gates (keep / reject / unsure), Verify, and AI prompts in a single automated pass, and on Pro ($39/mo) or Scale ($99/mo) you can run Scheduled Flows automatically as new rows arrive.

Can I trigger this waterfall from Claude or ChatGPT?

Yes. Connect the Sorzio MCP server (https://www.sorzio.com/api/mcp, 39 tools) in Claude or ChatGPT to create a Hosted List, run multi-step enrichment and Decision Mode filters in chat, preview exact run costs before execution, and export clean CSVs.

Do failed or #not_found lookups consume balance?

No. Every Sorzio adapter settles strictly on succeeded rows: dead domains, #not_found LinkedIn profiles, and skipped gate rows cost $0.

On this page
  • Step-by-step: build a 5-stage waterfall in Google Sheets, Hosted Lists, or MCP
  • 1,000-row TCO math: credit waterfalls vs pay-on-success
  • When you still need a licensed contact broker
  • Common questions

Keep reading

All articles
Firmographics
Glossary

Firmographics

Waterfall enrichment
Glossary

Waterfall enrichment

Lead enrichment in Google Sheets: the complete guide
Use case

Lead enrichment in Google Sheets: the complete guide

Try it on your own list

Sorzio runs inside Claude, ChatGPT, and Google Sheets. Start free with up to $20 credit, no card needed.

Get started free