Start a new topic

Supermetrics triggers

Good Afternoon. 


I have observed that triggers aren´t being fired in many supermetrics docs. Is there a way to change this? the set up is correctly done and they are still not responding.


I´m Candelaria Mc Lean and am currently working in OLX.


Best and thank you,


Candelaria

1 Comment

Hi Candelaria,

Thanks for reporting this. Sorry about the 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.

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

Login or Signup to post a comment