Google Sheets is part of the Google Docs suite of productivity apps. Google Sheets lets you create and format online spreadsheets, and work on them simultaneously with other people. The Looker Studio Google Sheets connector allows you to access data stored in a Google Sheets worksheet.
A Google Sheets data source can connect to a single worksheet in a Google Sheet.
To connect:
Sign in to Looker Studio.
On the Looker Studio home page, in the top left, click Create and then select Data Source.
Select the Google Sheets connector.
Select a Spreadsheet and Worksheet.
You can connect to 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.
Configure any of the data source options (see below).
In the upper right, click CONNECT.
The data source fields panel appears.
The data source is now connected to your data set.
All of the columns you've included in the connection now appear as fields in the data source. See Create and edit data sources to learn more about configuring your data source.
Options
Use first row as headers 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.)
Include hidden and filtered cells lets you include or exclude this datafrom the data source. The default value is to include them. This option only applies to filters, not to filtered views. Learn more about filters in the Sheets Help Center.
Optional Range lets you define a range of cells in the selected worksheet. Use standard column-row syntax to define the range: e.g., A1:Z26.
Field editing in reports
The Field Editing in Reports data source option allows report editors to change field definitions at the chart level. Editing field definitions in the report makes customizing your reports faster and easier. Learn more about editing fields in reports.
Configure the data source
The data source fields panel is where you configure the data source by renaming fields and adding descriptions, adding calculated fields, and changing data types and aggregations. Learn more about working with data source fields.
Control who sees the data
At the top of the fields panel, you can change the data credentials. Credentials control who can see the data that this data source provides.
OWNER'S CREDENTIALS lets other people view or create reports that use this data without requiring them to have their own access to the dataset.
VIEWER'S CREDENTIALS, on the other hand, requires each user of the data source to provide their own credentials to access the dataset.
Learn more about data credentials.
Create a new report from the data source
In the upper right, click CREATE REPORT.
The report editor appears.
Click ADD TO REPORT.
This adds the data source to the report.
You can now create charts and controls that get their data from this data source.
New to Looker Studio?
Take the Create a report tutorial. Or learn more about the report editor.
Notes
Your data must be in a tabular format. Learn more about how to prepare yourGoogle Sheets to work withLooker Studio.
The header row must be a single row.
All cells within a column should be of the same type.
If you make changes to a sheet after connecting itto a data source, be sure to refresh the data source fields to see those changes.
To connect to data in Microsoft Excel, save the spreadsheet in Google Sheets first.
Troubleshooting
If you're having trouble connecting to your spreadsheets, consider the following:
Looker Studio does not support accessing files on Team Drive. Please ensure that your Sheets are stored in standard Drive folders.
Make sure that you are using the same account for both Looker Studio and Google Drive. If you've accidentally connected Looker Studio to a different Drive account, you can remove that connection, then reconnect using a different account.
Here are some general tips on troubleshooting issues with Drive.
If you are a Google Workspace user, your organization must permit access to Drive. Learn how to manage Drive in Google Workspace.
About data sources
About Google Sheets
Google Docs help center
Was this helpful?
How can we improve it?
Need more help?
Try these next steps:
Post to the help community Get answers from community members
What's new in Looker Studio?
Learn about new features and recent changes.Looker Studio release notes live onGoogle Cloud.
Open your Microsoft Access database. Select the External Data tab in the ribbon. Expand the New Data Source drop-down and select From Other Sources, then select ODBC Dababase. In the Get External Data - ODBC Database dialog box, select Link to the data source by creating a linked table.
Open your Microsoft Access database. Select the External Data tab in the ribbon. Expand the New Data Source drop-down and select From Other Sources, then select ODBC Dababase. In the Get External Data - ODBC Database dialog box, select Link to the data source by creating a linked table.
Go to datastudio.google.com and log in with your Google account. Then, on the Data Studio homepage, create a blank report. Then, you'll be shown the Google Data Studio connectors gallery. Type "Porter" on the search bar, and you will find our available connectors.
Looker is a paid BI platform with advanced data modeling and machine learning, ideal for businesses with complex data needs. Looker Studio, on the other hand, is a free visualization tool perfect for creating reports and dashboards.
Make sure that your permissions on the google sheet are set to exactly "anyone with the link can view". If the permission is not exactly this, the sync process will be unable to open the sheet in order to sync, which may result in getting stuck. To solve, set the permission to "anyone with the link can view".
You can open Sheets in any of the following ways: Any web browser—Go to sheets.google.com. Google Drive—Click New. Google Sheets and create from scratch or from a template.
If you need to change or remove someone's access to your Google Sheet you can easily do this from the "Share with people and groups" dialog.Click the dropdown next to the person's name and choose a new option. You can also make someone the owner of the Google Sheet this way too.
It can be achieved by clicking on the URL Embed icon on the Google Data Studio toolbar, pasting the Google Forms link, which would then Embed the Google Form in the Report.
Introduction: My name is Kimberely Baumbach CPA, I am a gorgeous, bright, charming, encouraging, zealous, lively, good person who loves writing and wants to share my knowledge and understanding with you.
We notice you're using an ad blocker
Without advertising income, we can't keep making this site awesome for you.