Skip to content
Menu
Home / Workflow

Build an enrichment waterfall with a cost ledger

Start with a unique contact record, query one provider, and move to the next only when the result fails your acceptance rule. Log what each stage returned and charged so the extra coverage has a visible cost.

The short answer

Start with a unique contact record, query one provider, and move to the next only when the result fails your acceptance rule. Log what each stage returned and charged so the extra coverage has a visible cost.

01Normalize the input02Define acceptance before calling a provider03Query the first provider04Stop or continue05Write and reconcile

1. Normalize the input

Store a stable record ID, company domain, person name and any existing address. Lowercase domains and addresses; preserve the original values for audit. Decide whether the unique key is a CRM record or a person-domain pair.

2. Define acceptance before calling a provider

Choose the fields and statuses required for a usable output. Keep confirmed, catch-all and unknown addresses separate. A provider response is not automatically an accepted result.

3. Query the first provider

Keep the API credential in the platform’s credential store. Log request ID, provider, returned fields, result status and billable amount. On a timeout, use a bounded retry path rather than immediately charging another provider.

4. Stop or continue

Stop when the output meets the acceptance rule. Call the next provider only for unresolved records. Use an idempotency key so a replay does not create duplicate CRM records or repeat a successful charge.

5. Write and reconcile

Store the chosen address, provider, source date and verification state in the CRM. Route uncertainty to review. Reconcile the ledger with supplier usage before estimating the next run.

Download the implementation spec

This JSON describes the fields, stop conditions and cost ledger. It is a platform-neutral specification, not an importable n8n workflow.

Download waterfall spec (JSON)

Questions buyers ask

What is waterfall enrichment?

It is a sequence of data-provider requests that stops when the record meets an acceptance rule. Its value comes from incremental usable results on records earlier providers could not complete.

How do you calculate waterfall cost?

Add the actual billable charges from every attempted stage, plus the allocated platform cost. Divide by accepted unique records, not by all responses or uploaded rows.

Keep comparing

Sources and verification

Implementation documentation

n8n webhook documentation · n8n Code node