function doGet(e) {
if (e.parameter.id && e.parameter.status) {
updateStatus(e.parameter.id, e.parameter.status);
return ContentService.createTextOutput("Success");
}
return ContentService.createTextOutput("Invalid Request");
}
function updateStatus(id, status) {
var sheet = SpreadsheetApp.openById('1rGzD78y55__o1OF6rXUep5Seg5c5BmT8UtqwSJ6rNeM').getSheetByName('quote');
var data = sheet.getDataRange().getValues();
for (var i = 0; i < data.length; i++) {
if (data[i][0] == id) {
data[i][2] = status;
sheet.getRange(i+1, 3).setValue(status);
break;
}
}
}