Qualify Google Maps Leads in n8n: ScrapeHero + OpenAI + Sheets

Turn Google Maps searches into qualified leads—automatically

This n8n workflow scrapes Google Maps business listings with ScrapeHero, uses OpenAI to generate lead-qualification scores from each listing, and appends the enriched results into Google Sheets—one qualified business per row.

What this workflow does

• Runs on demand: start the workflow manually in n8n.
• Scrapes Google Maps listings via ScrapeHero: sends your configured Google Maps search query to ScrapeHero.
• Paginates through results: repeatedly follows the returned next-page URL until pagination ends or your configured max page limit is reached.
• Normalizes and deduplicates: combines results from all pages, splits them into individual businesses, normalizes key Google Maps fields, and removes duplicate listings.
• Qualifies each lead with OpenAI: for every unique listing, sends the listing details plus your targetService description to OpenAI (Chat Model: gpt4o-mini by default or another model you have access to).
• Flattens structured output: merges original Google Maps data with the AI response and parses it into a single flattened record (including a structured lead-qualification result such as score, quality/fit, and recommended action).
• Appends to Google Sheets: writes one enriched business lead per row to your specified worksheet tab.

Use cases

• Generate a qualified Google Maps lead list for local services (e.g., agencies, contractors, vendors) without manual research.
• Feed sales or outreach tools indirectly by maintaining a continuously updated Google Sheets pipeline.
• Test and iterate lead-fit criteria using different targetService descriptions and AI scoring prompts.

Technical details

• ScrapeHero: Google Maps Search API with pagination support.
• OpenAI: Chat Model (default gpt4o-mini) to produce structured lead qualification.
• Google Sheets: appends enriched rows to your spreadsheet using provided document URL/ID and sheet tab.
• n8n nodes referenced in the workflow: if, code, merge, split out plus supporting nodes like sticky note.

Setup requirements

• Add ScrapeHero credentials and ensure the Google Maps Search API is enabled.
• Add an OpenAI credential for the Chat Model (or change the model).
• Add Google Sheets credentials and set spreadsheet/worksheet details.
• Update search-config values: Google Maps search text, targetService, and maxPages.