Qualify Google Maps B2B Leads in n8n with Apify & Google Sheets

Qualify Google Maps B2B Leads automatically in n8n using Apify + Google Sheets

Turn local business searches into a ready-to-use Leads list. This n8n workflow reads your Google Maps search criteria from Google Sheets, runs the Google Maps Scraper API on Apify, then appends the best-matching places to a Leads tab—with AI verdicts and no LLM key needed.

What this workflow does

• Reads searches from a Google Sheet: each row includes search term, city/location, and an ideal_customer in one sentence, plus a status. Rows marked done are skipped.
• Runs Apify’s Google Maps Scraper API actor once per search.
• Collects rich place data for every returned business: phone, website, address, rating, and reviews count.
• Adds AI verdicts per place directly from the actor: fit with your ideal customer (0 to 1), digital maturity, whether online booking is expected but missing, independent vs chain, size, and price tier—without wiring an LLM key.
• Filters and ranks leads by your minimum fit (and when there’s no ideal customer, it keeps all places), then attaches each place to its originating search.
• Appends results to a Leads tab, best fit first.
• Marks searches as done with places scanned and leads found, so you can add searches over time and re-run safely.

Use cases

• Agencies prospecting local B2B companies by niche (e.g., “dentists in Austin” + ideal customer description).
• SaaS operators validating lead lists from Google Maps with consistent AI qualification.
• Automation engineers building repeatable Google Maps lead generation workflows using Apify and Sheets.

Technical details

• Google Sheets integration: Read searches, Append leads to a Leads tab, Mark searches as done.
• Apify: Google Maps Scraper API actor for place and AI verdict outputs.
• n8n nodes used: set, sort, merge, filter, summarize, and sticky note to structure the qualification and output.