How do I check Google Apps Script calls and time limits?

Asked 2 years ago, Updated 2 years ago, 48 views

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?

google-apps-script

2022-09-30 19:32

1 Answers

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.


2022-09-30 19:32

If you have any answers or tips


© 2024 OneMinuteCode. All rights reserved.