best habit tracker template google sheets

pick the right layout

Start with a simple table: date, habit name, status, notes. Keep the header row bold and freeze it so it stays visible while you scroll. A narrow date column (MM/DD) saves space and lets you glance at the month at a glance.

define habit types

Create a dropdown for each habit cell. In Google Sheets, Data → Data validation → List of items, type “done, skipped, freeze”. The three options cover check‑off habits, a rest day, and a missed day without breaking a streak. I use the same list in my Trider app, where “freeze” is a limited feature that protects my streaks.

calculate streaks automatically

Add a helper column called “streak”. Use this formula in row 2 and drag down:

=IF(B2="done", IF(A2=TODAY()-1, C1+1, 1), IF(B2="freeze", C1, 0))  

It checks whether yesterday’s status was “done”, then adds one; a freeze carries the previous count forward. The result is a live streak count that updates every day.

color‑code for quick scanning

Conditional formatting turns green when the status is “done”, orange for “freeze”, and red for anything else. Select the status column, Format → Conditional formatting, add three rules with custom formulas like =$B2="done". The visual cue is the same vibe I get from Trider’s color‑coded categories (Health, Productivity, Mindfulness).

embed a timer habit

If you want a Pomodoro‑style habit, add a column named “timer”. Put the minutes you plan to work (e.g., 25) and a checkbox next to it. When the checkbox is ticked, a script can pop a toast:

function onEdit(e){  
  var range = e.range;  
  if(range.getColumn()==5 && e.value=="TRUE"){  
    SpreadsheetApp.getActiveSpreadsheet().toast("Timer completed – great job!");  
  }  
}  

The toast mimics the satisfaction of finishing a timer habit in Trider, where the habit only marks complete after the built‑in timer runs out.

link to your journal entries

Create a second sheet called “journal”. Each row mirrors the date column from the tracker. Write a quick note, add a mood emoji, and tag it with keywords. In the tracker sheet, use =VLOOKUP(A2, journal!A:C, 2, FALSE) to pull the mood into the main view. This mirrors the way Trider auto‑tags journal entries and lets you see mood trends alongside habit performance.

set up daily reminders

Google Sheets can’t push notifications, but you can schedule an email reminder with Apps Script:

function sendReminder(){  
  var today = Utilities.formatDate(new Date(), "GMT", "MM/dd");  
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("tracker");  
  var range = sheet.getRange("A2:A");  
  var dates = range.getValues().filter(r=>r[0]==today);  
  if(dates.length){  
    MailApp.sendEmail(Session.getActiveUser().getEmail(), "Your habit check‑in", "Open your sheet and update today’s habits.");  
  }  
}  

Trigger it to run every morning. It’s a cheap hack that feels like the push notifications Trider sends for each habit reminder.

use a template pack for quick start

Search the template gallery for “habit tracker”. Pick one that matches your style, then tweak the columns to match the dropdown and streak formula above. I often import a “Morning Routine” pack, then replace the generic checkboxes with the three‑option list I described. The result is a ready‑made board that still feels personal.

track progress over time

Add a chart on a separate “analytics” sheet. Highlight the streak column, Insert → Chart, choose a line chart. The visual line shows ups and downs, just like the analytics tab in Trider where you can see consistency over weeks.

keep it tidy with archiving

When a habit is no longer relevant, move its rows to an “archive” sheet. The main tracker stays lean, and the historical data is still searchable. In Trider you’d archive a habit, preserving the data without cluttering the dashboard.

And that’s the core of a flexible, free habit tracker you can build in Google Sheets. No fluff, just the pieces you need to start logging, visualizing, and improving your daily routines.