Work / Automation / n8n
Lead Gen Automation. Finds, verifies and emails local businesses while I sleep.
Six n8n workflows and one Google Sheet. It scrapes contractors with no website, proves they really have none, writes each one a personal email with Claude, sorts the replies and hands me a call list every morning. I built it to run my own business. The same kind of system can run yours.
The film / 57 seconds, no sound needed
One fictional lead travels through all six workflows. Every node, rule and column shown comes from the real workflow files.
How it works
Five stages, one source of truth.
Every workflow reads and writes the same Google Sheet, so each one picks up exactly where the last one left off.
Scrape + import
Scrape Sources daily 5 AMImport Leads on CSV drop
- Google Maps, Yelp, Indeed via Apify
- 18 trades x 21 towns
- No site, 10+ reviews, 3.8+ stars
→ Verification queue
Prove no website
Verify Leads every 5 min
- 7 Google searches
- Up to 20 domain probes
- Claude scores confidence
→ Leads or Call List
Personal emails
Send Outreach weekdays 9 AM
- Grades their current site
- Claude writes from real data
- 3 touch sequence, same thread
→ sent_1, sent_2, done
Sort every reply
Reply Catcher every 10 min
- Reply, unsub, OOO or bounce
- Pings my phone on replies
- Auto pause on bounces
→ status replied
Pipeline + digest
CRM every 2 hrs + 8 AM
- Replies and good calls become deals
- Next action + due date
- Morning follow up email
→ I call and close
RLD Leads sheet
The shared brain. Every workflow syncs through it.
Under the hood
Who touches what.
Sheet access by workflow
Pulled straight from the workflow files.
| Verification | Leads | Call List | Pipeline | Settings | |
|---|---|---|---|---|---|
| Scrape Sources | |||||
| Import Leads | |||||
| Verify Leads | |||||
| Send Outreach | |||||
| Reply Catcher | |||||
| CRM |
Nine gates before an email goes out
Each gate removes leads. Only businesses that pass all nine get contacted.
Outreach
AI copy that reads like a local guy typed it.
Claude writes every email from the lead's real data. A code check then rejects anything with dashes, links, spam words or too many words, and gets one rewrite before the lead is skipped.
Email 1, no website case
To: Example Roofing
Subject: question about example roofing
Hi Example Roofing team,
Saw you have a 4.8 rating from 63 reviews on Google but your listing only links to a Facebook page.
People searching for a roofer in Stafford tap the places with a real website first.
I can put together a free mockup of what a site for Example Roofing could look like, no cost and no strings.
Want me to send it over?
Ron
Ron Lenser Digital
Illustration with a made up business, written to the live prompt's rules
The sequence
Day 0
Specific observation + free mockup offer
Day 3
New angle, replies in the same thread
Day 7
Short last note, then it stops
Daily send ramp
Volume grows by week so the inbox builds trust. Hard ceiling of 25 a day.
Guardrails
Built to protect the inbox and the brand.
Kill switch
One cell in the Settings tab pauses every send. Outreach checks it before doing anything.
Bounce auto pause
Two bounces in one day flips the kill switch on its own and emails me to check the list.
Email validation
Format check, blocks role and disposable addresses, then a live MX lookup before sending.
Human timing
Random 0 to 45 min start each morning and a random 1 to 3 min gap between emails.
Copy quality gate
No links, no dashes, no spam words, under 90 words. Fails get one rewrite, then skip.
Opt outs honored
Every email has an opt out line and mailing address. Stop replies end the sequence for good.
Node for node
Every workflow, rebuilt from the source.
Drawn from the actual n8n export files. Credentials, sheet IDs and email addresses are stripped.
Scrape Sources
Daily at 5 AM · 44 nodes
Pulls local contractors from Google Maps, Yelp and Indeed through Apify, then keeps only real trades with 10+ reviews, a 3.8+ rating and no real website.
- Rotating search matrix: 18 trades x 21 Virginia towns, picks up where yesterday stopped
- Up to 1,500 Maps places per run, polled async until the scraper finishes
- Drops salons, closed shops, low ratings and anyone with a real site
- Dedupes against every tab by phone, name + city and email
- Survivors land in the Verification queue as pending
Division of labor
It does the grind. I do the talking.
The engine
- Scans up to 1,500 Maps listings a day for prospects
- Checks each one has no website, nine ways
- Writes and sends personal emails and follow ups
- Reads replies, handles unsubscribes and bounces
- Builds the pipeline and my morning to do list
Me
- Answer replies and send the free mockup
- Call the phone only leads on the Call List
- Run the meeting and close the deal
- Tune prompts, filters and targets as results come in
Want a system like this?
Lead gen, follow ups, scheduling, intake. If you do it by hand every day, it can run itself.