Read Google Spread Sheet Data from ESP32

In this video we will see how to read data from google spread sheet and update the data on ESP32.

Code:

You get the Materials from links:

Send Data to Google Spread Sheet using ESP32 IFTTT

Google spreadsheet using esp8266

Google spreadsheet using ESP32

Tutorial on How to post data to Google Firebase using ESP8266

Tutorial on How to post data to Thingspeak using ESP8266

How to Get Gmail Notification on ESP8266 & OLED

#esp32
#spreadsheet
#readspreadsheet

[FadlyMaskom-muim]

Does this work with reading multiple cells? Can you show this or by using json maybe

[danielbonzo]

Great Video, Well done.
Please can you show me how I can read data from multiple cells at an instant.

[MuhammadUsman-twbv]

Can you please share the Http Client Library because i searched alot to get the library but i get error every time at line48 of your code at Follow Redirects line so please share the library link with us.

[sohan]

i am trying this with esp8266, even though i have downloaded the HTTPClient library from library manager, it is saying that: no such file or directory. Can you please help !

[martinchirwa]

Can you make the same please by using dht 11?

[zouhirmsahli]

Hi is this procedure available even when the spreadsheet is not in use ?

[plusmartini]

what does "var ss" do in the google script?

[billintyvarralaya]

thanks for this video
how to do the same but from esp8266??

[annentasudihartama]

i do like the instruction but why on my oled show doctype html and the data is not show in spreedsheet too whats the problem

[mohammedyasarshaikh]

I want to get data of a column, approx. 500 cells(For now) for an attendance based project...

[willylee]

I would like to ask if my ESP32 uses google script to get the sheet content, there will be a request time of 5 seconds. Is there any way to reduce or eliminate this time?

[g-c]

for me it takes too much time to read data from a cell..what shall i do?

[iberiocabrerahernandez]

Hello, I am trying to read data with an ESP82266 and I tried to do it with your video but I am also something new and it has given me a lot of work and I have not succeeded, do you know any tutorial that can guide me, thank you very much, excellent video.

[jcjiang]

Hi, thanks for the video, but I met a problem, I use esp8266, and when I verify the code, it says that "fatal error: esp32-hal-log.h: No such file or directory", so how should I fix this problem

[anandsamdadiya]

Actually I am working on project on esp32 and i am facing problem in sending data to Google sheets through esp32 and also I have to perform more task.I will be helpful to you please if u can share ur contact no