Enrich Google Sheets leads via LinkedIn, SerpAPI, Claude and Apify
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 AI workflow has 34 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets and Anthropic. It also calls serpapi.com and api.apify.com over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Google Sheets: uses Google Sheets
- Batch Size Limit (Limit): keeps the first few items
- SerpAPI - Find LinkedIn URL (HTTP Request): calls serpapi.com
- Filter & Clean Search Results (Code): runs custom JavaScript code
- Has Search Results? (If): checks a condition and branches into true / false
- Prepare AI Input (Edit Fields (Set)): sets 5 fields: clean_results, person_name, Licensed as…
- Rate Limit Wait (AI) (Wait): waits 3 seconds
- AI - Validate LinkedIn Match (Anthropic): uses Anthropic
- Parse AI Response (Code): runs custom JavaScript code
- Google Sheets: update
…plus 23 more steps. See the full node list below.
Services it uses
HTTP calls to: serpapi.com, api.apify.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 (11)
- HTTP Request
n8n-nodes-base.httpRequest - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - Limit
n8n-nodes-base.limit - If
n8n-nodes-base.if - Edit Fields (Set)
n8n-nodes-base.set - Wait
n8n-nodes-base.wait - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Anthropic
@n8n/n8n-nodes-langchain.anthropic - Filter
n8n-nodes-base.filter - Manual Trigger
n8n-nodes-base.manualTrigger
From the author
Quick Overview This workflow enriches leads from Google Sheets by finding and validating LinkedIn profile URLs with SerpAPI and Anthropic, then scraping matched profiles with Apify to extract a relevant company and discover its website domain via SerpAPI,…