Send Data to Google Spread Sheet using ESP32 | IoT Projects | IoT Training | JLCPCB
ฝัง
- เผยแพร่เมื่อ 11 ส.ค. 2020
- $2 for PCB Prototype & Free SMT assembly : jlcpcb.com
This Project is to Post the data using ESP32 to google spread sheet. This will involve google script which will be manage to write the google spread sheet column and row. So, No need to use any third party server to update the google spread like IFTTT.
Here, we are updating the temperature value to google spreadsheet. Likewise we can use any sensors like Soil moisture, LDR, HC-SR04 etc. connected to ESP32.
Code and Connection Diagram:
github.com/stechiez/iot_proje...
www.buymeacoffee.com/stechiezdiy
Links to get the parts,
Nodemcu - www.banggood.in/custlink/mmKh...
ESP32 - www.banggood.in/custlink/KDmh...
Read Google Spreadsheet using ESP32
• Read Google Spread She...
Google spreadsheet using esp8266
• [IOT Projects #1] How ...
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 ...
Support My Channel:
buymeacoffee : www.buymeacoffee.com/stechiezdiy
Patreon : / stechiez
#esp32
#google
#spreadsheet - วิทยาศาสตร์และเทคโนโลยี
![[LIVE] : ONE ลุมพินี 63 วันนี้!! คู่เอก "ยอดภูผา vs โซเนอร์"](http://i.ytimg.com/vi/RGVmBsegKEI/mqdefault.jpg)
Thanks a lot! Very clear and accessible description.
I had to find out what the in the Arduino IDE had to be; it turned out to be the ID of the deployed app and not simply the spreadsheet's ID.
Thank you so much!!!!!!! I was scared of working with IoT but you made it easy. You're the best! Subscribed
Incredible! Thanks so much
Glad you liked it!
very clearly explained, thank you so much for sharing your knowledge 🔥👌
Thanks, very good
Hi sr, I have doubts about the Root_ca, no information is sent to Google Spread and seeing the link that the ESP32 accesses and copying it to the browser tells me that I do not have permissions to access the requested file.
Do you have any idea how to grant it the necessary permissions?
Nestor R
What is the root certification?
Is the same can be done with esp32 camera with a IP address generate by it to store a data????
incredible tutorial, works great!
I'm having an issue where the sendData process takes too long and I can send around 6-8 readings per minute even with the sendInterva at 0 but i need more
I've been trying to store the info a flash or something so I can then dump data every minute of 30-40 readings (every 2 secs or 3) but i cant find any tutorial or anything similar
How would you do this? can you help me with some pointers? any ideas? thanks!
Yes there is issue with that ..it takes long time to send. If you want to achive good speed then i think IFTTT based approach is faster..
Thank you for the video. I cannot get the serial no for IC , LDR sensors and Resistors
module is esp32 module
you can use any LDR sensor
Resistor : 10K
can you make a video on how to send any gas senor data from nodemcu to spreadsheet .
please share both spread sheet code and nodemcu code
You just have to replace the code in the place of sensor i have used.
I also doing the similar project.. Is this can be use for rfid attendance system.. I want to send the data of rfid card to google sheet
Sure. You can use it.
thank you for the video. I cannot get my code to work. In the serial monitor I see that it makes the requests (start and end certificate) but ti does not seem to display "done" from the last line (Serial.println(": done "+httpCode);).
I am not sure of what I am doing wring
did you replace the google sheet ID and are you using same script as me.
Please make sure you have followed all the steps as me.
@@StechiezDIY yes
Did you ever figure this out? I am seeing a similar result. I see making a request in the serial monitor and then it jumps part way into the certificate and I never see a done or anything else.
@@lunsfordppg8395 no, i broke my head for hours (I am a beginner) and could not figure it out. I found another video and following that video worked "ESP32: Sending data directly to Google Sheets, sending alarm emails" by anyboards. I hope this helps you
Hey dude, I am doing a similar Project in which face recognition attendance by using ESP32 cam and Google spreadsheet .We couldn't find an exact source for it.Could you give suggestions and source codes for it
I don't have source code ready. But you can take this project as a reference.
I don't have source code ready. But you can take this project as a reference.
HOW to get root ca ???
hello i make this by mlx90614 sensor. but serial monitor and spread sheet always show 1037c only. not change temperature. plz healp me
can you please post your code here.
how about change to DHT11 go to Google sheet with ESP32 ... I can't send temp & humi to google sheet .. Just send 4-5 time after that
"Humidity: 37.00 % Temperature: 28.00 *C 82.40 *F Heat index: 27.47 *C
==========
connecting to script.google.com
connection failed
"
How to fix it ? Thank you
Try to add , client.setInsecure(); on your loop and client.stop(); on your last loop
how do you synchronise the root certification? I copied yours but I believe I have to change it
AFAIK you don't have to change the root_ca certificate. This will work with you as well.
@@StechiezDIY Thank you for your reply. I am facing a weird issue. I get no error. The esp32 shows success on the connection, but no data is added to the spread sheet
you can put the logs in gscript and tried to give the HTTP request on your browser. You will get the response..
Which logs are you referring to?
for log, you can customize the response with following call
return ContentService.createTextOutput("Wrote:
tag: " + tag + "
value: " + value);
I tried this a 100 times, each time there is an error of connection failed
This worked for several days and stopped working. Now I do not see the Root CA after the "making request" in the serial monitoring. Got any suggestions?
Yes this was working previously but now Google has changed the request API.
@@StechiezDIY Thanks. Is there another way other than a 3rd party app (ie LFTTT)? And also, how was this working for the last three days?
You will just have to change the API in the code. I think url request is redirecting nowadays. And again deploy the app.
@@StechiezDIY Do you plan on making a video of how to do this now that Google has changed the API? And if you do make another video of how to directly send data to Google Sheets from ESP32, could you use a BME280 sensor with the project? Thanks.
@StechiezDIY how do we get the root ca certificate ??
You can use same as mine.
sir do you have the same code but with vl53l0x sensor
No i don't have that code ready.
@@StechiezDIY sir but that is possible right,
actually im complately new to arduino, trying
thank you
Yes. That is possible.
Can you please assist me, i am using an arduino uno wifi rev2 and i want to send data to the spreadsheet
sure. you can post the problem here. I have not used the board you mentioned but i will try to help you. :)
@@StechiezDIY I have been following your video step by step but i noticed i had to make some changes with the board not using the HTTP but did take HttpClient.h NOW the problem is with the last part In function 'void sendData(String): accessing the client an establishing the request. Http.begin is not declared and seem to be an error also with int httpCode = http.GET();
Please assist in the request to client, I am new at this but i am also doing a research should i go right with it i will also post here the solution but please do assist me in the meantime thank you
you can refer my example for esp8266 for that i was using library. If i face any problem then i used to put the serial prints and check the behavior and data.
github.com/stechiez/iot_projects/tree/master/PostDataToGoogleSheet
@@StechiezDIY thank you i will refer to it, i'll comment on the update
you does not explain what is the root certification and how to have it
Intend of the project was limited 😊.
Can we send Google sheets data to esp8266
Yes that can be done...
Hello sir I want to make a device
Can you make a device for me..?
Great video, too bad Google changed it all up and this does not work anymore.... 😞
@@androidtv5254 too much for a TH-cam comment, I'm afraid... I tried to follow this but the step where you turn the code into a Web API is pretty different now. With much more options, no doubt, but 1.000x more complicated. You need all kinds of registrations and setups before you can publish an API now. I'm not 100% sure but it seems to be aimed at corporate use primarily. I stopped my attempt, it WAY too much.
I agree. Google keep on the changing the interfaces and their softwares. This can not be long term solution.
Sir, how to get HTTPClient.h header file?
If you already dowloaded ESP32 at your IDE, prob you already have it
The background music makes me sleep.. please dont use such sleepy music
You have a good video but you talk too fast and I can't understand you.
sorry about that. I will make a note of it. :)
your code returns HTTP CODE -1