In this post I’ll show you how to display Google Form results in Data Studio.
Google Forms are very useful for informal market research, gathering opinions on social media and deciding where to go for the office Christmas party!
Displaying Google Form results in Google Data Studio is relatively straightforward, and allows you to choose to display the data however you want. In this post I’ll give you an example of how to do it.
Below is a Google Form. Please fill it in!
Once you’ve submitted your responses they are sent to a Google Sheet.
Below is the Data Studio report which is connected to that Google Sheet.
How to display Google Form results in Data Studio
To connect our Google Form to Google Data Studio is relatively straightforward.
In Google Forms, go to the Response tab (as shown below).
Then click to view responses in Google Sheets.
It will then give you the option of creating a new sheet, or using an existing one.
We can create a new spreadsheet, and the responses will be added to it, as shown below.
To display these responses in Google Data Studio, we need to create a new Data Studio report.
Once we have done that we need to add the sheet as a data source.
We now have our responses in the sheet as a data source.
And then we can create a report showing the results however we want.
So that’s a very brief example of how you can display Google Form responses in Google Data Studio.
If you liked this article you might like my other blog posts.
Or you can follow me on Twitter!