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.


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


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


Youtube Channel




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