Introduction
Google Apps Script is a rapid application development platform that makes it fast and easy to create business applications that integrate with Google Workspace. You write code in modern JavaScript and have access to built-in libraries for favorite Google Workspace applications like Gmail, Calendar, Drive, and more.
More information on Google Apps Script can be found here.
Capabilities, Benefits, and Key Features
- Add custom menus, dialogs, and sidebars to Google Docs, Sheets, and Forms.
- Write custom functions and macros for Google Sheets.
- Publish web apps — either standalone or embedded in Google Sites.
- Interact with other Google services including AdSense, Analytics, Calendar, Drive, Gmail, and Maps.
- Build add-ons to extend Google Docs, Sheets, Slides, and Forms, and publish them to the Add-on store.
- Convert an Android app into an Android add-on so that it can exchange data with a user's Google Doc or Sheet on a mobile device.
- Streamline Google Chat workflows by building a chatbot.
Limitations / Technology Requirements
Need up-to-date Chrome browser
What can I expect?
-
Support Tier: Tier 1 - Best Effort: While approved for use there is no institutional support for the application. IT Help would make an effort to assist using general technical knowledge. If unable to do so, the user would need to resolve the issue on their own or contact a commercial vendor for assistance.
-
Acquisition Model: Registration: Online user account is used to login to the application each time of use, frequently using Miami's Identity and Access single-sign on capability with your Miami UniqueID and password.
-
Licensing Model: Site license: Miami has negotiated terms that allow for all current students and instructors to use the application.
-
Authentication Model: GSuite or Azure: The application allows users to login using a federated login to Google or MS Azure. If using your Miami account, @miamioh.edu, on these services, the login is subject to the same requirements as though you logged into those services directly. In many cases, it is possible to use a personal Google or Microsoft account that is unrelated to your Miami account.
Who may use it?
ULB Library staff will be using it to enhance calendaring capabilities.
How do I get started?
ULB Library staff should log in to their Google accounts and navigate to script.google.com to get started.
Is there a charge to me or my department?
Google Apps Script is free as part of the G suite