How to Setup a Custom Habit Tracking Dashboard Using Google Forms and Google Data Studio
By: Pat Strickler
Determine a Habit to Track
Create a Google Form to Track Your Habit
Connect Google Data Studio to Habit Tracking Sheet
In this tutorial, I will show you how I created a simple way to setup a custom habit tracking dashboarding using two free tools: Google Forms and Google Data Studio.
Step 1: Determine a Habit to Track
Luckily, the first step in our process is also the easiest, and you’ve probably already completed it — you need to determine what habit you want to track. This can be any habit that you are trying to build into your daily or weekly routine, and if you need more help in developing a habit, check out Atomic Habits by James Clear.
Step 2: Create a Google Form to Track Your Habit
Alright, it’s time to actually do some work — luckily this will be pretty easy as well because I’ve developed a great Google Forms Habit tracking template for you. Unfortunately, there isn’t a way to share an editable version, so you will have to follow my general format and create a new Google Form of your own.
Once you have your form setup, it’s crucial that you go to the ‘Responses’ tab and click the ‘Create a Sheet’ icon. This will generate a Google Sheet with all of your form responses, which we will need for the next step.
Step 3: Connect Google Data Studio to Habit Tracking Sheet
Now it’s time to create our custom Habit Tracking dashboard! If that sounds like a daunting task, then you can use this awesome Google Data Studio Habit Tracking dashboard template that I created. After opening the template, click copy in the top right, connect to your own data, and *voila* your data should appear. If data doesn’t automatically appear, you may need to adjust the visuals by adding the correct metrics and resorting.
And that’s all there is to it. Now you can fill out your Google Form every time you complete a habit and watch your dashboard update in real time! If you run into any issues following this tutorial, please leave a comment below.
CompassRed is a full-service data agency that specializes in providing data strategy for clients across multiple industries.