AutomationMart
Home/Browse/Business lead generation with Apify web scraping and Google Sheets storage
n8n

Business lead generation with Apify web scraping and Google Sheets storage

n8nn8n7 modulesv1.0
Google Sheets

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
Business lead generation with Apify web scraping and Google Sheets storage workflow diagram

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

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 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

Make will watch for new rows in your Google Sheets spreadsheet at regular intervals and create a lead in Odoo CRM using information received. The template uses this [example spreadsheet](https://docs.google.com/spreadsheets/d/1HMeSnS0arQamHb_Pton2zCjSz3TnSSPLClfWkiQnqc8/edit?usp=sharing).

Free

Route social media content reviews with Google Gemini and Google Sheets

Quick overview This workflow collects a social media content brief via an n8n form, uses Google Sheets for client brand context, and runs a three-stage human-in-the-loop process powered by Google Gemini (strategy angles, draft writing, and quality audit) before logging the approved post back to Google Sheets. How it works 1. Receives a new content request through an n8n Form that captures client, platform, content type, and optional topic and tone notes. 2. Looks up the client’s brand fields in

Free

Smart sales support chatbot with GPT-4o and Google Sheets

Who is this tempate for? This workflow powers a simple yet effective customer and sales support chatbot for your webshop. It's perfect for solopreneurs who want to automate customer interactions without relying on expensive or complex support tools. How it works? The chatbot listens to user requests—such as checking product availability—and automatically handles the following - Fetches product information from a Google Sheet - Answers customer queries - Places an order - Updates the stock after

Free

Automate Instagram carousel posts with Google Sheets, Drive & Cloudinary

Who is this for? This workflow is ideal for social media managers, content creators, marketers, and small businesses who want to automate Instagram Carousel posts using Google Sheets and Google Drive. It is also suitable for anyone looking to streamline repetitive Instagram publishing tasks with n8n, Cloudinary, and the Instagram Graph API. What problem is this workflow solving? / Use case Managing and publishing Instagram Carousel posts manually can be time-consuming, especially when h

Free

Add Google Sheets rows for Layerise topics

Make will import your Layerise topics into Google Sheets spreadsheet as rows. Here's the [sheet](https://docs.google.com/spreadsheets/d/1z6q7-A8CVKjUkZbwioeAce4Asj70--Dp2ZlHoyVdQ7U/edit?usp=sharing) used in this scenario.

Free

Create a detached charge with Asaas from a new Google Sheets Row

Este modelo foi criado pela Asaas e não foi testado pela Make. Se você tiver alguma dúvida ou pergunta sobre este modelo, entre em contato conosco em integracoes@asaas.com.br. This template was created by Asaas and has not been tested by Make. If you have any doubts or questions about this template, please contact us at integracoes@asaas.com.br.

Free

Social media content generator and publisher | X, Linkedin

Generate and Publish AI Content to LinkedIn and X (Twitter) with n8n Overview This n8n workflow automates the generation and publishing of AI-powered social media content across LinkedIn and X (formerly Twitter). By leveraging AI, this workflow helps social media managers, marketers, and content creators streamline their posting process. Who is this for? - Social media managers - Content creators - Digital marketers - Businesses looking to automate content generation F

Free

Track menstrual cycles and send Gmail phase reminders with GPT-4o and Google Sheets

Description Most period tracking apps tell you when your period is coming. This workflow goes further — it tracks every phase of every subscriber's unique cycle, sends the right email at exactly the right time, and delivers GPT-4o powered wellness coaching every week tailored to where each woman is in her cycle. Built for women's health platforms, wellness coaches, femtech creators, and community builders who want to deliver genuinely useful cycle-aware health support at scale without build

Free

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.

Log in to review
Free
No ratings yet

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.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free