Test 2

function doGet(e) { var ss = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet1"); var email = e.parameter.email; if (!email) { return ContentService.createTextOutput("0").setMimeType(ContentService.MimeType.TEXT); } var range = ss.getDataRange().getValues(); for (var i = 1; i < range.length; i++) { if (range[i][1] && range[i][1].toLowerCase() == email.toLowerCase()) { return ContentService.createTextOutput(String(range[i][2] || 0)) .setMimeType(ContentService.MimeType.TEXT); } } return ContentService.createTextOutput("0").setMimeType(ContentService.MimeType.TEXT); } function doPost(e) { var ss = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet1"); var data = JSON.parse(e.postData.contents); if (data.action == "savePoints") { var range = ss.getDataRange().getValues(); var found = false; for (var i = 1; i < range.length; i++) { if (range[i][1] && range[i][1].toLowerCase() == data.email.toLowerCase()) { var currentPoints = parseInt(range[i][2] || 0); ss.getRange(i + 1, 3).setValue(currentPoints + data.points); found = true; break; } } if (!found) { ss.appendRow([data.name, data.email, data.points]); } } return ContentService.createTextOutput("OK").setMimeType(ContentService.MimeType.TEXT); }