How to connect Google forms with Google Data Studio to Create a Simple Dashboard

Google products are generally free for use, don’t need to go overboard if you handle simple data. No Cost, Just Productive Dashboard

Reminder: this is just a soft introduction tutorial on connecting google forms and data studio. Depth explanation of charts configuration is not included.

Photo by Luke Chesser on Unsplash

Everyone wants to create their own dashboard that could help them understand and track their productivity. Also, we have to consider that metric of productivity is vague, and people have their version to follow.

So here is the intro. tutorial that could help you guys get started in exploring your data through google forms and google data studio that is generally free of use.

*thanks Google!

First, we gather data… but in a uniformed way. Spreadsheets may create too much freedom, which may deter us from inserting data every day or every hour, so we will use google forms.

you can make your own question as you see fit

Second, we go to the from editor > responses then click the spreadsheet button to check if data is being saved properly.

Note: you could always alter your results in the spreadsheet but this may affect your data integrity when doing a data sensitive project

click the spreadsheet button to check if the information is being saved correctly

Third, go to google datastudio to add ‘blank report’ to create a dashboard.

Click the blank report

then click new data source to add to your dashboard

create a new data source

then select spreadsheets to find your survey file,

just hover your cursor to google sheet then you will see the select button light up

then click the file name that is connected to your survey.

NOTE: usually the end with a post-fix called ‘(Responses)

click connect to import them to google data studio

then google data studio would automatically parse and connect your data to your new blank dashboard.

Fourth, play around with pre-built charts, filters, and tables.

Quick Tip: Usually, I use all the tools in the insert section.

retracted some of the sensitive data

I suggest exploring the following features:

1. Table — just a way to organize data (you could use hyperlinks here as well)
2. Filter Control — for filtering data using your categorical data
3. Text — just simple text to add labels
4. scorecard — Calculates the sum of all data or using a specific filter

an okay result for something free for use

Tada! We are done.

Friendly Personal Note: Just make it a habit of using the form system; By the end of the year, you will have serious personal data to analyze to add to your new year’s resolution!

Thank for reading, should you have any questions about this project please comment below. I will try to answer the question to the best of my knowledge.