Google Sheets Data Integration Guide

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 the Power My Analytics Sheets add-on:

Open a new Google Sheets spreadsheet.

Go to the "Extensions" menu, select "Add-ons", and click "Get add-ons".



Search for "Power My Analytics" in the Google Workspace Marketplace.



Click "Install" on the "Power My Analytics Sheets Data Connector".



Authorize the add-on when prompted.



Go back to the "Extensions" menu, select "Power My Analytics", and click "Log In".



Reload the spreadsheet page for the add-on to initialize.





Create a New Google Sheets Report

To create a new report:


Click "Add Report" from the Power My Analytics menu.




Select a connector and data account.







Configure your report settings like date range, fields, filters, order by, and row limit. The Power My Analytics Spreadsheets Addon automatically prevents mix-and-match errors when selecting fields for Google Sheets reports:
  1. When configuring fields in your report, the add-on will remove incompatible fields as options when they conflict with your currently selected fields.
  2. This field filtering ensures compatibility between selected fields and prevents the field conflicts that can occur in other reporting destinations like Looker Studio.

Click "Add Report" again to create the report on a new sheet.




Edit or Delete a Report

To edit or delete an existing report:

Select the three dots and click "Edit".








Choose "Edit" to modify the report settings or "Delete" to remove the report and sheet.

Refresh a Report's Data Manually

To manually refresh a report's data:

Navigate to the report sheet.

Click "Refresh" from the Power My Analytics menu.



The report will reload with the latest available data.



Set Up a Scheduled Refresh for a Report

To automatically refresh a report on a schedule:

Click "Scheduled refresh" from the Power My Analytics menu.

Select the report you want to schedule.




Choose the refresh frequency and optional email notifications.













Click "Update" to save the schedule.

Sort the List of Reports

To sort your report list:

Click "Sort by" from the Power My Analytics menu.

Choose to sort by report name, sheet name, or connector.




    • Related Articles

    • Integrate Data with a Reporting Tool

      Congratulations on successfully connecting your first data source account to Power My Analytics! This article will guide you on how to start creating reports. Integrating with Looker Studio 1. Go to hub.powermyanalytics.com 2. Select Looker Studio ...

    • 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 ...

    • Data Destinations

      Once you've connected sources and built datasets, Power My Analytics offers multiple ways to visualize, analyze, and export your data. Not sure which to choose? Most users start with Data Visualization or Spreadsheets for immediate insights. Reports ...

    • Configure Data Source Sync Time and Google Sheets Refresh for the Latest Data

      Keeping your marketing data up-to-date is crucial for accurate reporting and analysis. This guide will walk you through configuring your data source sync time and Google Sheets scheduled refresh to ensure you're always working with the most recent ...

    • How to Connect a Google Sheets Report to Looker Studio

      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. ...