Automated Google Maps Business Lead Generation with Contact Enrichment
detail.loadingPreview
Automate the tedious process of finding business leads from Google Maps. This workflow continuously scrapes business information based on your search queries and saves it directly to Google Sheets for easy access and further action.
About This Workflow
This powerful n8n workflow revolutionizes your lead generation strategy by automating the scraping of business data from Google Maps. Set it up once, and it will diligently monitor a Google Sheet for new search queries. Upon finding new queries, it leverages Apify's robust Google Places Crawler to extract crucial business details like names, addresses, phone numbers, websites, and categories. The workflow intelligently polls for job completion and then seamlessly pushes all the collected data back into your Google Sheet. While this specific snippet focuses on initial scraping, the workflow name indicates its design allows for advanced contact extraction and enrichment using tools like Firecrawl, transforming raw data into actionable sales leads.
Key Features
- Automated Scheduling: Runs periodically (e.g., every 30 minutes) to ensure continuous lead discovery without manual intervention.
- Dynamic Query Input: Reads new search queries from a designated Google Sheet, allowing for flexible and scalable target market definition.
- Google Maps Data Scraping: Utilizes Apify's powerful Google Places Crawler to reliably extract business names, addresses, phone numbers, websites, and categories.
- Intelligent Job Monitoring: Automatically waits and polls Apify until the scraping job is successfully completed, ensuring data integrity.
- Centralized Data Storage: Seamlessly saves all scraped business information directly into a Google Sheet for easy organization, analysis, and further processing.
How To Use
- Google Sheets Setup:
- Create a new Google Sheet named "Google Maps Scraper".
- Within it, create two sheets: one named "Query" (for input queries) and another for results (e.g., "Business Leads").
- In the "Query" sheet, add columns like
Search String,Location, andStatus(setStatustofalsefor new queries). - Configure the "Read Pending Queries" and "Save Business Data" nodes with your Google Sheets credentials and the correct Spreadsheet ID and Sheet Names.
- Apify Integration:
- Obtain an API token from your Apify account.
- Configure new HTTP Query Auth and HTTP Header Auth credentials in n8n for Apify, using your API token.
- Ensure the Apify "compass~crawler-google-places" actor is accessible and correctly referenced in the "Start Apify Scraping Job" node.
- Customize Scraping Parameters:
- In the "Start Apify Scraping Job" node, update the
jsonBodyto dynamically pullsearchStringsArrayandlocationQueryfrom theRead Pending Queriesnode using n8n expressions (e.g.,{{ $json.SearchString }}and{{ $json.Location }}). - Adjust
maxCrawledPlacesPerSearchand other Apify parameters as needed.
- In the "Start Apify Scraping Job" node, update the
- Workflow Activation:
- Activate the workflow. It will run on its schedule, process new queries from your Google Sheet, scrape data, and populate results.
- (Optional: To achieve full "contact extraction via Apify and Firecrawl" as per the workflow title, integrate additional nodes after "Fetch Scraped Results" to process individual business websites using a service like Firecrawl, then update the status in your Google Sheet accordingly.)
Apps Used
Workflow JSON
{
"id": "ac39c037-edf1-44c0-bd05-0cd6ee73664e",
"name": "Automated Google Maps Business Lead Generation with Contact Enrichment",
"nodes": 14,
"category": "Sales",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: ac39c037-edf1...
About the Author
DevOps_Master_X
Infrastructure Expert
Specializing in CI/CD pipelines, Docker, and Kubernetes automations.
Statistics
Related Workflows
Discover more workflows you might like
AI-Powered Stack Overflow Lead Generation
Unleash the power of AI to automatically scrape valuable lead data from Stack Overflow user profiles. This workflow intelligently identifies and extracts key information like names, locations, skills, and reputation, then seamlessly organizes it into your Google Sheet for effortless lead management.
AI-Powered Upwork Proposal Automation Suite
This n8n workflow leverages AI to automate the entire freelance proposal process, from crafting personalized application text to generating professional Google Doc proposals and visual workflow diagrams. It significantly reduces manual effort, allowing freelancers to scale their client acquisition rapidly and effectively.
Automate LinkedIn Job Change Monitoring and Role Classification
Proactively track career shifts within your LinkedIn network. This n8n workflow utilizes Airtop to automatically extract detailed job change information, including new positions, LinkedIn profiles, and functional classifications, enabling timely outreach and CRM updates.