Google Apps脚本配额 [英] Google Apps Script Quota

问题描述

我正在运行一个Apps脚本，通过URL访问来更改Google表格中的行，并将其作为网络应用部署。
类似macroUrl /？sheet = SheetName& key = KeyName& value = ValueName。

这对我所需要的完全适用，但我不确定强加给它的配额。真的，我所做的只是使用脚本中的doGet和doPost函数来抓住/推动行到表单，但是我预测自己可能每天访问它超过50k次。我不确定如何测试我可以创建的最大请求数，而Google的配额页相当混乱。

- 亨利

$ b $如果您使用的是spreadsheetApp，那么您不需要担心任何配额，但是您可能会超过每日脚本执行总时间。请参阅此处了解更多详情： https://developers.google.com/apps -script / guides / services / quotas＃current_quotas

除非您直接调用电子表格api v3 / v4而不使用电子表格应用程序，否则urlFetch配额不适用。

I'm running an Apps Script that changes rows in a Google Sheet through URL access, deployed as a web app. Something like macroUrl/?sheet=SheetName&key=KeyName&value=ValueName .

This works perfectly for what I need it but I'm unsure on the quotas imposed on it. Really all I'm doing is using the doGet and doPost functions in the script to grab/push rows to the sheet, however I foresee myself possibly accessing it upwards of 50k times per day. I'm unsure how to test for the max number of requests that I can make and google's quota page is rather confusing.

--Henry

解决方案

if you are using spreadsheetApp then there are no quotas you need to worry, however you may exceed the total daily script execution time. see here for more details: https://developers.google.com/apps-script/guides/services/quotas#current_quotas

urlFetch quotas do not apply unless you are making the call to the spreadsheets api v3/v4 directly without spreadsheetApp.

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