Course Highlights
  • Set up a project plan and stakeholders communication plan with Google Sheets
  • Automate email communication with Google Apps Script
Curriculum

9 Topics
Set up a project plan in Google Sheets using multiple sheets and conditional formatting
Use formulas to create a stakeholder communication plan with dynamic rules templates and conditions
Write a Google Apps Script processing the Spreadsheet creating a data structure
Add Google Apps Script functions to automate emails
Format a dynamic HTML message with Apps Script
Create a structure of functions so to execute the core function in different modes based on triggers
Set up Google Apps Script action-based and time-based triggers
Use a Google Apps Script third-party library
Test the Google Apps Script manage authorizations

  Write a Review

Automating Team Communication with Google Sheets and Apps Script

Go to Free Course