Be one of our first users and enjoy an exclusive 50% lifetime discount. Learn more

Waterfall

Waterfall is a sequential enrichment system. Instead of relying on a single provider to find data, you define a chain of enrichment steps — and the system runs each one in order until it finds a result. As soon as one step returns data, the sequence stops and the result is stored. This saves credits by only running further steps when earlier ones fail to find anything.

A common use case is finding a person's work email: you might try Enrow first, then Hunter, then Findymail, then Leadmagic — and the waterfall stops at whichever one finds the email first.

The result of the waterfall is stored in a single output column in your table. Each individual enrichment step also gets its own column showing its result.

How to access Waterfall

There are two ways to create a waterfall column from the Enrich panel:

  1. Create a blank waterfall — On the left side of the Enrich panel, click the waterfall icon the blue "+". This opens an empty waterfall sequence where you build your own chain of steps from scratch.

  2. Use a pre-built waterfall — Browse to "Person attributes" or "Company attributes" in the Enrich panel. Each attribute (e.g. Work email, Personal email, Phone number) contains a list of options including both single providers and pre-configured waterfalls. Select a pre-built waterfall to open it with a recommended sequence already set up, which you can then customise.

Add an action (enrichment step)

Each step in the waterfall sequence is an enrichment action from a specific provider. Click "Add action" to open the action picker and choose from available providers such as Enrow, Hunter, Findymail, Rocketreach, Leadmagic, Prospeo, Datagma, Wiza, Apollo, People Data Labs, or a Custom API integration.

Once you select a provider, configure its step:

  1. Account — Select the API key connection to use for this provider.
  2. Output — Define the output route: the field from the provider's response that should be treated as the result of this step (e.g. the email address field). This is either predefined by the system or set by you.
  3. Run next step if this formula resolves to true — Set the condition that determines when to move on to the next step. If the formula resolves to false, the sequence stops.
  4. Map inputs — Map your table columns to the fields the provider needs. Required fields (marked with a red asterisk) must be filled. For example: Person's full name, Company website URL, Company LinkedIn URL, Person's location.
  5. Click "Save" to add the step to the waterfall sequence.

Waterfall output column

The waterfall creates a main output column in your table that automatically pulls the result from whichever step in the sequence successfully found data. This column uses a formula generated by the system — not written by the user — that checks each step's output route in order and returns the first non-empty result. You do not need to configure this column manually.

Run only if this formula resolves to true

At the waterfall level, you can set a condition that controls whether the entire sequence runs for a given row. If the formula resolves to false, the waterfall is skipped entirely for that row. Describe the condition in plain language and click "Generate", or write your own expression and click "Test".

Auto-update

When enabled, the waterfall sequence will automatically re-run for a row whenever its input data changes. When disabled, re-runs must be triggered manually.

Save as recipe

You can save your waterfall configuration as a reusable recipe. Click "Save recipe" and give it a name and description. Saved recipes appear in the enrichment panel under "Waterfall" and can be applied to other tables, saving you from reconfiguring the same sequence from scratch.

Edit recipe settings

To update a saved recipe, open the waterfall panel and click "Edit recipe". From here you can update the recipe name, description, and the full waterfall sequence including its steps, formulas, and settings.

Waterfall columns

When a waterfall is created, it adds a set of columns to your table — one for the waterfall itself, one for each enrichment step in the sequence, and one final formula column that holds the result.

  • Waterfall column — The first column represents the overall waterfall run. It shows whether the sequence is complete ("Run complete") or still processing ("Loading"). Clicking this column header opens a dropdown where you can Rename, Edit, Change color, Filter on this column, Hide, or Delete the waterfall.
  • Step columns — Each enrichment provider in the sequence gets its own column (e.g. Hunter, Enrow, Findymail). These show the status of that individual step for each row. Clicking a step column header opens the same dropdown: Rename, Edit, Change color, Filter on this column or Hide.
  • Result formula column — The last column in the sequence (e.g. "Person work email") is a formula column automatically generated by the system. It checks each step's output route in order and pulls the result from whichever step successfully found data. You do not need to configure or write this formula manually.

Table of content:

line background

Learn from the best in our private Slack community.

Join a network of industry leaders and gain exclusive insights, tips, and strategies.

Join community