This n8n workflow automates the process of extracting business data from Google Maps, enriching it with AI-generated insights, and storing it in a database for targeted outreach. It is ideal for entrepreneurs, sales teams, or marketing agencies aiming to streamline lead generation and qualification.

The workflow begins with a user submitting a form that captures the location URL, search keyword, country, and business segment. This triggers several nodes: the Bright Data MCP is called to scrape data based on the provided location, and the workflow monitors the progress of this scraping job. Once completed, the data is downloaded for processing.

Next, the workflow extracts latitude and longitude from the URL to pinpoint the exact geographic coordinates crucial for precise scraping. It then checks if the business website exists; if so, it initiates a web scraping and summarization process using the ‘scrape_as_markdown’ tool within ChatGPT, extracting key company information, reviews, and other relevant content.

AI-powered message generation nodes then craft a personalized cold outreach script and supporting talking points, utilizing language models like GPT-4 or Google Gemini. These insights are prepared for cold contact strategies, aiding users in approaching prospects effectively.

The enriched data, including business details, reviews, and generated scripts, are then upserted into a Supabase database, which facilitates organized storage and easy retrieval for future campaigns or analysis. Additional notes and instructions within sticky nodes provide guidance on setting up database connections and understanding key parameters, such as the impact of zoom levels in map searches.

This workflow is particularly useful for agencies or sales teams aiming to automate lead prospecting, improve outreach effectiveness, and utilize comprehensive, enriched business data for better engagement strategies.

The entire automation ensures minimal manual intervention, supports error handling with retry logic, and offers scalable data processing through batching and looping mechanisms, making it a powerful tool for data-driven growth activities.

Node Count	>20 Nodes
Nodes Used	@brightdata/n8n-nodes-brightdata.brightData, @n8n/n8n-nodes-langchain.agent, @n8n/n8n-nodes-langchain.chainLlm, @n8n/n8n-nodes-langchain.lmChatGoogleGemini, @n8n/n8n-nodes-langchain.lmChatOpenAi, @n8n/n8n-nodes-langchain.mcpClientTool, formTrigger, httpRequest, if, limit, manualTrigger, merge, noOp, postgres, set, splitInBatches, stickyNote, wait