Extract local business contacts with Google Sheets, SerpAPI, Apify & GPT-4o
UnknownUnknown. This template uses community nodes we can't verify statically. Uses community nodes that can't be verified statically (unverified community packages are off by default in 3.0). Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 15 nodes and runs manually, when you click “Execute workflow”. Along the way it connects OpenAI Chat Model, Google Sheets and Serpapi (community).
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Extract Search Terms (Google Sheets): uses Google Sheets
- Keep Unprocessed Rows (Filter): keeps only the items that match a condition
- Filter to first row (Code): runs custom JavaScript code
- Mark Row as Completed (Google Sheets): append or update
- Search Google Maps (Serp Api): google maps
- Format output as table (Code): runs custom JavaScript code
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Save Emails to Sheet (Google Sheets): append or update
- Reduce to 1 row (Summarize): summarizes / groups the items
- Scrape Web Page (HTTP Request): calls an HTTP API (POST)
…plus 2 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-serpapi is verified or supports 3.0 (used in Search Google Maps).
Nodes used (12)
- Manual Trigger
n8n-nodes-base.manualTrigger - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Execute Sub-workflow
n8n-nodes-base.executeWorkflow - Google Sheets
n8n-nodes-base.googleSheets - Filter
n8n-nodes-base.filter - Code
n8n-nodes-base.code - Serp Api
n8n-nodes-serpapi.serpApi - HTTP Request
n8n-nodes-base.httpRequest - AI Agent
@n8n/n8n-nodes-langchain.agent - Summarize
n8n-nodes-base.summarize
From the author
Extract Local Business Contacts with Google Sheets, SerpAPI & GPT‑4o Status: Ready for Use ✅ Disclaimer: This workflow relies on community nodes that are not part of n8n’s core package. Install the following from n8n → Community Nodes before running: -…