Scrape business leads from Google Maps using OpenAI and Google Sheets
n8n template #3443Summary
Use templateGoogle Maps Data Extraction Workflow for Lead Generation This workflow is ideal for sales teams, marketers, entrepreneurs, and researchers looking to efficiently gather detailed business information from Google Maps for: Lead generation Market analysis Competitive research Who Is This Workflow For? Sales professionals aiming to build targeted contact lists Marketers looking for localized business data Researchers needing organized, comprehensive business information Problem This Workflow Solves Manually gathering business contact details from Google Maps is: Tedious Error-prone Time-consuming This workflow automates data extraction to increase efficiency, accuracy, and productivity. What Thi
How to set it up
- Open template #3443 on n8n.io and click Use for free, or copy the template JSON and paste it onto an empty canvas in n8n.
- Create 3 credentials under Credentials → Add credential: Google Sheets, OpenAI Chat Model, SerpApi (Google Search). Then open each of those nodes and pick the credential.
- Check the model in the AI Agent node. The template may point at a model your account can't use; swap it for one you have access to.
- Click Execute workflow and step through each node's output to confirm the data looks right.
- Toggle the workflow to Active so its trigger runs on its own.
Hand off to your agent
Prompt
Help me set up the n8n workflow "Scrape business leads from Google Maps using OpenAI and Google Sheets" (https://n8n.io/workflows/3443). It uses: Google Sheets, HTTP Request, AI Agent, OpenAI Chat Model, Simple Memory, SerpApi (Google Search), Call n8n Workflow Tool. Import the template JSON into my n8n instance, list every credential I need to create, and walk me through testing it.
Paste into Claude Code and it will do the rest.
Apps and nodes
Google SheetsHTTP RequestAI AgentOpenAI Chat ModelSimple MemorySerpApi (Google Search)Call n8n Workflow Tool
Questions
Yes. Dr. Firas published it free on n8n.io as a verified creator, and it has 44K views. It runs on n8n Cloud or a self-hosted n8n instance.
Google Sheets, OpenAI Chat Model, SerpApi (Google Search). The other 4 nodes are built into n8n.
Similar workflows
NameViews
- Explore n8n Nodes in a Visual Reference Library5,197
- ✨🩷Automated Social Media Content Publishing Factory + System Prompt Composition55K
- Automate social media content with AI for Instagram, Facebook, LinkedIn & X16K
- Automate SEO blog content creation with GPT-4, Perplexity AI and WordPress6,949
- Automate SEO blog creation + social media with GPT-4, Perplexity and WordPress5,798
- Build Your First AI Data Analyst Chatbot134K
- Create a Branded AI-Powered Website Chatbot88K
- AI web researcher for sales69K