Open navigation

How to fix "Query failed: ScriptError" error

If you encounter an error reading Query failed: ScriptError, there are a few steps you can take to diagnose and resolve the issue.

Causes and solutions

Multi-account login

Being logged into multiple Google Accounts while using Supermetrics can cause errors, including ScriptError.

Learn how to manage multiple Google Accounts while using Supermetrics.

Google Sheets cell limitations

Google Sheets imposes some limitations on how much data you can have in a single spreadsheet. Including too many rows of data in a spreadsheet can trigger this limitation and cancel any queries that would push the number of rows over Google Sheets' limit.

Rows in every tab in a spreadsheet count toward the spreadsheet's total row value.

To solve this, lighten and optimize your Google Sheets queries.

Google application conflicts

Occasionally, third-party applications running in Google Sheets (like Supermetrics) can conflict with each other. This can cause errors, including ScriptError.

The best way to solve this is to clear your browser's cache and cookies. Here are instructions on how to do this in some popular browsers:

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.