Google Sheets Error: "Exception: This add-on has created too many time-based triggers in this document for this Google user account"
When using the Power My Analytics spreadsheets add-on in Google Sheets, you may encounter an error about too many time-based triggers. This guide explains the cause of this error and provides a simple solution to resolve it.
Error
"Exception: This add-on has created too many time-based triggers in this document for this Google user account"
Cause
This error occurs when your PMA report spreadsheet has too many scheduled refreshes configured.
Solution
To resolve this issue, create a copy of your spreadsheet and use the copy instead of the original:
- Open the Google Sheets document containing your PMA reports.
- Go to File > Make a copy in the menu bar.
- Give the copy a new name and choose where to save it.
- Click Make a copy to create the duplicate.
- Open the newly created copy of your spreadsheet. Use this copy for your PMA reports going forward instead of the original document.
The new copy will allow you to continue using the Power My Analytics add-on without the trigger limit error.
Related Articles
Google Sheets Error: "Exception: Service Timed Out: Spreadsheets" or "Service Spreadsheets timed out when accessing document"
When using the Power My Analytics spreadsheets add-on in Google Sheets, you may encounter a timeout error that prevents your reports from refreshing. This guide will help you understand the cause of this error and provide a straightforward solution ...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 ...Report a Different Time Zone in Spreadsheets
When reporting your data with our spreadsheets addon, you may want to adjust the date and time reported to account for a timezone offset. This article will show you how to use a formula to adjust the reported date and time in Sheets. Some connectors ...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 ...Spreadsheets Error: Exceeded Maximum Execution Time
This article will assist you with the following error: Exceeded maximum execution time Cause When using the spreadsheets add-on for Google Sheets or Excel, the add-on may time out with this error when you have a large number of reports in your ...