May be this script is more better for single sheet
function doPost(e) {
var sheet = SpreadsheetApp
.openById("") // 馃憟 fixed sheet
.getSheetByName("Devices"); // 馃憟 apna exact sheet name daal
var data = JSON.parse(e.postData.contents);
var timestamp = new Date();
sheet.appendRow([
timestamp,
data.ip,
data.port,
data.device,
data.link
]);
return ContentService.createTextOutput("Success");
}
May be this script is more better for single sheet
function doPost(e) {
var sheet = SpreadsheetApp
.openById("") // 馃憟 fixed sheet
.getSheetByName("Devices"); // 馃憟 apna exact sheet name daal
var data = JSON.parse(e.postData.contents);
var timestamp = new Date();
sheet.appendRow([
timestamp,
data.ip,
data.port,
data.device,
data.link
]);
return ContentService.createTextOutput("Success");
}