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...
Sheet Automation is a powerful, easy-to-use extension that takes Google Sheets to next level. Create your mini workflow with the intuitive UI and automate everything without writing script.
Under Run, select the name of function you want to trigger. Under Events, select either Time-driven or the Google App that the script is bound to (for example, From spreadsheet). Select and configure the type of trigger you want to create (for example, an Hour timer that runs Every hour or an On open trigger).
Triggers let Apps Script run a function automatically when a certain event, like opening a document, occurs. Simple triggers are a set of reserved functions built into Apps Script, like the function onOpen(e) , which executes when a user opens a Google Docs, Sheets, Slides, or Forms file.
Now it is possible to add time based events.
from: http://code.google.com/googleapps/appsscript/guide_events.html
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With