Automate business lead generation with SerpAPI 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 7 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets. It also calls serpapi.com over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- SERPAPI- GOOGE SEARCH (HTTP Request): calls serpapi.com
- Split Out: splits a list into separate items
- HTTP Request: calls an HTTP API
- Merge: merges the data from its input branches
- Code: runs custom JavaScript code
- Google Sheets: append
Services it uses
HTTP calls to: serpapi.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 (6)
- Manual Trigger
n8n-nodes-base.manualTrigger - HTTP Request
n8n-nodes-base.httpRequest - Split Out
n8n-nodes-base.splitOut - Merge
n8n-nodes-base.merge - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets
From the author
Overview This workflow helps you automatically collect verified business leads from Google Search using SerpAPI — no coding required. It extracts company names, websites, emails, and phone numbers directly from search results and saves them into Google Sheets…