function doGet(e) {
  var book = SpreadsheetApp.getActiveSpreadsheet();
  var masterSheet = book.getSheetByName("New_072018");
//  var json = convertSheet2Json(masterSheet);
  var colStartIndex = 1;
  var rowNum = 1;
  var firstRange = masterSheet.getRange(1, 1, 1, masterSheet.getLastColumn());
  var firstRowValues = firstRange.getValues();
  var titleColumns = firstRowValues[0];

  // after the second line(data)
  var lastRow = masterSheet.getLastRow();
  var ui = SpreadsheetApp.getUi();

  var rowValues = [];
  for(var rowIndex=2; rowIndex<=lastRow; rowIndex++) {
    var colStartIndex = 1;
    var rowNum = 1;
    var range = masterSheet.getRange(rowIndex, colStartIndex, rowNum, masterSheet.getLastColumn());
    var values = range.getValues();
    rowValues.push(values[0]);
  }



  // create json
  var json = [];
  for(var i=0; i<rowValues.length; i++) {
    var line = rowValues[i];
    var jsontemp = new Object();
    for(var j=0; j<titleColumns.length; j++) {
      jsontemp[titleColumns[j]] = line[j];
      json.push(jsontemp);
    }
   }

  var t = HtmlService.createTemplateFromFile('index');
  t.data = JSON.stringify(json);
  var html = t.evaluate();
  html.setTitle("Generated JSON here");
  html.setWidth(500);
  SpreadsheetApp.getUi().showSidebar(html);
}

function onOpen() {
  SpreadsheetApp.getUi()
  .createMenu("RC Stuff")
  .addSeparator()
  .addItem("Generate JSON", "doGet")
  .addToUi();
}