This n8n workflow turns local business searches into a Leads list. It reads your Google Maps search criteria from Google Sheets, runs the Google Maps Scraper API actor on Apify once per search, and appends the best-matching places to a Leads tab.
Each row in the searches sheet has a search term, a city or location, an ideal_customer described in one sentence, and a status. Rows marked done are skipped. For every business returned, the workflow collects its phone, website, address, rating and reviews count.
The actor also adds AI verdicts for each place, so no LLM key is needed. The verdicts cover fit with your ideal customer (0 to 1), digital maturity, whether online booking is expected but missing, independent versus chain, size, and price tier.
- Platform
- n8n workflow
- Integrations
- Google Sheets, Apify (Google Maps Scraper API actor)
- Search inputs
- Search term, city/location, ideal_customer, status
- Place data
- Phone, website, address, rating, reviews count
- AI verdicts
- Fit with ideal customer (0 to 1), digital maturity, online booking expected but missing, independent vs chain, size, price tier
- AI key
- No LLM key needed
- Output
- Leads tab in Google Sheets, best fit first
- Search tracking
- Searches marked done with places scanned and leads found
- n8n nodes
- Set, sort, merge, filter, summarize, sticky note
- Use cases
- Agency prospecting by niche, validating lead lists, repeatable Google Maps lead generation