Test ESP8266 + DS18B20 Onewire + Google Speadsheets (Google Docs)

If we want a simple solution to monitor temperature, for complicate applications?
if we have Google Docs, This test perform temperature measurement using a probe DS18B20 and transmit directly to  Google spreadsheets using as Google app script bridge.
For this test approximately every 10 seconds temperature data was sent.

Requirements

Arduino IDE
Google Docs account

 

Connection ESP8266 and Google spreadsheet (Google Docs) Direct

I tested the bookstore Library HTTPSRedirect created by Sujay hadke (electronicsguy) thanks for their contribution to the ESP community, in your example creates a kind of chat between Google Docs and ESP8266, below a tutorial video where settings are explained and Connection.

ESP8266 direct connection to Google Spreadsheets (Google Docs)





 

Important note:

To perform this test is required to see the previous tutorial, settings for Google script and Google spreadsheets, Below are the sofware related to this project.

Sensor DS18B20

 

Google Spreadsheets Sheet

This sheet has the following characteristics:
 
1. Historical Record
2. Graph Historical
3. Dial for Current Status
 





 

Video Tutorial





 

Materials very Cheaps!!

1  – 1 ESP8266 – 01  or NodeMCU aliexpress
2  – 2 Converter FTDI  Serial -Usb ttl
3  – 3 Regulator 5 a 3.3v
4  – 1 Sensor DS18B20

Downloads  Github  Project

Related

Youtube Channel

PDAControl

 

 





 

Leave a Reply