You launch an outbound campaign. Your usual data provider comes back with a 55% completion rate. Nearly half your prospects have no email, no phone number. The result: broken sequences, a shrinking pipeline, and wasted budget.
This isn’t a volume problem — it’s an enrichment strategy problem. No single B2B data provider covers your entire target market on its own. The approach used by the highest-performing sales teams is called waterfall enrichment: a multi-provider method that takes contact coverage from 40–60% with a single source to 80%+ by combining several.
In this guide, you’ll understand how waterfall enrichment works, why it’s becoming the new standard for B2B data enrichment, and how to set it up concretely in your stack.
Enrich your leads directly in Google Sheets
Find professional emails and phone numbers for your prospects without juggling multiple tools or exports.
What is waterfall enrichment?
Waterfall enrichment (also called cascade enrichment) is a B2B data enrichment method that queries multiple data providers in sequence, one after another, until the target information is found — or until all sources have been exhausted.
The waterfall image is fitting: data flows from one provider to the next. If Apollo finds the email, the process stops there. If not, it cascades to the next provider — Clearbit, Hunter, People Data Labs — until a valid result is returned.
The core insight is straightforward: B2B data provider databases barely overlap. One provider might be excellent for tech profiles in North America, another for European SMBs, a third for direct-dial phone numbers. None of them cover everything.
Here’s the basic waterfall logic:
| Step | Action | Outcome |
|---|---|---|
| 1 | Provider A queried | Email found → stop, move to next record |
| 2 | Provider B queried (if A fails) | Email found → stop |
| 3 | Provider C queried (if B fails) | Email found or field remains empty |
| N | … | Complete data or field marked “not found” |
The system only continues if the field is still empty. You don’t pay duplicate credits for data that’s already been found.
Why a single data provider is no longer enough
For years, sales teams got by with a single subscription — ZoomInfo, Apollo, Lusha — hoping the database would cover all their targets. This approach hits a ceiling fast.
The geographic coverage problem: US-centric providers tend to be weak on Europe, Asia-Pacific, or Latin America. An SDR prospecting French companies with a US-oriented provider will get a disappointing match rate.
The sector specialization problem: some providers excel on tech profiles, others on healthcare or manufacturing. A generalist database often misses niche or regional contacts.
The data freshness problem: B2B contact data degrades at roughly 30% per year. A contact enriched 18 months ago has a solid chance of having changed roles, companies, or email addresses. Update frequency varies enormously between providers.
The data type problem: some providers are strong on professional emails but weak on mobile numbers. Others are the reverse. A market-leading email provider may have almost no usable phone data.
The direct consequence? With a single-provider approach, even the best-organized sales teams rarely exceed 60% coverage on their lists. The remaining 40% simply can’t be reached.
How multi-provider waterfall enrichment works: a step-by-step breakdown
Let’s move from concept to concrete mechanics. Here’s how a well-configured waterfall enrichment setup works in practice.
Step 1: Define which fields to enrich
Before running anything, identify precisely which data points you’re looking for. The most common waterfall use cases cover:
- Professional email (the most commonly enriched field in B2B)
- Direct phone number (mobile or landline)
- Current job title and function
- Company data (headcount, industry, location, tech stack)
Each data type can have its own waterfall with its own provider sequence. Email and phone require different sources — treat them separately for best results.
Step 2: Order your providers by priority
The sequence in which you query sources matters more than most teams realize. A few rules of thumb:
- Cheapest provider first: if the data is found early, you save expensive credits downstream
- Best-fit provider for your audience first: if you’re prospecting in the UK, start with a source strong on European data
- Specialized providers by data type: one source for emails, a different one optimized for mobile numbers
Sarah, an SDR at a B2B SaaS company targeting marketing directors across Europe, would prioritize sources with strong EU coverage before falling back to broader global sources if needed.
Step 3: Set up your conditional logic
The key to an efficient waterfall is the stop condition: only move to the next provider if the field is empty or the result is invalid.
In an implementation via Make or n8n, this looks like:
- If email found AND verified valid → stop
- If email found BUT bounce detected → continue to next provider
- If email not found → continue to next provider
This logic prevents duplicate billing and optimizes your credits at each stage.
Step 4: Validate results on output
A found email isn’t necessarily a deliverable email. Before pushing data into your CRM or outbound sequence, email verification is essential. The key categories to watch:
- Valid: active, deliverable address
- Catch-all: the domain accepts all emails — impossible to know if the specific address exists
- Invalid: guaranteed bounce, exclude from campaigns
For teams operating at scale, database enrichment with real-time validation is now table stakes for maintaining acceptable deliverability rates.
What data types can a B2B waterfall cover?
Waterfall enrichment can go well beyond email and phone. Here’s an overview of fields commonly enriched through this approach:
Contact data:
- Professional email
- Direct or mobile phone number
- LinkedIn profile
- Job title and function
- Department
Company (firmographic) data:
- Company size (headcount, revenue)
- Industry
- Headquarters location
- Technologies in use (tech stack)
Behavioral and timing data:
- Purchase intent signals
- Company news (funding rounds, hiring sprees, expansion)
Each data type calls for different providers with different strengths. A granular waterfall — one cascade per field type — consistently outperforms a single generic waterfall trying to do everything at once.
How to build your multi-provider waterfall strategy
Now that the mechanism is clear, here’s how to deploy this approach concretely.
Identify your current gaps
Start with an audit of your existing database. Which fields are empty? On what percentage of contacts? For which profile types (company size, sector, geography) does your current provider underperform most?
Mike, Sales Ops at a London-based SaaS scale-up, found that across 4,000 leads pulled from LinkedIn Sales Navigator, only 58% had a valid email — and fewer than 30% had a phone number. His primary provider was strong on US profiles but nearly useless for French and German SMBs.
Select complementary sources
To build an effective waterfall, identify 2 to 4 providers whose strengths genuinely complement each other. Key selection criteria:
- Geographic coverage: does it cover your target markets (UK, DACH, Benelux, Nordics…)?
- Data types: email only, or also phone and mobile?
- Billing model: credits, subscription, per API call?
- GDPR compliance: was the data collected with a valid legal basis?
On that last point — we cover this in the next section, as it’s a critical consideration in the European context.
Automate via an orchestration layer
Manual waterfalling isn’t viable once you’re beyond a few hundred contacts. Automation options include:
- All-in-one platforms that already aggregate multiple providers (BetterContact, FullEnrich, Surfe)
- Orchestration tools like Make or n8n, which let you build your own cascade with your own provider selection
- Native Google Sheets enrichment tools like Derrick, which let you run enrichment workflows directly inside your spreadsheet — no CSV exports, no re-imports
The advantage of native Google Sheets tools is eliminating operational friction: there’s no file to export, no platform to log into, no import step to manage. Everything happens in an interface your team already uses.
Measure and optimize continuously
A waterfall isn’t a one-time configuration. Provider databases evolve, their coverage shifts, and your target audience changes too.
Key metrics to track:
| Metric | Definition | Indicative target |
|---|---|---|
| Email coverage rate | % of contacts with a valid email found | 70–85% |
| Phone coverage rate | % of contacts with a number found | 40–60% |
| Hard bounce rate | % of emails returned with a permanent error | < 3% |
| Cost per enrichment | Total cost / fields successfully filled | Varies by stack |
| Overall completion rate | % of contacts with all key fields filled | 75%+ |
For teams looking to go deeper, this overview of professional email enrichment tools breaks down the options by budget and volume.
How to verify and clean your email lists
Learn how to remove invalid addresses and reduce your bounce rate before sending.
Waterfall enrichment and GDPR: what you need to know
Multi-provider enrichment raises legitimate questions about GDPR compliance, particularly in the UK and across Europe. Here are the key points to understand.
Responsibility stays with you. Even if you outsource enrichment to a third-party provider, you remain the data controller responsible for how personal data is ultimately processed. You need to verify that each provider in your waterfall collects data with a valid legal basis.
Legitimate interest in B2B prospecting. GDPR allows the use of professional data for B2B prospecting under the legitimate interest basis — provided the processing is proportionate, individuals can easily opt out, and only professional data is used (work email, not personal email).
Data minimization. Only enrich the fields you actually need. Enriching 50 attributes per contact when you only use 5 in your sequences isn’t in line with the data minimization principle.
Watch out for non-compliant providers. Some aggregated data sources don’t meet GDPR requirements in their collection methods. Before adding a new provider to your waterfall, review their compliance policy and ask specifically where and how data was sourced.
For a deeper look at the intersection of outbound prospecting and legal compliance, this article on cold emailing and GDPR is a useful companion read.
Common waterfall enrichment mistakes (and how to avoid them)
Mistake 1: Not validating emails on output
Impact: You pay for “found” emails that bounce at 20–30%. Your sender reputation degrades, your campaigns land in spam.
Fix: Always include an email verification step after enrichment. Exclude catch-all domains if you can’t afford deliverability risk on a given campaign.
Mistake 2: Too many providers with no clear prioritization logic
Impact: Costs spiral, results overlap, operational complexity grows. Having 10 providers in your waterfall is worthless if the last 7 never find anything.
Fix: Start with 2–3 providers. Measure per-provider match rates on your actual data. Add a new source only if it delivers a measurable coverage gain over what you already have.
Mistake 3: Ignoring firmographic data
Impact: You enrich contact details but your team still doesn’t know if the company fits your ICP — right headcount, sector, tech stack, buying signals.
Fix: Include company-level enrichment in your waterfall, not just individual contact data. A valid email on an out-of-ICP prospect isn’t worth much.
Mistake 4: Enriching once and never refreshing
Impact: At a 30% annual decay rate, your database becomes unreliable within 18 months. Reps start losing trust in the data, CRM adoption drops.
Fix: Set up re-enrichment cycles for active contacts — open pipeline, strategic accounts, recently inbound leads. Native Google Sheets enrichment tools make this kind of rolling update practical without dedicated tooling.
Key takeaways
- Waterfall enrichment queries multiple data providers in sequence, only moving to the next if the field is empty or the result is invalid
- Single-provider approaches typically cap out at 40–60% coverage; a well-configured waterfall regularly exceeds 80% on most audiences
- Provider order matters: start with the cheapest and most relevant for your target geography
- Email validation on output is non-negotiable — found doesn’t mean deliverable
- GDPR applies: verify the compliance of each provider before adding it to your waterfall
- Native Google Sheets enrichment tools remove operational friction and make continuous data refresh practical
Conclusion: where to start with waterfall enrichment
Waterfall enrichment isn’t reserved for large teams with significant data budgets. It’s an accessible strategy as soon as you understand the fundamentals: audit your gaps, pick 2–3 complementary sources, automate the cascade logic, and validate results before pushing into your outreach tools.
The concrete first step? Audit your current database to identify which profile types your primary provider performs worst on — then find one complementary source that’s specifically strong on that segment.
Start enriching your leads in Google Sheets
Derrick finds professional emails, phone numbers, and company data directly from your spreadsheet — no exports, no complex setup, no wasted credits.
FAQ
What is waterfall enrichment in B2B? It’s a method that queries multiple data providers in sequence to enrich a contact record. If the first provider can’t find an email or phone number, the system automatically moves to the next one, continuing until a result is found or all sources are exhausted.
What coverage rate can you achieve with waterfall enrichment? Single-provider enrichment typically delivers 40–60% coverage. By combining 2 to 4 complementary sources in a waterfall, teams regularly hit 80–90%+ match rates on their prospect lists.
Is waterfall enrichment GDPR-compliant? Yes, provided each provider in your cascade collects data under a valid legal basis. Review the compliance policy of every source before integrating it, and apply data minimization — only enrich the fields you’ll actually use.
How many providers do you need for an effective waterfall? 2 to 4 well-chosen providers cover most use cases. Adding too many sources creates operational complexity and unnecessary costs without proportional coverage gains. Start small, measure, then add only if a measurable gap remains.
Can you build a waterfall enrichment workflow in Google Sheets? Yes. Tools like Derrick let you run enrichment workflows — email, phone, company data — directly from Google Sheets, without needing to export CSV files to third-party platforms or manage separate API keys.