Enrich and classify company leads in Google Sheets with Crawl4AI and Gemini
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 19 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Gemini Chat Model and Google Sheets. It also calls xx.xx.xx.xx:11235 over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Read Leads from Sheets (Google Sheets): uses Google Sheets
- Process in Batches of (Loop Over Items (Split in Batches)): loops over the items in batches
- Set Email Field (Edit Fields (Set)): sets 1 field: email
- Set Company URL (Edit Fields (Set)): sets 1 field: url
- Post Crawling Request (HTTP Request): calls xx.xx.xx.xx:11235 (POST)
- Extract Information (Information Extractor): extracts structured fields from text with AI, with model: Use Google Gemini Chat
- Set Markdown Field (Edit Fields (Set)): sets 1 field: md
- Update Row in Sheet (Google Sheets): update
- Merge: merges the data from its input branches
- Analyze Markdown Content (AI Agent): runs an AI agent, with model: Google Gemini Interaction; output parser: Parse Structured Output
…plus 3 more steps. See the full node list below.
Services it uses
HTTP calls to: xx.xx.xx.xx:11235
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 - Manual Trigger
n8n-nodes-base.manualTrigger - Information Extractor
@n8n/n8n-nodes-langchain.informationExtractor - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Wait
n8n-nodes-base.wait - Merge
n8n-nodes-base.merge - Google Sheets
n8n-nodes-base.googleSheets - Edit Fields (Set)
n8n-nodes-base.set - AI Agent
@n8n/n8n-nodes-langchain.agent
From the author
Quick overview This workflow reads unenriched leads from Google Sheets, derives each company website from the email domain, crawls the homepage via Crawl4ai, and uses Google Gemini to extract company details and generate an Italian category and description…