Google Apps Script
You need this to: build add-ons to extend Google Sheets, Docs, Slides, Forms and Gmail.
Updates
--None at the moment--
Getting Started
Google Apps Script is a rapid application development platform that makes it fast and easy to create business applications that integrate with G Suite. You write code in modern JavaScript and have access to built-in libraries for favorite G Suite applications like Gmail, Calendar, Drive, and more. There's nothing to install—you can access the code editor directly from your browser, and your scripts run on Google's servers.
App Scripts requires basic to intermediate knowledge of scripting. You are responsible for the creation and maintaining of your script.
For more information about Apps Scripts and guides, including code sheets and training links, view the Google App Script Documentation page.
To explore JavaScript training, visit the Codecademy JavaScript courses.
Google Forms Scripts
Gmail Scripts
Google Sheet Scripts
Frequently Asked Questions
What if I have questions on setting up and maintaining my script?
The OIT Google team would happy to provide basic guidance, however apps scripts are custom coded functions which means users are responsible for the creation and maintaining of their scripts.
Are app scripts tied to the product or the user?
When an app script is created the ownership is tied to the user that created it. What this means is if the user leaves the State of Colorado workforce, their data - including their owned - scripts will be deleted and will stop functioning. Best practice is to create multiple user use scripts under a shared mailbox account. This way the chance of an account being deleted is much less and other users can log in and view/update the scripts.
Are apps scripts safe for use on state data?
The provided app scripts do not transfer any data outside the state and are completely safe. The benefit for using custom scripts is that you know where data is being sent so there is no need to worry if data is being stored somewhere it shouldn't be. The risk on using pre-built extensions or add-ons is that you do not know what amount or where your data is being saved externally.
Does this have cost associated with it?
There are not any costs with using a custom script. Since these are manually coded scripts, you own the functions.