👉Google Apps Script

Send Email

function doPost(e) {
  var param = e.parameter ;
  var title = '' ;
  var body = '' ;
  switch (param.Order_Status)  {
    case "新成立":
      title = "新訂單成立" ;
      body = "如有現貨，寄貨時間為1~3天內。" ;
      break;
    case "缺貨中":
      title = "品項缺貨中" ;
      body = "﹝目前訂單內品項尚有缺貨﹞" ;
      break;
    case "已完成":
      title = "訂單已完成" ;
      body = "感謝您本次購買<br>如使用商品符合您的期待<br>歡迎再次回購<br>購物網站：<br>https://jay.twl.ink/" ;
      break;
    case "取消單":
      title = "訂單已取消" ;
      body = "取消原因：" + param.Order_Remarks ;
      break;
    default:
      title = "";
      break;
  }
  try {
    MailApp.sendEmail({
      name: "Jay 管理系統",
      to: param.Client_Email,
      bcc: "[e-mail]",
      replyTo: "[e-mail]",
      subject: "小傑的賣場﹝" + title + "﹞",
      htmlBody: "<p>" + param.Client_Name + " 您好，訂單資訊如下</p>"+
                "<p>訂單編碼：" + param.Orders_ID +
                "<br>下單時間：" + param.Time_Create +
                "<br>目前狀態：" + param.Order_Status +
                "</p><p>" + body + "</p>" +
                "<a href=\"https://jay.1oe0.com/Data.php?SID=" + param.Orders_ID + "\" target=\"_blank\"> 點我查看訂單 </a>" +
                "<p>此為系統自動發送，請勿直接回覆。</p>"+
                "<p>若您對訂單有任何問題，歡迎透過客服信箱：<br>[e-mail]<br>或者聯絡本人Instagram：<br>https://www.instagram.com/_____28.o7_prince/</p>",
    });
  } catch(ex) {
    console.error(ex);
  }
  return ContentService.createTextOutput("傳送成功");
}

function emailQuotaRemaining() {
  var emailQuotaRemaining = MailApp.getRemainingDailyQuota();
  Logger.log("Remaining email quota: " + emailQuotaRemaining);
}

Google Forms To Line Notify

表單收到新回應傳送LINE通知

創建一個表單 https://forms.new

點選『回覆』連結一個試算表

點選『工具』選擇『指令碼編輯器』

貼上程式碼

圖片程式碼僅供參考，請以下方最新程式碼為準。

function onSubmit(datas) {
  // 取得提交的值
  var Data = datas.namedValues;
  // 要傳送的訊息
  var Message = 'Google表單收到新提交\\n';
  // 整理訊息
  for(var Key in Data) {
    Message += Key + '：' + Data[Key] + '\\n';
  }
  // 發送訊息
  var List = JSON.parse(UrlFetchApp.fetch('<https://org.1oe0.com/Api/Notify?T=46963e88437560cbe463b1fdc2d9543a>'));
  for (var Key in List) {
    try {
      UrlFetchApp.fetch('<https://notify-api.line.me/api/notify>', {
        'headers': {
          'Authorization': 'Bearer ' + List[Key],
        },
        'method': 'post',
        'payload': {
          'message': Message
        }
      })
    } catch(ex) {
      console.error(List[Key] , ex);
    }
  }
}

切換至『觸發條件』

新增一個觸發條件『活動類型』選擇『提交表單時』