We often need to log data to different platforms. Due to the wide popularity of the NodeMCU, it is now possible to Log data to a secure and easy to access data sources like Google Sheet. Today, we are going to log temperature sensor data to google sheet using nodemcu esp8266. The reason for choosing the Google Sheet is because it is already widely used spread sheet platform among different applications. The NodeMCU is our every time favorite due to its huge functionality in a very low price which will help us log temperature sensor data to google sheet. So let’s get started.

Required Components

We are going to reuse our previous ds18b20 interfacing circuit with NodeMCU, so all we need is a

  • ESP8266 NodeMCU board
  • DS18b20 Temperature Sensor
  • Breadboard
  • Male to Male Jumper Wires
  • Valid Internet Connection

Circuit Diagram

We are going to reuse our previous circuit, so the diagram is also pretty similar to our previous one.

ds18b20 esp8266
DS18b20 interfacing with esp8266

Create Google Sheet and Find Sheet ID

Now you need to prepare your google sheet to receive the data. I created a new google Spread sheet and named it with Temperature Logger. I need to find the SpreadSheetID which is embedded into the url. Here is the url of my spread sheet

https://docs.google.com/spreadsheets/d/1RaJn7Rwd88t0w3VjhnbPg0bZ1A5sX5QbUpU_AMBJ_bQ/edit#gid=0Code language: JavaScript (javascript)

According to above url This will be my sheet ID

1RaJn7Rwd88t0w3VjhnbPg0bZ1A5sX5QbUpU_AMBJ_bQ

(Note: If you tried to open the sheet and it did not open, this could be because I had deleted the sheet or it is protected)

API Credentials

Next we need to find the credentials for the Google Sheet API. For this, you need to go to the developer console. Once you are in, all you need to do is to first create a new project if there is no project in your developer console. After that enable the Sheet API . There is also Google oAuth Playground if you wish to play around. You must check that as well.

By Abdul Rehman

My name is Abdul Rehman and I love to do Reasearch in Embedded Systems, Artificial Intelligence, Computer Vision and Engineering related fields. With 10+ years of experience in Research and Development field in Embedded systems I touched lot of technologies including Web development, and Mobile Application development. Now with the help of Social Presence, I like to share my knowledge and to document everything I learned and still learning.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.