LINE Bot ที่ตอบคำถามอัตโนมัติโดยดึงข้อมูลจาก Google Sheets

const LINE_TOKEN = 'xxxxx';

function doPost(e) {
  const data = JSON.parse(e.postData.contents);
  const event = data.events[0];
  
  if (event.type === 'message' && event.message.type === 'text') {
    const userText = event.message.text.trim().toLowerCase();
    const replyToken = event.replyToken;
    
    if (userText === 'สวัสดี') {
      sendMessage(replyToken, { type: 'text', text: 'สวัสดีครับ! 😊' });
    } else {
      sendMessage(replyToken, { type: 'text', text: findAnswer(userText) });
    }
  }
}

function sendMessage(replyToken, message) {
  const url = 'https://api.line.me/v2/bot/message/reply';
  
  UrlFetchApp.fetch(url, {
    method: 'post',
    contentType: 'application/json',
    headers: { Authorization: `Bearer ${LINE_TOKEN}` },
    payload: JSON.stringify({ replyToken, messages: [message] })
  });
}

function findAnswer(userQuestion) {
  const sheet = SpreadsheetApp.openByUrl("xxxxxx").getSheetByName("xxxxx");
  
  if (!sheet) return "ขออภัย ไม่พบข้อมูล";

  const data = sheet.getDataRange().getValues();
  if (data.length <= 1) return "ขออภัย ไม่พบข้อมูล";
  
  data.shift(); // Skip headers
  for (let row of data) {
    const question = String(row[0]).trim().toLowerCase();
    const answer = String(row[1]).trim();
    const keywords = row[2] ? String(row[2]).split(',').map(k => k.trim().toLowerCase()) : [];
    if (question === userQuestion || keywords.some(k => userQuestion.includes(k))) {
      return answer;
    }
  }
  
  return "ขออภัย ไม่เข้าใจคำถาม";
}