Pushing data from the photon into google sheets

[jcarron2]

Hi,

I am trying to get data into google sheets, without using IFTTT or "thinkspeak" webhooks.

Is there anyway to make this legacy method work still?

Example: Logging and graphing data from your Spark Core using Google

Like many other people, one of the more fun things to get your Core to do is interact with the real-world with sensors. The beauty of the Core, perhaps over the arduino, is the ability to access this sensor-read data from anywhere without the need for additional Shields / punching holes in NAT-routers etc etc. A few people have asked how they can log data, and draw graphs from it - so this weekend I spent some time finding out how to do this with the spreadsheets available in G…

using this code in google sheets

function collectData() {
var sheet = SpreadsheetApp.getActiveSheet();

var response = UrlFetchApp.fetch("https://api.spark.io/v1/devices/YOUR-DEVICE-ID/result?access_token=YOUR-ACCESS-TOKEN");

try {
var response = JSON.parse(response.getContentText()); // parse the JSON the Core API created
var result = unescape(response.result); // you'll need to unescape before your parse as JSON

try {
  var p = JSON.parse(result); // parse the JSON you created
  var d = new Date(); // time stamps are always good when taking readings
  sheet.appendRow([d, p.data1, p.data2]); // append the date, data1, data2 to the sheet
} catch(e)
{
  Logger.log("Unable to do second parse");
}

} catch(e)
{
Logger.log("Unable to returned JSON");
}
}

thanks,
Jonathan