Customer personality (BaZi, DISC, Numerology) with Gemini & 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 21 nodes and runs on Google Sheets events. Along the way it connects Google Sheets and Google Gemini.
How it runs
Trigger: On Google Sheets events.
- Filter: keeps only the items that match a condition
- Compute Bazi (Code): runs custom JavaScript code
- Compute Numerology (Code): runs custom JavaScript code
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Update row in sheet (Google Sheets): uses Google Sheets
- Get row(s) in sheet (Google Sheets): uses Google Sheets
- If: checks a condition and branches into true / false
- If: checks a condition and branches into true / false
- If: checks a condition and branches into true / false
- Summary Customer Insight (Google Gemini): uses Google Gemini
…plus 10 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 (9)
- Google Sheets Trigger
n8n-nodes-base.googleSheetsTrigger - If
n8n-nodes-base.if - Merge
n8n-nodes-base.merge - Aggregate
n8n-nodes-base.aggregate - Google Sheets
n8n-nodes-base.googleSheets - Filter
n8n-nodes-base.filter - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Code
n8n-nodes-base.code - Google Gemini
@n8n/n8n-nodes-langchain.googleGemini
From the author
📄 What this workflow does This workflow turns your n8n into an automated personality-insights engine driven by Google Sheets. When a row is updated with Analysis Status = Run, it: - Computes Lunar Date of Birth and Four Pillars (BaZi) from DOB and optional…