Supermetrics Support Forum

Enabling Enhanced Scheduled Refreshing (Backend Triggers)

This guide covers how to enable and disable the enhanced scheduled refresh feature (also called backend triggers). This system works for most query configurations and also now supports both standard- and email-type triggers.

Quick links to the sections below:

Before You Begin

This option only appears if you have been whitelisted for the feature by the Supermetrics Support team and have a paid license. If you would like to try this new system for your triggers, please submit a support request to request access - include your license user ID and if you need email-triggers enabled or just the standard.

The access is granted per Google Sheets license, so if you have multiple licenses or change licenses, you may need to re-enable the setting.

Enabling Enhanced Scheduled Refreshing

  1. Login to https://team.supermetrics.com/ with the user account for the Sheets license.
  2. Navigate to the LICENSES tab.

    Blue arrow points to the "LICENSES" tab in the main navigation header

  3. Find your current Supermetrics for Google Sheets license in the list.
  4. Click Manage to expand the settings.
  5. Click the AUTHORIZATION tab.
  6. Click the AUTHORIZE button to enable the feature. You may need to log in again with the license user and accept some additional Drive permissions that are required to make the feature work.

    Blue boxes show the path to get to the "AUTHORIZE" button to enable the feature.

  7. The section should now list that it is "authorized" with a note of who and when it was authorized.

    Example of authorized feature

  8. Your triggers can now use the enhanced scheduled refresh feature! No additional changes to your trigger settings should be required to work with this.

Disabling Enhanced Scheduled Refreshing

  1. Login to https://team.supermetrics.com/ with the user account for the Sheets license.
  2. Navigate to the LICENSES tab.

    Blue arrow points to the "LICENSES" tab in the main navigation header

  3. Find your current Supermetrics for Google Sheets license in the list.
  4. Click Manage to expand the settings.
  5. Click the AUTHORIZATION tab.
  6. Click the Revoke link to remove the authorization.

    Blue arrow points to link to "Revoke" which will remove authorization to use the backend system

  7. Your triggers will revert to using the standard trigger system.

Did you find it helpful? Yes No

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