All work

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.

6
connected workflows
146
n8n nodes
9
gates before anyone gets emailed
95%
AI confidence bar to approve a lead
24/7
runs on its own

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.

01 Find

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

02 Verify

Prove no website

Verify Leads every 5 min

  • 7 Google searches
  • Up to 20 domain probes
  • Claude scores confidence

→ Leads or Call List

03 Reach out

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

04 Catch replies

Sort every reply

Reply Catcher every 10 min

  • Reply, unsub, OOO or bounce
  • Pings my phone on replies
  • Auto pause on bounces

→ status replied

05 Close

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.

VerificationLeadsCall ListPipelineSettings

Under the hood

Who touches what.

Sheet access by workflow

Pulled straight from the workflow files.

VerificationLeadsCall ListPipelineSettings
Scrape Sources
Import Leads
Verify Leads
Send Outreach
Reply Catcher
CRM
Reads Writes Both

Nine gates before an email goes out

Each gate removes leads. Only businesses that pass all nine get contacted.

Scrape Maps, Yelp, Indeed18 x 21 matrix
Is a real trade, not a salonregex filter
10+ reviews, 3.8+ starsquality
No real website listeddirectory check
Not already in any tabdedupe
Google Business Profile linkslayer 4
7 Google searchesSerper API
Domain guesses probedup to 20
Claude judge95+ only
Approved lead→ outreach

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.

5Week 1
10Week 2
15Week 3
20Week 4+

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.

TriggerGoogle SheetsAPI callClaude AIGmailCodeLogic / loopWait

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
Every node and connection from the real n8n file. Drag to explore.
Schedule: Daily 5AMSchedule: Daily5AMBuild Search MatrixBuild SearchMatrixRoute BranchRoute BranchScrape Google Maps BusinessesScrape GoogleMaps BusinessesWait For ActorWait For ActorCheck Actor StatusCheck ActorStatusIs Actor DoneIs Actor DoneFetch Actor DatasetFetch ActorDatasetShape Maps LeadsShape Maps LeadsCombine LeadsCombine LeadsAdd Dedupe KeysAdd Dedupe KeysRead Leads TabRead Leads TabRead Call List TabRead Call ListTabRead Verification TabRead VerificationTabDedupe Against SheetsDedupe AgainstSheetsDedupe CompleteDedupe CompleteRoute by SourceRoute by SourcePrep Verification RowsPrep VerificationRowsAppend to VerificationAppend toVerificationRoute by Contact InfoRoute by ContactInfoPrep Leads RowsPrep Leads RowsAppend to LeadsAppend to LeadsCap Enrichment (Test Mode)Cap Enrichment(Test Mode)Enrich CompleteEnrich CompleteRoute EnrichedRoute EnrichedPrep Leads Rows (Enriched)Prep Leads Rows(Enriched)Append to Leads (Enriched)Append to Leads(Enriched)Prep Call List Rows (Enriched)Prep Call ListRows (Enriched)Append to Call List (Enriched)Append to CallList (Enriched)Enrich Website ContactsEnrich WebsiteContactsMerge Enriched ContactsMerge EnrichedContactsLoop Over EnrichmentLoop OverEnrichmentPrep Call List RowsPrep Call ListRowsAppend to Call ListAppend to CallListScrape Indeed JobsScrape IndeedJobsShape & Filter Job LeadsShape & FilterJob LeadsLookup Business on Google MapsLookup Businesson Google MapsShape Google Places LeadShape GooglePlaces LeadLoop Over Indeed LeadsLoop Over IndeedLeadsScrape Yelp BusinessesScrape YelpBusinessesShape Yelp LeadsShape Yelp LeadsSet Leads Source HeaderSet Leads SourceHeaderSet Call List Source HeaderSet Call ListSource Header

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
n8nClaude Haiku 4.5Google SheetsGmail APIGoogle DriveApifySerper search APIPageSpeed Insights APIGoogle DNSJavaScript

Want a system like this?

Lead gen, follow ups, scheduling, intake. If you do it by hand every day, it can run itself.