google-docs-air-quality-script

//this is a function that fires when the webapp receives a POST request
function doPost(e) {

  //Return if null
  if( e == undefined ) {
    Logger.log("no data");
    return HtmlService.createHtmlOutput("need data");
  }

  //Parse the JSON data
  var event = JSON.parse(e.postData.contents);
  var data = JSON.parse(event.data);

  //Get the last row without data
  var sheet = SpreadsheetApp.getActiveSheet();
  var lastRow = Math.max(sheet.getLastRow(),1);
  sheet.insertRowAfter(lastRow);

  //Get current timestamp
  var timestamp = new Date();

  //Insert the data into the sheet
  sheet.getRange(lastRow + 1, 1).setValue(event.published_at);
  sheet.getRange(lastRow + 1, 2).setValue(data.temperature);
  sheet.getRange(lastRow + 1, 3).setValue(data.humidity);
  sheet.getRange(lastRow + 1, 4).setValue(data.pm10);
  sheet.getRange(lastRow + 1, 5).setValue(data.pm25);
  sheet.getRange(lastRow + 1, 6).setValue(data.tvoc);
  sheet.getRange(lastRow + 1, 7).setValue(data.c02);

  SpreadsheetApp.flush();
  return HtmlService.createHtmlOutput("post request received");
}