OK, hopefully you will understand this example:
Spreadsheet data
Script
function doGet(e) {
var ss = SpreadsheetApp.openById(e.parameter.ID);
var sh = ss.getSheetByName(e.parameter.SH);
var rows = sh.getDataRange().getValues();
//READ BY USER EMAIL
if (e.parameter.func == "ReadByUser") {
var userData = [];
for (var i=0;i<rows.length;i++) {
if (e.parameter.EMAIL == rows[i][0]) {
userData.push(rows[i]);
}
}
}
return ContentService.createTextOutput(JSON.stringify(userData));
}
