Read Google Spread Sheet Data from ESP32

hello everyone welcome back to the channel in this video we will see how to read the data from google spreadsheet and display it on oled display so let's get started for this project we'll need a breadboard esp32 board i2c based oled display and few jumper wires so let's do the connection we will do the connection as per given in the table so we'll connect sda to the gpu 21 and we'll connect scl to gpio22 ground will be connected to ground and vcc will be connected to 5v or win we can say this project is divided into two parts the first part is google spreadsheet coding and the configuration and second part is arduino coding part so let's start with the first part so we'll create a new google spreadsheet i already have created one spreadsheet so i will open that one go to the tools script editor now the script is the way to access this spreadsheet for reading or for writing purpose and when this application is deployed then special callbacks functions like do get and do post are invoked whenever the request is made to the scripts url i already have created one example so we'll be using this one so whatever data we are sending from esp32 so we'll get that data in the do get function so e is the parameter which will contain the data so if you are requesting for reading then we are reading the c2 cell from the spreadsheet so whatever data we are updating in the c2 cell so that data will get transmitted to the esp32 so whenever we are getting the request we are reading the c2 cell and we are transmitting the data to the esp32 so after creating the example we have to deploy the example so click on deploy new deployment for the first time you will get the configuration window like this click on this icon and now click on web app now change the access level to anyone and now click on deploy now we have to authorize the access to the google spreadsheet select the email id click on addons now click on go to the project unsafe click on allow and done after this we'll get the deployment id which we'll be using in the code copy the deployment id so we'll paste that id into the arduino code so in the arduino code you have to paste the deployment id here now our google spreadsheet is ready now we'll move to the arduino coding part so let's see what is there in the arduino code this is the library file for wifi connection this is the library file for http connection these are the library files for for oled display so here we have to change the data like here we have to change the ssid here you have to change the password we have to paste the deployment id here so these parameters are defined for oled display this is the image we which will be showing on the oled display here we have taken one instance for wi-fi client this function will update the data which we received from google spreadsheet so in the setup function here we are setting the serial communication we are setting the border to double one five two double zero so in this part we are initializing the oled display here we are initializing the wi-fi communication and after that we are printing some logs so in the loop function we are communicating with a spreadsheet and here we have given some delay so in the spreadsheet communication function here we are forming the url and here we are passing it to the http client so after making the request we'll get the data in the payload and we'll print the payload on the serial terminal let's compile the code and let's flash the code and let's see the demo now now after flashing will power on the board and will send the data from google spreadsheet to the esp32 thanks for watching please like share comment and subscribe to the channel for more videos you

Channel: StechiezDIY

Views: 25,924

Keywords: ESP8266, WiFi, diy, Arduino, Display, freertos, automation, sensor, google, assistant, spread, doget, dopost, https, redirect, ssid, drive, fingerprint, iot, internet, things, firebase, thingspeak, projects, esp8266 doget, esp8266 dopost, ifttt, json, google script, esp32, cloud, amazon aws, esp8266 spreadsheet, esp32 https example, esp32 iot sensor, esp32 doget, esp32 dopost, nodemcu, excel, csv, attendance, cload, esp32 google spreadsheet, esp32 spreadsheet, esp32 google, read spreadsheet, read, esp8266

Id: 0LoeaewIAdY

Length: 6min 42sec (402 seconds)

Published: Mon Sep 20 2021