Generate weekly habit and mood insights with Google Sheets and OpenAI
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 17 nodes and runs when someone submits an n8n form (“Daily Check In”) (plus 1 other trigger). Along the way it connects Google Sheets, Gmail and OpenAI Chat Model.
How it runs
Trigger: When someone submits an n8n form (“Daily Check In”) (plus 1 other trigger).
- Normalize Answers (Edit Fields (Set)): sets 15 fields: Mood, Energy, Stress…
- Get Daily Entries (Google Sheets): uses Google Sheets
- Calculate Daily Scores (Code): runs custom JavaScript code
- Calculate Weekly Analytics (Code): runs custom JavaScript code
- Append Daily Entry (Google Sheets): append
- Enough Entries? (If): checks a condition and branches into true / false
- Check Support Flag (If): checks a condition and branches into true / false
- Basic LLM Chain: sends a prompt to an LLM, with model: OpenAI Chat Model
- Send Not Enough Data Message (Gmail): uses Gmail
- Send Supportive Confirmation (Gmail): uses Gmail
…plus 4 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)
- Edit Fields (Set)
n8n-nodes-base.set - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - n8n Form Trigger
n8n-nodes-base.formTrigger - Gmail
n8n-nodes-base.gmail - Schedule Trigger
n8n-nodes-base.scheduleTrigger - If
n8n-nodes-base.if - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi
From the author
Quick overview Track daily mood, energy, sleep, stress, focus, and habits with a simple form, then receive a weekly AI-generated personal analytics report with patterns, best/hardest day comparison, and one small experiment for the next week. The result helps…