# 數位知能活動 || Google Apps Script 雲端自動化與動態網頁實戰
慈濟大學 教資中心數位教學組主辦
講師：李燕秋老師 ([FB](https://www.facebook.com/Hyonith2014/?ref=hl) / [YT](https://www.youtube.com/channel/UC8LZYIbGBOhTApJ09y9ldnQ))
課程網址：https://reurl.cc/eDXA5W

---
## 基本練習-單封信件

function sendEmails() {
  let emailAddress= "[e-mail]";
  let subject= "測試信件";
  let message = "這是測試信件";
  MailApp.sendEmail(emailAddress,subject,message);
}

## 基本練習-多封信件
[名單下載](https://docs.google.com/spreadsheets/d/1wIZC6UXuZSkILEwe6zq2hQOsRLX23i9XSEja3nOj00k/edit?usp=sharing)

function  sendEmails() {
   // 讀取Google試算表的內容(起始值為1)
   let sheet = SpreadsheetApp.getActiveSheet();
   let startRow = 2;
   let numRows = 10;
   let startCol = 2;
   let numCols = 4;
   let dataRange = sheet.getRange(startRow, startCol, numRows, numCols);

   let data = dataRange.getValues();
    //安排信件內容（起始值為0）
   for (let i in data) {
     let row = data[i];
     let receiver = row[0]
     let emailAddress = row[1];
     let subject = row[2] + ' '+ receiver;
     let message = row[3];
     MailApp.sendEmail(emailAddress, subject, message);
   }
}

## 基本練習-多封信件(含檔案連結)

function  sendEmails() {
   // 讀取Google試算表的內容(起始值為1)
   let sheet = SpreadsheetApp.getActiveSheet();
   let startRow = 2;
   let numRows = 10;
   let startCol = 2;
   let numCols = 5;
   let dataRange = sheet.getRange(startRow, startCol, numRows, numCols);

   let data = dataRange.getValues();
    //安排信件內容（起始值為0）
   for (let i in data) {
     let row = data[i];
     let receiver = row[0]
     let emailAddress = row[1];
     let subject = row[2] + ' '+ receiver;
     let message = row[3] + "<br/> <a href='" + row[4] + "'>" + row[4] + "</a>";
     MailApp.sendEmail(
      {to: emailAddress, subject: subject, htmlBody: message}
    );
   }
}

每天不超過100封

---

## 範例一【個資查詢應用】
情境:個人成績、獎勵、資料繳交與否
教師端彙整成績，個資成績學生線上查看
行政端彙整學生繳交文件，繳交情況學生可線上查看進度:是否 已上傳、已審核、已核銷等
https://sky.tcu.edu.tw/media/8065

[範例展示](https://script.google.com/macros/s/AKfycbza5xAnksBtOQnSmBVn3JeHx-JMyIpe06O8MlWXU8JF71GkXsYbf6vjnakJs55rl3RoeA/exec)

程式碼下載 [影片來源](https://youtu.be/V8nwvQJ25IY)
https://drive.google.com/drive/folders/1rW-KNlN0zw9NMWVSROGiTP16iMUj2H0o

先把檔案>建立副本到自己的雲端硬碟中
::: success
確定檔案轉為Google試算表，才會有Apps Script
:::

---

## 範例二【GOOGLE試算表自動轉換成GOOGLE測驗卷】
程式來源
https://sites.google.com/email.nchu.edu.tw/gdrive-addon/線上測驗表單?fbclid=IwAR0JW25oHmxbdl_T-oOB8G4BV3lmCokR9Qqrc-qSGm0QnIhG2O9kmHNEEDQ

---