Google Maps lead scraper & enrichment with AI-powered personalized outreach

by A Z ✓ · 5,376 views · created 2025-07-17 · Lead Generation, Multimodal AI

What this workflow does

This AI workflow has 21 nodes and runs manually, when you click “Execute workflow” (plus 1 other trigger). Along the way it connects Google Sheets and OpenAI Chat Model. It also calls api.apify.com and api.firecrawl.dev over HTTP.

How it runs

Trigger: Manually, when you click “Execute workflow” (plus 1 other trigger).

1. HTTP Request: calls api.apify.com (POST)
2. Filter: keeps only the items that match a condition
3. Filter: keeps only the items that match a condition
4. Filter: keeps only the items that match a condition
5. Batch Processing Logic (Loop Over Items (Split in Batches)): loops over the items in batches
6. Edit Fields (Edit Fields (Set)): sets 18 fields: title, categoryName, city…
7. Edit Fields (Edit Fields (Set)): sets 6 fields: title, street, city…
8. Edit Fields (Edit Fields (Set)): sets 5 fields: Title, Website, City…
9. Filter: keeps only the items that match a condition
10. Append or update row in sheet (Google Sheets): append or update

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

Services it uses

Google SheetsOpenAI Chat Model

HTTP calls to: api.apify.com, api.firecrawl.dev

Before you upgrade to n8n 3.0

Nodes used (10)

• Manual Triggern8n-nodes-base.manualTrigger
• HTTP Requestn8n-nodes-base.httpRequest
• Edit Fields (Set)n8n-nodes-base.set
• Loop Over Items (Split in Batches)n8n-nodes-base.splitInBatches
• AI Agent@n8n/n8n-nodes-langchain.agent
• Google Sheetsn8n-nodes-base.googleSheets
• Coden8n-nodes-base.code
• Filtern8n-nodes-base.filter
• OpenAI Chat Model@n8n/n8n-nodes-langchain.lmChatOpenAi
• Google Sheets Triggern8n-nodes-base.googleSheetsTrigger

From the author

⚡ Quick Setup - Import this workflow into your n8n instance. - Add your Apify, Google Sheets, and Firecrawl credentials. - Activate the workflow to start your automated lead enrichment system. - Copy the webhook URL from the MCP trigger node. - Connect AI…

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