Duration
4 days
Course Description
Google Apps Script is a rapid application development platform that makes it fast and easy to create business applications that integrate with Google Workspace. You write code in modern JavaScript and have access to built-in libraries for favorite Google Workspace applications like Gmail, Calendar, Drive, and more. There is nothing to install - we give you a code editor right in your browser, and your scripts run on Google's servers.
Course Prerequisite
Knowledge and experience working on web application development would be helpful.
Chapter 1 – Introducing Google Apps Scripts
- Google Applications
- Google Apps Scripts
- Google Drive
- Gmail
- Google Calendar
- Google Docs
- Google Sheets
- Google Apps services
- Script projects
- Google Forms
Chapter 2 – Creating Basic Elements
- Creating a clickable button
- Showing toast when a button is clicked
- Creating a custom menu
- Creating a sidebar
- Creating an Add-ons menu
- Creating a modal dialog
- Creating a modeless dialog
- Debugging your script
Chapter 3 – Parsing and Sending Emails
- Creating Gmail Contacts by script
- Accessing Sheet, cell, range, and offset
- Reading and writing the Sheet data
- Building a Gmail Contact search application
- Building the Gmail parser application
- Properties service
- Downloading Gmail attachments to Drive
- Sending emails using the MailApp service
- Sending an email notification on Form submission
- Creating triggers manually
- Creating and deleting triggers by script
- Forwarding emails if the specific keyword is found in the message body
- Sending email with attachments
- Embedding inline images in an email message
- Building an email merger application
Chapter 4 – Creating Interactive Forms
- Creating Forms using script
- Publishing the script as web application
- HtmlService
- Creating a Form using HtmlService
- Submitting form using Google script API method
- Creating forms using add-ons CSS and jQuery libraries
- Creating an e-voting application
- Creating a ticket reservation application
Chapter 5 – Creating Google Calendar and Drive Applications
- The CalendarApp class
- Enabling advanced Google services
- The DriveApp class
Chapter 6 – Creating Feed Reader and Translator Applications
- The UrlFetchApp class
- RSS and Atom feeds
- The LanguageApp class
- Creating a document reviewing and instant inline commenting application
Chapter 7 – Creating Interactive Webpages
- Creating a web app to render Sheet data as HTML
- Creating a web app to return JSON
- Converting Sheet data as PDF file
- Sending an HTTP/HTTPS request with query string
- Creating RSS feed using ContentService
- Creating a file upload application
- Creating an employee timesheet application
Chapter 8 – Building a Workflow Application
- Order processing workflow – steps explained
- Configuring Google Sheets
- Creating the Order form
- Enhancing the Order form
- Creating the dispatch form
- Dispatching the articles
- Enabling the user to acknowledge the article delivery
Chapter 9 – More Tips and Tricks and Creating an Add-On
- Overcoming the “script exceeded maximum execution time” error
- Configuring your script project to use external libraries
- Using JSDoc annotations
- Using the OAuth open-source library
- Creating, testing, and publishing add-ons
Programme scope, delivery arrangements and suitability are confirmed during enquiry.