Google Maps Lead Generation to Sheets - n8n Workflow

Sales Development Representatives (SDRs) needing targeted cold lists.
Marketers running localized outreach campaigns.
Users looking for high-quality, pre-built n8n templates for data extraction.
Businesses needing automated ways to leverage the Google Maps API without custom coding.

This powerful n8n workflow provides a structured, scalable solution for generating high-quality business leads directly from the Google Maps and Places APIs. Instead of manual searching or using unreliable scrapers, this n8n template ensures you utilize the official Google APIs for maximum data accuracy. The workflow automatically converts your target location into coordinates, executes a precise search for a specified business type, validates each result to ensure it has a phone number or website, and then neatly organizes the valid leads into a Google Sheet. This process saves significant time and allows you to build highly targeted prospecting lists using the flexibility of the n8n node ecosystem. Using this specific n8n workflow helps streamline market research and prospecting efforts.

1. The n8n workflow is initiated using the 'Extraction Configs' n8n trigger (a Form Trigger), where the user inputs the desired business type, target location, maximum result count, and their Google Maps API Key.


2. The 'Main Set' n8n node prepares and standardizes this user input.


3. The 'Get Location Coordinates' n8n node executes an HTTP Request to the Google Geocoding API to convert the plain-text location into precise latitude and longitude coordinates.


4. The 'Prepare Search Data Set' n8n node combines the new coordinates with the original search terms.


5. The 'Search Google Places' n8n node executes the core search against the Google Places Search API (via another HTTP Request), finding relevant businesses based on the coordinates and business type query.


6. The 'Split Results' n8n node separates the array of search results, allowing the remaining steps of the n8n workflow to process each potential lead individually.


7. The 'If Lead is Valid' n8n node implements filtering logic: only leads containing a website OR a national/international phone number are allowed to proceed, ensuring data quality.


8. The 'Format Lead Data' n8n node standardizes and formats the valid data, mapping complex API fields to simple column headers like businessName and website.


9. Finally, the Google Sheets n8n node ('Append row in sheet') appends the newly formatted, validated lead data as a new row in the designated spreadsheet.

Import the n8n template: Copy the provided JSON and import it into your self-hosted or cloud n8n instance.
Google Sheets Credentials: Click on the Google Sheets n8n node ('Append row in sheet') and set up or select your Google Sheets OAuth2 credentials. Ensure the credentials grant n8n permission to write to your target spreadsheet.
Google Maps API Key: Obtain a valid, billing-enabled Google Maps Platform API key (required for both Geocoding and Places API services). This key is provided dynamically through the initial n8n trigger form input when you execute the n8n workflow.
Sheet Preparation: Create a Google Sheet named 'Leads Generation' (or update the n8n node configuration) with appropriate headers corresponding to the data fields (e.g., Business Name, Address, Phone, Website, Google Maps URL, etc.) before running the n8n workflow.

Extraction Configs (Form Trigger n8n trigger): Function: Initiates the entire n8n workflow and collects necessary parameters such as the search term, location, max results, and the required Google Maps API key. This is the starting n8n trigger point.
Get Location Coordinates (HTTP Request n8n node): Function: Converts the user's plain-text location into latitude and longitude using the Google Geocoding API, preparing data for the Places search. Key Configuration: Uses address and key query parameters dynamically.
Search Google Places (HTTP Request n8n node): Function: Executes the primary business search using the Google Places API Text Search method. Key Configuration: POST request configuration includes locationBias (a 10km circle radius) and the crucial X-Goog-FieldMask header, which specifies retrieval of contact fields like phone numbers and website URIs.
If Lead is Valid (If n8n node): Function: Filters out leads lacking essential contact information. Key Configuration: Condition checks if nationalPhoneNumber OR websiteUri exists, ensuring only actionable leads proceed through the n8n workflow.
Format Lead Data (Set n8n node): Function: Standardizes and cleans up the variable API response data into a consistent structure for the spreadsheet. Key Configuration: Maps detailed API fields (e.g., displayName.text) into standard fields (e.g., businessName) and adds metadata like scrapedAt and searchQuery.
Append row in sheet (Google Sheets n8n node): Function: The final data persistence step. It writes the validated and formatted leads into the target Google Sheet. Key Configuration: Operation set to Append row, utilizing previously configured Google Sheets credentials.