Google Maps to Airtable lead scraper with GPT contact extraction from impressum

by SuS ✓ · 1,155 views · created 2025-08-28 · Lead Generation

What this workflow does

This AI workflow has 27 nodes and runs when another workflow calls it (plus 1 other trigger). Along the way it connects OpenAI Chat Model and Airtable. It also calls maps.googleapis.com over HTTP.

How it runs

Trigger: When another workflow calls it (plus 1 other trigger).

1. already scraped (Airtable): search
2. Airtable: search
3. Array all Companies scraped (Summarize): summarizes / groups the items
4. Filter: keeps only the items that match a condition
5. Searchword (Edit Fields (Set)): sets 1 field: Suchbegriff
6. Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
7. search Place (HTTP Request): calls maps.googleapis.com
8. Execute Workflow (Execute Sub-workflow): calls another n8n workflow
9. Split Out: splits a list into separate items
10. Airtable: create or update

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

Services it uses

OpenAI Chat ModelAirtable

HTTP calls to: maps.googleapis.com

Scraping pages by hand? Firecrawl is a simpler option (10% off for new users).

Before you upgrade to n8n 3.0

Nodes used (15)

• Split Outn8n-nodes-base.splitOut
• HTTP Requestn8n-nodes-base.httpRequest
• OpenAI Chat Model@n8n/n8n-nodes-langchain.lmChatOpenAi
• Edit Fields (Set)n8n-nodes-base.set
• Loop Over Items (Split in Batches)n8n-nodes-base.splitInBatches
• Waitn8n-nodes-base.wait
• HTMLn8n-nodes-base.html
• Execute Workflow Triggern8n-nodes-base.executeWorkflowTrigger
• Manual Triggern8n-nodes-base.manualTrigger
• Execute Sub-workflown8n-nodes-base.executeWorkflow
• Airtablen8n-nodes-base.airtable
• Filtern8n-nodes-base.filter
• Summarizen8n-nodes-base.summarize
• Ifn8n-nodes-base.if
• Information Extractor@n8n/n8n-nodes-langchain.informationExtractor

From the author

How it Works This workflow automates the process of discovering companies in different cities, extracting their contact data, and storing it in Airtable. 1. City Loop (Airtable → Google Maps API) - Reads a list of cities from Airtable. - Uses each city…

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