2015
Lynda
Scott Simpson
1:19
English

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.

Introduction
Welcome
What is Google Apps Script?
What you need to know before continuing
1. Navigating the Google Apps Script Platform
Understanding script types and permissions
Working with the online integrated development environment (IDE)
Logging and debugging your app
Using the online documentation
2. Working with Common Services
Creating and editing a document
Accessing and editing a spreadsheet
Reading information from a spreadsheet
Working with files in Drive
Finding and sending messages with the Gmail service
3. Extending Apps with Custom Functions and Add-ons
Building custom functions
Running your script automatically
Creating a menu
Alerting the user
Building dialogs and sidebars
4. Script and Web Services
Storing data for your script
Using external data from an API
Publishing your script as a web app
Conclusion
Next steps

http://www.lynda.com/

Download File Size:209.22 MB

---