Generate and enrich Google Maps B2B leads with SDR-ready data in Google Sheets
Ready for 3.0What this workflow does
This workflow has 10 nodes and runs when someone submits an n8n form (“SDR”). Along the way it connects Google Sheets. It also calls maps.googleapis.com over HTTP.
How it runs
Trigger: When someone submits an n8n form (“SDR”).
- Format Search Query (Edit Fields (Set)): sets 3 fields: tipoDeNegocio, cidade, api_key
- Google Maps Text Search (HTTP Request): calls maps.googleapis.com
- Merge: merges the data from its input branches
- Split Out: splits a list into separate items
- Aggregate: combines items into one
- Fetch Place Details (HTTP Request): calls maps.googleapis.com
- Data Cleaning Logic (Code): runs custom JavaScript code
- Validate Lead Quality (If): checks a condition and branches into true / false
- Log Lead to Google Sheets (Google Sheets): append
Services it uses
HTTP calls to: maps.googleapis.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (9)
- Split Out
n8n-nodes-base.splitOut - Aggregate
n8n-nodes-base.aggregate - n8n Form Trigger
n8n-nodes-base.formTrigger - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - Merge
n8n-nodes-base.merge - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Google Sheets
n8n-nodes-base.googleSheets
From the author
🚀 Overview This workflow is a powerful B2B Lead Generation engine designed specifically for SDRs (Sales Development Representatives). It automates the entire process of finding, enriching, and qualifying prospects directly from Google Maps based on any…