Created
April 4, 2024 14:45
-
-
Save maxpromer/9a8b46f26f21ea7c075fc228a1bdc307 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
function doGet(e) { | |
Logger.log(JSON.stringify(e)); | |
var result = 'Ok'; | |
if ((!e) || e.parameter == 'undefined') { | |
result = 'No Parameters'; | |
} | |
else { | |
var sheet_id = '10rTTvj3XmHhh2mrXOlFySaBB1DWFF-vXgEjziFkG56I'; // 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; | |
var Curr_Time = Utilities.formatDate(Curr_Date, "Asia/Bangkok", 'HH:mm:ss'); | |
rowData[1] = Curr_Time; | |
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 'temperature': | |
rowData[2] = value; // Temperature in column C | |
result = 'Temperature Written on column C'; | |
break; | |
case 'humidity': | |
rowData[3] = value; // Humidity in column D | |
result += ' ,Humidity Written on column D'; | |
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, ""); | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment