Scheduled report triggers 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. For example, deleting and re-adding a trigger usually fixes most problems.
Step 1: Delete and re-add the trigger
The best first step for any trigger issue is to try removing the trigger and then re-adding it.
To do this, open the Schedule tab in the Supermetrics sidebar. Click the trash can icon next to it to delete it. Then, click Add trigger and create a new version of the deleted trigger.
Step 2: Check the trigger’s time of day and timezone
The time that you set a trigger to run at is the time it will begin processing. If you have a lot of large queries, it can take several hours for the refresh to complete.
If a trigger 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 trigger time to earlier in the evening, or early the next morning, solves this issue.
Triggers are set to run in a timezone that you choose during setup. If the timezone in the Sheets file changes, the triggers won’t update to match it. To reset a trigger’s timezone, delete it and re-add it.
Step 3: Check email attachment size
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 triggers 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 email@example.com to ensure reliable delivery.
Step 4: Check accounts and permissions
If the files your triggers are attached to is in a team Google Drive, or any location other than the licensed user’s Google Drive, the triggers will fail. Move the file to the licensed user’s Google Drive.
Step 5: Optimize queries
Creating lighter queries can help ensure that triggers continue to work properly. Enabling the "Combine new results with old" setting and deleting any unnecessary triggers or queries from your sheets are good ways to achieve this.
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 Edit access enabled for the email address firstname.lastname@example.org
- Description of what's wrong
- A screenshot of your list of triggers under Schedule tab → Manage triggers in all your files in the Supermetrics sidebar
- A screenshot of the SupermetricsQueries sheet (this is hidden by default; to show it, navigate to Extensions → Supermetrics → Manage queries)