Technology Education Program: Workflow Automation - Google Apps Script

The Workflow Automation training using Google Apps Script is designed to be a hands-on software development course focused around the employee’s understanding and the thinking patterns needed to leverage technology to solve everyday workflow challenges. The course provides a foundational understanding of Google Apps Script through coding exercises that solve real world workflow and automation challenges. The program requires a capstone project to be delivered that solves a real work challenge or develop new enabling capability to improve business outcomes. Google Apps Script is a rapid application development platform that makes it fast and easy to create business applications that integrate with Google Workspace. The employee writes code in modern JavaScript and leverages the built-in libraries provided for Google Workspace tools like Sheets, Mail and Forms. Those who complete this course will be able to: 1. Create a working JavaScript codebase that leverage constants, variables and different function types, including: Anonymous, Arrow and Immediately Invoked Expressions (IIFE), exception handling and control-flow statements using loops, if…else and switch…case. 2. Code workflow solutions in JavaScript using the Google Sheets, Mail and Forms APIs 3. Identify a Capstone Project idea and step through the analysis, design, code, test and deployment process for use in a production environment. 4. Develop a hypothesis and value proposition for a problem that identifies a capability and through discovery, identifies the dependencies, feasibility and expected outcome value.