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 ...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. ...Google Sheets Error: "Exception: You do not have permission to access the requested document."
When working with Power My Analytics in Google Sheets, you may encounter an error message stating that you don't have permission to access a document. This guide will help you understand the cause of this error and provide steps to resolve it ...Installing the Power My Analytics Add-on for Google Sheets
If you'd like to merge and manipulate data from popular sales and advertising platforms with Google Sheets to create insightful and automated reporting, follow the instructions below to install and launch the Power My Analytics Sheets Data Connector. ...