Парсинг ячеек из google sheets

function getData(parameters){
  try{
    var values = SpreadsheetApp.openById(parameters.id).getSheetByName(parameters.sh).getDataRange().getValues();
    return values;
  }catch(e){
    return [[e.message], ['U SENT ' + JSON.stringify(parameters)]];
  }
}
function doPost(e){
  var cs = ContentService.createTextOutput();
  cs.setMimeType(ContentService.MimeType.JSON);
  cs.setContent(JSON.stringify(getData(e.parameter)));
  return cs;
}
function doGet(e){
  // get the query "name" parameter and set the default to "World!"
  var name = e.parameter.id || "99999";
  var lock = LockService.getScriptLock();
  try {
   lock.waitLock(10000);    // try to get a lock for 10 sec else throw error
   var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Dashboard");
   var cell = sheet.getRange(1,1);
   cell.setValue(name);
   SpreadsheetApp.flush(); // Apply changes right away.
   var html = HtmlService.createTemplateFromFile("index")
   // added this line to serve data to the scriplet
   html.data = sheet.getDataRange().getValues();
   html = html.evaluate()  // evaluate scriplet
   html.setTitle("Your Individual Dashboard");
 
   } catch (e){   //catch  failure
   var html = HtmlService.createHtmlOutput("Server busy, please try again after sometime")
 
   }
  lock.releaseLock()  // Release lock so that the next person in line can access the code
  return html;
}