Prospecting for local-business leads by hand is repetitive and inconsistent — copying names from maps and directories, checking duplicates, pasting into spreadsheets. It consumes hours every week and still produces incomplete, unscored lists.
What I built
Six n8n workflows running in production, one per niche (clinics, real estate, dentistry, gyms, law firms, aesthetics). Each one runs automatically every week on its own schedule and delivers a scored, deduplicated lead list without any manual step.
Multi-source scraping — Google Places and other public sources, per niche
Lead scoring — each lead is ranked so outreach starts with the best targets
Deduplication — no lead enters the base twice, across all sources and runs
Delivery — results written to a Notion CRM and Google Sheets, ready to work
Monitoring — every run posts a summary to Telegram, so failures never pass silently
How it works
Each niche has its own workflow with sources and scoring rules tuned to that market. Workflows run self-hosted on n8n, spread across different days of the week to balance load. Results land in Notion and Google Sheets in a consistent schema, and the Telegram summary reports how many leads came in, how many were new and whether anything failed.
Stack
n8n (self-hosted) · Google Places API · Notion · Google Sheets · Telegram
Want something like this?
I build production automation end to end, from discovery to deploy — including rescuing broken automations and migrating teams from Zapier/Make to n8n.