Skip to content
FlowHubFluxonLab
A
AI Automationfree

Scrape business leads from Google Maps using OpenAI and Google Sheets

by Dr. Firasadapted from n8n official workflow galleryUpdated Aug 2026
RequiresAAI AgentCall n8n Workflow ToolCall n8n Workflow ToolGoogle SheetsGoogle SheetsHTTP RequestHTTP RequestOpenAI Chat ModelOpenAI Chat ModelSerpApi (Google Search)SerpApi (Google Search)SSimple Memory
Share Post Share
ChTrigger - When User Sends MessageTrigger - When …AgAI Agent - Lead CollectionAI Agent - Lead…GPT-4o - Generate & Process RequestsGPT-4o - Genera…MBMemory - Track Recent ContextMemory - Track …TWTool - Scrape Google Maps Business DataTool - Scrape G…TSFallback - Enrich with Google SearchFallback - Enri…TWTool - Crawl Business WebsiteTool - Crawl Bu…EWTrigger - On Subworkflow StartTrigger - On Su…HRScrape Google Maps (via Apify)Scrape Google M…Save Extracted Data to Google SheetsSave Extracted …AgAggregate Business ListingsAggregate Busin…HRScrape Website Content (via Apify)Scrape Website …Save Website Data to Google SheetsSave Website Da…AgAggregate Website ContentAggregate Websi…123456
1/5
FLOWS
STEPS · 6
Starts from a chat message

Google 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 This Workflow Does Automates extraction of business data (name, address, phone, email, website) from Google Maps Crawls and extracts additional website content Integrates OpenAI to enhance data processing Stores structured results in Google Sheets for easy access and analysis Uses Google Search API to fill in missing information Setup Import the provided n8n workflow JSON into your n8n instance. Set your OpenAI and Google Sheets API credentials.

Tags

n8nreference-onlyagentgoogle-sheetslm-chat-open-aimemory-buffer-windowtool-serp-apitool-workflow
Connects
AAI Agentcalln8nworkflowtoolCall n8n Workflow ToolsheetsGoogle SheetsWHTTP RequestopenaichatmodelOpenAI Chat ModelserpapigooglesearchSerpApi (Google Search)
CategoryAI Automation
Triggermanual
Complexitycomplex
Nodes14
AddedApr 5, 2025

Related workflows

See all AI Automation
Acalln8nworkflowtoolCdhl
free

Summarize Zoom meetings and create follow-ups with OpenAI, ClickUp, and Outlook

Quick overview This workflow pulls the transcript and participant list from a recent Zoom meeting, uses OpenAI to generate formal meeting minutes, emails the summary via SMTP, and runs an AI agent that creates ClickUp tasks and (when details exist) schedules a follow-up meeting in Microsoft Outlook Calendar. How it works Starts when you manually run the workflow. Fetches your scheduled Zoom meetings and keeps only those that started within the last 24 hours. Requests the meeting recording files from Zoom, stops with an error if no transcript is available, then extracts the transcript download URL. Downloads the Zoom transcript file, extracts its text, and reformats it into clean, readable dialogue. Pulls the Zoom meeting participant list (including emails) and sends the transcript and participants to OpenAI to generate structured meeting minutes. Formats the minutes into an HTML email and sends the summary via SMTP to a participant email address. Uses an OpenAI-powered agent to extract action items and follow-up details from the same transcript, then creates tasks in ClickUp and creates a follow-up event in Microsoft Outlook Calendar when scheduling information is present. Setup Ad

by Redowan Ahmed Farhan
AopenaichatmodelserpapigooglesearchS
free

Slack chatbot powered by AI

This workflow offers an effective way to handle a chatbot's functionality, making use of multiple tools for information retrieval, conversation context storage, and message sending. It's a setup tailored for a Slack environment, aiming to offer an interactive, AI-driven chatbot experience. Note that to use this template, you need to be on n8n version 1.19.4 or later.

by n8n Team
AopenaichatmodelserpapigooglesearchS
free

AI agent chat

This workflow employs OpenAI's language models and SerpAPI to create a responsive, intelligent conversational agent. It comes equipped with manual chat triggers and memory buffer capabilities to ensure seamless interactions. To use this template, you need to be on n8n version 1.50.0 or later.

by n8n Team