Google Spreadsheet or Google Sheets with ESP8266 Nodemcu for Data Logging (2022)

Contents

  • 1 Google Spread Sheet with ESP8266, Description:
  • 2 Amazon Links:
  • 3 ESP8266 NodeMCU:
    • 3.1 Specifications:
  • 4 DHT11 Sensor:
  • 5 Nodemcu ESP8266 and DHT11 Circuit Diagram:
  • 6 Nodemcu esp8266 power supply Circuit Diagram:
  • 7 Altium Designer:
  • 8 Creating Google Spreadsheet:
  • 9 Google Spreadsheet Nodemcu ESP8266 Code:
  • 10 Watch Video Tutorial:

Google Spread Sheet with ESP8266, Description:

Google Spreadsheet or Google Sheets with ESP8266 Nodemcu for Data Logging (1)

Google Spreadsheet or Google Sheets with ESP8266 Nodemcu for Data Logging, Temp & Hum DHT11- So far I have covered majority of the IoT platforms for monitoring different types of sensors and for controlling different types of electrical devices. Usually for the real-time sensors monitoring I display the sensors values on the Gauges and for this I mostly use Blynk IoT platform, Ubidots, and Thingspeak etc. In majority of the cases only displaying the sensor values is not enough. There are guys who are interested in the data logging for the post analysis. The sensors data logging service offered by majority of the IoT platforms isn’t as impressive as offered by the Google which is absolutely free, highly secured, fast, and reliable. In this article, I will be using Nodemcu ESP8266 WiFi module with Google Sheets for the sensor data logging. Google Sheets is a spreadsheet program included as part of the free, web-based Google Docs Editors suite offered by Google.

Read my latest Article on How to send data from Google Spreadsheet to ESP8266 or ESP32.

Since this is my first time using the Google sheets for the Sensors data logging; so, I will try my level best to explain each and every detail. I will be using DHT11 Temperature and Humidity sensor as this is the most basic and easily available sensor. Once you learn how to send the temperature and humidity values to the Google Spreadsheet then you can replace this sensor with any other sensor of your choice. So, before, I am going to explain the circuit diagram, programming, and how to get started with the Google sheets, first let me explain; how this projects works.

Google Spreadsheet or Google Sheets with ESP8266 Nodemcu for Data Logging (2)

I am using my homemade 4S lithium Ion battery pack for powering up my Nodemcu ESP8266 Development board. Read my article on how to make 3S and 4S lithium Ion batteries pack, if you want to make the same battery pack. As soon as I powered my Nodemcu ESP8266 module, after a few seconds I started to receive the data. The temperature and humidity values are stored along with the date and time information. For the demonstration purposes I am using a short delay in the programming, if you want you can increase the delay time. It’s totally up to you whether you want to send data after every 1 minute or 10 minutes, or 1 hour.

Google Spreadsheet or Google Sheets with ESP8266 Nodemcu for Data Logging (3)

Anyways, you can also open the Google spreadsheet using your laptop or computer; again it’s up to you whether you want to use your computer or your cell phone for the monitoring and post analysis. Since this is an IoT based project so, you can monitor the temperature and humidity values from anywhere in the world. One thing that I really liked about the Google sheets is that; if you share the same Google account with multiple users then all the users can monitor the same sensor from anywhere in the world.

As this is a getting started tutorial, that’s why I only started with the DHT11 temperature and Humidity sensor, if you want you can use multiple sensors, just go ahead and give it a try and if you face any issues then let me know in a comment. Anyways, now you have got the idea of what exactly you are going to learn after reading this article. Without any further delay, let’s get started!!!

Amazon Links:

12v Adaptor:

Nodemcu ESP8266 WiFi Module:

DHT11 Temperature and Humidity Module:

LM7805 Voltage Regulator:

(Video) Google Spread Sheet or Google Sheets with ESP8266 Nodemcu for Data Logging, Temp & Hum DHT11, IoT

470uf capacitor:

330-ohm resistor:

DC Female Power Jack:

Female Headers:

Other Tools and Components:

Top Arduino Sensors:

Super Starter kit for Beginners

Digital Oscilloscopes

Variable Supply

Digital Multimeter

Soldering iron kits

PCB small portable drill machines

*Please Note: These are affiliate links. I may make a commission if you buy the components through these links. I would appreciate your support in this way!

ESP8266 NodeMCU:

ESP8266 is a highly integrated chip designed for the needs of a new connected world. It offers a complete and self-contained Wi-Fi networking solution, allowing it to either host the application or to offload all Wi-Fi networking functions from another application processor.
ESP8266 has powerful on-board processing and storage capabilities that allow it to be integrated with the sensors and other application specific devices through its GPIOs with minimal development up-front and minimal loading during runtime. Its high degree of on-chip integration allows for minimal external circuitry, and the entire solution, including front-end module, is designed to occupy minimal PCB area.

Google Spreadsheet or Google Sheets with ESP8266 Nodemcu for Data Logging (4)

(Video) NodeMCU ESP8266 + Google Spreadsheet | NodeMCU Sends Data to Google Sheets Directly (No Third Party)

Specifications:

Serial/UART baud rate: 115200 bps
Input power: 3.3V
I/O voltage tolerance: 3.6V Max
Flash Memory Size: 1MB (8Mbit)
WiFi security modes: WPA, WPA2

DHT11 Sensor:

  • DHT11 digital temperature and humidity sensor is a digital signal output with a calibrated temperature and humidity combined sensor.
  • It uses a dedicated digital modules and acquisition of temperature and humidity sensor technology to ensure that products with high reliability and excellent long term stability.
  • Sensor consists of a resistive element and a sense of wet NTC temperature measurement devices, and with a high-performance 8-bit microcontroller connected.
  • The product has excellent quality, fast response, anti-interference ability, high cost and other advantages.

The single-wire wiring scheme makes it easy to be integrated to other applications and the simple communication protocol greatly reduces the programming effort required.

Google Spreadsheet or Google Sheets with ESP8266 Nodemcu for Data Logging (5)

Nodemcu ESP8266 and DHT11 Circuit Diagram:

Google Spreadsheet or Google Sheets with ESP8266 Nodemcu for Data Logging (6)

If you are just getting started with the Nodemcu ESP8266 and DHT11 Temperature and Humidity sensor then these are the minimal connections which you will need for this project. You can power up your Nodemcu module using your laptop. Connect the VCC and GND pins of the DHT11 sensor with the 3.3V and GND pins of the Nodemcu Module; and connect the Data pin of the dht11 sensor with the digital pin D1 of the Nodemcu module. Don’t forget to add a 10k ohm resistor between the VCC and Data pins of the DHT11 sensor. Now, let’s take a look at the other circuit diagram.

Nodemcu esp8266 power supply Circuit Diagram:

Google Spreadsheet or Google Sheets with ESP8266 Nodemcu for Data Logging (7)

This circuit diagram is for those guys who want to power up the Nodemcu module using an external power supply. As you can see the DHT11 sensor connections with the Nodemcu ESP8266 WiFi module remains exactly the same. On the left side is the regulated 5v power supply which is based on the 7805 voltage regulator. J1 is the DC female power jack and this is where we connect a 12v adaptor, battery, or a solar panel. Don’t forget to add these 470uF decoupling capacitors.

Google Spreadsheet or Google Sheets with ESP8266 Nodemcu for Data Logging (8)

Here is my Nodemcu ESP8266 WiFi module based development board which I use for testing my IoT based projects. If you want to make the same development board then you can read my previous article. Anyways, I interfaced my DHT11 sensor with the Nodemcu module as per the circuit diagram. My connections are completed and now let’s start with the Google sheets, there is nothing complicated just follow the same exact steps.

Altium Designer:

Google Spreadsheet or Google Sheets with ESP8266 Nodemcu for Data Logging (9)

Altium Designer is the world’s most trusted PCB design system.Altium Designerenables engineers to effortlessly connect with everyfacetof the electronics design process. Over 35 years of innovation and development focused on a truly unified design environment makes it the most widely used PCB design solution. WithAltium Designeryou can create PCB designs with anintuitiveand powerful interface that connects you to every aspect of the electronics design process. Route it your way through any angle, tune for the delay, Push, Slide, and Walkaround faster than ever. Interact andcollaboratewith mechanical designers like never before in a photo-realistic, 3D design environment. If you want to get started with the Altium designer, you can click on theget started.

Creating Google Spreadsheet:

First of all we will create the Google Spreadsheet for which we will click on the Google apps and in which we will click on the Sheets.

Google Spreadsheet or Google Sheets with ESP8266 Nodemcu for Data Logging (10)

After that we will click on the blank in order to create a new spreadsheet.

Google Spreadsheet or Google Sheets with ESP8266 Nodemcu for Data Logging (11)

After that we will give the title name of the project and then in columns we will write the date, time, temperature, and humidity.

(Video) NodeMCU বা ESP8266 দিয়ে গুগল শিটে ডাটা লগ | Google sheet data logger using NodeMCU

Google Spreadsheet or Google Sheets with ESP8266 Nodemcu for Data Logging (12)

In the date column which is “A” we will receive the date, in column “B” we will receive the time, in column “C” we will receive the temperature, and in the column “D” we will receive the humidity. After that we will open the script editor in the previous versions of spread sheet it was found in the tools but in the new versions of the spread sheet it is in the extensions with the name Apps Script click on it.

Google Spreadsheet or Google Sheets with ESP8266 Nodemcu for Data Logging (13)

After that we will click on the untitled project and give the name to the project which is DHT_monitoring and click on the ok.

Google Spreadsheet or Google Sheets with ESP8266 Nodemcu for Data Logging (14)

After that paste the following code in it.

function doGet(e) { Logger.log( JSON.stringify(e) );var result = 'Ok';if (e.parameter == 'undefined') {result = 'No Parameters';}else {var sheet_id = ''; // Spreadsheet IDvar sheet = SpreadsheetApp.openById(sheet_id).getActiveSheet();var newRow = sheet.getLastRow() + 1; var rowData = [];var Curr_Date = new Date();rowData[0] = Curr_Date; // Date in column Avar Curr_Time = Utilities.formatDate(Curr_Date, "Asia/", 'HH:mm:ss');rowData[1] = Curr_Time; // Time in column Bfor (var param in e.parameter) {Logger.log('In for loop, param=' + param);var value = stripQuotes(e.parameter[param]);Logger.log(param + ':' + e.parameter[param]);switch (param) {case 'temperature':rowData[2] = value; // Temperature in column Cresult = 'Temperature Written on column C'; break;case 'humidity':rowData[3] = value; // Humidity in column Dresult += ' ,Humidity Written on column D'; break; default:result = "unsupported parameter";}}Logger.log(JSON.stringify(rowData));var newRange = sheet.getRange(newRow, 1, 1, rowData.length);newRange.setValues([rowData]);}return ContentService.createTextOutput(result);}function stripQuotes( value ) {return value.replace(/^["']|['"]$/g, "");}

In the above code we will make several changes in the var_sheet id we will paste the code copied from the spread sheet main page which is shown below in the diagram.

Google Spreadsheet or Google Sheets with ESP8266 Nodemcu for Data Logging (15)

We can change the time by changing the command

varCurr_Time = Utilities.formatDate(Curr_Date, "Asia/Karachi", 'HH:mm:ss');

As the Pakistan time is based on the Karachi so we will write Asia/Karachi. If you are living in India then you will write Asia/New Dehli. You can search the time zone of your country and replace it. After that we will click on the publish and then click on the deploy as web.

Google Spreadsheet or Google Sheets with ESP8266 Nodemcu for Data Logging (16)

Then we will select the “anyone even anonymous” and click on the Deploy.

Google Spreadsheet or Google Sheets with ESP8266 Nodemcu for Data Logging (17)

Then click on the review permission

Google Spreadsheet or Google Sheets with ESP8266 Nodemcu for Data Logging (18)

(Video) Send Data to Google Spread Sheet using ESP32 || IoT Projects || IOT Training | DHT11 || Google Sheet

Then choose the account the g-mail account with which you have created the spread sheet. After that we will click on the advance.

Google Spreadsheet or Google Sheets with ESP8266 Nodemcu for Data Logging (19)

Then click on the go to dht_monitoring

Google Spreadsheet or Google Sheets with ESP8266 Nodemcu for Data Logging (20)

After that we will click on the allow button.

Google Spreadsheet or Google Sheets with ESP8266 Nodemcu for Data Logging (21)

After that we will copy the script url and click on the ok.

Google Spreadsheet or Google Sheets with ESP8266 Nodemcu for Data Logging (22)

Now the process of the Google spreadsheet is completed and we will open the Arduino IDE. If this is your first time using the Nodemcu ESP8266 WiFi module then you will need to install the Nodemcu board. I have a very detailed article on how to install the Nodemcu board. You will also need to install the DHT11 library for this click on the Sketch Menu then go to the Include Library and then click on the Manage Libraries. Type dht in the search box and then install the dht sensor library.

Google Spreadsheet Nodemcu ESP8266 Code:

#include <ESP8266WiFi.h>#include <WiFiClientSecure.h>#include "DHT.h"#define DHTTYPE DHT11 // type of the temperature sensorconst int DHTPin = 5; //--> The pin used for the DHT11 sensor is Pin D1 = GPIO5DHT dht(DHTPin, DHTTYPE); //--> Initialize DHT sensor, DHT dht(Pin_used, Type_of_DHT_Sensor);#define ON_Board_LED 2 //--> Defining an On Board LED, used for indicators when the process of connecting to a wifi routerconst char* ssid = "AndroidAP3DEC"; //--> Your wifi name or SSID.const char* password = "123456"; //--> Your wifi password.//----------------------------------------Host & httpsPortconst char* host = "script.google.com";const int httpsPort = 443;//----------------------------------------WiFiClientSecure client; //--> Create a WiFiClientSecure object.String GAS_ID = "AKfycby8Lfzwu-5SBj9tHxbw3_j8ZPZy6P6_3e_BBISC0Jg7SstXLUed"; //--> spreadsheet script IDvoid setup() { // put your setup code here, to run once: Serial.begin(115200); delay(500); dht.begin(); //--> Start reading DHT11 sensors delay(500); WiFi.begin(ssid, password); //--> Connect to your WiFi router Serial.println(""); pinMode(ON_Board_LED,OUTPUT); //--> On Board LED port Direction output digitalWrite(ON_Board_LED, HIGH); //--> Turn off Led On Board //----------------------------------------Wait for connection Serial.print("Connecting"); while (WiFi.status() != WL_CONNECTED) { Serial.print("."); //----------------------------------------Make the On Board Flashing LED on the process of connecting to the wifi router. digitalWrite(ON_Board_LED, LOW); delay(250); digitalWrite(ON_Board_LED, HIGH); delay(250); //---------------------------------------- } //---------------------------------------- digitalWrite(ON_Board_LED, HIGH); //--> Turn off the On Board LED when it is connected to the wifi router. Serial.println(""); Serial.print("Successfully connected to : "); Serial.println(ssid); Serial.print("IP address: "); Serial.println(WiFi.localIP()); Serial.println(); //---------------------------------------- client.setInsecure();}void loop() { // Reading temperature or humidity takes about 250 milliseconds! // Sensor readings may also be up to 2 seconds 'old' (its a very slow sensor) int h = dht.readHumidity(); // Read temperature as Celsius (the default) float t = dht.readTemperature(); // Check if any reads failed and exit early (to try again). if (isnan(h) || isnan(t)) { Serial.println("Failed to read from DHT sensor !"); delay(500); return; } String Temp = "Temperature : " + String(t) + " °C"; String Humi = "Humidity : " + String(h) + " %"; Serial.println(Temp); Serial.println(Humi); sendData(t, h); //--> Calls the sendData Subroutine}// Subroutine for sending data to Google Sheetsvoid sendData(float tem, int hum) { Serial.println("=========="); Serial.print("connecting to "); Serial.println(host); //----------------------------------------Connect to Google host if (!client.connect(host, httpsPort)) { Serial.println("connection failed"); return; } //---------------------------------------- //----------------------------------------Processing data and sending data String string_temperature = String(tem); // String string_temperature = String(tem, DEC); String string_humidity = String(hum, DEC); String url = "/macros/s/" + GAS_ID + "/exec?temperature=" + string_temperature + "&humidity=" + string_humidity; Serial.print("requesting URL: "); Serial.println(url); client.print(String("GET ") + url + " HTTP/1.1\r\n" + "Host: " + host + "\r\n" + "User-Agent: BuildFailureDetectorESP8266\r\n" + "Connection: close\r\n\r\n"); Serial.println("request sent"); //---------------------------------------- //----------------------------------------Checking whether the data was sent successfully or not while (client.connected()) { String line = client.readStringUntil('\n'); if (line == "\r") { Serial.println("headers received"); break; } } String line = client.readStringUntil('\n'); if (line.startsWith("{\"state\":\"success\"")) { Serial.println("esp8266/Arduino CI successfull!"); } else { Serial.println("esp8266/Arduino CI has failed"); } Serial.print("reply was : "); Serial.println(line); Serial.println("closing connection"); Serial.println("=========="); Serial.println(); //----------------------------------------} //==============================================================================

Upload the above. Power up your Nodemcu ESP8266 module, next open your spreadsheet App on your cell phone or computer and you should be able to receive the temperature and humidity values along with the date and time information.

Google Spreadsheet or Google Sheets with ESP8266 Nodemcu for Data Logging (23)

For detailed explanation and practical demonstration watch video given below.

Watch Video Tutorial:

Tags

(Video) Log DHT11 sensor Data to Google Sheet using NodeMCU ESP8266, Make your own Weather Station IoT

google sheets Google spreadsheet how to send sensor data to google spreadsheet how to use google spreadsheet with esp8266 sensor data logging using google spreadsheet

FAQs

How do I connect NodeMCU to Google Sheets? ›

Connect the VCC and GND pins of the DHT11 sensor with the 3.3V and GND pins of the Nodemcu Module; and connect the Data pin of the dht11 sensor with the digital pin D1 of the Nodemcu module. Don't forget to add a 10k ohm resistor between the VCC and Data pins of the DHT11 sensor.

How does NodeMCU store sensor data? ›

Sensor Data Upload to Google Sheets Through NodeMCU
  1. An Updated Video Walkthrough (2020)
  2. Step By Step written guide (2019)
  3. Step 1: Set Up NodeMCU for Arduino IDE.
  4. Step 2: Setting Up Google Sheets.
  5. Step 3: Code.
  6. Did you like my work.
May 6, 2019

How do I transfer data from ESP8266 to excel? ›

In this project we are going to establish a wireless communication between two ESPs and send data from three sensors to an Excel spreadsheet.
...
Launching Your Things Gateway Application
  1. Go to the Config tab.
  2. Select the Serial COM Port of your ESP8266 Server.
  3. Set the Serial port Speed to 9600.

How do I transfer data from ESP32 to Google Sheets? ›

In the loop function if the WiFi is connected the ESP32 will create an HTTP instance with the HTTPClient Library. Then a request is made to the Google Sheets with the script URL which has our Google Script ID. Once the request is made the ESP will use the HTTP Get method to get the data from the Google sheets.

How do I transfer data from Arduino to Google Sheets? ›

Auto-Generate the Sketch

13Go to the Google > Sheets > AppendValues in our Library. 14Select Arduino from the drop down menu at the top of the Choreo page, then choose your Arduino device. Make sure that you've added details about how your Arduino will connect to the internet.

What is ESP8266 NodeMCU? ›

NodeMCU is an open source platform based on ESP8266 which can connect objects and let data transfer using the Wi-Fi protocol. In addition, by providing some of the most important features of microcontrollers such as GPIO, PWM, ADC, and etc, it can solve many of the project's needs alone.

How does ESP32 read data from ThingSpeak? ›

ESP32 Send Sensor Readings to ThingSpeak using Arduino IDE (BME280)
  1. Introduction to BME280 sensor.
  2. Connecting BME280 sensor with the ESP32 development board.
  3. Setting up Arduino IDE.
  4. Getting ThingSpeak API Ready.
  5. Publish to a single field of sensor readings to ThingSpeak (Only Temperature)

Can ESP8266 send data? ›

Step 1: Program ESP8266 To Send Data

h> gives us access to the functions to send and receive data from the internet. In setup() , I connect to WiFi using the connectToWiFi() function and then connect to internet using the grandeur. init() function.

How do I log data from Arduino to excel? ›

Let's get started!
  1. Connect your sensor to the Arduino microcontroller. ...
  2. Write and flash a sketch that reads in the sensor and prints the value to the Serial Monitor with a new line at the end. ...
  3. Open Excel and navigate to the Data Streamer tab. ...
  4. Click Start Data to begin streaming data into Excel.
Sep 26, 2019

How do I use data streamer in Excel? ›

To Enable Data Streamer in Excel:
  1. Go to File > Options.
  2. In the Excel Options dialogue click Add-ins.
  3. At the bottom of the dialogue in the Manage: dropdown select COM Add-ins and click Go.
  4. In the COM Add-ins dialogue check the box for Microsoft Data Streamer for Excel and Click OK.
Apr 23, 2021

How do I send data from ESP8266 to cloud? ›

Connecting Arduino WiFi to the Cloud Using ESP8266
  1. Introduction: Connecting Arduino WiFi to the Cloud Using ESP8266. ...
  2. Step 1: AskSensors Setup. ...
  3. Step 2: Prepare Hardware. ...
  4. Step 3: Build the Hardware. ...
  5. Step 4: Write the Code. ...
  6. Step 5: Run the Code. ...
  7. Step 6: Visualize Your Data. ...
  8. Step 7: Well Done!

How do I transfer data from ESP8266 to Arduino? ›

The best to connect multiple ESP8266 to Arduino is via Software Serial Communication. You can use any 2 digital pins in Arduino and make then Tx and Rx and then connect your ESP with it to transfer the data. You also need to include the library SoftwareSerial. h in your Arduino Sketch to make it work.

How do I push data into Google Sheets? ›

Import data sets & spreadsheets
  1. On your computer, open a spreadsheet in Google Sheets.
  2. Open or create a sheet.
  3. At the top, click File. Import.
  4. Choose a non-password-protected file in one of these file types: . ...
  5. Select an import option. ...
  6. Optional: If you import a plain text file, like . ...
  7. Click Import.

How do I transfer data from Arduino to Google Sheets 2017? ›

  1. Step 1: Get Accounts (FREE) Get the required accounts: ...
  2. Step 2: Create a Google Form and Get FORM KEY. Inside of google Drive you can create a 'Form' . ...
  3. Step 3: Pushingbox, Service and Scenarios. ...
  4. Step 4: CODE THE ARDUINO. ...
  5. 110 Comments.

How do I use the script editor in Google Sheets? ›

Create a script
  1. In Docs, Sheets, Slides, or Forms, open a document, spreadsheet, presentation, or form.
  2. If you're using Docs, Sheets, or Slides, at the top, click Tools. Script editor.
  3. If you're using Forms, in the top-right corner, click More. Script editor.
  4. Create your script.

Which NodeMCU is best? ›

We recommend the NodeMCU Kit or the WeMos D1 Mini because both boards have a built-in programmer chip, making it easy to upload code. Additionally, they also offer a reasonable number of GPIO pins.

What is the difference between ESP8266 and NodeMCU? ›

ESP8266 is a microcontroller with WiFi capability. it requires external flash memory and some antenna to work. There are different modules and development boards with this system. NodeMcu is a development board with esp8266 .

Is NodeMCU better than Arduino? ›

Advantages of NodeMCU over Arduino UNO:

Better Processor & Memory: NodeMCu comes with an 80MHz of clock speed and 4MB of flash memory. Built-in TCP/IP Stack - IoT Ready: The NodeMCU contains a Wifi connection and can connect to the internet through Wifi. It is best suited for IoT applications.

What programming language does Google Sheets use? ›

Google Apps Script is a coding language based on JavaScript that allows you to extend and manipulate Google apps like Drive, Sheets, Docs, and Gmail.

Does Google Sheets have coding? ›

Google Apps Script is a coding language and allows you to create automation and functions for Google Apps (which can include Google Sheets, Google Docs, Google Forms, Drive, Maps, Calendar, etc.)

What programming language does Google use? ›

Google uses JavaScript and TypeScript in the front-end, and C++, Java, Golang, Python, and PHP in the back-end.

How do I transfer data from ESP32 to server? ›

Go to your network settings, select the network that your devices(ESP32, phone, etc.) are connected and change its profile to Private, meaning that you trust this network, making your PC discoverable and able to accept requests. (That is really simple but took me hours to find)

How does ESP8266 WiFi module work? ›

The ESP8266 WiFi Module is a self contained SOC with integrated TCP/IP protocol stack that can give any microcontroller access to your WiFi network. The ESP8266 is capable of either hosting an application or offloading all Wi-Fi networking functions from another application processor.

How do you send sensor data to cloud using ESP32? ›

Connect the ESP32 module to your computer through a USB cable. Upload the code with the Arduino IDE. Open a serial terminal. You should get an output similar to the figure above.

How do I use the script editor in Google Sheets? ›

Create a script
  1. In Docs, Sheets, Slides, or Forms, open a document, spreadsheet, presentation, or form.
  2. If you're using Docs, Sheets, or Slides, at the top, click Tools. Script editor.
  3. If you're using Forms, in the top-right corner, click More. Script editor.
  4. Create your script.

How do I transfer data from Arduino to Google Sheets 2017? ›

  1. Step 1: Get Accounts (FREE) Get the required accounts: ...
  2. Step 2: Create a Google Form and Get FORM KEY. Inside of google Drive you can create a 'Form' . ...
  3. Step 3: Pushingbox, Service and Scenarios. ...
  4. Step 4: CODE THE ARDUINO. ...
  5. 110 Comments.

How do I connect my Arduino to Google cloud? ›

Arduino Set Up with Wio Terminal
  1. STEP 1: Open Arduino IDE.
  2. STEP 2: Navigate to Sketch > Include Library > Manage Libraries.
  3. STEP 3: Type lwMQTT and Google Cloud IoT in the search box and install the libraries.

Videos

1. NodeMCU ESP8266 + Google Spreadsheet | NodeMCU Sends Data to Google Sheets Directly (No Third Party)
(Teach Me Something)
2. Google Sheet Controlled Smart Notice Board using NodeMCU ESP8266/ESP32 || Read Google Spread Sheet
(Teach Me Something)
3. Read Google Spread Sheet Data ESP8266 || Controlling lights through Google Sheets NodeMCU 8266
(Teach Me Something)
4. ESP8266 Sending Data to Google Spreadsheet w/o Using Any 3rd Party Tool
(IMH Videos)
5. Send Data from NodeMCU to Google Sheets
(thatiotguy)
6. Google spreadsheet to ESP8266, Google Sheets to ESP8266, data from Google Spreadsheet to ESP8266
(Electronic Clinic)

You might also like

Latest Posts

Article information

Author: Kimberely Baumbach CPA

Last Updated: 10/18/2022

Views: 6448

Rating: 4 / 5 (41 voted)

Reviews: 88% of readers found this page helpful

Author information

Name: Kimberely Baumbach CPA

Birthday: 1996-01-14

Address: 8381 Boyce Course, Imeldachester, ND 74681

Phone: +3571286597580

Job: Product Banking Analyst

Hobby: Cosplaying, Inline skating, Amateur radio, Baton twirling, Mountaineering, Flying, Archery

Introduction: My name is Kimberely Baumbach CPA, I am a gorgeous, bright, charming, encouraging, zealous, lively, good person who loves writing and wants to share my knowledge and understanding with you.