Excel Forum

Code: Select all

var ss = SpreadsheetApp.openById("1Z0SuxtG5I9avc7_Lr4lLxgzs3iDVjIaP7QKnB4Wo0Ko");
var sheet = ss.getSheetByName("ชีต1");
function doPost(e) {
   
  var data = JSON.parse(e.postData.contents)
  var userMsg = data.originalDetectIntentRequest.payload.data.message.text;
  var values = sheet.getRange(2, 1, sheet.getLastRow(),sheet.getLastColumn()).getValues();
for(var i = 0;i<values.length; i++){
    
    if(values[i][0] == userMsg ){
      i=i+2;
var Data = sheet.getRange(i,2).getDisplayValue();
   
      var result = {
    "fulfillmentMessages": [
  {
    "platform": "line",
    "type": 4,
    "payload" : {
    "line":  {
  "type": "text",
  "text": 'มีโคมรุ่น'+Data+ 'ค่ะ'
    }
        
   }
  }
 ]
}
      
    var replyJSON = ContentService.createTextOutput(JSON.stringify(result)).setMimeType(ContentService.MimeType.JSON);
    return replyJSON;
}
  }
}