Google Apps Script

Course Overview:

The Google Apps Script training course give you a detailed knowledge on coding like Automating data calculation, Fetching and sending data from third party software like Trello & Salesforce, connecting different sheets, Documents and other tools, Setting a trigger based on an event. This course is ideal for someone who use google sheets and have no coding background.

Course Objectives:

• Know Handling Spreadsheet and Loop
• Understand IF Statement and Array
• Using Commonly used Functions in Spreadsheet
• Understand usage of Menus, Dialogs and Sidebars, User Interfaces, Add-Ons
• Store and Serve Data
• Know about Triggers & Events and Sending email with details from Google Form

Pre-requisites:

• Fundamental knowledge of Google Spreadsheet
• Basic Experience with coding will be helpful but not mandatory

Course Duration:

• 35 hours – 5 days

Course Content:

1. Introduction

• Introduction
• script Editor: Where codes are written
• Writing the first line of code
• Good Practices for writing Codes

2. Handling Spreadsheet and for Loop o Accessing an outside spreadsheet

• What can we do with the Spreadsheets?
• Introduction to for Loop
• More on for Loop

3. IF Statement and Array

• IF Statements o Array of Variables
• Combining Array and for Loop

4. Commonly used Functions in Spreadsheet

• Get Last Row of Spreadsheet
• Copy to: Copying from one cell to another
• Change Name, Hide and Show Sheets
• Customized Menu
• Pop Up Dialogue Box

5. Menus, Dialogs and Sidebars

• Custom Menus
• Dialogs / Sidebars

6. User Interfaces o Create and Serve HTML

• Client-to-Server Communication
• Template HTML o Restrictions
• Migration to IFRAME

7. Add-Ons o Translate for Google Docs

• Notification for Google Forms
• Translate for Google Slides
• Progress bars for Google Slides

8. Store and Serve Data

• Script/user/Document Properties
• External Databases via JDBC
• Content Service

9. Live Project: Send email with details of Google Form

Course Customization Options

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