Latenode
Google sheets
Apify
Firecrawl

Automated Google Maps lead generation with contact sync

This automated workflow allows marketing agencies, sales teams, lead generation specialists, and business development professionals to quickly build comprehensive business databases with contact information for outreach campaigns.

It scrapes business data from Google Maps using Apify, extracts contact details like emails and social media profiles from the businesses' websites using Firecrawl, and stores all the data in organized Google Sheets. The workflow runs every 30 minutes, automatically updating the database with new business information. It can be customized to target different business types, locations, and contact fields, making it a powerful tool for lead generation and competitor research across various industries.

Updated Apr 2, 2026Est. run: 28sEst. cost: $0.0018
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

  • Scrapes business data from Google Maps using Apify
  • Extracts contact details like emails and social profiles from websites using Firecrawl
  • Stores the data in organized Google Sheets for lead generation campaigns
  • Updates the database automatically every 30 minutes with new business information
  • Allows customization to target specific business types, locations, and contact fields

How it works

1
Trigger

Read Pending Queries

The workflow reads unprocessed business records from a Google Sheet to begin the scraping and data collection process.

2
Action

Start Apify Scraping Job

The workflow initiates a Google Places scraping job using the Apify API to retrieve basic business information, including name, address, and website URL.

3
Logic

Wait for Apify Scraping Job

The workflow waits for the Apify scraping job to complete and monitors the status to ensure successful data collection.

4
Action

Save Business Data

The basic business information scraped from Google Maps is stored in a Google Sheet for further processing.

5
Logic

Filter Businesses with Websites

The workflow filters the collected data to only include businesses that have a valid website URL, which is necessary for the next step of extracting contact details.

6
Action

Scrape Website Content

For each filtered business, the workflow uses the Firecrawl API to scrape the website content and extract contact details such as email addresses and social media profiles.

7
Action

Save Contact Details

The extracted contact information is stored in a separate Google Sheet for use in lead generation and outreach campaigns.

8
Action

Mark as Processed

The original Google Sheet is updated to mark the processed businesses, ensuring that the workflow does not repeat work on the same records.

Setup guide

1

Add Apify Credential

1. In the Latenode Credentials panel, add an Apify credential by providing your Apify API key.

2

Add Firecrawl Credential

2. In the Latenode Credentials panel, add a Firecrawl credential by providing your Firecrawl API key.

3

Configure Google Sheets Connection

3. In the Latenode Credentials panel, add a Google Sheets credential by completing the OAuth2 authentication flow.

4

Set Google Sheet ID

4. In the Google Sheets nodes, update the Google Sheet ID to the ID of the sheet you want to use for this workflow.

5

Customize Search Criteria

5. In the Apify node settings, modify the search parameters to target the specific business types or locations you want to scrape.

Requirements

An Apify account with access to the Apify platform and APIs
A Firecrawl account with access to the Firecrawl APIs
A Google Sheets account with access to create and modify spreadsheets
Access to the Latenode workspace to set up the scraping workflow using the Apify, Firecrawl, and Google Sheets nodes

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