Generate business leads with OpenStreetMap data and save to Goog
Who is this template for? This n8n lead generation workflow template is designed for business owners, marketers, sales professionals, and entrepreneurs who n...
🔌 Nodes & Integrations Used (3)
📖 Implementation & Setup Guide
Who is this template for?
This n8n lead generation workflow template is designed for business owners, marketers, sales professionals, and entrepreneurs who need to generate targeted business leads without paying for expensive APIs or third-party services. The template leverages the free Overpass API (powered by OpenStreetMap data) to gather comprehensive business information for any industry in almost any region worldwide.
Perfect for: - Small businesses looking to expand their customer base - Real estate agents seeking potential clients - Marketing agencies needing targeted lead lists - Entrepreneurs researching potential markets - Sales teams building prospect databases
You can watch the video tutorial here: https://youtu.be/6WVfAIXdwsE
How it works
This n8n lead generation template provides a powerful solution using n8n core nodes and the free OpenStreetMap Overpass API, allowing you to generate thousands of business leads with comprehensive contact information:
Data Collection Process
**1. Define Your Queries** - Create a list of search queries combining keywords (like "real estate", "dentist", etc.) with target locations - Use both inner areas (specific cities) and outer areas (broader regions) to precisely target your search
**2. Iterative Query Execution** - The workflow processes each query in sequence, preventing API timeout issues - Each query triggers a sub-workflow that handles the data extraction process
**3. Data Extraction via OpenStreetMap's Overpass API** - Searches for businesses matching your keywords in name, description, and relevant OpenStreetMap tags - Collects comprehensive business data including names, addresses, and contact details from the OpenStreetMap database - Searches using both regular expressions and exact tag matching for optimal n8n lead generation results
**4. Website Scraping for Additional Information** - For businesses with websites but missing email addresses, the workflow visits their homepage - Extracts email addresses using regular expressions for more complete contact information - Filters out irrelevant emails using configurable patterns
**5. Data Cleaning and Organization** - Removes duplicate contact information and standardizes data format - Filters results based on your specific requirements for contact details - Saves all extracted data to Google Sheets for easy access and management
Setup
**1. Configure Your Queries:** - Open the "Run Workflow" node and input your list of queries - Format queries with outer area, inner area, and keyword (e.g., "California,Los Angeles,real estate")
**2. Optimize Tag Targeting:** - After initial runs, identify the specific tags used by your target industry - Update the HTTP Request node with these specific tags to improve result quality - Common tags include "office", "shop", and "amenity" with industry-specific values
**3. Configure Data Filters:** - Customize the filter node to keep only results meeting your specific requirements - Adjust the email filtering regex to remove irrelevant email addresses
**4. Set up Google Sheets Integration:** - Configure the Google Sheets node to save results to your preferred spreadsheet - Authorize the connection to your Google account
**5. Run the Workflow:** - Start the workflow and watch as your Google Sheet fills with comprehensive business leads - The template automatically handles pagination and rate limiting to prevent API timeouts
The resulting leads include comprehensive contact information such as: - Business names - Complete addresses (street, city, postal code) - Phone numbers - Email addresses (both from API and website scraping) - Website URLs - Social media accounts - Opening hours - And more!
⚡ How to import this workflow into n8n:
- Click the Direct Download JSON button above to save
Generate_business_leads_with_OpenStreetMap_data_and_save_to_Goog.json. - Log in to your n8n Cloud or self-hosted n8n instance.
- In your workflow canvas, click the menu in top-right and select Import from File (or paste the JSON directly).
- Configure your credentials (e.g. API keys, database URLs) in the corresponding node settings.
- Click Execute Workflow to test and switch to Active!
Related General Automation Workflows
View All in General Automation →Generate Application Copy
Production-ready n8n automation template for Generate Application Copy built by AhiXLight. Seamlessly connects Execute Workflow Trigger, OpenAI with 4 configured nodes.
2-way sync Google Contacts and Notion
Sync your Google Contacts with your Notion database. You can filter contacts by label or sync all contacts. All contact information is kept in sync between G...
2D Image to 3D Model Automation
Production-ready n8n automation template for 2D Image to 3D Model Automation built by AhiXLight. Seamlessly connects HTTP Request, Google Sheets, Google Drive with 17 configured nodes.
2 way sync assignments completion between Canvas LMS and Notion
Syncs assignments and completion states to and fro between Canvas LMS and a Notion database. Automatically triggers every 2 hours during the schoolday by def...