Who is this for?
Marketing agencies, sales teams, lead generation specialists, and business development professionals who need to build comprehensive business databases with contact information for outreach campaigns across any industry.
What problem is this workflow solving?
Finding businesses and their contact details manually is time-consuming and inefficient. This workflow automates the entire process of discovering businesses through Google Maps and extracting their digital contact information from websites, saving hours of manual research.
What this workflow does
This automated workflow runs every 30 minutes to:
- Scrape business data from Google Maps using Apify’s Google Places crawler
- Save basic business information (name, address, phone, website) to Google Sheets
- Filter businesses that have websites
- Scrape each business’s website content using Firecrawl
- Extract contact information including emails, LinkedIn, Facebook, Instagram, and Twitter profiles
- Store all extracted data in organized Google Sheets for easy access and follow-up
Setup
Required Services:
- Google Sheets account with OAuth2 setup
- Apify account with API access for Google Places scraping
- Firecrawl account with API access for website scraping
Pre-setup:
- Copy this Google Sheet
- Configure your Apify and Firecrawl API credentials in n8n
- Set up Google Sheets OAuth2 connection
- Update the Google Sheet ID in all Google Sheets nodes
Quick Start:
The workflow includes detailed sticky notes explaining each phase. Simply configure your API credentials and Google Sheet, then activate the workflow.
How to customize this workflow to your needs
- Change search criteria: Modify the Apify scraping parameters to target different business types (restaurants, gyms, salons, etc.) or locations
- Adjust schedule: Change the trigger interval from 30 minutes to your preferred frequency
- Add more contact fields: Extend the extraction code to find additional contact information like WhatsApp or Telegram
- Filter criteria: Modify the filter conditions to target businesses with specific characteristics
- Batch size: Adjust the batch processing to handle more or fewer websites simultaneously
Perfect for lead generation, competitor research, and building targeted marketing lists across any industry or business type.
