Enhanced scheduled refreshes offer increased reliability for Supermetrics scheduled refreshes in Google Sheets.
Unlike regular scheduled refreshes, which rely on Google, the processes that power enhanced scheduled refreshes run in Supermetrics itself. This offers increased reliability, more runtime per query, and improved retry logic.
If you're already using scheduled refreshes in your reporting, enabling enhanced scheduled refreshes is something you only need to do once. Once the enhanced scheduled refreshes are enabled, the improvements are applied across all of your existing scheduled refreshes.
Before you begin
This feature is in public beta. It’s available to all users with a paid subscription.
Enhanced scheduled refreshes need the same access rights to your files as the Supermetrics Add-in itself. Having this access means that the scheduled refreshes can automatically update the spreadsheets running Supermetrics queries.
Instructions
Enable enhanced refreshes
- Open the Supermetrics sidebar.
- Go to the Schedules tab.
- Scroll down to Enable enhanced scheduled refreshes.
- Log in with the Google Account you use with Supermetrics.
- Click Continue.
- Close the confirmation window.
Disable enhanced refreshes
If you want to disable this feature at any time, launch the Supermetrics sidebar with the account you used to enable enhanced scheduled refreshes. In the Schedules tab, select Disable enhanced scheduled refreshes. This will revert all of your scheduled reports to the standard refresh feature.
See 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. You can see the file name, refresh name, last refresh date, and status. Any errors also appear here. Click the arrow at the beginning of the row to view more details.