Automating Team Communication with Google Sheets and Apps Script

4.5
95 个评分
提供方
Coursera Project Network
3,902 人已注册
在此免费指导项目中,您将:

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 Management
  • JavaScript
  • Google Sheets
  • Apps 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的热门评论

查看所有评论

常见问题

常见问题

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