How to Connect a Google Sheets Report to Data Studio

How to Connect a Google Sheets Report to Data Studio

Though Data Studio is the superior presentation tool, many reports are easier to create with spreadsheets. This article will help you learn how to take the reports you've created in Google Sheets and connect them to Data Studio to create a seamless presentation. 

Activate the Spreadsheet Addon

The spreadsheet addon is included in our Agency and Enterprise plans and is available for $49.95 USD per month with all other plans. It enables you to use all of our connectors with Google Sheets and Excel, though only Google Sheets can be connected to Data Studio.
Follow the instructions in Installing the Google Sheets add-on to install the tool and activate this option.

Create a Report in Google Sheets

The addon panel is similar to the connector configuration page in Data Studio except that you create each table individually. When creating a report to connect to Data Studio, make sure the date range matches the one you are using in your Data 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 Data Studio

Click Add data at the top of the screen.

Select Google SheetsThis is a free connector provided by Google.

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

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.

    Still having issues?
    Send us a ticket and we will get back to you.
      • Related Articles

      • 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 100 row limit. Solution Check the sidebar under ...
      • Data Studio Connector Guide

        When connecting to Google Data Studio, there are a few best practices to keep in mind.  From demo templates to customizations to troubleshooting, this guide will teach you some pro tips for using Power My Analytics data connectors. Use a Free Power ...
      • Choose a Data Destination

        Not sure where to begin with making reports or having trouble deciding which reporting tool will be best for your business? Let us help! This article will tell you what you need to know about which reporting options are available with your plan and ...
      • Transfer Ownership of a Google Data Studio Report

        When you create a report in Google Data Studio, your account becomes the owner of that report. If you want to transfer ownership over a report to another user, follow these instructions. Begin in your Data Studio report. In the upper right corner, ...
      • Google Sheets Data Integration Guide

        See the following video for a quick overview of using our Google Sheets data destination: To install the Google Sheets add-on, you can find it here: Once ...