Google Sheets connector
Google Sheets is part of the Google Docs suite of productivity apps. Google Sheets is an online spreadsheet app that lets you create and format spreadsheets and simultaneously work with other people. The Data Studio Google Sheets connector allows you to access data stored in a Google Sheets worksheet.In this article:
How to connect to Google Sheets
A Google Sheets data source can connect to a single worksheet in a Google Sheet.
When creating a Google Sheets connector, you can select from any of the spreadsheets that you own or that have been shared with you. You can also paste in the URL of a Google Sheet to which you have access.
Next, you need to specify which worksheet to use.
The Use first row as headers option causes the data source to use the first row in your worksheet as the field names in the data source. If this option is not selected, the field names will use the column index (A, B, C, etc.)
The Optional Range field lets you define a range of cells in the selected worksheet. Use standard column-row syntax to define the range: e.g., A1:Z26.
Data Studio requires that the range or worksheet selected be in a tabular format.
The header row must be a single row.
All cells within a column should be of the same type.
The range or worksheet you select should represent a table. Mixing other non tabular data, charts, sparklines, or other non-data information will result in data quality issues in your reports.
Once you connect to a spreadsheet, you may only append, or remove columns from the sheet. Rearranging, inserting, or removing columns other than the last one is currently not supported and can lead to data quality issues. If you need to rearrange columns, you should create a new data source.