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

by Santhej Kallada ✓ · 100 views · created 2026-06-11 · Lead Generation

What this workflow does

This workflow has 7 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets. It also calls api.apify.com over HTTP.

How it runs

Trigger: Manually, when you click “Execute workflow”.

1. Run Google Maps Lead Finder (HTTP Request): calls api.apify.com (POST)
2. Keep leads with a verified email (Filter): keeps only the items that match a condition
3. Verify Emails (HTTP Request): calls api.apify.com (POST)
4. Merge: merges the data from its input branches
5. Keep only safe-to-send (Filter): keeps only the items that match a condition
6. Append lead to Google Sheet (Google Sheets): append

Services it uses

Google Sheets

HTTP calls to: api.apify.com

Before you upgrade to n8n 3.0

Nodes used (5)

• Manual Triggern8n-nodes-base.manualTrigger
• HTTP Requestn8n-nodes-base.httpRequest
• Filtern8n-nodes-base.filter
• Google Sheetsn8n-nodes-base.googleSheets
• Mergen8n-nodes-base.merge

From the author

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…

View the original on n8n.io → Check your own copy