Generate LinkedIn leads using Google Sheets and Serper API
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 14 nodes and runs manually, when you click “Execute workflow”. 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”.
- Get Search Criteria (Google Sheets): uses Google Sheets
- Filter: keeps only the items that match a condition
- Create Paginated Search Queries (Code): runs custom JavaScript code
- Batch Process 50 Pages (Loop Over Items (Split in Batches)): loops over the items in batches
- Post to LinkedIn Search API (HTTP Request): calls google.serper.dev (POST)
- Wait: pauses before continuing
- Terminate on Error (Stop and Error): stops the run with an error
- Extract Profile Data (Code): runs custom JavaScript code
- Deduplicate Profiles by URL (Code): runs custom JavaScript code
- Read Existing Profiles from Sheets (Google Sheets): uses Google Sheets
…plus 3 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 (9)
- Manual Trigger
n8n-nodes-base.manualTrigger - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Wait
n8n-nodes-base.wait - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - HTTP Request
n8n-nodes-base.httpRequest - If
n8n-nodes-base.if - Filter
n8n-nodes-base.filter - Stop and Error
n8n-nodes-base.stopAndError
From the author
The automation starts by retreiving the unused queries from a sheet, executes queries in the web using Serper API and extracts linkedin profiles of decision makers.