google app script: query data from googl sheet

googlesheet_query.js

function doGet(request) {
  //var spreadsheetId = '14UvTqbN3jxOnXj59HilYllfjetV6eGv6WevQsw---axx';
  //var rangeName = 'A2:D';
  var spreadsheetId = request.parameter.id;
  var rangeName = request.parameter.range;
  var values = Sheets.Spreadsheets.Values.get(spreadsheetId, rangeName).values;
  
  if (!values) {
    Logger.log('No data found.');
  } else {
    Logger.log('Vocab, Explanation, Hanja, Sentence:');
    for (var row = 0; row < values.length; row++) {
      // Print columns A and E, which correspond to indices 0 and 4.
      Logger.log(' - %s, %s, %s, %s', values[row][0], values[row][1], values[row][2], values[row][3]);
    }
  }
  
  var myJSON = JSON.stringify(values)
  return ContentService.createTextOutput(myJSON).setMimeType(ContentService.MimeType.JSON);
}