n8n Google Maps Scraper and Outreach Message Generator

This n8n workflow automates the process of scraping Google Maps data for businesses within a specified area and then generates personalized outreach messages for lead generation using AI.

What it does

This workflow streamlines your lead generation efforts by:

1. Triggering Manually: The workflow is initiated manually, allowing you to control when the scraping and generation process begins.
2. Preparing Data for Scraping: It sets up the necessary parameters for the Google Maps scraping process.
3. Executing Google Maps Scraping: It makes an HTTP request to an external service (likely a Google Maps scraper API) to retrieve business data based on the defined area.
4. Handling Successful Scraping: If the scraping is successful, it proceeds to process the retrieved data.
5. Handling Failed Scraping: If the scraping fails, it uses a "No Operation" node, implying that the workflow might stop or log the error without further action in this branch.
6. Looping Through Scraped Items: It iterates over each business found by the scraper.
7. Introducing a Delay: A "Wait" node is used to introduce a delay between processing each item, likely to avoid rate limiting on external APIs or to simulate human-like interaction.
8. Generating Outreach Messages with AI: For each business, it uses an AI Agent (likely powered by an OpenAI or Google Gemini Chat Model) to generate a personalized outreach message. This AI agent likely has access to an "MCP Client Tool" (Model Context Protocol Client Tool), suggesting it might interact with a specialized model or service for context and generation.
9. Storing Generated Leads: The generated outreach messages and associated business data are then stored in a PostgreSQL database.
10. Limiting Output (Optional): A "Limit" node is present, which could be used during development or for specific use cases to process only a subset of the scraped data.
11. Form-based Trigger (Alternative/Future): A "n8n Form Trigger" node is present but not connected in the provided JSON, suggesting a potential future enhancement to trigger the workflow via a web form.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running n8n instance.
• External Google Maps Scraper API: An API key and access to a Google Maps scraping service. The "HTTP Request" node will need to be configured with the appropriate URL and authentication.
• OpenAI or Google Gemini API Key: Credentials for either OpenAI or Google Gemini (or both, depending on which Chat Model node you choose to enable/configure) for the AI Agent to generate outreach messages.
• PostgreSQL Database: Access to a PostgreSQL database to store the scraped data and generated outreach messages. You will need the host, port, database name, user, and password.
• MCP Client Tool (Optional but likely required for AI Agent): Depending on the configuration of the AI Agent, you might need specific setup or credentials for the "MCP Client Tool."

Setup/Usage

1. Import the Workflow: Import the provided JSON into your n8n instance.
2. Configure Credentials:
   • HTTP Request (Node 19): Update the "HTTP Request" node with the URL of your Google Maps scraper API and any required authentication (e.g., API keys in headers or query parameters).
   • OpenAI Chat Model (Node 1153) / Google Gemini Chat Model (Node 1262): Select and configure the appropriate AI Chat Model node. Provide your OpenAI API Key or Google Gemini API Key in the credentials section.
   • Postgres (Node 30): Configure the PostgreSQL credentials (host, port, database, user, password) to connect to your database.
3. Define Scraping Parameters: In the "Edit Fields (Set)" node (Node 38), ensure the input data for the Google Maps scraper (e.g., search query, location, radius) is correctly set.
4. Adjust AI Agent Prompt: Review and modify the prompt within the "AI Agent" node (Node 1119) to fine-tune the outreach message generation according to your specific needs and target audience.
5. Activate the Workflow: Once configured, activate the workflow.
6. Execute Manually: Click "Execute Workflow" on the "Manual Trigger" (Node 838) to start the process.
7. Monitor Results: Monitor the execution in n8n and check your PostgreSQL database for the scraped business data and generated outreach messages.