The Gratitude & Daily Journal Tracker in Google Sheets is a 4-tab daily journal tracker in Google Sheets built around a 16-column journal log, 6 columns that calculate themselves, 4 live charts and a single running counter that reached 38 gratitude moments across 15 sample days. Setup takes under 10 minutes: open the PDF, click the copy link, clear the sample rows and start writing.
🌍 Join 8,400+ people in 40+ countries using NextGenTemplates to replace subscription apps with one-time-purchase Excel, Google Sheets, Power BI and HTML templates.
✅ Instant download · One-time payment · No subscription · No per-user fees · Lifetime access
⚠️ This is a personal journaling and reflection template. It is not a medical or mental-health record, not a diagnostic tool and not a substitute for therapy. It contains no validated clinical scale. If a low mood persists, please speak with a qualified professional.
🔑 Key Features of the Gratitude & Daily Journal Tracker
📝 One row is one day. You type nine things — Date, Mood, Energy on a 1-10 scale, up to three separate gratitudes, a Gratitude Focus, a Journal Prompt and the Journal Entry itself. Everything else on the row is a formula, so a day takes about two minutes to log.
🧮 Six columns calculate themselves. Day, Word Count, Gratitude Count, Mood Score, Wellbeing Score and Entry Status are all formula-driven. Mood Score is looked up from the List tab, so changing a mood in the dropdown instantly re-scores that day.
📊 A Wellbeing Score out of ten, with the arithmetic on show. The score is (Mood Score ÷ 5) × 6 + (Energy ÷ 10) × 3 + (Gratitude Count ÷ 3) × 1 — mood weighted 6, energy weighted 3, gratitude weighted 1. It is a plain formula over numbers you typed yourself, not a clinical assessment, and every sample row reconciles to it exactly.
✅ Entry Status flags rushed days. A day reads Complete only when you have logged all three gratitudes and written at least 25 words. Everything else stays In Progress, so a month of one-line entries is visible at a glance instead of hiding in the scroll.
🎯 Three dropdown lists you own. Mood, Gratitude Focus and Journal Prompt read the List tab from rows 2 to 500. Ten moods ship with scores from 1 (Low) to 5 (Grateful, Joyful); ten focus areas ship — Family, Friends, Health, Career, Personal Growth, Finances, Faith & Spirit, Nature, Home & Comfort and Learning; eight reflection prompts ship. Type your own underneath any list and it appears in the dropdown immediately.
⚡ Charts wired straight to the log. All four charts read rows 16 to 1000 of the journal sheet directly. There are no hidden helper tables to maintain and no refresh button to press — a new entry updates every visual the moment you finish typing.
📦 What’s Inside the Daily Journal Tracker in Google Sheets
The file is four tabs: the Gratitude Journal page, a List tab holding the dropdown values, a How to Use tab and an Explore More Templates tab.
Page 1: Gratitude Journal — dashboard and log on one screen
The dashboard band across the top carries one KPI card, GRATITUDE MOMENTS, which counts every individual gratitude you have ever logged (38 in the shipped sample), plus four charts: Entry Count by Mood, Entry Count by Gratitude Focus, Wellbeing Score by Date and Word Count by Date. Immediately below sits the 16-column journal table, pre-filled with 15 worked days from 01-Aug-2026 to 15-Aug-2026 so you can see exactly how a good entry reads before you write your own.
Page 2: How to Use — the four-step setup guide
A plain-language guide covering the four things that matter: write your day, let the automatic columns run, read your progress off the counter and Entry Status, and extend the dropdowns from the List tab. It also carries the customisation notes and the reminder that this is a reflection tool, not a mental-health record.
Page 3: Explore More Templates
A shortlist of related NextGenTemplates products with categories, formats, prices and direct links, plus a coupon code for your next purchase.
📊 Gratitude & Daily Journal Tracker vs. an Excel journal vs. a paid journaling app
| Feature | Gratitude & Daily Journal Tracker in Google Sheets | Microsoft Excel journal template | Day One / Daylio / Reflectly |
|---|---|---|---|
| Cost | $6.99 one-time ✅ | $5-15 one-time | $3-6 / month, billed yearly |
| Platform | Google Sheets, any browser ✅ | Desktop Excel | Phone app, vendor cloud |
| Setup time | Under 10 minutes ✅ | 15-30 minutes | 5 minutes |
| Your data lives | In your own Google Drive ✅ | On your PC | On the vendor’s servers |
| Editable scoring formula | Yes — reweight mood, energy and gratitude ✅ | Yes | No, the algorithm is closed |
| Add your own moods and prompts | Yes, rows 2-500 of the List tab ✅ | Yes, by editing the file | Limited to the paid tier |
| Charts included | 4, live off the log ✅ | Build them yourself | Vendor’s own charts only |
| Export your entries | CSV, XLSX or PDF any time ✅ | Yes | Often gated or lossy |
| Year-1 cost | $6.99 ✅ | $5-15 | $36-72 |
For people who want their journal to stay in a file they control rather than in someone else’s app, the Gratitude & Daily Journal Tracker sits in the sweet spot.
👥 Who This Template Is For — and Who It’s Not For
✅ This template is built for:
- Anyone keeping a daily gratitude practice who wants the entries searchable rather than scattered across notebooks
- Journalers who already live in Google Sheets and want mood, energy and gratitude on the same row as the writing
- Coaches, therapists’ clients and habit-builders who want a printable, exportable record of their own reflection
- People who dislike subscription journaling apps and want the file in their own Drive
❌ This template is NOT for:
- Anyone needing a clinical instrument — there is no PHQ-9, GAD-7 or any other validated scale here, and the Wellbeing Score is arithmetic, not an assessment
- Clinicians keeping patient records; this has no encryption, no audit trail and no HIPAA or GDPR compliance layer
- People who want push notifications, streak badges or phone-first journaling — a spreadsheet will always be a deliberate sit-down
- Teams wanting shared, permissioned journals with role separation
⚙️ How to Use the Gratitude & Daily Journal Tracker
- Open the PDF in your download and click the “Make a copy” link to put your own editable copy in Google Drive.
- Open the List tab and adjust the moods, focus areas and prompts to your own language. Change the Mood Score values if you want a different weighting.
- Go to the Gratitude Journal tab and delete the 15 sample rows once you have read a few of them.
- Add today’s row: Date, Mood, Energy 1-10, up to three gratitudes, a Gratitude Focus, a Journal Prompt, then write your entry.
- Leave the last six columns alone — Day, Word Count, Gratitude Count, Mood Score, Wellbeing Score and Entry Status fill themselves in.
- Check Entry Status. Anything still reading “In Progress” means fewer than three gratitudes or under 25 words, so finish the thought.
- Review the four charts weekly to see which moods and which focus areas your good days actually come from.
💼 Real-World Use Cases
Priya keeps a five-minute morning practice. She logs three gratitudes, her mood and her energy before opening email. After six weeks the Entry Count by Gratitude Focus chart showed her that almost every good day traced back to Friends and Nature — and almost none to Career — which is why she now blocks Friday afternoons.
Daniel journals to manage a demanding job. He uses the Wellbeing Score line to see the shape of a month rather than the noise of a day, and the Word Count chart to catch the weeks where he was only typing one rushed line. He pairs it with the Habit Tracker in Google Sheets so the reflection and the routine sit side by side.
Meera runs a small coaching practice. She sends each new client a copy of the tracker, asks them to fill it for thirty days, and reviews the exported PDF at the next session — no app account, no per-seat fee, and the client keeps the file when the engagement ends.
❓ Frequently Asked Questions
What exactly does the Gratitude & Daily Journal Tracker record?
The Gratitude & Daily Journal Tracker records one row per day with your date, mood, energy 1-10, up to three gratitudes, a gratitude focus, a reflection prompt and your written entry. Six further columns — day, word count, gratitude count, mood score, wellbeing score and entry status — calculate automatically.
How is the Wellbeing Score calculated?
The Wellbeing Score is (Mood Score ÷ 5) × 6 + (Energy ÷ 10) × 3 + (Gratitude Count ÷ 3) × 1, giving a number out of ten. Mood carries the most weight, then energy, then how many gratitudes you logged. You can change the Mood Score values on the List tab to reweight it.
Is this a mental-health or medical tool?
No. The Gratitude & Daily Journal Tracker is a personal journaling and reflection template. It is not a medical or mental-health record, not diagnostic and contains no validated clinical scale. If a low mood persists, please speak with a qualified professional.
Can I add my own moods and journal prompts?
Yes. The List tab feeds the three dropdowns and is read from rows 2 to 500, so anything you type underneath an existing list appears in the Gratitude & Daily Journal Tracker dropdowns automatically. Give each new mood a score from 1 to 5.
How long does setup take?
Under 10 minutes. Open the PDF in your download, click the “Make a copy” link, edit the List tab to your own language and delete the 15 sample rows. The Gratitude & Daily Journal Tracker is ready to write in immediately after that.
How does this compare to a paid journaling app like Day One or Daylio?
Those apps cost roughly $36-72 a year and keep your entries and their scoring logic on their servers. The Gratitude & Daily Journal Tracker is a one-time $6.99 purchase, lives in your own Google Drive, exposes every formula and exports to CSV, XLSX or PDF whenever you want.
Do I need Excel or any add-on to use it?
No. The Gratitude & Daily Journal Tracker runs entirely in Google Sheets in any browser, with no add-ons, no macros and no scripts. You can open the same copy on a phone, though writing longer entries is easier on a laptop.
👤 About the Author
Built by PK — Microsoft Certified Professional with 15+ years of Excel, Google Sheets and Power BI experience. Founder of NextGenTemplates, reaching 300K+ subscribers across YouTube channels (@PK-AnExcelExpert, @NextGenTemplates, @NeoTechNavigators). Every template is hand-built and tested before release.
🔗 Explore Related Templates
- Mood & Mental Health Tracker in Google Sheets — the mood-first sibling, with a risk flag and a longer daily log.
- Anxiety & Trigger Journal Tracker in Google Sheets — same journaling shape, aimed at naming triggers rather than gratitudes.
- Meditation & Mindfulness Tracker in Google Sheets — logs sessions and minutes alongside the reflection.
- Gratitude Practice Checklist in Google Sheets — the lighter checklist version if you do not want a written journal.
Browse the full range of Google Sheets Dashboards and Tracker Templates for more one-time-purchase tools.
📖 Click here to read the Detailed Blog Post
🎥 Visit our YouTube channel for step-by-step video tutorials
👉 YouTube.com/@NextGenTemplates
Watch the step-by-step video Demo:
📅 Last updated: September 2026
