GOHIGHLEVEL ANSWERS & PROMPTS: PLAYBOOK T49 · PAY-PER-USE LEAD ENRICHMENT WATERFALL & JSON DEFAULTS
AUTHOR: DANIEL HALLMAN
KEYWORD: ENRICHMENT WATERFALL
PLAYBOOK T49 · Pay-Per-Use Lead Enrichment Waterfall & JSON Defaults KEYWORD: ENRICHMENT WATERFALL

How Do You Build a Pay-Per-Use Lead Enrichment Waterfall in n8n and GoHighLevel Without 4 Monthly API Subscriptions?

Answer: When an agency only enriches 50 to 100 domains twice a month, paying four separate monthly API subscriptions wastes budget and crashes downstream steps whenever a small business has no X account or returns empty JSON fields. Cache lookup timestamps in GoHighLevel Settings > Custom Fields so you never pay twice for the same domain, set HTTP Request nodes to Continue on Error with default empty strings in a single Format Data / Set step, and use an If/Else waterfall so paid email APIs only run when the contact email is still blank.

STEP-BY-STEP INSTRUCTIONS + ANNOTATED GHL SCREENSHOTS

Steps in GoHighLevel

  1. STEP 1
    In Settings > Custom Fields, create contact fields for Enrichment Status (Pending, Complete), Last Enriched Date, and social URLs so GoHighLevel caches completed domains and skips any lead enriched within the last 30 days.
    REAL GHL SCREEN · SETTINGS > CUSTOM FIELDS ANNOTATED GHL SCREENSHOT
    Annotated GoHighLevel Custom Fields screenshot showing Settings > Custom Fields menu, Contact/Opportunity/Company object filters, and + Create field button
    1Open Settings > Custom Fields 2Filter by Contact or Opportunity Object 3Click + Create Field
  2. STEP 2
    In Automation > Workflow Builder (and your n8n HTTP Request nodes), enable Continue (using error output) on social lookups, normalize missing values to empty defaults ({{ $json.x_handle ?? '' }}) in one Format Data / Set step, and add an If/Else waterfall that calls pay-per-use email enrichment only when the email field is still blank.
    REAL GHL SCREEN · AUTOMATION > WORKFLOW BUILDER CANVAS ANNOTATED GHL SCREENSHOT
    Annotated GoHighLevel Workflow Builder canvas screenshot showing If/Else condition branch, priority routing steps, and Builder/Settings/Execution logs tabs
    1Add If/Else Condition & Tag Guard 2Chain Priority & Wait Steps 3Switch to Settings or Execution Logs
  3. STEP 3
    In Automation > Workflow > Execution Logs, save each enriched contact's status as Complete immediately after lookup so if a batch stops mid-run, re-enrolling Pending contacts only retries the remaining domains.
    REAL GHL SCREEN · WORKFLOW > EXECUTION LOGS ANNOTATED GHL SCREENSHOT
    Annotated GoHighLevel Workflow Execution Logs screenshot showing Execution logs tab, All actions and All statuses filters, and populated contact run rows
    1Open Execution Logs Tab 2Filter by Action Type or Status 3Search Contact to Trace Runs
MODE: AGENT PROMPT
PASTE INTO CLAUDE CODE, CURSOR, CHATGPT, OR GOHIGHLEVEL ASK AI AGENT PROMPT
Build a cached pay-per-use lead enrichment waterfall in sub-account <YOUR_LOCATION_ID>:
1. In Settings > Custom Fields, create Enrichment Status (Pending, Complete) and Last Enriched Date fields on the Contact object.
2. In Automation > Workflow Builder, filter out contacts enriched in the last 30 days, normalize empty social fields with Format Data, and use an If/Else branch to trigger outbound pay-per-use webhook lookups only when Email or Phone is blank.
3. In Automation > Workflow > Execution Logs, mark Enrichment Status as Complete on each returned webhook payload so retries only run on Pending contacts.
Cause
  • Chaining four enrichment APIs in n8n or GoHighLevel creates two problems for low-volume batches: fixed monthly API plans sit idle 95% of the month
  • and smaller local business websites without social profiles return null fields that break downstream nodes and force you to re-run the entire paid batch from row one.
GoHighLevel Configuration
  • Store Enrichment Status and Last Enriched Date in Settings > Custom Fields, normalize missing JSON fields with default empty strings in Automation > Workflow Builder (and n8n Edit Fields)
  • and check Automation > Workflow > Execution Logs so retries only process rows where Enrichment Status is still Pending.
MENU PATH REFERENCE

GoHighLevel Menu Paths

Step Menu Path in GHL Action
Step 1 Settings > Custom Fields Create contact fields for Enrichment Status (Pending, Complete), Last Enriched Date, and social URLs so GoHighLevel caches completed domains and skips any lead enriched within the last 30 days.
Step 2 Automation > Workflow Builder Enable Continue (using error output) on social lookups, normalize missing values to empty defaults ({{ $json.x_handle ?? '' }}) in one Format Data / Set step, and add an If/Else waterfall that calls pay-per-use email enrichment only when the email field is still blank.
Step 3 Automation > Workflow > Execution Logs Save each enriched contact's status as Complete immediately after lookup so if a batch stops mid-run, re-enrolling Pending contacts only retries the remaining domains.
3-step diagram showing Cache lookup dates skipping domains enriched within 30 days, Default empty fields continuing on missing social profiles, and Conditional paid lookup calling paid APIs only when blank.
VISUAL PLAYBOOK · PLAYBOOK T49 (PAY-PER-USE LEAD ENRICHMENT WATERFALL & JSON DEFAULTS) Back to Annotated GHL Screenshots ↑
DEFAULT SETUP VS. AUTOMATED WORKFLOW

Operational Comparison

Speed to Lead & Callback Safety
Default 0s Checkbox: Collides with Rep
45s Guard Workflow: Zero Collision
Caller Reply & Booking Rate
Generic 'We Missed You' SMS: 12%
Question-First Workflow SMS: 64%

Related Questions

BUILD FASTER IN GOHIGHLEVEL · FREE TRIAL BONUSES + MCP SERVER

Build this directly inside your GoHighLevel sub-account

Connect Claude Code, Cursor, or OpenAI Codex to our ghl-tools MCP Server & Rust CLI to build workflows, forms, and funnels from your editor, or start your GoHighLevel plan through our partner link to unlock $612+ in ready-to-import kits (including GHL & n8n Pay-Per-Use Enrichment Waterfall Pack) and weekly live clinics.