Skip to content
Knowledge Base

Google Sheets Data Source Connector User Guide

Last updated

The Google Sheets data source connector brings data from your own Google Sheets spreadsheets into Power My Analytics, so you can report on it in Data Studio or combine it with your other marketing data in Data Builder.

Note: Google Sheets (as a data source) is a Beta connector. It is available in every Hub, where it appears in the source gallery with a BETA label. While it is in Beta, some fields, configuration options, and behavior may still change as we continue to improve it. We will expand this guide as the connector develops, and your feedback helps shape what comes next.

Note: This connector is not the same as the Power My Analytics add-on for Google Sheets. The data source connector, added under Sources, imports data from your spreadsheets into Power My Analytics. The add-on does the opposite: it sends your Power My Analytics data into a spreadsheet. For the add-on, see the Google Sheets Data Integration Guide.

Prerequisites

Before you begin, make sure you have:

  • The Google account that owns the spreadsheets you want to connect.
  • The URL of each Google Sheets spreadsheet you want to connect.

Adding Google Sheets as a Data Source

  1. In your Power My Analytics Hub, select Sources from the menu.
  2. Click + Add new source and choose Google Sheets from the gallery.
  3. Choose the Google account that owns the spreadsheets you want to connect.
  4. On Google's permissions screen, grant the See, edit, create, and delete all your Google Sheets spreadsheets permission, then click Allow.
  5. Enter the URL of each Google Sheets spreadsheet you want to connect, then click Continue.

Note: Power My Analytics requests this permission only to read and import data from the spreadsheets you connect. It will never edit, create, or delete your spreadsheets without your specific approval.

Creating a Data Studio Report

  1. In your Hub, go to Reports > Data Studio and click the orange + Create report button.
  2. In the Templates window, select Single sources, find Google Sheets, and click Open in Data Studio.
  3. In Data Studio, click Authorize if you are prompted, then select your Power My Analytics Hub and the Google Sheets account you connected.
  4. Under Sheet, select the sheet you want to report on.
  5. Click Connect (top right), then click Create report.

Key Reports and Fields

The fields for this connector come from the sheet you select, so every spreadsheet has its own set of fields. Because of that, the Google Sheets Schema Explorer lists only the standard Power My Analytics fields for this connector, not your sheet's columns.

What you'll see in your report

  • The columns of the sheet you selected, ready to use as dimensions and metrics.
  • Sheet Composite Key, a combination of two or more columns that uniquely identifies each row, used when no single column is unique.

Limitations and Important Considerations

  • One sheet per data source configuration: In Data Studio, each data source reports on one sheet. To combine data from several sheets, build a dataset in Data Builder.
  • Beta connector: While the Google Sheets data source connector is in Beta, fields, configuration options, and behavior may change. If a field is renamed or removed, you may need to update the reports that use it.
  • Spreadsheet permission: The connector needs the See, edit, create, and delete all your Google Sheets spreadsheets permission to read your spreadsheets. If it is not granted, the connection fails.

What does this mean for me?

  • To report on two sheets side by side, add each one as its own Data Studio data source, or blend them in Data Builder.

Good to know

  • Power My Analytics syncs the data from the spreadsheets you connect.
  • The permission is used only to read and import data from the spreadsheets you connect.

If there is a Google Sheets field or report you would like to see, please submit a ticket with a description or screenshot of what you need. Requests during Beta help us decide what to add next.

Troubleshooting

If your Google Sheets data does not look the way you expect, start with Basic Troubleshooting. A few Google Sheets patterns are worth checking first:

  • "Missing Google Sheets Connector Scopes": The Google account was connected without the spreadsheet permission. Remove the source and connect it again, granting the permission. For full steps, see Error: Missing Google Sheets Connector Scopes.
  • A spreadsheet is missing: Check that you entered its URL when you connected and that it belongs to the Google account you signed in with.

Still have questions? Submit a ticket and our support team will be glad to help. Please include the connector name and a short description of what you are seeing; screenshots are always helpful.

Related Articles