Capture and score local business leads with Serper, Hunter.io, and Google Sheets
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 23 nodes and runs manually, when you click “Execute workflow” (plus 1 other trigger). Along the way it connects Google Sheets. It also calls google.serper.dev over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow” (plus 1 other trigger).
- Build search queries (Code): runs custom JavaScript code
- Loop over areas (Loop Over Items (Split in Batches)): loops over the items in batches
- Finalize lead list (Code): runs custom JavaScript code
- Search Google Places (Serper) (HTTP Request): calls google.serper.dev (POST)
- Read existing leads (Google Sheets): uses Google Sheets
- Collect and filter results (Code): runs custom JavaScript code
- Remove already-captured leads (Code): runs custom JavaScript code
- Loop over businesses (Loop Over Items (Split in Batches)): loops over the items in batches
- Build CRM payload (Code): runs custom JavaScript code
- Store current business (Code): runs custom JavaScript code
…plus 11 more steps. See the full node list below.
Services it uses
HTTP calls to: google.serper.dev
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 (7)
- Manual Trigger
n8n-nodes-base.manualTrigger - Code
n8n-nodes-base.code - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - HTTP Request
n8n-nodes-base.httpRequest - Google Sheets
n8n-nodes-base.googleSheets - Crypto
n8n-nodes-base.crypto - Webhook
n8n-nodes-base.webhook
From the author
Quick overview This workflow searches Google Places via Serper.dev for local businesses across multiple areas, enriches and scores each lead using website email extraction and Hunter.io, and appends the results to Google Sheets with an optional HMAC-signed…