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.



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.





    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 1,000 row limit. Solution Check the sidebar under ...
      • 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. ...
      • Google Analytics Data Connector User Guide

        The following article is a guide to automating reports with your Google Analytics connector. It includes information on available data as well as currently unavailable data and tips on how to get the most out of your Google Analytics reports. To ...
      • Google Ads Data Connector User Guide

        The following article is a guide to automating reports with your Google Ads connector. It includes information on available data as well as currently unavailable data and tips on how to get the most out of your Google Ads reports. To begin creating ...
      • Google Search Console Data Connector User Guide

        The following article is a guide to automating reports with your Google Search Console connector. It includes information on available data as well as currently unavailable data and tips on how to get the most out of your Google Search Console ...