Customer personality (BaZi, DISC, Numerology) with Gemini & Google Sheets
n8n21 modulesv1.0What 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 birth time. - Calculates Numerology (Life Path, Birth Day, Pinnacles/Challenges, Expression, Soul Urge, Personality, Maturity) and a phone “vibration” number. - Generates concise, sales-oriented bullet-point analyses with Gemini for BaZi, Numer
At a glance
Customer personality (BaZi, DISC, Numerology) with Gemini & Google Sheets is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects aggregate, code, filter, googleGemini. It's free to download. Follow the 5-step import below to go live in minutes.
- Platform
- n8n
- Connects
- aggregate, code, filter, googleGemini, googleSheets, googleSheetsTrigger
- Modules
- 21
- Price
- Free
- Version
- v1.0
About this workflow
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 birth time. - Calculates Numerology (Life Path, Birth Day, Pinnacles/Challenges, Expression, Soul Urge, Personality, Maturity) and a phone “vibration” number. - Generates concise, sales-oriented bullet-point analyses with Gemini for BaZi, Numerology, and DISC (from Notes). - Merges results and writes back to the sheet: Lunar Date of Birth, Four Pillars, Numerology, Four Pillars Analysis, Numerology Analysis, DISC Analysis, and a combined Personality summary—then flips Analysis Status to Done. - Handles missing data gracefully and logs clear warnings in the sheet fields. 👤 Who is this for - Sales teams working from spreadsheets who want fast personality cues for outreach. - Coaches/consultants providing light BaZi/Numerology/DISC summaries at scale. - SMBs maintaining lead/customer lists in Google Sheets and wanting auto-generated insights. ✅ Requirements - An n8n instance. - Google Sheets with these columns (English): No, Full Name, Date of Birth, Birth Time, Gender, Email, Phone, Status, Analysis Status, Purchase Value, Notes, Four Pillars, Four Pillars Analysis, Lunar Date of Birth, Numerology, Numerology Analysis, DISC Analysis, Personality, Script. - Google Sheets OAuth2 credentials connected in n8n. - Google Gemini API credentials (nodes use models like models/gemini-1.5-flash and models/gemini-2.5-flash). - (Optional) Confirm timezone (+07:00) used in the BaZi lunar calculations fits your use case. ⚙️ How to set up - Import the provided workflow JSON into n8n. - Connect Google Sheets credentials and point to your spreadsheet + sheet (gid). - Connect Gemini credentials and keep/adjust the default model IDs. - Ensure your sheet has the listed English column headers. - (Optional) Adjust the timezone constant in the Code nodes if you’re not in GMT+7. - Set Analysis Status = Run in any row you want analyzed and trigger a row update. 🔁 How it works 1. Trigger → Google Sheets Trigger fires on row update where Analysis Status = Run. 2. Pre-processing → Code computes Lunar DOB + Four Pillars; Code1 computes Numerology and phone metric. 3. Conditional flows → IF nodes check available inputs (BaZi/Numerology/Notes) and call the relevant Gemini nodes. 4. LLM Generation → Gemini returns three focused analyses (BaZi, Numerology, DISC) plus a combined Personality summary. 5. Merge/Aggregate → Results are merged for a single row. 6. Write-back → Google Sheets nodes update Lunar Date of Birth, Four Pillars, Numerology, Four Pillars Analysis, Numerology Analysis, DISC Analysis, Personality and set Analysis Status = Done. 💡 About Margin AI Margin AI is an AI-services agency that acts as your AI Service Companion. We design intelligent, human-centric automation solutions—turning your team’s best practices into scalable workflows and tools. Industries like marketing, sales, and operations benefit from our tailored AI consulting, automation tools, and chatbot development.
How to import this n8n workflow
- 1
Download the workflow JSON file after purchase.
- 2
Open n8n → click the menu → Import from File.
- 3
Select the downloaded JSON and import.
- 4
Set up credentials for each node that requires them.
- 5
Click Execute Workflow to test, then activate.
Setup guide
Setup guide included
Purchase to unlock the full step-by-step guide
Related N8n workflows
Estimate Construction Costs from Revit/IFC Models with GPT-4 and Claude
Content farming - : AI-powered blog automation for WordPress
Email summary agent
Automated SEO performance collection from Google Search Console to NocoDB
AI content creation and publishing engine with Mistral, Creatomate, and YouTube
Automated LinkedIn content creation with GPT-4 and DALL-E for scheduled posts
AI Timesheet Generator with Gmail, Calendar & GitHub to Google Sheets
n8n enterprise AI security firewall — guardrails for secure agents
Reviews
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
- JSON blueprint — instant download
- Setup guide PDF included
- 5 downloads · valid 30 days
- Works with n8n
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.
- Configure live on Google Meet / Zoom
- Free follow-up if workflow has defects
- Platform expert assigned to you