Google Chatにシートの内容やフォームの回答を自動投稿する

function sendToChat() {
  const url = "https://chat.googleapis.com/v1/spaces/XXXXXXXXXXX/messages?key=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX&token=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX"
  const options = {
    "method": "post",
    "headers": {
      "Content-Type": "application/json; charset=UTF-8"
    },
    "payload": JSON.stringify({
      "text": "Hello from Apps Script!"
    })
  };
  const response = UrlFetchApp.fetch(url, options);
}

function sendToChat() {
  const url = "https://chat.googleapis.com/v1/spaces/XXXXXXXXXXX/messages?key=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX&token=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX"
  const threadKey = Utilities.formatDate(new Date(), "JST", "yyyyMMdd");
  const options = {
    "method": "post",
    "headers": {
      "Content-Type": "application/json; charset=UTF-8"
    },
    "payload": JSON.stringify({
      "text": "Hello from Apps Script! with threadKey!"
    })
  };
  const response = UrlFetchApp.fetch(
    `${url}&threadKey=${threadKey}&messageReplyOption=REPLY_MESSAGE_FALLBACK_TO_NEW_THREAD`,
    options
  );
}

    "payload": JSON.stringify({
      "text": "Reply from Apps Script! with threadKey!"
    })

function sendToChat() {
  const url = "https://chat.googleapis.com/v1/spaces/XXXXXXXXXXX/messages?key=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX&token=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX"
  const options = {
    "method": "post",
    "headers": {
      "Content-Type": "application/json; charset=UTF-8"
    },
    "payload": JSON.stringify({
      "cardsV2": [
        {
          "cardId": "unique-card-id2",
          "card": {
            "header": {
              "title": "ユーザー新規登録依頼",
              "subtitle": "2023年5月28日 川田 新一（営業部）",
              "imageUrl": "https://web-breeze.net/wp-content/uploads/2019/12/cropped-favicon-1.jpg"
            },
            "sections": [
              {
                "header": "申請内容",
                "widgets": [
                  {
                    "textParagraph": {
                      "text": "5月末までに、以下のユーザーの新規登録をお願いいたします。"
                    }
                  },
                  {
                    "divider": {}
                  },
                  {
                    "decoratedText": {
                      "startIcon": { "knownIcon": "PERSON" },
                      "text": "山　智子",
                    },
                  },
                  {
                    "decoratedText": {
                      "startIcon": { "knownIcon": "EMAIL" },
                      "text": "yama@web-breeze.net",
                    }
                  },
                  {
                    "buttonList": {
                      "buttons": [
                        {
                          "text": "却下",
                          "onClick": {
                            "openLink": { "url": "https://example.com/reject" }
                          }
                        },
                        {
                          "text": "承認",
                          "onClick": {
                            "openLink": { "url": "https://example.com/approve" }
                          }
                        },
                      ],
                    }
                  },
                ],
              },  
            ]
          },
        },
      ]
    })
  };

  const response = UrlFetchApp.fetch(url, options);
}

function sendToChat() {
  const url = "https://chat.googleapis.com/v1/spaces/XXXXXXXXXXX/messages?key=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX&token=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX"
  const options = {
    "method": "post",
    "headers": {
      "Content-Type": "application/json; charset=UTF-8"
    },
    "payload": JSON.stringify({
      "text": createMessage()
    })
  };
  const response = UrlFetchApp.fetch(url, options);
}

function createMessage() {
  // 「勤務予定」シートを取得
  const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('勤務予定');

  // 本日の 0時 0分 0秒 0ミリ秒 のDateオブジェクトを作成
  const today = new Date(new Date().setHours(0, 0, 0, 0));

  // チャットに送信するメッセージ（1行目は <MM/dd 勤務予定> とする）。 **で囲うと太字になる
  let message = `*<${today.getMonth() + 1}/${today.getDate()} 勤務予定>*`;

  for (let col = 2; col <= sheet.getLastColumn(); col++) {
    //　1行目が本日日付の列を探す
    if (sheet.getRange(1, col).getValue().getTime() === today.getTime()) {
      // 3行目から最終行まで、氏名と勤務予定を取得し、メッセージに追加する
      for (let row = 3; row <= sheet.getLastRow(); row++) {
        const name = sheet.getRange(row, 1).getValue();
        const cellValue = sheet.getRange(row, col).getValue();
        const plan = cellValue ? cellValue : '出勤';
        message += '\n' + `${name}:\t${plan}`;
      }
    }
  }

  return message;
}

function webhook(e) {
  const url = "https://chat.googleapis.com/v1/spaces/XXXXXXXXXXX/messages?key=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX&token=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX"
  const options = {
    "method": "post",
    "headers": {
      "Content-Type": "application/json; charset=UTF-8"
    },
    "payload": JSON.stringify({
      "text": createMessage(e.response)
    })
  };
  const response = UrlFetchApp.fetch(url, options);
  Logger.log(response);
}

function createMessage(response) {
  // 質問・回答およびメールアドレスを取得
  const itemResponses = response.getItemResponses();
  const respondentEmail = response.getRespondentEmail();

  // チャットに送信するメッセージ。 **で囲うと太字になる
  let message = '*フォームに問合せが届きました*';

  // 回答した質問すべてのタイトル・回答を取得し、メッセージにセット
  for (const itemResponse of itemResponses) {
    const title = itemResponse.getItem().getTitle();
    const response = itemResponse.getResponse();
    message += '\n\n' + `${title}:\n${response}`;
  }

  // メッセージ末尾に返信先のメールアドレスを記載
  message += '\n\n' + `返信先:\n${respondentEmail}`;
  
  return message;
}