Lead Generation Engine Pro

Who is this for?

You run sales building local prospect lists from 4 zip sweeps on manual run, and this GMaps Sheets workflow queries, dedupes and fills rows. Each sweep needs Maps searched, names and addresses copied, and duplicates removed.

What problem does this solve?

You search Maps, copy names and addresses into Sheets, then remove duplicates. When you run it manually, the flow queries the GMaps API by zip and subcategory, dedupes, and appends rows. You just dispatch fresh rows for calling instead of searching each zip yourself.

What this workflow does

1. GMaps API (HTTP API)
2. Update Status to Success (Google Sheets)
3. Add rows in Google Sheets (Google Sheets)
4. GS - Get Subcategory (Google Sheets)

How it works

You run it manually from the n8n editor → Settings, GS - Get Zip Codes, Zips, ending in Split Out.

Setup

1. Open danielgrey.shop/app/templates/dg-0005 → Copy JSON → n8n → Import from Clipboard (or Push to n8n)
2. Connect credentials: Google, Google Sheets
3. Run once manually to verify each branch — it imports clean and goes green first try — then a 10-minute review and activate.

Requirements

- n8n 1.50.0 or later
- Credentials for Google, Google Sheets
- One-time $119 — yours forever, Pro unlocks it too.

Customising

- Tune the logic inside Exponential Backoff — thresholds and weights are plain code with comments.
- Adjust the branch condition in Check Max Retries1 to match your own cutoff.