The error: Query failed: ScriptError may occur in 3 scenarios:
Scenario 1 - Multi-account login
Please follow the steps on this guide to resolve the problem: How to fix Google errors when logged in with multiple accounts. To sum up, there are 2 possible solutions:
- Log out all users from Google in your browser except for the one account attached to the Supermetrics license. Then try to log in to the data source again.
- If logging out all users is a hassle, you can also do this via Incognito/private browsing. Make sure that you log in with only one Google account (or the issue will continue there, too).
Scenario 2 - Google Sheets cell limitations
Google Sheets imposes some limitations on how much data you can have in a single Spreadsheet. This error also occurs when your sheet (the whole file) has so many cells populated with data that the new query results would push the populated cell number over that limit, and for this reason, the query is aborted. This applies to all the tabs that you have in a single Spreadsheet, not only 1 query in a tab. If you have many tabs in your Google Sheets file with many rows and columns per tab, it might cause this error.
The solution is to create and run the query in a new file or remove unnecessary data from the current file to make more space for new data.
Scenario 3 - AppScript or add-on is conflicting with Supermetrics
This error also occurs when your own AppScript or another add-on is conflicting with the Supermetrics products. To fix this error, clear your cache/browser cookies.
We’ve included some links to common browser guides here: