tusharacc

function doGet(e) {
 
    var json = convertSheet2JsonText();
    return ContentService.createTextOutput(JSON.stringify(json))
    .setMimeType(ContentService.MimeType.JSON);

}
function convertSheet2JsonText() {
 //XXXX is the id of the spreadsheet.ID is in the spreadsheet url - docs.google.com/spreadsheets/d/XXXX/editkkkk
  var sheet = SpreadsheetApp.openById("XXXX").getActiveSheet();