Troubleshooting Google Sheets
Most errors that occur with Google Sheets reports can be fixed easily without the need to wait for a response from our support team. This article will help you find everything you need to troubleshoot your Google Sheets reports.
Google Sheets
If you are experiencing authentication or account access errors, start here:
- Error: Authorization Is Required to Perform That Action
- Error: "This action is not supported while logged into multiple accounts" or "accounts.google.com refused the connection"
- Google Sheets Error: "Exception: You do not have permission to access the requested document."
- Google Sheets Error: "You are not part of this organization, please check your access token or organization ID"
- Google Account Disconnects When Using Google Workspace
If your report data is missing or not displaying correctly, start here:
If you are experiencing performance issues, timeouts, or data limit errors, start here:
- Google Sheets Error: "Exception: Service Timed Out: Spreadsheets" or "Service Spreadsheets timed out when accessing document"
- Spreadsheets Error: Exceeded Maximum Execution Time
- Apps Script Error: This Report is Over 50MB of Compressed Data
- Google Sheets Error: Query Inactivity Error
If you are experiencing other report or configuration errors, start here:
- Google Sheets Error: "Error: Sheet does not exist:"
- Google Sheets Error: "Exception: This add-on has created too many time-based triggers in this document for this Google user account"
- Unable to Schedule Refresh in Google Sheets
If you still need help after reviewing these articles, please contact our support team.
Related Articles
Google Sheets Error: "Exception: This add-on has created too many time-based triggers in this document for this Google user account"
Your Schedule Refresh won't save, and Google Sheets shows an error about too many time-based triggers. This is a Google limit on the spreadsheet, not a Power My Analytics limit, and you can usually clear it yourself in a couple of minutes. Here is ...Required Google Account Permissions for Spreadsheets Add-on
When using Power My Analytics' Spreadsheets Addon with Google Sheets, you'll be asked to grant certain permissions to your Google account. We understand that granting these permissions may raise concerns about data security and privacy. This guide ...UTM Fields Show No Data in Google Ads Reports
When working with the Power My Analytics Google Ads connector, you may notice that UTM fields — UTM Source, UTM Medium, UTM Campaign, UTM Content, and UTM Term — return no data in your reports. This article explains why this happens and how to ...Google Business Profile Data Connector User Guide
Google Business Profile (formerly known as Google My Business) is a powerful tool for businesses to manage their online presence across Google, including Search and Maps. This guide will walk you through how to connect and use Google Business Profile ...Google Ads Data Connector User Guide
Google Ads is a powerful online advertising platform that allows businesses to reach potential customers across Google's vast network. This guide will walk you through how to connect your Google Ads data to Power My Analytics, create reports in Data ...