Google Apps脚本触发配额和限制 [英] Google Apps Script trigger quota and limitations

问题描述

我使用表单提交触发器来处理我的表单，并在我的电子表格中进行一些处理。表单提交过程可能需要一段时间才能完成（大约30秒）。由于响应是以表格的形式提交的，因此触发器的处理时间可能会超过Google Apps Work / Edu / Gov的触发器运行时间的6小时配额。此外，每个脚本限制的触发器数量为20个。

有没有解决这些问题的方法。解决方案

有几种方法可以考虑：

1）使用其他服务进行批处理。这可能类似于App Engine，Google功能或其他服务。

2）在您的域中创建批处理用户帐户。每个人都有自己的6小时配额限制。您的表单提交触发器会构建一个请求并将其发送到其中一个批处理帐户。请注意，这些帐户需要访问该脚本所需的任何资源。

<3>打开Goog​​le Apps脚本问题，请求更多处理时间。我没有具体的信息，但我听说一些非常重的用户可以购买包含较长运行时间的应用程序脚本的专业版支持。

4）刮掉你的脚本的时间。找出为什么需要整整30秒才能处理，看看你是否可以减少工作量。

I use form submit trigger for my form which does some processing on my spreadsheets. The form submit process may take a while to complete(approximately 30secs). As responses are submitted in the form the trigger's processing time may exceed the quota of triggers run time which is 6 hours for Google Apps Work/Edu/Gov. Also the number of triggers per script limit is 20.

Are there any workarounds for these problem.

解决方案

There are a few methods I can think of:

1) Use another service to do batch processing. This could be something like App Engine, Google functions, or some other service.

2) Create batch processing user accounts in your domain. Each one will have their own 6 hour quota limit. Your form submit trigger would build a request and send it to one of the batch processing accounts. Note these accounts would need access to any resources required by the script.

3) Open a Google Apps Script issue requesting more processing time. I have no specific information, but I've heard some very heavy users can purchase "pro" support for apps script that includes longer run times.

4) Shave time off your script. Figure out why it needs a full 30 seconds to process and see if you can reduce that work load.

这篇关于Google Apps脚本触发配额和限制的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！