是否可以自动化 Google 电子表格脚本(例如,无需事件来触发它们)?
有谁知道是否可以使用 Google Apps 脚本来运行而无需手动事件?含义 - 我想设置一个电子表格,以便每天在指定时间发送表格。我已经弄清楚如何通过执行脚本来手动发送表单,但是 Google 是否实现了设置脚本在将来运行(并且定期运行)的能力?
我一直在寻找答案,但找不到。
谢谢...
Does anyone know if it's possible to use Google Apps Scripts to run without needed a manual event? Meaning - I would like to set up a spreadsheet to send a form every day at a specified time. I have figured out how to manually send the form by executing a script, but has Google implemented to ability to set a script to run in the future (and on a recurring basis)?
I have searched for an answer but can't find one.
Thanks...
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(3)
现在可以添加基于时间的事件。
来自:http://code.google.com/googleapps/appsscript/guide_events.html
Now it is possible to add time based events.
from: http://code.google.com/googleapps/appsscript/guide_events.html
这实际上是可能的。请查看 http://code.google.com/googleapps/appsscript/guide_events .html#可安装
It's actually possible. Have a look at http://code.google.com/googleapps/appsscript/guide_events.html#Installable
您可以使用
ScriptApp
类的newTrigger
函数来完成此操作。您可以在以下位置查看完整文档:
https://developers.google.com/apps -script/reference/script/script-app#newTrigger(String)
https://developers.google.com/apps-script/reference/script/trigger-builder
You can do that using the
newTrigger
function of theScriptApp
class.You can see the entire documentation at:
https://developers.google.com/apps-script/reference/script/script-app#newTrigger(String)
https://developers.google.com/apps-script/reference/script/trigger-builder