Something like this:
SCRIPT
function doGet(e) {
var passphrase = e.parameter.passphrase;
var ss = SpreadsheetApp.openById('<Spreadsheet ID here>');
var sh = ss.getSheetByName('<sheet name here>');
var name = e.parameter.name;
var age = e.parameter.age;
if (passphrase == 'AB12xyz') {
sh.appendRow([name,age]);
return ContentService.createTextOutput('passphrase correct, data added');
} else {
return ContentService.createTextOutput('passphrase incorrect');
}
}
BLOCKS
