Automate Lead Generation from Google Search & Maps to Google Sheets

This n8n workflow automates the process of extracting lead information from Google Search and Google Maps and then saving it into a Google Sheet. It's designed to streamline lead generation efforts by programmatically searching for businesses and capturing relevant details.

What it does

1. Triggers on Chat Message: The workflow starts when a chat message is received, likely containing a search query for businesses.
2. Performs HTTP Request: It makes an HTTP request, presumably to a service that scrapes Google Search and Google Maps based on the input query.
3. Processes Search Results: The results from the HTTP request are then processed:
   • Filters Data: It filters the received data, likely to isolate relevant lead information.
   • Removes Duplicates: Duplicate entries are removed to ensure unique lead data.
   • Loops Over Items: It iterates through each unique lead item.
   • Applies Logic (If/Else): For each item, it applies conditional logic (an "If" statement), potentially to categorize or further refine the lead based on certain criteria.
   • Edits Fields: It modifies or sets specific fields for each lead, preparing the data for storage.
   • Adds a Wait: A "Wait" node is included, which might be used to introduce a delay between processing items, possibly to respect API rate limits or to space out operations.
4. Merges Data: After individual processing, the data from different branches of the "If" node is merged back together.
5. Writes to Google Sheets: Finally, the processed and merged lead data is appended to a specified Google Sheet.

Prerequisites/Requirements

• n8n Instance: A running n8n instance.
• Google Sheets Account: A Google account with access to Google Sheets.
• Google Sheets Credential: An n8n credential for Google Sheets (OAuth or Service Account).
• Chat Service Integration: A chat service integrated with n8n (e.g., Telegram, Slack, Mattermost) to trigger the workflow via Chat Trigger node.
• Web Scraping Service/API: Access to a web scraping service or API that can query Google Search and Google Maps and return structured data (this is implied by the HTTP Request node). You will need to configure the HTTP Request node with the appropriate URL, headers, and authentication for your chosen service.

Setup/Usage

1. Import the workflow: Import the provided JSON into your n8n instance.
2. Configure Credentials:
   • Google Sheets: Set up your Google Sheets credential in n8n.
   • HTTP Request: Configure the HTTP Request node with the details of your Google Search/Maps scraping API. This will include the API endpoint, any necessary API keys or authentication headers, and the query parameters to pass the search term.
3. Configure Chat Trigger: Ensure your Chat Trigger node is correctly set up to listen for messages from your chosen chat service.
4. Customize Logic (Optional):
   • Adjust the Filter node to refine which data points are kept from the scraping results.
   • Modify the If node's conditions to implement specific lead qualification logic.
   • Update the Edit Fields (Set) node to map the scraped data to the desired columns in your Google Sheet.
5. Specify Google Sheet: In the Google Sheets node, configure the Spreadsheet ID and Sheet Name where you want the leads to be appended.
6. Activate the workflow: Once configured, activate the workflow.
7. Trigger the workflow: Send a chat message with your desired search query to the configured chat service to initiate the lead generation process.