上司の承認が遅くてイライラ、を解決！？「何でも承認してくれる上司」で遊んでみた

const LINE_API_ACCESS_TOKEN = PropertiesService.getScriptProperties().getProperty('LINE_API_ACCESS_TOKEN');
const LINE_REPLY_URL = 'https://api.line.me/v2/bot/message/reply';

function doPost(e) {
  const eventData = JSON.parse(e.postData.contents).events[0];
  const replyToken = eventData.replyToken;
  const userMessage = eventData.message.text;
  const messageType = eventData.message.type;
  let replyMessage = "";

  console.log(messageType);
  console.log(userMessage);
  replyMessage = getCandidate('シート1');
  reply(replyToken, replyMessage);
}

function reply(token, message) {
  const payload = {
    'replyToken': token,
    'messages': [{
        'type': 'text',
        'text': message
      }]
  };
  const options = {
    'payload' : JSON.stringify(payload),
    'myamethod'  : 'POST',
    'headers' : {"Authorization" : "Bearer " + LINE_API_ACCESS_TOKEN},
    'contentType' : 'application/json'
  };
  UrlFetchApp.fetch(LINE_REPLY_URL, options);
}

function getCandidate(sheetName) {
  const activeSheet = SpreadsheetApp.getActiveSpreadsheet();
  const sheet = activeSheet.getSheetByName(sheetName);
  const values = sheet.getDataRange().getValues();
  const candidates = [];
  for(let i = 0; i < values.length; i++ ) {
    candidates.push(values[i][0]);
  }
  let rand = Math.random();
  rand = Math.floor(rand * candidates.length)
  
  return candidates[rand];
}