I've been using a script on Google sheets for the past month and it seems to be running fine when manually executed. However, I'd like to add a time trigger to it so that it runs every 30 mins every business day between 6AM and 6PM. Thus, theoretically, the script would be triggered 25 times a day. Given the quota of 20 / user / script, does this mean that it would run the first 20 times per day only, skipping the last 5? Or does it mean something else?
This is the number of triggers that may exist per user, per script, at any one time.
It is not a limit on the number of executions those triggers may trigger.
Thus a trigger that runs the script every 30 minutes from 6 to 6 counts as a single Trigger, 1 of the 20 allowed for the user, on the given script.
Rather than a limit the number of total executions per day, you instead are limited in the total amount of Run Time per day via the "Triggers total runtime" limit.
For example, consumer level gmail accounts are limited to 90 minutes of trigger runtime per day. So if your script took 5 minutes to execute each time it was triggered, this type of user could only trigger it 18 times before running out of execution time for the day.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With