How to Build a Clay Waterfall Enrichment for B2B Prospecting (2026 Tutorial)

Yananai A. Chiwuta · Reviewed by Celine Sky · · 7 min read Last updated February 2026
Cover Image

TL;DR


Contents


A clay waterfall enrichment is a multi-tool email finding process where contacts pass through a sequence of verification tools — if Tool A doesn't find the email, Tool B tries, then Tool C. The combined result is an email find rate of 85–92% instead of the 60–75% you'd get from any single source.

That 15–25% difference sounds incremental. It's not. On a list of 2,000 contacts, it's the difference between 1,400 reachable contacts and 1,750+. That's 350 more people entering your sequence — with no additional prospecting. For a campaign running at 6% reply rates, that's 21 extra replies from the same source list.

We run this exact waterfall on every client campaign. The sequence is Prospeo → Findymail → Datagma, orchestrated inside Clay and automated through n8n. This tutorial walks through the full setup — from table structure to automation logic.


What Waterfall Enrichment Is and Why It Matters for B2B Outbound

Waterfall enrichment is the practice of chaining multiple data sources in sequence, where each tool only processes the contacts the previous tool couldn't find.

The concept isn't complicated. The value comes from coverage diversity — each email-finding tool has different strengths. Prospeo is strongest on LinkedIn-sourced contacts. Findymail has better coverage on European and mid-market segments. Datagma fills remaining gaps and adds phone numbers.

No single tool covers everything. A waterfall covers almost everything.

Why it matters for outbound specifically: Your campaign economics are directly tied to how many contacts you can reach. If your prospecting produces 2,000 target contacts but your email finding only verifies 1,300, you're running campaigns on 65% of your list. The other 35% — contacts who might have responded — never receive an email.

A waterfall closes that gap. And inside Clay, the whole process can be automated so it runs without manual intervention.


Why Single-Tool Email Finding Falls Short

Here's what typical find rates look like from individual tools:

Tool Typical find rate (cold B2B list) Strongest segment
Prospeo 65–75% LinkedIn-sourced, North American
Findymail 60–70% European, mid-market
Apollo (email finder) 60–70% Large company, well-covered industries
Datagma 55–65% Gap filling, phone numbers

Each tool is hitting 60–75% on its own. The contacts each tool misses are different contacts. Prospeo misses a European marketing director. Findymail finds them. Apollo misses a 20-person startup's CTO. Datagma catches them.

Running all three in sequence — and only passing unfound contacts to the next tool — produces 85–92% coverage. That's not a theoretical number. It's what we see across our campaigns.


The Clay Waterfall Enrichment Setup: Prospeo → Findymail → Datagma

Here's the architecture of the waterfall inside Clay.

Tool order and logic

  1. Prospeo (first pass): Receives the full contact list. Attempts to find and verify email addresses. Contacts with a verified email are marked "found" and skip the remaining tools.

  2. Findymail (second pass): Receives only contacts Prospeo didn't find. Attempts verification on these remaining contacts. Found contacts are marked and skip Datagma.

  3. Datagma (third pass): Receives only contacts neither Prospeo nor Findymail found. Attempts email finding plus mobile number lookup where available.

Why this order?

Prospeo first because it has the highest accuracy on LinkedIn-sourced contacts, which is where most of our starting lists come from (via Sales Navigator). Findymail second because it handles the segments Prospeo misses best. Datagma last because it's the broadest catch-all and also provides phone data for multi-channel sequences.

The order matters. Running the most accurate tool first means fewer false verifications enter the waterfall downstream.


Step-by-Step: Building Your Clay Waterfall Enrichment Table

Step 1: Create the Clay table

Set up a new Clay table with the following columns:

Column Type Purpose
Full name Text Contact name from Sales Nav / Apollo
Company Text Company name
LinkedIn URL URL Profile link for enrichment
Email (Prospeo) Enrichment Prospeo email lookup
Email (Findymail) Enrichment Findymail lookup — conditional
Email (Datagma) Enrichment Datagma lookup — conditional
Verified email Formula Final verified email from first successful tool
Source Formula Which tool found the email
Phone (Datagma) Enrichment Mobile number from Datagma (optional)

Step 2: Configure Prospeo enrichment

Add a Prospeo enrichment column. Input: LinkedIn URL or full name + company name. Output: verified email address.

Set this column to run on every row automatically when a contact is added to the table.

Step 3: Configure Findymail with conditional logic

Add a Findymail enrichment column. Set it to run only when the Prospeo email column is empty. This is the waterfall logic — Findymail only processes contacts Prospeo missed.

In Clay, you do this by adding a condition to the enrichment: "Run only if Email (Prospeo) is blank."

Step 4: Configure Datagma with conditional logic

Add a Datagma enrichment column. Set it to run only when both Prospeo and Findymail columns are empty. Datagma processes only the contacts both previous tools missed.

Condition: "Run only if Email (Prospeo) is blank AND Email (Findymail) is blank."

Step 5: Create the verified email formula

Add a formula column that picks the first non-empty email:

IF Email (Prospeo) is not empty → use Prospeo email
ELSE IF Email (Findymail) is not empty → use Findymail email
ELSE IF Email (Datagma) is not empty → use Datagma email
ELSE → "No email found"

Step 6: Create the source attribution column

Add a formula column that records which tool found the email. This is useful for tracking coverage quality and cost attribution:

IF Email (Prospeo) is not empty → "Prospeo"
ELSE IF Email (Findymail) is not empty → "Findymail"
ELSE IF Email (Datagma) is not empty → "Datagma"
ELSE → "Not found"

Step 7: Export to Smartlead

Filter the table for rows where "Verified email" is not "No email found." Export these contacts to Smartlead for sequence entry. You can do this via CSV download or through Clay's integration with Smartlead.

For automated workflows, connect Clay to Smartlead via n8n — so enriched contacts flow into sequences automatically without manual export.


Expected Results: Find Rates, Costs, and Throughput

Here's what we see across live campaigns using this exact waterfall setup:

Metric Value
Combined find rate 85–92%
Prospeo finds (first pass) 60–70% of total list
Findymail finds (second pass) 12–18% of total list
Datagma finds (third pass) 5–8% of total list
Contacts still unfound 8–15% of total list

Monthly cost at standard campaign volume (2,000 contacts)

Tool Monthly cost
Prospeo $39–$79
Findymail $49
Datagma $49–$99
Total waterfall cost $137–$227
Cost per verified email $0.08–$0.13

At $0.08–$0.13 per verified email, the waterfall is cheaper than most single-tool alternatives at similar coverage levels. And the coverage difference — 85–92% vs. 60–75% — translates directly into more contacts entering sequences and more replies generated.


Common Mistakes in Clay Waterfall Enrichment Setups

1. Running all tools simultaneously instead of sequentially. This wastes credits. If Prospeo and Findymail both find the same email, you've paid twice for one result. The waterfall logic (conditional enrichment) exists specifically to prevent this.

2. Putting the cheapest tool first instead of the most accurate. Cost optimisation matters, but accuracy matters more. A cheap tool with lower accuracy in the first position sends more contacts downstream — some of which are false negatives (the first tool said "not found" but the email exists). Start with the most accurate tool for your primary list source.

3. Not tracking which tool found each email. Without the source attribution column, you can't optimise. If Findymail is finding 25% of your contacts consistently, it's worth keeping. If it's finding 3%, you might switch the order or replace it.

4. Skipping the phone number layer. Datagma's mobile number lookup is a bonus that feeds LinkedIn + phone multi-channel sequences. If you're only doing email outbound, this is optional. If you're running multi-channel, it's free data you're already paying for.

5. Not connecting Clay to n8n for automation. A manual export from Clay to Smartlead after every enrichment run is a time sink. Connect the workflow through n8n so enriched contacts push to Smartlead automatically when the waterfall completes. That's what turns a manual process into a system.


ICP Worksheet — Download Free

Define your ICP criteria before you build your Clay enrichment table. This worksheet covers company stage, headcount, tech stack, funding status, and the specific filters that should govern which contacts enter your waterfall.

Download the ICP Worksheet →


FAQ: Clay Waterfall Enrichment for B2B

What is a clay waterfall enrichment?

A Clay waterfall enrichment is a multi-tool email-finding process inside Clay where contacts pass through a sequence of verification tools — Prospeo first, then Findymail, then Datagma. Each tool only processes contacts the previous tool couldn't find. The combined find rate is 85–92%, compared to 60–75% from any single email-finding tool.

How much does a waterfall enrichment setup cost?

The total tool cost is $137–$227/month at standard campaign volumes (2,000 contacts). That breaks down to Prospeo ($39–$79), Findymail ($49), and Datagma ($49–$99). The cost per verified email is roughly $0.08–$0.13, which is competitive with single-tool alternatives that deliver lower coverage.

Can I build a waterfall enrichment without Clay?

Technically yes — you could chain the API calls manually or through n8n alone. But Clay makes it dramatically easier because of its built-in conditional enrichment logic. Setting up a "run only if previous column is empty" condition in Clay takes seconds. Replicating that in raw API calls takes significant engineering time.

What find rate should I expect from waterfall enrichment?

Expect 85–92% on a well-targeted ICP list of B2B SaaS contacts. The rate varies by geography (North American lists typically run 88–92%, European lists run 82–88%) and by company size (larger companies tend to have better email coverage than startups). Below 80% usually indicates a targeting issue with the source list rather than a tool issue.