Function doGet(e) {
Logger.log( JSON.stringify(e) );
var result = 'Ok';
if (e.parameter == 'undefined') {
result = 'No Parameters';
}
else {
var sheet_id = '1adwHUpM2s5MUCR6U_u5GW34dr59Su-RhQxxxxxx'; // Spreadsheet ID
var sheet = SpreadsheetApp.openById(sheet_id).getActiveSheet();
var newRow = sheet.getLastRow() + 1;
var rowData = [ ];
rowData[0] = new Date();
for (var param in e.parameter) {
Logger.log('In for loop, param=' + param);
var value = stripQuotes(e.parameter[param]);
Logger.log(param + ':' + e.parameter[param]);
switch (param) {
case 'value1': //Water Pressure (PSI)
rowData[1] = value; //Value in column B
result = 'Written on column B';
break;
case 'value2': //Water Temp (F)
rowData[2] = value; //Value in column C
result += ' Written on column C';
break;
case 'value3' : //Air Pressure (PSI)
rowData[3] =value; //Value in column D
result += 'Written on Column D';
break;
case 'value4' : //Air Temp (F)
rowData[4] = value; //Value in column E
result += 'Written on Column E';
break;
case 'value5' : //Battery vcc (volts)
rowData[5] = value; //Value in column F
result += 'Written on Column F';
break;
default:
result = "unsupported parameter";
}
}
Logger.log(JSON.stringify(rowData));
var newRange = sheet.getRange(newRow, 1, 1,rowData.length);
newRange.setValues([rowData]);
}
return ContentService.createTextOutput(result);
}
function stripQuotes( value ) {
return value.replace(/^["']|['"]$/g, "");
}