Classify lead function and seniority in Google Sheets with Google 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 13 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets and Google Gemini.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Global Settings (Edit Fields (Set)): sets 10 fields: Google Document ID, Sheet ID, Batch Size…
- Read Data (Google Sheets): uses Google Sheets
- Configuration (Code): runs custom JavaScript code
- Filter Data (If): checks a condition and branches into true / false
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Normalise Company Name and Job Title (Code): runs custom JavaScript code
- Remove Duplicates (Code): runs custom JavaScript code
- Wait: pauses before continuing
- Gemini Payload (Code): runs custom JavaScript code
- Categorization (Google Gemini) (Google Gemini): uses Google Gemini
…plus 2 more steps. See the full node list below.
Services it uses
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 (8)
- Manual Trigger
n8n-nodes-base.manualTrigger - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Wait
n8n-nodes-base.wait - Google Gemini
@n8n/n8n-nodes-langchain.googleGemini - Edit Fields (Set)
n8n-nodes-base.set
From the author
Quick overview This workflow reads contacts from Google Sheets, uses Google Gemini to classify each contact’s job function and seniority from their job title and company name, and writes the Function, Seniority, and Confidence Score back to the same sheet.…