在与您的工作区一起在分屏中播放的视频中，您的授课教师将指导您完成每个步骤：

1. •

   Set up a project plan in Google Sheets using multiple sheets and conditional formatting

2. •

   Use formulas to create a stakeholder communication plan with dynamic rules, templates and conditions

3. •

   Write a Google Apps Script processing the Spreadsheet, creating a data structure

4. •

   Add Google Apps Script functions to automate emails

5. •

   Format a dynamic HTML message with Apps Script

6. •

   Create a structure of functions so to execute the core function in different modes based on triggers

7. •

   Set up Google Apps Script action-based and time-based triggers

8. •

   Use a Google Apps Script third-party library

9. •

   Test the Google Apps Script, manage authorizations