How to Connect a Google Sheets Report to Looker Studio

How to Connect a Google Sheets Report to Looker Studio

Info
In this article, we'll show you how to use Google Sheets as a data source for Looker Studio. Learn all about connecting your spreadsheet, choosing field types, and integrating your data into Looker Studio charts for visually engaging presentations.

Activate the Spreadsheet Addon


Using the Spreadsheet Addon

The spreadsheet addon is included in our Pro and Custom (formerly Enterprise) plans. It enables you to use all of our connectors with Google Sheets and Excel, though only Google Sheets can be connected to Looker Studio.

Create a Report in Google Sheets

The addon panel is similar to the connector configuration page in Looker Studio except that you create each table individually. When creating a report to connect to Looker Studio, make sure the date range matches the one you are using in your Looker Studio report.



Deselect Show report header under Options.



Make a note of the name of the report and the sheet you wish to connect.



Connect the Sheet to Looker Studio

Click Add data at the top of the screen.



Select Google Sheets. This is a free connector provided by Google.



Select the report and sheet you wish to connect. Leave Use first row as headers checked.



Click Add, then click Add to Report.



Verify and Edit Your Data

Select Manage added data sources under Resource.



Click Edit next to the spreadsheet.



Verify each field has the correct label and type. If needed, modify the field type. Select the arrow and choose the correct type from the drop-down menu.



Use Your Sheet in Charts

Select your spreadsheet under Data Source to use it in a chart. 



    • Related Articles

    • Google Sheets Data Integration Guide

      Integrate your marketing data into Google Sheets to build custom reports and dashboards. This guide will walk through how to install the Sheets add-on, create reports, edit reports, refresh data, and more. Install the Google Sheets Add-on To install ...

    • Power My Analytics Data Connector User Guide

      The Power My Analytics (PMA) Data Connector is your gateway from Data Builder datasets to your reporting destinations. Design your datasets in Data Builder, then report your data in Looker Studio or Sheets or export to destinations like BigQuery and ...

    • Error: Authorization Is Required to Perform That Action

      This article provides troubleshooting steps for the "Authorization is required to perform that action" error. This error can occur when using Power My Analytics with Google services, including the Google Sheets add-on, Looker Studio connectors, or ...

    • Missing Data in Google Sheets Report

      This article will assist with the following issue: A Google Sheets report is missing data or does not show enough data for a date range. Cause Power My Analytics' Google Sheets connector defaults to a 1,000 row limit. Solution Check the sidebar under ...

    • Error: Data Appears Blank in Cells in Google Sheets Report

      If your Power My Analytics data appears blank in Google Sheets but becomes visible when you click on the cells, this is likely caused by incorrect column formatting. This article will help you identify and resolve this common formatting issue. Error ...