Email

試算表內容

程式碼.gs

function doGet() {

  return HtmlService.createHtmlOutputFromFile('index');

}

function sendEmailToRecipient(email) {

  var spreadsheetId = '試算表ID';

  var sheetName = '工作表名稱'; //大小寫有區別

  var sheet = SpreadsheetApp.openById(spreadsheetId).getSheetByName(sheetName);

  var data = sheet.getDataRange().getValues();

  for (var i = 1; i < data.length; i++) {

    if (data[i][0] == email) {

      var recipientName = data[i][1];

      var recipientEmail = data[i][2];

      try {

        MailApp.sendEmail({

          to: recipientEmail,

          subject: '測試信件',

          body: '親愛的' + recipientName + '，您好！這是一封測試信件。',

        });

        return recipientName;

      } catch (error) {

        throw new Error('郵件寄送失敗：' + error.message);

      }

    }

  }

  throw new Error('找不到相對應的帳號：' + email);

}