Agentic B2B lead enrichment from Google Search to 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 AI workflow has 27 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Gemini Chat Model, Google Sheets and Gmail. It also calls google.serper.dev and api.scraperapi.com over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Edit Fields (Edit Fields (Set)): sets 1 field: search_query
- Serper Search (HTTP Request): calls google.serper.dev (POST)
- parse search results (Code): runs custom JavaScript code
- Normalize leads (Code): runs custom JavaScript code
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Send a message (Gmail): uses Gmail
- Wait: waits 1.5 seconds
- Fetch Homepage (HTTP Request): calls an HTTP API
- Home Page Analyst (Basic LLM Chain): sends a prompt to an LLM, with model: Google Gemini Chat Model
- Format output (Code): runs custom JavaScript code
…plus 13 more steps. See the full node list below.
Services it uses
HTTP calls to: google.serper.dev, api.scraperapi.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 (12)
- Manual Trigger
n8n-nodes-base.manualTrigger - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Wait
n8n-nodes-base.wait - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Edit Fields (Set)
n8n-nodes-base.set - Merge
n8n-nodes-base.merge - If
n8n-nodes-base.if - Google Sheets
n8n-nodes-base.googleSheets - Gmail
n8n-nodes-base.gmail - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm
From the author
How it works This is an advanced "Agentic" workflow that acts as an autonomous lead generation specialist. It goes beyond simple scraping by "thinking" about where to look for contact info. 1. Search & Filter: It performs a Google Search for your niche (e.g.,…