Send Data to Google Spread Sheet using ESP32 || IoT Projects || IOT Training | DHT11 || Google Sheet
ฝัง
- เผยแพร่เมื่อ 25 พ.ย. 2021
- Whatsapp - bit.ly/3vNBEPo
Contact Number - +919043392011
- Dear Viewers,
If any customized project or any help required for your project, I am willing to support you
==========================================================================
Contact Details
##################################################################
Email : TeachMeSomethingSK@gmail.com
Instagram: / teach_me_something_ard...
Fb Messenger : / teachmesomething.teach...
==========================================================================
======================================
************Donation Link************
----------- rzp.io/l/TeachMeSomething -------------====================================== ============================================
Code & Circuit Diagram
Program Download Link -sites.google.com/view/teachme...
Program Download Link 2 - bit.ly/3rr6go6
============================================
Awesome project bro
Thank you sir
Your tutorial is the best. I watched other videos about this subject and was not able to get things to work. After I watched your video, I had success. Thank you.
Thank you
Hey! Can you suggest what would be the changes to be done apart from the header files if we use esp8266 instead of esp32
Refer my friend youtube channel. He done same project with 8266.
Tech trends shameer
@@TeachMeSomething okay , thanks
Hello. Could you help me with a project?
Hey! I have created the temp and humidity monitor in blynk app as shown in your recent video. How can I integrate this as well. I want to store the temp and humidity data
Do you want to integrate Blynk and Google sheet?
@@TeachMeSomething yes
It’s possible to adjust script so if any value is existing,for example a row have the same data, to now write. So no duplicates of data?
Possible
👌👌👌👌sprrr bro
நன்றி
Good Work. Greatly useful. where and how can I get Root CAI certification? I'm struggling to get and add in the code. Please tell the procedure.
It will work
I can't see and find your code anywhere, can I have a reference for your code please? Please. Thank you very much
Write email to teachmesomethingSk@gmail.com
Is it possible to receive that sensor data from anywhere around the world or it requires you to be close to the esp 32 board inorder to receive that data?
You can use it anywhere.
eras mi esperanza, ERAS
sir in this project, data cable use in esp32 for power or using connection to pc or both
Only power. It will work anywhere in this world.
I need to 20 column data transfer. Please explain and how to edit scripts ?
Contact throught instagram,
Hello. Very interesting, congratulations. Is it possible to get the code? Thank you
Code available in link
After sending the value for a while It will contain the message HTTP Status Code : -1, the data will not be sent.
Some setting error.
Redo the process newly.
Your video is very helpful.
My query is any method to update data in spread sheet for every 1 sec ,generally it is taking 6 to 8 sec delay for each row updation?
It is based on internet speed.
It may reduce to 3 sec. But not possible to 1 sec
@@TeachMeSomething
How we can reduce update time to 3 sec
Thank you for your valuable solution
I put no delay in loop also I will take 5 to 6 sec
Is any changed required In google spread sheet
I loved the project, but I have a question. How can I change the sheet to keep sampling, for example I want to sample every 5 minutes to take 244 samples per day, then I want to put the next 244 samples on a different sheet? Briefly, use a different sheet for each 244 samples.
Each Sheet id should be return in program
@@TeachMeSomething Today i tried your code, its works well
@@revathychandaran989 thank you
@@TeachMeSomething I need to update on google sheet every 2 minutes. can u explain me
Put some delay for 2 min
Hello, do i need always open google sheet or not?
Not required
Hi Sir is it possible to read and write to Google sheet even when spreadsheet is closed/not in use
Yes possible. For making video only i opened the sheet. It writes and reads data in google sheet. Also it is not required to connect to the computer always. It is required only internet connection. World wide you use this project
@@TeachMeSomething Thanks very much
can u please upload the httpclient library i m getting error in it
R u using esp32 or esp 8266?
Update esp32 board latest version. You will automatically
I can't see or find your code anywhere can I have some reference for your code please and thank you very much
Contact me in email.
I already sent you an email, thanks
Hello how can i display the newest data is always on top
Everything possible. But program need to modify
How to fixs the timezone because in my google sheet time in column B was wrong ?
It get time from system only
Good afternoon Sir
Good afternoon Sir
How can 3 to 4 sensors like analog sht and dsb183b
It is possible to and many sensor values in one sheet
Can you ease make a video to add 3 to 4 sensors data
@@NIKHILkumar-gp2cf sure sir. Wait 5 - 7 days. I will upload
hi, can i have your code?
Available in description
bgm too loud.
Thank you for your feedback
Why for me it's not send humi & temp ? just date & time
Sensor not reading or sensor pin not connected to Arduino. Open serial monitor & check.
Watch video once again. You will get idea..
@@TeachMeSomething Thank you sir ... It's show in the serial monitor but not show in the Google sheet .. Just date & time (I don't no why .. I used ESP32 WROOM 32 >> Select board "Node32s" in IDE tool)
Google srcipt id is wrong. Or generate new gmail id & try.
@@TeachMeSomething
It works!!! After switching to Publishing is the current version in apps script...
After sending the value for a while It will contain the message HTTP Status Code : -1, the data will not be sent.
code pls
Code available in description
help me code sir
Contact me in WhatsApp