Business lead generation with Apify web scraping and Google Sheets storage
This flexible template scrapes business listings for any industry and location, perfect for sales teams, marketers, and researchers. Good to know - Works with any business category (restaurants, contractors, retailers, etc.) - Fully customizable search parameters - Results automatically organized in Google Sheets - Built-in delay ensures scraping completes before data collection How it works 1. Trigger: Manual or scheduled start 2. Apify Configuration: Sets scraping parameters (in
At a glance
Business lead generation with Apify web scraping and Google Sheets storage is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Google Sheets. It's free to download. Follow the 5-step import below to go live in minutes.
- Platform
- n8n
- Connects
- Google Sheets
- Modules
- 7
- Price
- Free
- Version
- v1.0

About this workflow
This flexible template scrapes business listings for any industry and location, perfect for sales teams, marketers, and researchers. Good to know - Works with any business category (restaurants, contractors, retailers, etc.) - Fully customizable search parameters - Results automatically organized in Google Sheets - Built-in delay ensures scraping completes before data collection How it works 1. Trigger: Manual or scheduled start 2. Apify Configuration: Sets scraping parameters (industry, location, data fields) 3. Scraping Execution: Runs the web scraping job 4. Data Processing: Cleans and structures the raw data 5. Storage: Saves results to your Google Sheets What is Apify? Apify is a webscraping tool, in this workflow the data is scraped from a google maps scraper: How to use Apify Small # Lead Generation (Purple) 1. Add location and industry to scrape (Apify) 2. Add the number of leads to output (Apify) 3. Copy over the JSON file into N8N 4. Copy & paste API endpoint "Get Run URL" in N8N Apify Large # Lead Generation (Grey) Configure the Manual Trigger When clicking 'Execute workflow' node is ready to use as-is This triggers the entire lead generation process Setup "Start Results (Apify)" Node Get Your Apify API Information Go to Apify.com and create a free account Navigate to Settings → Integrations → API tokens Copy your API token Find the Google Maps scraper actor ID: Configure the HTTP Request (start results) Method: POST URL: Replace "enter apify (get run)" with: C. Customize the JSON Body Parameters In the JSON body, modify these key fields: Location & Search: "locationQuery": Change "Toronto" to your target city "searchStringsArray": Change ["barber"] to your business type Examples: ["restaurants"], ["dentists"], ["contractors"] Configure the HTTP Request (start results) Method : Get Url: enter the get dataset URL from Apify Split Out Node Select fields to append in the google sheet Test the Configuration Click Execute workflow to test Check that the Apify job starts successfully Note the job ID returned for the next section This section initiates the scraping process and should complete in 30-60 seconds depending on your lead count. Setup Google Sheets Create a new Google Sheet with these columns: title (business name) address (full address) state (state/province) neighborhood (area/district) phone (contact number) emails (email addresses) Copy your Google Sheets document ID for workflow configuration Requirements - Apify account - Google Sheets document - Google OAuth credentials Customization Options For different use cases: - Lead Gen: Get business leads - Local SEO: Collect competitor data - Market Research: Analyze industry trends Advanced mofications: - Add email enrichment - Integrate with CRM systems - Set up automatic daily runs
How to import this n8n workflow
- 1
Download the workflow JSON file after purchase.
- 2
Open n8n → click the menu → Import from File.
- 3
Select the downloaded JSON and import.
- 4
Set up credentials for each node that requires them.
- 5
Click Execute Workflow to test, then activate.
Setup guide
Setup guide included
Purchase to unlock the full step-by-step guide
Related N8n workflows
Add leads to Odoo CRM from new Google Sheets spreadsheet rows
Route social media content reviews with Google Gemini and Google Sheets
Smart sales support chatbot with GPT-4o and Google Sheets
Automate Instagram carousel posts with Google Sheets, Drive & Cloudinary
Add Google Sheets rows for Layerise topics
Create a detached charge with Asaas from a new Google Sheets Row
Social media content generator and publisher | X, Linkedin
Track menstrual cycles and send Gmail phase reminders with GPT-4o and Google Sheets
Reviews
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
- JSON blueprint — instant download
- Setup guide PDF included
- 5 downloads · valid 30 days
- Works with n8n
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.
- Configure live on Google Meet / Zoom
- Free follow-up if workflow has defects
- Platform expert assigned to you