-
Notifications
You must be signed in to change notification settings - Fork 0
/
code.gs
66 lines (61 loc) · 1.77 KB
/
code.gs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
function doGet(e)
{
Logger.log( JSON.stringify(e) );
var result = 'Ok';
if (e.parameter == 'undefined')
{
result = 'No Parameters';
}
else
{
var sheet_id = 'Google Spreadsheet ID'; // Spreadsheet ID
var sheet = SpreadsheetApp.openById(sheet_id).getActiveSheet();
var newRow = sheet.getLastRow() + 1;
var rowData = [];
var Curr_Date = new Date();
// Date in column A
rowData[0] = Curr_Date;
var Curr_Time = Utilities.formatDate(Curr_Date, "GMT+5:30", 'HH:mm:ss');
// Time in column B
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)
{
// Temperature in column C
case 'temperature':
rowData[2] = value;
result = 'Temperature Written on column C';
break;
case 'humidity':
// Humidity in column D
rowData[3] = value;
result += ' ,Humidity Written on column D';
break;
case 'moisture':
// Moisture in column E
rowData[4] = value;
result += ' ,Moisture Written on column E';
break;
case 'message':
// Message in column F
rowData[5] = value;
result += ' ,Message Written on column E';
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, "");
}