How to Connect Google Data Studio (Looker Studio) to a Google Sheet

Google Sheets is an excellent tool for storing and organising data, but when it comes to presenting that data to clients, stakeholders, or team members, standard spreadsheets often fall short. Reading rows and columns of raw numbers is rarely the most effective way to communicate performance metrics or trends.

Google Looker Studio (formerly known as Google Data Studio) bridges this gap. It is a powerful, free data visualisation platform that allows you to turn raw spreadsheet data into interactive, professional dashboards and reports. By connecting Looker Studio directly to your Google Sheets, any updates you make to your spreadsheet are automatically reflected in your visual dashboard.

In this guide, you will learn how to properly prepare your Google Sheet, establish a live connection to Looker Studio, and build your first interactive report.

Step 1: Prepare Your Google Sheet for Looker Studio

Before attempting to connect the two platforms, you must ensure your Google Sheet is formatted correctly. Looker Studio requires structured data to read your spreadsheet accurately.

1. Use a Single Header Row: The very first row of your sheet (Row 1) must contain your column names (e.g., “Date”, “Revenue”, “Region”). Looker Studio uses this row to create your metrics and dimensions.
2. Do Not Merge Cells: Merged cells will break the data connection. Ensure every cell contains a discrete value.
3. Ensure Consistent Data Types: Do not mix text and numbers in the same column. For example, a “Revenue” column should only contain numerical data (e.g., 1500), not text like "1500 USD". Apply currency formatting via the Google Sheets toolbar instead.
4. Remove Empty Rows and Columns: Delete unnecessary empty rows at the bottom and empty columns to the right of your dataset to improve report loading speeds.

Step 2: Connect the Google Sheet to Looker Studio

Once your spreadsheet is structured properly, you can establish the connection.

1. Navigate to Looker Studio (lookerstudio.google.com) and log in with the same Google Account you use for Google Sheets.
2. Click the large Blank Report button (featuring a plus icon) in the top left corner.
3. You will immediately be prompted to add data to your report. Under the Google Connectors section, click on Google Sheets.
4. If this is your first time using Looker Studio, click Authorise to grant the application permission to view your Google Drive files.
5. You will see a list of your spreadsheets. Select the spreadsheet you prepared in Step 1.
6. Under Worksheet, select the specific tab containing your data.
7. Ensure the checkboxes for “Use first row as headers” and “Include hidden and filtered cells” are checked.
8. Click the blue Add button in the bottom right corner.
9. A prompt will appear confirming you want to add this data to the report. Click Add to Report.

Step 3: Understanding Dimensions and Metrics

Looker Studio will automatically generate a simple table on your blank canvas using your data. Before building complex charts, you must understand how Looker Studio categorises your spreadsheet columns.

• Dimensions (Green fields): These are categories or qualitative data (e.g., Dates, Names, Regions, Product Types). They define what you are measuring.
• Metrics (Blue fields): These are quantifiable numbers (e.g., Revenue, Clicks, User Count, Totals). They define how much of something there is.

Looker Studio generally guesses these correctly, but you can change a field’s type in the right-hand properties panel if it makes a mistake (e.g., treating a zip code as a metric instead of a dimension).

Step 4: Building Your Dashboard

With the connection established, you can now visualise your data.

1. Add a Chart: Click Add a chart in the top toolbar. Select a Time series chart and click anywhere on the canvas to place it.
2. Configure the Data: Click on your new chart. In the right-hand panel under the Setup tab, set your Dimension to a Date column, and your Metric to a numerical column (e.g., Revenue).
3. Style the Chart: Switch to the Style tab in the right-hand panel. Here you can change line colours, add data labels, adjust background colours, and configure the axes.
4. Add a Filter Control: To make the dashboard interactive, click Add a control in the toolbar and select Drop-down list. Place it at the top of your report. Set the Control Field to a dimension (e.g., “Region”). Viewers can now use this drop-down to filter the entire report to only show data for a specific region.

Step 5: Refreshing Data and Sharing

The connection between your Google Sheet and Looker Studio is live, but it is heavily cached to ensure fast loading times.

If you add new rows to your Google Sheet, the dashboard will automatically update every 15 minutes by default. If you need the dashboard to reflect changes instantly, click the three-dot menu in the top right corner of Looker Studio and select Refresh data.

To share your completed dashboard, click the blue Share button in the top right corner. You can invite specific team members via email, or generate a public link allowing anyone to view (but not edit) your interactive report.

By connecting Google Sheets to Looker Studio, you transform static data entry into dynamic, automated reporting, saving hours of manual presentation work.