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

Response Summary Email: Google Form Script

Would an email summary of Google Form responses save you valuable time? Click on the guide to the left.

Create Doc From Template: Google Form Script

Looking to automate or digitize form responses to display in a certificate or other Doc template? Click on the guide to the left.

Gmail Scripts

Save Gmail Attachments to Drive: Google Form Script

Want email attachments saved automatically into your Google Drive? Click on the guide to the left.

Google Sheet Scripts

Basic Mail Merge Google Sheets Script

Looking for a basic mail merge that uses a simple text template? Click on the guide to the left.

Mail Merge Google Sheets with Template Apps Script Guide

Wanting a mail merge that uses a Google Doc or Slides template to build a document? Click on the guide to the left.

Time Tracker Google Sheets Apps Script Guide

Do you need analytical data on multiple YouTube videos? Click on the guide to the left.

Sentiment Analysis Google Sheets Apps Script Guide

Do you need to analyze text from feedback or evaluations with an objective view? Click on the guide to the left.

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.