AutomationMart
Home/Browse/Generate verified local leads from Google Maps with Apify and Google Sheets
n8n

Generate verified local leads from Google Maps with Apify and Google Sheets

n8nn8n7 modulesv1.0
Google Sheets

Quick Overview This workflow uses Apify to scrape Google Maps business leads, verify their emails with a live SMTP check, and append only safe-to-send contacts to a Google Sheets spreadsheet. How it works 1. Starts when you manually run the workflow. 2. Calls the Apify Google Maps Lead Finder actor to search Google Maps for the configured queries and enrich results with email addresses. 3. Filters the results to keep only leads that include a non-empty primary email address. 4. Sends each primar

At a glance

Generate verified local leads from Google Maps with Apify and Google Sheets 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
Generate verified local leads from Google Maps with Apify and Google Sheets workflow diagram

About this workflow

Quick Overview This workflow uses Apify to scrape Google Maps business leads, verify their emails with a live SMTP check, and append only safe-to-send contacts to a Google Sheets spreadsheet. How it works 1. Starts when you manually run the workflow. 2. Calls the Apify Google Maps Lead Finder actor to search Google Maps for the configured queries and enrich results with email addresses. 3. Filters the results to keep only leads that include a non-empty primary email address. 4. Sends each primary email to the Apify Email Verifier actor to validate deliverability and return a safe-to-send flag and verification details. 5. Combines the original lead data with the corresponding email verification result. 6. Filters out any leads that are not marked safe to send. 7. Appends the remaining verified leads to a Google Sheets tab with business, contact, and email verification fields. Setup 1. Create an Apify personal API token and configure an HTTP Header Auth credential (Header name Authorization, value Bearer

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

Scrape Apollo leads with BrowserAct, draft Gemini emails, and save to Sheets

This workflow creates a fully automated B2B lead generation & outreach pipeline. It combines BrowserAct (for scraping) with Google Gemini AI (for writing) to automate the entire prospecting process. It takes a search request via a Form, scrapes verified leads from Apollo.io, uses AI to write a personalized cold email for EACH lead, saves everything to Google Sheets, and notifies you via Gmail when the batch is done. How it works Form Trigger: You input the Target Role (e.g., "Engineer") and Loc

Free

Add new TSheets timesheets to Google Sheets

Every time a new Timesheet is posted to a specified TSheets account, Make will automatically add that timesheet to Google Sheets. The template uses this [example spreadsheet](https://docs.google.com/spreadsheets/d/1GTHFXIZTYjC7hdnbwsQFL83dq2AJzwxLRm26pF24hY0/edit?usp=sharing).

Free

Add Salesflare opportunities from new Google Sheets rows

Every time a new row is added to your Google Sheets spreadsheet, Make will automatically create a new opportunity in Salesflare. If the account name for which the opportunity should be created does not yet exist in Salesflare, Make will create it. The template uses this [example spreadsheet](http://bit.ly/2WUe1F9).

Free

Push Google Sheets values to Cyfe

Every time a new row is added to your Google Sheets spreadsheet, Make will automatically push the new data in your Cyfe widget. The template uses this [example spreadsheet](https://docs.google.com/spreadsheets/d/1UUP8arJB1WUmHjaILAd_bcfvWJvF9qEJmZIQeUMU-Nw/edit?usp=sharing).

Free

Auto-create and publish AI social videos with Telegram, GPT-4 and Blotato

Auto-create and publish AI social videos with Telegram, GPT-4 and Blotato > ⚠️ Disclaimer: This workflow uses Community Nodes and must be run on a self-hosted instance of n8n. Who is this for? This template is perfect for social media managers, content creators, AI enthusiasts, and automation pros who want to generate short-form videos (Reels) from a simple Telegram message, then publis

Free

Export BigQuery Tables to Google Sheets

This template helps you export a BigQuery table to Google Sheets. The scenario can be set up to run at regular intervals (every hour, day, week or a specific date).

Free

Create stunning AI images directly from WhatsApp with Gemini

Create Stunning AI Images Directly from WhatsApp with Gemini This workflow transforms your WhatsApp into a personal AI image generation studio. Simply send a text message with your idea, and this bot will use the advanced prompt engineering capabilities of Gemini 2.5 Pro to craft a detailed, artistic prompt. It then uses Gemini 2.0 Flash to generate a high-quality image from that prompt and sends it right back to your chat. It's a powerful yet simple way to bring your creative ideas to l

Free

Generate and publish Instagram Reels with Gemini and Veo

How it Works The workflow runs automatically on a schedule (daily at a set time). It defines the video topic, caption, and aspect ratio. Gemini generates a detailed visual prompt for a short-form vertical video. Google Veo creates the video based on that prompt. The finished video is published to Instagram as a Reel with the preset caption. --- Set-up Steps Connect Google Gemini and Veo API credentials. Authenticate Instagram publishing access. Customize the video topic, caption, and pos

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