Generate and score Google Maps leads with Gemini, Apify, and Google Sheets

by iamvaar ✓ · 364 views · created 2026-07-13 · Lead Generation, AI Chatbot

What this workflow does

This AI workflow has 16 nodes and runs when a chat message arrives. Along the way it connects Google Sheets. It also calls generativelanguage.googleapis.com over HTTP.

How it runs

Trigger: When a chat message arrives.

1. Parse Search Intent (HTTP Request): calls generativelanguage.googleapis.com (POST)
2. Set Search Parameters (Edit Fields (Set)): sets 4 fields: business_type, location, max_results…
3. Scrape Google Maps via Apify (HTTP Request): calls an HTTP API (POST)
4. Select Lead Fields (Edit Fields (Set)): sets 10 fields: placeId, title, category…
5. Deduplicate by Place ID (Remove Duplicates): removes duplicate items
6. Merge Scraped Leads (Aggregate): combines items into one
7. Score and Rank Leads (HTTP Request): calls generativelanguage.googleapis.com (POST)
8. Prepare Scored Leads (Edit Fields (Set)): sets 1 field: leads
9. Split Leads Array (Split Out): splits a list into separate items
10. Read Leads from Sheet (Google Sheets): uses Google Sheets

…plus 5 more steps. See the full node list below.

Services it uses

Google Sheets

HTTP calls to: generativelanguage.googleapis.com

Before you upgrade to n8n 3.0

Nodes used (8)

• Chat Trigger@n8n/n8n-nodes-langchain.chatTrigger
• HTTP Requestn8n-nodes-base.httpRequest
• Edit Fields (Set)n8n-nodes-base.set
• Remove Duplicatesn8n-nodes-base.removeDuplicates
• Aggregaten8n-nodes-base.aggregate
• Split Outn8n-nodes-base.splitOut
• Google Sheetsn8n-nodes-base.googleSheets
• Coden8n-nodes-base.code

From the author

Quick overview Youtube Video:https://youtu.be/NGruDecKxAg?si=ot9pj6IN4IoLstow This workflow takes a chat-based search request, scrapes matching businesses from Google Maps using Apify, scores and ranks them with Google Gemini, deduplicates against an existing…

View the original on n8n.io → Check your own copy