开发者

Is it possible to automate Google Spreadsheets Scripts (e.g. without an event to trigger them)?

开发者 https://www.devze.com 2023-01-03 14:39 出处:网络
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

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)开发者_Go百科?

I have searched for an answer but can't find one.

Thanks...


Now it is possible to add time based events.

from: http://code.google.com/googleapps/appsscript/guide_events.html

  • Edit -> Current project's triggers. You see a panel with the message No triggers set up. Click here to add one now.
  • Click the link.
  • Under Run, select the function you want executed on schedule.
  • Under Events, select Time-driven.
  • On the first drop-down list that appears, select Week timer, Day timer, Hour timer, or Minutes timer. Depending on which you select, you see one or two additional lists. To test the trigger and your function, you might want to pick a short duration so that you can see the execution without having to wait hours or days.
  • If you picked Week timer, select a day of the week and time of day.
  • If you picked Day timer, select an hour.
  • If you picked Hour timer, select an interval of hours.
  • If you picked Minutes timer, select an interval of minutes.
  • Click Save.
  • To ensure that the script runs at the correct time for a particular time zone, click File > Properties, select a time zone, and click Save.


It's actually possible. Have a look at http://code.google.com/googleapps/appsscript/guide_events.html#Installable


You can do that using the newTrigger function of the ScriptApp class.

function createTimeDrivenTriggers() {
  // Trigger every 6 hours.
  ScriptApp.newTrigger('getEmails')
      .timeBased()
      .everyHours(6)
      .create();
}

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

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号