google sheet

ยังมีปัญหาอยู่

https://moremeng.in.th/2019/11/make-line-chatbot-get-google-sheets-data-with-dialogflow.html

var ss = SpreadsheetApp.openById("SHEET_ID ");var sheet = ss.getSheetByName("Sheet1");function doPost(e) { // var dialogflowDATA = JSON.parse(e.postData.contents); // dialogflowDATA .queryResult.queryText; var message = 10; var tableArray = sheet.getRange(2, 1, sheet.getLastRow(), sheet.getLastColumn()).getValues(); var monthName = ''; for (var i = 0; i < tableArray.length; i++) { if (tableArray[i][0] == message) { i = i + 2; var monthName = { "fulfillmentMessages": [{ "platform": "line", "type": 4, "payload": { "line": { "type": "text", "text": sheet.getRange(i, 2).getValue() } } }] } Logger.log(monthName) // var replyJSON = ContentService.createTextOutput(JSON.stringify(monthName)).setMimeType(ContentService.MimeType.JSON); // return replyJSON; } }}