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
Programming ESP8266
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

1  – 1 ESP8266 – 01
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

 

 

You may also like...

2 Responses

  1. coyayes says:

    Hola!, he seguido el tutorial, muy bueno!! tengo una duda ya que en mi caso la temperatura se actualiza siempre en la celda A1, como puedo hacer para que quede un registro que vaya acumulando los datos de temperatura hacia abajo y actualizar el grafico como se ve en el tutorial?

Leave a Reply