Google Apps Script for Beginners

Google Apps Script for Beginners

by Bruce Mcpherson
Released September 2016
Publisher(s): Infinite Skills
ISBN: 9781491967409

Watch it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Video description

Google Apps Script is a scripting language used in conjunction with Google web-based applications (Google Docs, Google Sheets, Google Forms, Gmail, etc.) and external APIs. In this course, you’ll see how Google Apps Script can integrate the functions of multiple Google services with an externally located data source to create a new custom app. For example, you’ll see how Google Apps Script pulled data from a Google Sheet and an external source, and then combined and formatted the data into a Google Doc.

The key to using Google Apps Script is understanding its underlying language – JavaScript. The course teaches you enough of the concepts and syntax of JavaScript that you’ll come away with the ability to confidently code Google Apps Script tasks on your own.

  • See how Google Apps Scripts combine Google services and external APIs to create new apps
  • Review the functionality of core Google services like Sheets, Forms, Docs, and Gmail
  • Understand advanced Google services like Cache, Properties, UrlFetch, and HTML
  • Learn the basics of JavaScript – the language of Google Apps Script
  • Become confident in your ability to use JavaScript to code Google Apps Script tasks
  • Gain the ability to create Google Apps Script based applications on your own
Bruce McPherson is a GDE (Google Developer Expert) who is passionate about helping problem solvers everywhere, to combine Google services and cloud based APIs into innovative solutions. A former CIO and Chief Architect for companies like Motorola and Lucent, Bruce runs Pepada Consulting, hosts the Google Apps Script and JavaScript Community on Google+, and is author of the O'Reilly titles "Going Gas: from VBA to Apps Script" and "Google Apps Script for Developers".

Table of contents

  1. Introduction To Scripting
    1. Course Introduction 00:03:10
    2. About The Author 00:03:00
    3. Why Script 00:02:05
    4. Making A Copy Of The Working Files 00:04:39
    5. Projects 00:03:17
    6. Script 00:04:07
    7. First Container Bound Script 00:04:41
    8. First Standalone Bound Script 00:05:18
    9. The Scripting Environment 00:04:11
  2. Spreadsheets Service
    1. The Spreadsheet Service 00:05:56
    2. New JavaScript For This Lesson 00:16:36
    3. The Spreadsheet Class 00:03:43
    4. The Sheet Class 00:06:30
    5. The Range Class 00:11:09
    6. Getting Data 00:10:03
    7. Setting Data 00:11:44
    8. Cell Properties 00:07:20
    9. Custom Functions 00:06:48
    10. Exercise 00:05:00
  3. Document Service
    1. The Document Service 00:05:27
    2. New JavaScript For This Lesson 00:10:28
    3. The Document Class 00:09:11
    4. Elements 00:07:59
    5. Range Elements 00:08:20
    6. Ranges 00:15:07
    7. Text 00:07:26
    8. Formatting 00:07:37
    9. Images 00:03:48
    10. Searching 00:05:41
    11. Exercise 00:03:42
  4. The Menu System
    1. The App Menu 00:01:28
    2. New JavaScript For This Lesson 00:06:15
    3. Adding Items To The App Menu 00:02:04
    4. Adding Submenus 00:01:55
    5. Grouping 00:03:19
    6. Exercise 00:00:38
  5. Forms Service
    1. The Forms Service 00:01:10
    2. New JavaScript For This Lesson 00:06:02
    3. Creating A Form With The UI 00:02:06
    4. Creating A From Using Scripting 00:03:21
    5. Manipulating The Result Data 00:04:45
    6. Items 00:04:24
    7. Choices 00:01:44
    8. Sections 00:01:51
    9. Routing 00:03:50
    10. Exercise 00:01:37
  6. Mail Service
    1. The Gmail And Mail Services 00:04:02
    2. New JavaScript For This Lesson 00:10:51
    3. Sending Mail 00:05:56
    4. Threads 00:03:16
    5. Messages 00:03:26
    6. Attachments 00:03:18
    7. Labels 00:02:28
    8. Searching 00:08:48
    9. Exercise 00:01:24
  7. Properties And Cache Services
    1. Properties And Cache Service 00:01:32
    2. New JavaScript For This Lesson 00:04:42
    3. Properties Service 00:04:28
    4. Cache Service 00:03:36
  8. Calendar And Contacts Service
    1. Calendar And Contacts Service 00:03:20
    2. New JavaScript For This Lesson 00:03:57
    3. Events 00:07:13
    4. Guests 00:09:11
    5. Contacts 00:04:23
    6. Exercise 00:01:40
  9. Drive Service
    1. Drive Service 00:02:01
    2. New JavaScript For This Lesson 00:07:07
    3. Folders 00:05:30
    4. Files 00:06:42
    5. Permissions And Access 00:03:25
    6. Searching 00:02:20
    7. Exercise 00:02:53
  10. Advanced Topics
    1. Advanced Topics 00:02:26
    2. URLFetch Service 00:08:52
    3. WebApps 00:03:27
    4. Templates And Scriptlets 00:09:02
    5. User Interaction Part 1 00:06:00
    6. User Interaction Part 2 00:10:19
    7. Add-Ons Part 1 00:05:41
    8. Add-Ons Part 2 00:09:10
    9. Advanced Services 00:09:06
    10. Exercise 00:06:48
    11. Wrap Up 00:10:10

Product information

  • Title: Google Apps Script for Beginners
  • Author(s): Bruce Mcpherson
  • Release date: September 2016
  • Publisher(s): Infinite Skills
  • ISBN: 9781491967409