Google Apps Script: Beginner to Advanced

• JavaScript experience

Audience

• Web Developers

Google Apps Script is a JavaScript framework for light-weight development in a G Suite environment. Using Google Apps Script, users can leverage the power of Google products by automating tasks, connecting Google products to data sources, and more.

This instructor-led, live training (online or onsite) is aimed at web developers who wish to use Google Apps Script to develop in a G Suite environment.

By the end of this training, participants will be able to:

• Develop web applications with Google Apps Script.
• Build add-ons to extend Google products, such as Gmail.
• Perform system administration tasks.
• Connect to a data source from a Google product.

Format of the Course

• Interactive lecture and discussion.
• Lots of exercises and practice.
• Hands-on implementation in a live-lab environment.

Course Customization Options

• To request a customized training for this course, please contact us to arrange.

Introduction

Google Apps Script Overview

• What is Google Apps Script?
• Google App Scripts features

Preparing the Development Environment

• Setting up Google Apps Script

Google Spreadsheet

• Writing a Google script
• Scripting UI options
• Accessing data sources
• Working with Bootstrap
• Using jQuery

Stand Alone Scripts

• Designing interfaces
• Adding scripts

Google Drive

• Getting data
• Creating and moving content

Gmail

• Working with emails and chat threads
• Automating tasks

Google Calendar

• Importing data
• Automating tasks

Summary and Conclusion