functiondoGet(e) {
returnManageSheet(e);
}
functiondoPost(e) {
returnManageSheet(e);
}

functionManageSheet(e) {

//READ ALL RECORDS

if( e.parameter.func == "ReadAll") {
  varss = SpreadsheetApp.getActive();
  varsh = ss.getSheets()[0];
  varrg = sh.getDataRange().getValues();
  varoutString = '';
    for(varrow=0 ; row<rg.length ; ++row){
      outString += rg[row].join(',') + '\n';
    }
  returnContentService.createTextOutput(outString).setMimeType(ContentService.MimeType.TEXT);
}

//READ SINGLE RECORD

elseif( e.parameter.func == "ReadRecord") {
varss = SpreadsheetApp.getActive();
varsh = ss.getSheets()[0];
varrg = sh.getDataRange().getValues();
varoutString = '';
outString += rg[parseInt(e.parameter.id)].join(',');
returnContentService.createTextOutput(outString).setMimeType(ContentService.MimeType.TEXT);
}

//UPDATE SINGLE RECORD

elseif( e.parameter.func == "Update") {
varss = SpreadsheetApp.getActive();
varsh = ss.getSheets()[0];
vardata = [[ e.parameter.ritirato, e.parameter.giornoritiro, e.parameter.oraritiro, e.parameter.cognomeritiro, e.parameter.nomeritiro ]];
sh.getRange("M"+(parseInt(e.parameter.id)+1)+":Q"+(parseInt(e.parameter.id)+1)).setValues(data);
returnContentService.createTextOutput("Success");
}

//QUERY RECORDS

elseif( e.parameter.func == "Query") {
varss = SpreadsheetApp.getActive();
varsh = ss.getSheets()[0];
varrg = sh.getDataRange().getValues();
varsql = e.parameter.SQL;
varqry = '=query(' + rg + ';\"' + sql + '\";1)';

varts = ss.insertSheet();
varsetQuery = ts.getRange(1,1).setFormula(qry);
vargetResult = ts.getDataRange().getValues();
ss.deleteSheet(ts);

returnContentService.createTextOutput(JSON.stringify(getResult));
}

}