How to display Google Form results in Data Studio

By 14th Apr 2019Blog, Google Sheets, Surveys
How to display Google Form results in Data Studio

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.

The data from the Google Form in Google Sheets.

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.

Choosing Google Sheets as the data source in Data Studio.

We now have our responses in the sheet as a data source.

The data from the Google Form in Google Data Studio.

And then we can create a report showing the results however we want.

An example of how to display Google Form results in Data Studio

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!

Michael

Author Michael

More posts by Michael

Join the discussion 2 Comments

  • oglak says:

    hi michael. i made your steps that you showed but i couldn’t make it happen.
    i have a google forms poll. and the responses of that pool.
    i just want to show my submitters to results on my wordpress site as an embed of google data studio.
    but i just couldn’t, and this is so sad.
    can you help me, please?

    • Michael says:

      Is your issue that you can’t embed your data studio report? Did you successfully get the google form results into data studio?

Leave a Reply