- What you are trying to achieve.
We have a lot of spreadsheets that have scripts running by time triggers. Every run uses time trigger quota which has a cap of 6 hours a day for Google G suite. Imaging that we have 50 spreadsheets, each with an hourly trigger that runs a script that takes 3 minutes to run. In such a case, it will use 50*24*3 = 3600 minutes = 6 hours, i.e. all given qouta.
We are trying to be able to create as many spreadsheet with such time triggers as we need.
The expected behaviour.
All spreadsheets triggers running without failures.
The actual behaviour
We are getting error Service using too much computer time for one day
Steps to reproduce your issue.
Create time trigger that will run a script with 60 seconds runtime every minute and wait for 6 hours under G suite account, or create a 100 of such triggers in order not to wait so long. In such case you will get an error within 36 minutes.