How to use Google Data Studio with Google Sheets
Last updated
Last updated
Step 1: Navigate to https://datastudio.google.com/overview
Step 2: Click on "use it for free button
Step 3: Sign in with your Google account and password. You should now see the home page of the Data Studio
Step 4: click on 'Create' button on the top left:
Step 5: Click on 'data source'
Step 6: Find and Click on Google sheet connector
Step 7: Find and Click on the Google sheet
Step 8: Once you select the worksheet, there are still some decisions to make. You have three options:
Use the first row as headers. Selected by default. Does what it says on the tin.
Include hidden and filtered cells. Selected by default. If you want to keep data out of Data Studio by hiding its columns in Google Sheets, deselect this.
An optional range of cells containing your data. Data Studio looks at the entire worksheet by default. If your table lies in a certain range, specify that here.
Step 9: Click “Connect” to give Data Studio access to the Sheet:
Step 10: You should now see a screen like the one below. Next we need to help Data Studio understand what kind of data you’ve given it.
All the green fields represent dimensions (fields that can be counted) and all the blue fields represent metrics, usually categorical data. See the documentation for dimensions and metrics.
Step 11: Google Data Studio doesn't always determine the correct data type for each field. so you need to make sure that each field is of the correct data type.
Step 12: Create calculated fields (optional)
Data Studio allows you to add custom fields to a data sources. So instead of adding all sorts of columns and formulas to your sheet, you can add them to your data source. That’s great because you can add calculated fields on the fly, without modifying your source data. Your new fields will be accessible in any reports that use this data source.
Step 13: Once everything looks right then click on the "create report" button, this will create an empty report with your Google Sheets data source connected to it:
Step 14: Charts in this report will use your new data source by default. Now you’ve got a data source and report to work with. The rest is up to you!