Chatbot_v2_default.gs

// 白名單 (試算表)
const url = "https://docs.google.com/spreadsheets/d/1cYwH14Y85b_yMp-FJCR9nKHDWc9FgFVYeAWIbVcljxk/edit"; // XXX 請更改為實際 chatbot_list 連結
const chatbot_list = SpreadsheetApp.openByUrl(url);
const space_list = chatbot_list.getSheets()[0]; // 聊天室名單

/**
 * Responds to a MESSAGE event in Google Chat.
 *
 * @param {Object} event the event object from Google Chat
 */
function onMessage(event) {
  var name = "";

  if (event.space.type == "DM") {
    name = "You";
  } else {
    name = event.user.displayName;
  }
  var message = name + " said \"" + event.message.text + "\"";

  return { "text": message };
}

function onAddToSpace(event) {
  var spaces = space_list.getRange("A:A").getValues(); // 取得 space_list 的資訊

  // 遍歷所有欄位，假如遇到空欄位，則將 space 寫進該欄位並傳送成功訊息
  for (var i = 0; i < spaces.length; i++) {
    if (spaces[i][0] === "") {
      var value = "A" + String(i+1);
      space_list.getRange(value).setValue(event.space.name.slice(7));
      var value = "B" + String(i+1);
      space_list.getRange(value).setValue(event.space.displayName);
      return { "text": "Successfully add to space." };
    }
  }
}

function onRemoveFromSpace(event) {
  var spaces = space_list.getRange("A:A").getValues(); // 取得 space_list 的資訊

  // 遍歷所有欄位，假如找到要移除的 space，則將該欄位移除
  for (var i = 0; i < spaces.length; i++) {
    if (spaces[i][0] === event.space.name.slice(7)) {
      space_list.deleteRow(i+1);
    }
  }
}