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
Publisher resources
Table of contents
-
Introduction To Scripting
- Course Introduction 00:03:10
- About The Author 00:03:00
- Why Script 00:02:05
- Making A Copy Of The Working Files 00:04:39
- Projects 00:03:17
- Script 00:04:07
- First Container Bound Script 00:04:41
- First Standalone Bound Script 00:05:18
- The Scripting Environment 00:04:11
-
Spreadsheets Service
- The Spreadsheet Service 00:05:56
- New JavaScript For This Lesson 00:16:36
- The Spreadsheet Class 00:03:43
- The Sheet Class 00:06:30
- The Range Class 00:11:09
- Getting Data 00:10:03
- Setting Data 00:11:44
- Cell Properties 00:07:20
- Custom Functions 00:06:48
- Exercise 00:05:00
-
Document Service
- The Document Service 00:05:27
- New JavaScript For This Lesson 00:10:28
- The Document Class 00:09:11
- Elements 00:07:59
- Range Elements 00:08:20
- Ranges 00:15:07
- Text 00:07:26
- Formatting 00:07:37
- Images 00:03:48
- Searching 00:05:41
- Exercise 00:03:42
-
The Menu System
- The App Menu 00:01:28
- New JavaScript For This Lesson 00:06:15
- Adding Items To The App Menu 00:02:04
- Adding Submenus 00:01:55
- Grouping 00:03:19
- Exercise 00:00:38
-
Forms Service
- The Forms Service 00:01:10
- New JavaScript For This Lesson 00:06:02
- Creating A Form With The UI 00:02:06
- Creating A From Using Scripting 00:03:21
- Manipulating The Result Data 00:04:45
- Items 00:04:24
- Choices 00:01:44
- Sections 00:01:51
- Routing 00:03:50
- Exercise 00:01:37
-
Mail Service
- The Gmail And Mail Services 00:04:02
- New JavaScript For This Lesson 00:10:51
- Sending Mail 00:05:56
- Threads 00:03:16
- Messages 00:03:26
- Attachments 00:03:18
- Labels 00:02:28
- Searching 00:08:48
- Exercise 00:01:24
-
Properties And Cache Services
- Properties And Cache Service 00:01:32
- New JavaScript For This Lesson 00:04:42
- Properties Service 00:04:28
- Cache Service 00:03:36
-
Calendar And Contacts Service
- Calendar And Contacts Service 00:03:20
- New JavaScript For This Lesson 00:03:57
- Events 00:07:13
- Guests 00:09:11
- Contacts 00:04:23
- Exercise 00:01:40
-
Drive Service
- Drive Service 00:02:01
- New JavaScript For This Lesson 00:07:07
- Folders 00:05:30
- Files 00:06:42
- Permissions And Access 00:03:25
- Searching 00:02:20
- Exercise 00:02:53
-
Advanced Topics
- Advanced Topics 00:02:26
- URLFetch Service 00:08:52
- WebApps 00:03:27
- Templates And Scriptlets 00:09:02
- User Interaction Part 1 00:06:00
- User Interaction Part 2 00:10:19
- Add-Ons Part 1 00:05:41
- Add-Ons Part 2 00:09:10
- Advanced Services 00:09:06
- Exercise 00:06:48
- Wrap Up 00:10:10
Product information
- Title: Google Apps Script for Beginners
- Author(s):
- Release date: September 2016
- Publisher(s): Infinite Skills
- ISBN: 9781491967409
You might also like
video
C# Basics for Absolute Beginners in C# and .NET
Learn the fundamentals of C# .NET programming from the ground up About This Video Build a …
video
Getting Started with Google Cloud Platform LiveLessons
2+ Hours of Video Instruction Two and a half hours of video instruction introducing cloud concepts, …
audiobook
The Art of Leadership
Many people think leadership is a higher calling that resides exclusively with managers who practice or …
video
Amazon Web Services (AWS), 3rd Edition
18+ Hours of Video Instruction Get intensive, hands-on AWS training with Chad Smith in this 2 …