Latenode
Apify
Headless browser
Google sheets

Automate business lead scraping and Google Sheets storage

This automation template allows users to scrape business lead information from the web using Apify, a web scraping service, and then automatically store the extracted data in a Google Sheets spreadsheet.

The workflow can be triggered manually or on a scheduled basis, and it allows for fully customizable search parameters to target specific industries and locations. The extracted data includes key business details like name, address, phone number, and email. This solution is designed to be flexible and useful for sales teams, marketers, and researchers looking to generate leads or analyze industry trends.

Updated Apr 2, 2026Est. run: 9sEst. cost: $0.0006
How Latenode estimates time and cost

Latenode bills workflow runs in credits: 1 credit = 30 seconds of processing. Minimum charge per run depends on your plan. Plug-and-Play (PnP) AI nodes are billed separately—each PnP token is $1 USD, charged pay-as-you-go at vendor cost plus a small processing fee, with no API keys required.

Full pricing — how credits work →
Scraping & data collection

Workflow preview

What this template does

  • Extracts lead data from websites using Apify web scrapers
  • Normalizes and structures the extracted data
  • Automatically stores the lead data in a Google Sheets spreadsheet
  • Allows for customizable search parameters to target specific industries and locations
  • Generates a spreadsheet with key business details like name, address, phone, and email

How it works

1
Trigger

Configure Apify Scraper

First, set up the Apify scraper by specifying the target industry, location, and other search parameters to find the desired business listings.

2
Action

Run Web Scraper

Execute the Apify scraper to fetch the relevant business data from the web, including details like name, address, phone, and email.

3
Logic

Process Scraped Data

Clean and structure the raw data from the scraper, preparing it for storage in the Google Sheets spreadsheet.

4
Action

Store in Google Sheets

Save the processed lead data to a new Google Sheets spreadsheet, making it accessible for sales, marketing, or research purposes.

Setup guide

1

Add Apify Credential

Add your Apify account credentials in the Latenode Credentials panel. This allows the workflow to authenticate with the Apify API and execute web scraping jobs.

2

Configure Apify Scraper Node

In the Latenode visual builder, add an Apify Scraper node. Configure the node with the following settings: - Select the Apify credential you added in the previous step - Specify the Apify actor ID for the web scraper you want to use (e.g. "google-maps-scraper") - Set the input parameters for your scraping job, such as industry, location, and data fields to extract

3

Add Google Sheets Node

In the Latenode visual builder, add a Google Sheets node. Configure the node with the following settings: - Select the Google Sheets credential in the Latenode Credentials panel - Specify the Google Sheets document ID where you want to store the scraped data - Map the scraped data fields (business name, address, phone, email, etc.) to the corresponding Google Sheets columns

4

Configure Headless Browser

If the Apify scraper requires authenticated access (e.g. to scrape data from a logged-in Google Maps account), add a Latenode Headless Browser node to the workflow. Configure the node to handle the necessary login steps and maintain the authenticated session during the scraping process.

5

Test and Deploy

Test the workflow in the Latenode builder by running it and verifying that the data is correctly scraped and stored in the Google Sheets document. Once you're satisfied with the setup, deploy the workflow to start automatically generating business lead data.

Requirements

Create an Apify account and set up an Apify Workspace
Generate an Apify API token and store it securely in the Latenode workspace
Set up a Google Sheets spreadsheet and obtain the Spreadsheet ID and relevant permissions
Add the Google Sheets integration to the Latenode workspace and configure the connection

FAQ

Common questions about this template

Each run uses credits on your Latenode plan. We charge for processing time (1 credit = 30 seconds). Your actual cost depends on your plan and how long the run takes. See pricing plans for plans and how credits work.
Contact support →

More templates

You might also like

Browse all templates →
Scraping & data collection

Automatically Sync Google Maps Business Data to a Spreadsheet

This automation workflow allows users to efficiently scrape business data from Google Maps, including names, contact details, and reviews, and export the structured information into a spreadsheet or database. The workflow uses the SerpAPI service to retrieve Google Maps search results, which are then transformed and appended to a Google Sheet. This enables users to generate leads, conduct market analysis, and gain valuable insights from the collected data in a cost-effective and scalable manner.

26s$0.0703
Scraping & data collection

Scrape Zillow property data and sync to Google Sheets automatically

This Latenode automation extracts real estate listing details from Zillow and automatically populates a Google Sheets spreadsheet with the property data. It leverages the Scrape.do web scraping API to bypass anti-bot protections and fetch the full HTML of Zillow listings, then parses key information like price, address, days on Zillow, and Zestimate, and saves the structured results into a Google Sheet. This solution is designed for real estate professionals, investors, and market analysts who need to collect property data at scale without manual effort, enabling better market research, portfolio tracking, and lead generation.

9s$0.0006
Scraping & data collection

Automatically scrape and store Booking.com hotel data

This workflow automates the search and extraction of hotel data from Booking.com, triggered by a chat message. It uses a combination of web scraping with Bright Data's Web Scraper and AI-powered data processing with OpenRouter to deliver a concise, human-friendly list of hotels, including the title, address, original price, and final price. The final output is a clean and formatted report, making it a valuable tool for travelers, event planners, and business professionals who need to quickly find accommodation.

26s$0.0703