Home Status App Script

home-status.gs

function doPost(e) {
  try {
    const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Data");
    const payload = JSON.parse(e.postData.contents);

    const row = [
      payload.timestamp,
      payload.livingRoom.temperature,
      payload.livingRoom.humidity,
      payload.livingRoom.airQuality,
      payload.elenaRoom.temperature,
      payload.elenaRoom.humidity,
      payload.elenaRoom.airQuality
    ];

    sheet.appendRow(row);
    return ContentService.createTextOutput("Success").setMimeType(ContentService.MimeType.TEXT);
  } catch (err) {
    return ContentService.createTextOutput("Error: " + err.toString())
      .setMimeType(ContentService.MimeType.TEXT);
  }
}