How to keep sending Looker Scheduled Report if there is an error

[DataAnalytics]

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?

[alisha47]

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.

What can you do?

1. 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.
   
2. 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.
   
3. 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.