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.
Troubleshooting steps
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.
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 noreply@supermetrics.com to ensure reliable delivery.
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.
We’re here for you
If you’ve tried these solutions and are still seeing errors, reach out to 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
- 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 Add-ons → Supermetrics → Manage queries)