Automate B2B lead generation using Google Places API & SendGrid with dashboard
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 35 nodes and runs on a schedule (every day) (plus 2 other triggers). Along the way it connects Google Sheets and SendGrid.
How it runs
Trigger: On a schedule (every day) (plus 2 other triggers).
- Get row(s) in sheet (Google Sheets): uses Google Sheets
- Read Grid Points (Google Sheets): uses Google Sheets
- Get row(s) in sheet (Google Sheets): uses Google Sheets
- Filter: keeps only the items that match a condition
- Code: runs custom JavaScript code
- Filter: keeps only the items that match a condition
- Assign Alternating Templates (Code): runs custom JavaScript code
- Read Grid Points (Google Sheets): uses Google Sheets
- Update row in sheet (Google Sheets): uses Google Sheets
- Respond to Webhook: sends the response back to the webhook caller
…plus 22 more steps. See the full node list below.
Services it uses
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 (12)
- Google Sheets
n8n-nodes-base.googleSheets - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Code
n8n-nodes-base.code - HTTP Request
n8n-nodes-base.httpRequest - Split Out
n8n-nodes-base.splitOut - Filter
n8n-nodes-base.filter - Wait
n8n-nodes-base.wait - If
n8n-nodes-base.if - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - SendGrid
n8n-nodes-base.sendGrid - Webhook
n8n-nodes-base.webhook - Respond to Webhook
n8n-nodes-base.respondToWebhook
From the author
This n8n workflow automates the entire lead generation pipeline from discovery to outreach: 1. Location Grid Generation and Management - Generates precise lat/lng grid points covering major US cities (New York, Texas, New Jersey, Atlanta, Miami) - Uses 1.5km…