linebot แยกชีท

var ss = SpreadsheetApp.openByUrl("sheetname");
var sheet = ss.getSheetByName("menu");
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 sheetname = sheet.getRange(i,2).getValue();    
    sheet = ss.getSheetByName(sheetname); 
    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).getValue();
var Data2 = sheet.getRange(i,3).getValue();  
var Data3 = sheet.getRange(i,4).getValue(); 
var Data4 = sheet.getRange(i,5).getValue(); 
var Data5 = sheet.getRange(i,6).getValue(); 
      

      
      var result = {
    "fulfillmentMessages": [
  {
    "platform": "line",
    "type": 4,
    "payload" : {
    "line":  {
  "type": "text",
      "text": 
 
      "โรงเรียน"+ Data+       
      "\nเว็บไซต์ : "+ Data2+ 
      "\nอีเมล์ : "+ Data3+ 
      "\nรหัสผ่าน : "+ Data4+ 
      "\nผู้ดูแลระบบ : "+ Data5
 
    }
        
   }
  }
 ]
}
} 
}
    var replyJSON = ContentService.createTextOutput(JSON.stringify(result)).setMimeType(ContentService.MimeType.JSON);
    return replyJSON;
    }
  }
}