Qualify Google Maps leads with ScrapeHero, OpenAI, and Google Sheets
UnknownWhat this workflow does
This AI workflow has 16 nodes and runs manually, when you click “Execute workflow”. Along the way it connects OpenAI Chat Model, Google Sheets and Scrapehero (community).
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Set Google Maps Search Parameters (Code): runs custom JavaScript code
- Fetch Data via ScrapeHero (Scrape Hero): uses Scrape Hero
- Process Scraped Page (Code): runs custom JavaScript code
- If: checks a condition and branches into true / false
- Build Next Page URL (Code): runs custom JavaScript code
- Compile Final Results (Code): runs custom JavaScript code
- Split Listings Data (Split Out): splits a list into separate items
- Normalize Listing Data (Code): runs custom JavaScript code
- Remove Duplicate Listings (Code): runs custom JavaScript code
- AI Lead Enrichment (Basic LLM Chain): sends a prompt to an LLM, with model: OpenAI Chat Model; output parser: Structured Lead Output
…plus 3 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that n8n-nodes-scrapehero is verified or supports 3.0 (used in Fetch Data via ScrapeHero).
Nodes used (10)
- Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Manual Trigger
n8n-nodes-base.manualTrigger - Code
n8n-nodes-base.code - Scrape Hero
n8n-nodes-scrapehero.scrapeHero - If
n8n-nodes-base.if - Split Out
n8n-nodes-base.splitOut - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Merge
n8n-nodes-base.merge - Google Sheets
n8n-nodes-base.googleSheets
From the author
Quick overview This workflow manually scrapes Google Maps business listings via ScrapeHero, paginates through results, deduplicates and normalizes each listing, enriches each business with an OpenAI lead-qualification score, and appends the structured results…