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

Scrape and export Google Maps business data to Google Sheets

This automation 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 for lead generation and market analysis. The workflow triggers manually or on a scheduled basis, fetching search results from Google Maps using the SerpAPI service, deduplicating the data, and writing it to a Google Sheet. This streamlines the process of gathering valuable business intelligence from Google Maps, empowering users to leverage this data for strategic decision-making and sales prospecting.

11s$0.0007
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

Automate Instagram profile data export to Google Sheets

This automation template allows users to scrape comprehensive Instagram profile data using the Apify platform, and automatically export the results into a Google Sheets spreadsheet for analysis. It is designed to run on a schedule, processing a list of usernames by calling the Apify API, appending the scraped data to a Google Sheet, and marking the usernames as processed. The automation integrates with Google Sheets and the Apify actor, providing a streamlined way to gather and organize Instagram profile information without manual intervention.

15s$0.0009