Build a Multi-Provider Email Waterfall for Maximum Coverage

This tutorial shows how to configure a waterfall of email finding providers in TexAu. The setup uses BetterEnrich as the primary source with FullEnrich, Apollo, and Findymail as fallbacks. The goal is to maximize the percentage of contacts with a verified work email address.

Before you begin

• Connect these integrations in Settings > Integrations:
  • BetterEnrich (primary)
  • FullEnrich (fallback 1)
  • Apollo (fallback 2)
  • Findymail (fallback 3)
• Confirm you have enough credits for the number of rows you plan to enrich. Email finding actions typically cost 2 credits per successful lookup. Check Settings > Billing for your balance.

What a waterfall does

A waterfall runs email finding actions in sequence for each contact. It tries the first source. If that source returns an email, it stops. If the first source returns no result, it tries the second source, then the third, and so on. Credits are only consumed for sources that return a result (pay-on-match).

The benefit: significantly higher overall email coverage than any single provider alone.

Set up the waterfall

Step 1: Create the table

1. Click New Table and name it (for example, Email Waterfall).
2. Import your list of LinkedIn profile URLs.
3. Confirm the first column is named LinkedIn URL.

Step 2: Add BetterEnrich as the primary source

1. Click Add Column and select Action Column.
2. Search for and select Find Work Email by LinkedIn URL (BetterEnrich).
3. Map the LinkedIn URL column as input.
4. Select Email as the output field.
5. Click Save.
6. Name the column Email - BetterEnrich.

Step 3: Add FullEnrich as fallback 1

1. Click Add Column and select Action Column.
2. Search for and select Find Work Email by LinkedIn URL (FullEnrich).
3. Map the LinkedIn URL column as input.
4. Add a Run Condition: run this column only when Email - BetterEnrich is empty.
5. Select Email as the output field.
6. Click Save.
7. Name the column Email - FullEnrich.

Step 4: Add Apollo as fallback 2

1. Click Add Column and select Action Column.
2. Search for and select Find Email using LinkedIn URL (Apollo).
3. Map the LinkedIn URL column as input.
4. Add a Run Condition: run only when both Email - BetterEnrich and Email - FullEnrich are empty.
5. Select Email as the output field.
6. Click Save.
7. Name the column Email - Apollo.

Step 5: Add Findymail as fallback 3

1. Click Add Column and select Action Column.
2. Search for and select Find Email Using LinkedIn URL (Findymail).
3. Map the LinkedIn URL column as input.
4. Add a Run Condition: run only when Email - BetterEnrich, Email - FullEnrich, and Email - Apollo are all empty.
5. Select Email as the output field.
6. Click Save.
7. Name the column Email - Findymail.

Step 6: Build the final email formula

1. Click Add Column and select Formula Column.
2. Enter the following formula:

IF(email_betterenrich != "", email_betterenrich,
  IF(email_fullenrich != "", email_fullenrich,
    IF(email_apollo != "", email_apollo,
      email_findymail
    )
  )
)

3. Name this column Final Email.

Use Copilot to build the waterfall (optional)

You can ask Copilot to configure this waterfall automatically:

1. Open a new table with a LinkedIn URL column.
2. Click Copilot in the sidebar.
3. Type: Find work emails using BetterEnrich, FullEnrich, Apollo, and Findymail in a waterfall. Use LinkedIn URL as input.
4. Copilot configures the columns and run conditions.
5. Review the setup and adjust if needed.

Run the table

1. Click Run All Rows.
2. Columns with run conditions execute only where needed. The first provider runs for all rows. Subsequent providers run only for rows where previous providers returned no result.
3. After completion, filter by Final Email is not empty to see your total coverage.

Expected coverage

Coverage varies by target industry, geography, and job function.

Troubleshooting

Run conditions are not being respected. All columns run for all rows. Verify the run condition references the exact column name used in the table. If you renamed a column after creating the condition, the condition may reference the old name. Open the column settings and update the condition.

The waterfall is too expensive for my budget. Use fewer fallback sources. For most use cases, BetterEnrich + one fallback provides 55 to 70% coverage at a lower cost. Add more sources only for priority lists where maximum coverage justifies the extra spend.

Two providers return different emails for the same contact. This can happen when providers have observed different email addresses for the same person. To determine which is valid, add a verification column using Verify Email (BetterEnrich) or another email verification action. Keep the email that passes verification.

Related articles

• Understand How Credits Work
• Understand Your TexAu Plan