--- title: "I built a Weekly and Monthly Habit Tracker app on Google Sheets" description: "Track your weekly and monthly habits with this spreadsheet built using Google Sheets." source: "Preetam Nath" canonical_url: "https://www.preetamnath.com/blog/weekly-monthly-habit-tracker-app-google-sheets" published: "2020-08-02" updated: "2021-01-24" --- # I built a Weekly and Monthly Habit Tracker app on Google Sheets Habit trackers are tricky. There's thousands of options and flavours to choose from. Each habit tracker app is reflective of the mindset and approach of the creator towards habits. Some are rigid, some try to be very customisable. Over the years, I've never once found a more perfect habit tracking app than drawing a table on my notebook with a pen, and marking the days. I was doing this on a weekly basis for nearly all of 2019, but losing last week's progress to the pages in my notebook and not being able to easily visualise progress longer than a week would constantly bother me. 2 months ago, I bought an iPad and tried drawing the table there. But something didn't sit right. It didn't make sense to make the same table with the same constraints, only on a digital paper this time. And thus, the [Weekly Habit Tracker Template](https://www.preetamnath.com/habit-tracker-template/weekly.md) and [30 Day Monthly Habit Tracker Template](https://www.preetamnath.com/habit-tracker-template/monthly.md) spreadsheets were born. ![](https://media.preetamnath.com/post-images/weekly-monthly-habit-tracker-app-google-sheets-image-1.webp) ![](https://media.preetamnath.com/post-images/weekly-monthly-habit-tracker-app-google-sheets-image-2.webp) This is the MVP, but it already does everything you would need. Here is how it works: * Set the habits you want to track. * Set a goal for each habit. "Goal" is simply the number of times you want to perform a habit in a week / month. * Mark the days you complete the habit with a \* or any character. The cell will automatically highlight to green. * The "Achieved" column will automatically count number of times you perform a habit, and will give you a Yay or a Nay based on whether you achieved your goal. * Add a note at the end of the week / month on why you couldn't hit your target, and what you would do differently next week. Best part is, your data is your own. After you duplicate the spreadsheet, it lives in your Google Drive account. I personally am using the monthly tracking spreadsheet since mid-July and I'm hopeful that it will benefit your life too. ✌️ ## 💬 Discuss on Twitter [View this tweet on X](https://twitter.com/i/status/1289775840130142209) --- Canonical page: https://www.preetamnath.com/blog/weekly-monthly-habit-tracker-app-google-sheets When citing or referencing this content, please credit Preetam Nath and link to the canonical page above. ## About Preetam Nath Preetam Nath is an entrepreneur and indie software builder. He writes about building profitable SaaS businesses while leading a good life, from first-hand experience: he co-founded SuperLemon, a WhatsApp plugin for Shopify stores that grew to $25k MRR, and DelightChat, a customer support product for ecommerce and D2C brands. His website (https://www.preetamnath.com) publishes his blog on business, life, mental models and building SaaS businesses, along with a Micro-SaaS guide, a Programmatic SEO course, and Google Sheets habit tracker templates. - Homepage: https://www.preetamnath.com/index.md - Blog: https://www.preetamnath.com/blog.md - X/Twitter: https://x.com/hipreetam93 - LinkedIn: https://www.linkedin.com/in/nathpreetam/ - Email: hipreetam93@gmail.com ## Continue Reading - [Mental model: Life is a RPG video game](https://www.preetamnath.com/blog/life-is-a-video-game-a-mental-model.md) - [Why you should fire your bad customers](https://www.preetamnath.com/blog/fire-your-bad-customers.md) - [Guide: Make Money Building Shopify Micro-SaaS Apps](https://www.preetamnath.com/blog/shopify-micro-saas.md) - [Focus on what you can control](https://www.preetamnath.com/blog/focus-on-what-you-can-control.md) --- Complete index of all pages on this site, with descriptions and markdown links: https://www.preetamnath.com/llms.txt