Extract Business Emails from Google Maps Listings for Lead Generation

This n8n workflow automates the process of extracting business emails from Google Maps listings, making it an efficient tool for lead generation. It takes a list of business names and locations, searches Google Maps for them, extracts relevant details including email addresses, and then compiles this data into a Google Sheet.

What it does

1. Manual Trigger: Initiates the workflow upon manual execution.
2. Google Sheets (Read Data): Reads a list of business names and locations from a specified Google Sheet.
3. Loop Over Items (Split in Batches): Processes the businesses from the Google Sheet in batches to manage API request limits and ensure stability.
4. Wait: Pauses the workflow for a specified duration (e.g., 5 seconds) between batches to avoid overwhelming APIs and respect rate limits.
5. HTTP Request (Google Maps Search): Sends an HTTP request to a Google Maps scraping API (e.g., SerpApi, Bright Data, or a custom solution) to search for each business based on its name and location.
6. Code (Extract Email): Executes custom JavaScript code to parse the JSON response from the Google Maps search, specifically looking for and extracting email addresses from the listing details.
7. Filter (Email Found): Checks if an email address was successfully extracted for the current business.
8. Google Sheets (Write Data - Email Found): If an email is found, the business name, location, and extracted email are appended to a specified "Found Emails" Google Sheet.
9. Google Sheets (Write Data - No Email): If no email is found, the business name and location are appended to a separate "No Emails Found" Google Sheet, allowing for further manual investigation if needed.
10. Remove Duplicates: Ensures that only unique email addresses are recorded in the "Found Emails" sheet.
11. Limit: (Potentially) Limits the number of items processed to manage workflow execution time or testing.
12. Split Out: (Potentially) Splits out items from an array into individual items for further processing.
13. Sticky Note: Provides a descriptive note within the workflow for clarity.

Prerequisites/Requirements

• n8n Instance: A running n8n instance to host and execute the workflow.
• Google Sheets Account: Access to Google Sheets to store input data (business names, locations) and output data (found emails, businesses without emails).
• Google Sheets Credentials: Configured Google Sheets OAuth2 or Service Account credentials in n8n.
• Google Maps Scraping API Key: An API key for a Google Maps scraping service (e.g., SerpApi, Bright Data, or a similar provider) that can programmatically search Google Maps and return detailed business information. The HTTP Request node will need to be configured with the endpoint and authentication for this service.

Setup/Usage

1. Import the workflow: Download the provided JSON and import it into your n8n instance.
2. Configure Credentials:
   • Set up your Google Sheets credentials (OAuth2 or Service Account) in n8n.
   • Configure the HTTP Request node with your chosen Google Maps scraping API's endpoint and API key/authentication method.
3. Prepare Input Google Sheet:
   • Create a Google Sheet with at least two columns: "Business Name" and "Location".
   • Populate this sheet with the businesses you want to find emails for.
   • Update the "Google Sheets (Read Data)" node to point to this input sheet and the correct range.
4. Prepare Output Google Sheets:
   • Create two new Google Sheets: one for "Found Emails" and one for "No Emails Found".
   • Update the "Google Sheets (Write Data - Email Found)" and "Google Sheets (Write Data - No Email)" nodes to point to these respective output sheets. Ensure the column headers in your output sheets match the data being written (e.g., "Business Name", "Location", "Email").
5. Review and Customize (Optional):
   • Adjust the "Wait" node's duration if you experience rate limit issues or want to speed up/slow down the process.
   • Modify the "Code (Extract Email)" node if your chosen Google Maps scraping API returns data in a different format, or if you want to extract additional information.
   • Adjust the batch size in the "Loop Over Items" node if needed.
6. Execute the workflow: Click "Execute Workflow" in the "Manual Trigger" node to start the process.

The workflow will then read your businesses, search Google Maps, extract emails, and populate your output Google Sheets with the results.