I set up a schedule to send a dashboard every week on Monday. Today, it did not send any results, due to the error below
Error: SQL Error Query execution failed: - Resources exceeded during query execution: Google Sheets service overloaded for spreadsheet id
I don’t know how this error occurred, but is there a way so that if an error occurs, it will try sending the dashboard again in the next hour?
This error takes place when the your Google Sheets quota limits. It means that you are querying too much data. In other words, there is also a possibility that too many users are trying to access the sheet at the same time.
Currently, platforms like Looker Studio don’t retry sending scheduled email reports if a dashboard fails to load. Once a query fails, that schedule stops functioning entirely—there’s no automatic retry or fallback mechanism after an hour.
Simplify the query or split large sheets
Try reducing the complexity of your query or breaking large datasets into smaller, manageable sheets to reduce processing load.
Switch to BigQuery for greater reliability
Moving your data from Google Sheets to BigQuery can significantly improve performance. Scheduled reports and dashboards run more reliably, and BigQuery is built to handle large volumes of data efficiently.
Use Windsor.ai for seamless, automated data transfers
With Windsor.ai, you can easily move data from 325+ sources into Google Sheets, Looker Studio, or BigQuery—no scripts, no manual exports. It’s a no-code solution that helps eliminate the need for heavy processing in Google Sheets while keeping your dashboards auto-refreshed and running smoothly.
Automate retries using tools like Google Cloud Functions or Zapier
These tools can be set up to monitor task failures and trigger automatic retries when needed, adding resilience to your reporting workflows.
Hi, sorry for missing this reply, but I do have most of the data in BigQuery (BQ). I only have less than 100 rows and 5 columns in Google Sheets (GS) and I transferred data from GS to BQ using the built in transfer mechanism of BQ.Then in Looker, I use the GS table in BQ to create a view. Additionally, I am confident that no one was accessing the GS when the scheduled query is running.
The queries I run in Looker aren’t simple but they are also not too complex. I never encounter this error when manually running the dashboards/explores. I only receive this error during the scheduled reports.
That being said, the GS table does join tables with thousands of rows. Is that enough to exceed the quota?
With the tools you mentioned, Google Cloud Functions and Zapier, can they resend a scheduled report in Looker BI or can they only rerun a query?