Back to Automating Team Communication with Google Sheets and Apps Script
Coursera

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.

Status: Google Sheets
Status: Stakeholder Management
IntermediateGuided Project3 hours

Featured reviews

HN

Reviewed Aug 19, 2020

Well structured. Resources organized very well. Good guiding to pause and try on our own.

JJ

Reviewed Feb 25, 2021

A very valuable practical course relevant to persons in the project management field and those in the field of corporate communications who have IT skills.

ID

Reviewed Mar 16, 2022

The only thing I would change is to go one level deeper:setting triggers based on cell values.

All reviews

Showing: 20 of 24

Pedro
Reviewed Jun 20, 2020
Nirjhar
Reviewed Nov 1, 2020
GAURAB
Reviewed Nov 3, 2020
KOUSALYA
Reviewed Nov 3, 2020
Mrina
Reviewed Apr 6, 2021
ShainAlex
Reviewed Nov 7, 2020
Veronica
Reviewed Sep 25, 2021
Ахмедова
Reviewed Aug 29, 2020
Issa
Reviewed Mar 17, 2022
Hari
Reviewed Aug 20, 2020
Richard
Reviewed Jun 7, 2020
Afeefa
Reviewed Jun 9, 2020
Mohamad
Reviewed Aug 7, 2021
Luffy
Reviewed Oct 4, 2020
Jephtah
Reviewed Nov 15, 2023
Wajahat
Reviewed Aug 3, 2020
Nicolas
Reviewed Dec 7, 2021
Nilmani
Reviewed May 30, 2020
Julia
Reviewed Feb 25, 2021
Kin
Reviewed Mar 21, 2021