Automating Team Communication with Google Sheets and Apps Script

4.8
39 个评分
提供方
Coursera Project Network
1,555 人已注册
在此指导项目中,您将:

Set up a project plan and stakeholders communication plan with Google Sheets

Automate email communication with Google Apps Script

Clock2 hours
Intermediate中级
Cloud无需下载
Video分屏视频
Comment Dots英语(English)
Laptop仅限桌面

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 ManagementJavaScriptGoogle SheetsApps Script

分步进行学习

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

  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

指导项目工作原理

您的工作空间就是浏览器中的云桌面,无需下载

在分屏视频中,您的授课教师会为您提供分步指导

审阅

来自AUTOMATING TEAM COMMUNICATION WITH GOOGLE SHEETS AND APPS SCRIPT的热门评论

查看所有评论

常见问题

常见问题

还有其他问题吗?请访问 学生帮助中心