There are two traditional ways to get a lead list: pay a broker for a spreadsheet where half the numbers are disconnected, or spend a weekend copy-pasting from Google Maps like it is 2009. Both are bad trades for your money or your life.
What it does
You type a niche and a city into a sheet: dentists, Austin. The workflow hands the query to a scraper that walks Google Maps and pulls every listing, then the filters earn their keep: has a phone number, rated four stars or better, enough reviews to be a real operating business. The junk gets dropped. The survivors land back in your sheet with name, phone, website, rating, and address, sorted and ready to work.
Full disclosure: this is a small version of the same engine I use to find my own clients. It is the workflow this whole library is named after.
How it works
The sheet is the control panel. A trigger reads your query, an Apify actor does the actual Maps walking (that part is their specialty, and their free tier is generous), and a code step applies the quality filters before anything touches your results tab. Change the filters to match what qualified means in your world; they are three plain lines.
Setup
- Import the workflow file into your n8n instance.
- Create a free Apify account and add your API token to the marked node (the free monthly credit covers plenty of runs).
- Connect Google Sheets and copy the two-tab template from the workflow's note.
- Type a niche and a city into the input tab.
- Run it and pour a coffee; the results tab fills itself.
The template runs on n8n, any recent version, cloud or self-hosted. Every place that needs one of your accounts is marked with a note inside the workflow.
Get the workflow
Rather have this running in your business without touching a single node? That is the actual job. Write to hello@nurho.net or start with the ROI calculator to see if it is even worth automating.