Join Scott Simpson for an in-depth discussion in this video What is Google Apps Script?, part of Learning Google Apps Script.
Apps Script can be used on its own or within documents and you can distribute the add-ons you create so others can benefit from your creativity. Whether you build a simple custom function to scratch a particular itch you have, or build a classroom management system, a scheduling dashboard or a data provider to share fields from a spreadsheet, Apps Script gives you a huge amount of power and flexibility.
First, learn how to use simple scripts to edit documents and spreadsheets, work with files in Drive, and find and send messages in Gmail. Then find out how to add custom functionality to your spreadsheets, and build user interface elements for your scripts, using menus, alerts, and dialogs. Finally, Scott shows how to share your work with others by publishing scripts as web apps.
- What is Google Apps Script?
- Understanding script types
- Logging and debugging your scripts
- Scripting common tasks
- Building custom spreadsheet functions
- Creating add-on functionality such as dialogs and sidebars
- Sharing your script as a web app