Automating Team Communication with Google Sheets and Apps Script

4.5
95 個評分
提供方
Coursera Project Network
3,889 人已註冊
在此免費指導項目中,您將:

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的熱門評論

查看所有評論

常見問題

常見問題

還有其他問題嗎?請訪問 學生幫助中心