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, this article outlines the steps you can take to fix any issues.
Our first suggestion is to enable enhanced scheduled refreshes for your reports, as they provide a more reliable way of regularly refreshing your reports.
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.
Instructions
View all scheduled refreshes
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.
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
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 timezone in the Sheets file changes, the refreshes won’t update to match it. To reset a scheduled refresh's timezone, follow the steps under "Fix one broken scheduled refresh" above to delete it and re-add it.
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.
If the files your scheduled refreshes are attached to are in a shared Google Drive, or any location other than the subscription user’s Google Drive, the refreshes will fail. Move the file to the subscription user’s Google Drive.
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.
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 noreply@supermetrics.com 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 supportfileshare@supermetrics.com
- 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