WiFi Temperature Monitor - Part II

Since writing the first WiFi temperature monitor post, I’ve implemented retrieving temperature values on a schedule, to generate a real-time dashboard. I came across this Gadgets Apps Hacks Post, which utilizes Google Apps Script’s ability to connect to External APIs and record stock ticker values over time in Google Sheets. The method I used in the first part to write the temperature sensor value in a Sheet is more suited for a single import of a larger data set in JSON format. There is also a tutorial from Particle that uses IFTTT to log the data in a Sheet. Although the tutorial from Particle might be a little easier to implement, I chose to work solely with Google Apps Script; since I wanted to pull data from other APIs. I’ll use WeatherUnderground for the outside temperature and Nest for a comparison of inside temperature from another device.

Read more  ↩︎

WiFi Temperature Monitor - Part I

Particle.io has some relatively inexpensive and lightweight IoT boards that connect via WiFi (Photon) or Cellular Networks (Electron). They are focused on providing a fully functioning cloud based IDE for development and production devices. Programming is accomplished via Wiring, the same framework as Arduino. Since the framework is open source down to the bare metal, you can also use C/C++ or ARM assembly.

For my first project with the Photon, I created a wireless temperature monitor that displays in a Google Sheet. I used a TMP36 Sensor and imported the results utilizing Script Editor and this Import JSON Script. The JSON output from the Photon looks like this (“deviceID” intentionally obscured):

{
 "cmd": “VarReturn”,
 "name": “analogvalue”,
 "result": 964,
 "coreInfo": {
   "last_app": “”,
   "last_heard": “2016-05-22T22:00:00.209Z”,
   "connected": true,
   "last_handshake_at": “2016-05-22T21:20:20.002Z”,
   "deviceID": “UNIQUE_ID”,
   "product_id": 6
 }
}
Read more  ↩︎