O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Google Apps Script for Developers

Video Description

In this Google Apps Script for Developers training course, expert author Bruce Mcpherson will teach you how to customize, enhance, and automate your Google Docs, Sheets, and Gmail with Google Apps Script. This course is designed for the absolute beginner, meaning no previous experience with Google Apps Script is required.

You will start by learning the basics of JavaScript, including variables and types, functions, and loops and conditions. From there, Bruce will teach you about Google Apps Script, Spreadsheet service, and Document service. This video tutorial also covers properties and cache services, Gmail service, Contact service, and Calendar service. Other topics that are covered include UrlFetch service, DriveApp service, advanced services, and Google APIs. Finally, you will learn about HTML service and add-ons, including controlling the server and using APIs with add-ons.

Once you have completed this computer based training course, you will have learned how to customize, enhance, and automate your Docs, Sheets, and Gmail with Google Apps Script.

Table of Contents

  1. Getting Started
    1. Going GAS - Google Apps Script From Start To Finish 00:04:52
    2. About The Author 00:03:20
    3. Google Apps Script Architecture 00:06:22
    4. The Integrated Development Environment 00:04:39
    5. The Debugger 00:07:34
    6. Limits And Quotas 00:04:11
    7. Triggers 00:05:35
  2. Javascript Basics
    1. Coding Style And Layout 00:06:24
    2. Language Fundamentals 00:05:06
    3. Operators 00:08:54
    4. Variables And Types 00:09:23
    5. Functions 00:07:02
    6. Objects And Prototypes 00:12:03
    7. Namespaces 00:09:25
    8. Loops And Conditions 00:09:22
    9. Functional Programming 00:12:04
    10. JSON And XML 00:07:26
  3. Google Apps Script
    1. Services 00:15:45
    2. Advanced Services 00:04:27
    3. Developer Console 00:04:05
    4. Authorization And Authentication 00:05:01
  4. Spreadsheet Service
    1. Spreadsheet Service - The Major Classes 00:08:36
    2. Reading And Writing Data 00:08:14
    3. Working With Data Objects 00:09:25
    4. Cell Properties 00:06:18
    5. Spreadsheet Events 00:09:44
    6. Custom Functions 00:07:33
  5. Document Service
    1. Major Classes 00:06:26
    2. Elements 00:09:51
    3. Traversing Elements 00:07:18
    4. Modifying Elements 00:05:11
    5. Ranges And RangeElements 00:10:05
    6. Cursor And Positions 00:07:54
    7. Attributes 00:07:21
  6. Properties And Cache Service
    1. Properties Stores 00:04:21
    2. Properties Stores And Libraries 00:10:24
    3. Caching 00:09:33
  7. Gmail Service
    1. Major Classes 00:06:55
    2. Threads And Messages 00:04:47
    3. Searching 00:04:11
  8. Contact Service
    1. Major Classes 00:04:13
    2. Manipulating Contacts 00:04:54
    3. Contact Groups 00:04:30
  9. Calendar Service
    1. Major Classes 00:05:01
    2. Events And Guests 00:07:36
    3. Event Recurrence 00:07:42
  10. URL Fetch Service
    1. Major Classes 00:08:05
    2. Options And Headers 00:05:59
    3. Requests And Headers 00:05:23
    4. Exponential Backoff 00:05:30
  11. DriveApp Service
    1. Major Classes 00:07:41
    2. Finding Folders And Files 00:06:23
  12. Advanced Services
    1. Advanced Versus Built In Services 00:10:01
    2. Advanced Service - Analytics API 00:05:24
    3. Advanced Service - Fusion Tables 00:08:50
  13. Authentication And Authorization
    1. Authentication And Authorization 00:06:30
    2. HTML Service Web Apps And Templates 00:09:25
    3. Access To Users Resources 00:07:59
    4. Service Accounts 00:05:36
  14. Google APIs
    1. API Explorer And Scopes 00:09:43
    2. Microsoft OneDrive And Google Drive APIs 00:06:10
    3. Content Service 00:04:24
    4. Execution API 00:09:37
  15. HTML Service And Add-Ons
    1. HTML Service And Add-On Structure 00:07:41
    2. Controlling The Server 00:03:16
    3. Using APIs With Add-Ons 00:03:24
  16. Summary
    1. Further Study 00:03:13