ESP32 Data to Google Sheet 2024

				
					function doGet(e) { 
Logger.log( JSON.stringify(e) );
var result = 'Ok';
if (e.parameter == 'undefined') {
result = 'No Parameters';
}
else {
var sheet_id = 'Google Sheet id'; // Spreadsheet ID
var sheet = SpreadsheetApp.openById(sheet_id).getActiveSheet();
var newRow = sheet.getLastRow() + 1; 
var rowData = [];
var Curr_Date = new Date();
rowData[0] = Curr_Date; // Date in column A
var Curr_Time = Utilities.formatDate(Curr_Date, "Asia/Bangkok", 'HH:mm:ss');
rowData[1] = Curr_Time; // Time in column B
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 'press1':
rowData[2] = value; 
result = 'OK'; 
break;

case 'temp1':
rowData[3] = value; 
result += ', OK'; 
break; 

case 'deep1':
rowData[4] = value; 
result += ', OK'; 
break;

case 'alti1':
rowData[5] = value; 
result += ', OK'; 
break;  

case 'press2':
rowData[6] = value; 
result = 'OK'; 
break;

case 'temp2':
rowData[7] = value; 
result += ', OK'; 
break; 

case 'deep2':
rowData[8] = value; 
result += ', OK'; 
break;

case 'alti2':
rowData[9] = value; 
result += ', OK'; 
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, "");
}