GSuite apps support a lot of installable triggers, but in my experience most are either time-driven or used to trigger something when someone submits a form.
Google spreadsheet script authorisation to BigQuery. See the documentation for standalone script. You may not want the code in the simple onEdit() trigger to run every time an edit is made. The only way to run it as a webapp is if the doGet()/doPost() function is called by the browser. If that’s the case, where you want to listen for a form submission and then take some action, the configuration … google-apps-script,google-spreadsheet,google-bigquery. Apps Script is a scripting language for light-weight Bound to Google Apps Script bound to Google Apps also known as container-bound script; unlike standalone scripts, are A few months ago I stumbled across Google Apps Script at work. 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, or Forms file.Installable triggers offer more capabilities than simple triggers but must be activated before use. Diagram 4 outlines the simple and installable Apps Script triggers used to perform this particular workflow automation and the corresponding actions performed by Apps Script when the triggers occur.

The user needs to authorize this script to use one or more services. Triggers let Apps Script run a function automatically when a certain event, like opening a document, occurs. Unfortunately you can only allow access to scripts running as 'you' if it is running as a web app.

Standalone script can be used to program Google apps independently, can be used as a Web App or can be set up to run automatically from an installable trigger. In most cases, the script prompts the user for authorization the next time it runs; however, if the script is published as an add-on that uses installable triggers , the trigger runs the script without prompting for authorization but throws an exception if the script attempts to call the unauthorized service. At The Floow, like many businesses we use G Suite (Google Mail, Google Calendar, Google Drive, etc.). For a simple “On Edit” trigger all you do, is type function onEdit() {put the code here}. Installable OnEdit() trigger not functioning I have a spreadsheet on Google sheets that I use to check-in and checkout packages at my workplace. To limit the amount of code that runs, the script can check for a condition. Users login with their google accounts to check a box which then runs an installable trigger (on edit trigger) to fill a box with the date/time and another box with their userid (gmail account) Introducing Google Apps Script - use JavaScript to automate your G Suite account. So there's the updated onTimer which gets run every minute via a Time-Dependent trigger.

Google drive.