Google Formの回答をLINE WORKSで受け取る方法! Incoming Webhookを使って実装を簡単に

var LINEWORKS_WEBHOOK_URL = 'https://webhook.worksmobile.com/message/xxxxxx-xxxxxx-xxxx-xxxx-xxxxxxxxxxxx';

function onFormSubmit(e) {
  var values = e.values;
  var timestamp = values[0];
  var messageLines = [];
  messageLines.push('【新しいフォーム回答を受信しました】');
  messageLines.push('送信日時: ' + timestamp);

  for (var i = 1; i < values.length; i++) {
    messageLines.push('回答' + i + ': ' + values[i]);
  }

  var finalMessage = messageLines.join('\n');
  sendToLineWorks(finalMessage);
}

function sendToLineWorks(message) {
  var payload = {
    body: {
      text: message
    }
  };

  var options = {
    method: 'post',
    contentType: 'application/json',
    payload: JSON.stringify(payload)
  };

  try {
    UrlFetchApp.fetch(LINEWORKS_WEBHOOK_URL, options);
  } catch (err) {
    Logger.log('LINE WORKS への送信に失敗: ' + err);
  }
}