You have started a spreadsheet script with a time-driven trigger. There were times when the code didn't work well even though there was no problem.
Google Apps Script has a limited number of calls and times, so
I suspect that this restriction is imposed.
https://docs.google.com/a/macros/fourmix.co.jp/dashboard
https://developers.google.com/apps-script/guides/services/quotas
1. To what extent of these restrictions are used or are subject to these restrictions
How do I check (API) / Is there a page where I can check the list?
2.
for the limited number of times and hours per day.
What time is the day based on?
Is it JST (reset at 00:00 Japan time)? Is it GMT (reset at 09:00 Japan time)?
3. For example, if the Trigger total runtime exceeds 6 hr/day,
If you run the script manually, you will see an error on the screen, so you will understand.
Can try{}catch(){} get this limitation when running on a trigger?
It's past time, so I feel like it's going to be terminated.
Could you please let me know if anyone knows?
I had the same problem, so I will answer as far as I know.
1: You can check the remaining quota of the email below.
MailApp.getRemainingDailyQuota();
Also, if you use Google's API, you can check the usage in the GCP API console.
2: I don't remember well, but it was reset around 15:00 (probably PST midnight)
3: I don't know because I haven't verified it.
© 2024 OneMinuteCode. All rights reserved.