Daily Trigger isn't working


I've purchased the super pro version and I've set up a daily trigger on some reports. Unfortunately those triggers aren't working properly. Even though supermetrics says that I'll receive a notification if a refresh didn't work, this wasn't the case. Today is June 29th and the last update has been on June 27th. The last status says "refreshed successfully" which obviusly isn't true. I really need to be able to trust in those triggers as I use them for client reports. Why didn't my triggers work properly?

1 person has this problem
  • Hi,

    Sorry to hear about the trigger issues.

    Currently Google Sheets is the one running scheduled refreshes on sheets and it sets limits on how long these processes can run per hour. Usually this time is around 6 minutes or so. As this runtime is shared between all your sheets that use triggers, with many files and queries refreshing at the same time, they are not always be completed in time and they are instead pushed to the next hour. This is the most common reason for delays with triggers.

    Might also be that you don't have many triggers, but the sheets you have applied a trigger on, has many queries or very complex queries in them. This will result in long query execution time, and may affect trigger performance.

    Normally Google provides more time to users with G Suite business account. If you are not using G Suite, upgrading to that can help.

    You should check if you have any files that use triggers which you do not need anymore. Triggers in those files might be delaying your scheduled refreshes. Also, please check if there are any such files in you recycle bin. Remove them permanently as triggers on those remain usually active regardless of their location. See all your triggers in Add-ons > Supermetrics > Schedule refresh & emailing > Manage triggers in all your files.

    Best regards,
    Heidi / Supermetrics team
Login to post a comment