spreadsheetDataToJSON.js

////////////////////////////////////////////////////////////////////////
//The function takes two inputs:
//url = Spreadhsheet URL
//sheetName = name of sheet in Spreadsheet you want to convert to json
//The resulting json objects will be a named based on text in the cells of row 1 with spaces removed 
////////////////////////////////////////////////////////////////////////
function getSpreadsheetData(ssURL,sheetName){
  var ss = SpreadsheetApp.openByUrl(ssURL);
  var sheet = ss.getSheetByName(sheetName);
  var data = sheet.getDataRange().getValues();
  var sheetArray = [];  
   var headers = data[0]
   var jsonArray = [];
   for(var i=1; i<data.length; i++) {
    var line = data[i];
    var json = new Object();
    for(var j=0; j<headers.length; j++) {
      var header = headers[j].replace(/\s/g, '');
      json[header] = line[j];
    }
    jsonArray.push(json);
  }
}