Open navigation

Troubleshooting scheduled refreshes in Google Sheets

Scheduled report refreshes for Supermetrics in Google Sheets enable you to seamlessly refresh your queries and send out copies of these refreshed reports by email.

If you encounter errors or failed refreshes, there are a few best practices that can help. You can see all the refreshes assigned to the account you're logged in to at any time by going to the Schedules tab in the Supermetrics sidebar and clicking View all schedules in all spreadsheets.

About refresh run limits

Note that Google limits the scheduled refresh runs to 6 minutes per hour, and unfinished refresh runs are pushed to the next hour. The same happens with the ones that were in the "queue" for that hour. This limit is at an account level. If you have multiple files refreshing at the same hour, they all need to finish within 6 minutes.

This 6-minute limit doesn't affect Supermetrics enhanced scheduled refreshes. Learn more about enhanced scheduled refreshes.

Fix one broken scheduled refresh

The best first step for an issue with an individual scheduled refresh is to try removing and then re-adding it.

To do this, open the Schedules tab in the Supermetrics sidebar. Click the 3-dot icon next to the schedule name and click Delete. Then, click Automatic refresh to create a new version of the deleted scheduled refresh.

If this doesn't help, follow the guidance for fixing more than one scheduled refresh below.

Fix multiple broken scheduled refreshes

Check timing and timezones

The time that you set a refresh to run is the time it'll begin processing. If you have a lot of large queries, it can take several hours for the refresh to complete.

If a refresh is set to run late at night, say at 11:00 PM or later, it might fail to complete before midnight. This would cause it to fail, as the date would change before it could complete. Moving the refresh time to earlier in the evening, or early the next morning, solves this issue.

Scheduled refreshes are set to run in a timezone that you choose during setup. If the time zone in the Sheets file changes, the refreshes won’t update to match it. To reset a scheduled refresh's time zone, follow the steps under "Fix one broken scheduled refresh" above to delete it and re-add it.

Space refreshes out

Running multiple scheduled refreshes at exactly the same time can cause them to slow down or fail. Make sure to space your refreshes out across the full day — run some in the morning, for example, and then others just after midnight — to maximize the speed they'll be able to run at.

Check accounts and permissions

If the files your scheduled refreshes are attached to are in a shared Google Drive, or any location other than the licensed user’s Google Drive, the refreshes will fail. Move the file to the licensed user’s Google Drive.

Optimize queries

Creating lighter queries can help ensure that the refreshes continue to work properly. Enabling the "Combine new results with old" setting and deleting any unnecessary scheduled refreshes or queries from your sheets are good ways to achieve this.

Check email attachments

If your queries are refreshing properly but you’re not receiving emailed reports, it could be because the email attachment is larger than Google supports. You can reduce the amount of content in the file, or split queries and scheduled refreshes into separate Google Sheets files, to help with this.

Custom sender addresses can cause scheduled refresh emails to fail. We recommend you set the sender address as to ensure reliable delivery.

Get in touch

If you’ve tried these solutions and are still seeing errors, contact our support team. When you do, please include the following information so we can get to work as quickly as possible:

  • The file’s URL, with temporary edit access enabled for the email address
  • A screenshot of your list of scheduled refreshes (to view all scheduled refreshes, click View all schedules in all spreadsheets under the Schedules tab in the sidebar)
  • A screenshot of the SupermetricsQueries tab

Did you find it helpful? Yes No

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