Read Google Spread Sheet Data from ESP32
Vložit
- čas přidán 21. 07. 2024
- In this video we will see how to read data from google spread sheet and update the data on ESP32.
Code:
github.com/stechiez/iot_proje...
You get the Materials from links:
ESP32 - www.banggood.in/custlink/KDmh...
Breadboard - www.banggood.in/custlink/DGKy...
Jumper Wires - www.banggood.in/custlink/vGGh...
Oled Display - www.banggood.in/custlink/DKvY...
Send Data to Google Spread Sheet using ESP32 IFTTT
• Send Data to Google Sp...
Google spreadsheet using esp8266
• [IOT Projects #1] How ...
Google spreadsheet using ESP32
• Send Data to Google Sp...
Tutorial on How to post data to Google Firebase using ESP8266
• [IOT Projects #3] How ...
Tutorial on How to post data to Thingspeak using ESP8266
• [IOT Projects #4] How ...
How to Get Gmail Notification on ESP8266 & OLED
• [IOT Projects #2] How ...
#esp32
#spreadsheet
#readspreadsheet - Věda a technologie
Hi is this procedure available even when the spreadsheet is not in use ?
Does this work with reading multiple cells? Can you show this or by using json maybe
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.
what does "var ss" do in the google script?
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 !
Nice.. I am working on it
Great Video, Well done.
Please can you show me how I can read data from multiple cells at an instant.
Can you make the same please by using dht 11?
how to do the same with esp8266??
thanks for this video
how to do the same but from esp8266??
Can you show, how to read google spread sheet data from ESP8266?
Awesome
U ARE A GOD
I want to get data of a column, approx. 500 cells(For now) for an attendance based project...
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
I tried esp8266 with google apps script. It never worked. Not enough TLS memory buffer. Pi pico W worked great.
Would that work on a ESP8266 nodemcu?
yes.
Best 👍
Thanks ✌️
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?
i not use any delay
Time can be reduce but cannot avoid completely. Delay is required to do processing and again send/receive process.
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
got the same problem says i dont have authorization but i clearly sad anyone
for me it takes too much time to read data from a cell..what shall i do?
There will be some limitation on reading the data. I never tried but you can try and let us know.
error: 'HTTPC_STRICT_FOLLOW_REDIRECTS' was not declared in this scope
Under board manager in Arduino IDE, uppdate to the latest ESP32 version.
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.
You can check for basic videos if you are new to esp8266.
hello
can i know what modifications you have done with the code to try with esp8266
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
I have published video on that too..please check my video list..If you still face any problem then let me know...