Automating Team Communication with Google Sheets and Apps Script

In 2-hours long project-based course, you will learn how to create a project plan on Google Sheets using color coded conditional formatting, set up a dynamic stakeholder communication plan with formulas, automate emails with Google Apps Script, utilize Apps Script third party libraries. Note: This course works best for learners who are based in the North America region. We’re currently working on providing the same experience in other regions.

• Project Overview
• In this project you will create a project management and email communication Google Sheet, and automate email communication with Google Apps Script. Please note that this project is now a browser-only project, while the recorded videos include a full desktop.