Learning Google Apps Script

Meet Google Apps Script, the master key that unlocks the power of your favorite Google apps, including Docs, Sheets, Gmail, Calendar, and Drive. This JavaScript-based platform allows you to access data from the Google cloud, edit files, automate tasks, and extend apps' power. You can even share your scripts with others in the form of add-ons. Interested in learning more? Join Scott Simpson in this introductory course, as he shows how to get up and running with Google Apps Script.

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.

Topics include:

• 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