Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Coursera Project Network

Automating Team Communication with Google Sheets and Apps Script

Coursera Project Network via Coursera

Overview

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.

Syllabus

  • 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. To open the resources folder, simply press CTRL+O or CMD+O to open the project files. All files can be opened in the browser.

Taught by

Angelo Paolillo

Reviews

4.5 rating at Coursera based on 124 ratings

Start your review of Automating Team Communication with Google Sheets and Apps Script

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.