Fetch latest dweet data and append to spreadsheet

fetch-latest-dweet.gs

function addData(time, val) {
  var sheet = SpreadsheetApp.getActiveSheet();
  var last = sheet.getLastRow();
  var cell = sheet.getRange(last, 1);
  var pretime = cell.getValue();
  if (pretime != time) {
    cell.offset(1, 0).setValue(time);
    cell.offset(1, 1).setValue(val);
  }
}

function pullData() {
  var url="http://dweet.io/get/latest/dweet/for/xxx";
  var res = UrlFetchApp.fetch(url);
  var json = JSON.parse(res.getContentText());
  var time = json["with"][0].created;
  var val = json["with"][0].content.light;
  addData(time, val);
}