ESP32 GPS Data Logger with Google Sheets | Send Data to Google Sheets using ESP32
ฝัง
- เผยแพร่เมื่อ 1 มิ.ย. 2024
- #ESP32 #GPS #GoogleSheets
In this video, I will show you how to make ESP32 GPS data logger with Google Sheets. The GPS data is sent to Google Sheets after every two seconds.
You might also change, the time interval from the sketch, according to your requirement. I have set it to 2000 milliseconds. its mean, the project will send GPS data to google sheets after every two seconds. you might set it 1 second, or even zero second to speed up the process.
Parts:
1. ESP32 - amzn.to/3YCq2dS
2. NEO-6M GPS Module - amzn.to/3YwyWd7
3. Jumper Wires - amzn.to/3YRafs5
4. Breadboard - amzn.to/3ysOvHX
--------------------------------------------------------------------------------------------------------------------
Useful Video Links
--------------------------------------------------------------------------------------------------------------------
ESP32 GPS Data to MySQL PHP | ESP32 PHP Web Server
• ESP32 GPS Data to MySQ...
ESP32 SIM800L Firebase
• ESP32 GPS Data Logger ...
--------------------------------------------------------------------------------------------------------------------
Social Media Links
--------------------------------------------------------------------------------------------------------------------
GitHub:
github.com/ahmadlogs/
TH-cam:
th-cam.com/users/ahmadlogs?sub...
--------------------------------------------------------------------------------------------------------------------
Download Code
--------------------------------------------------------------------------------------------------------------------
github.com/ahmadlogs/esp32/tr...
--------------------------------------------------------------------------------------------------------------------
Disclaimer
--------------------------------------------------------------------------------------------------------------------
Disclaimer: All videos are for educational purposes and use them wisely. Any video may have a slight mistake, please take decisions based on your research. This video is not forcing anything on you.
Nice and simple tutorial, thank you.
Now I need to buy that GPS module.
Glad it was helpful!
Hi excellent video, I have a question, can I send 10 variables to a spreadsheet in this way?
Good work, thanks.
Thank you too!
Thank you so much !!! I really need
Glad it helped!
Hi Ahmad! Many thanks for this tutorial, but can I do the redirecting with SIM7000 also? Sending data via GSM?
yes
Can we do it with ultrasonic? If ultrasonic active gps will upload to appsheet?
hmmm.... it is posible. I will try it.
Can you help me please. Mine the output in serial monitor said
0
No any valid GPS data.
my neo6m was working fine in arduino uno and i also tried to my esp32 in different code and it is also work fine but here said this.
After a many trial and error i came up with alternative traubleshooting to the GPS functions.
if the serial monitor says
"0
no any valid gps data."
the part of statement that == 1 try to change to 0 and test it. if there is a function will be send to your gsheet even 0,0,0,0 but the gps time and gps date there will have a value. means your gps is working. the device also depending on the satellites he will get on signal. if data sent even 0,0,0,0,gps time ,gps date. try to change the statement == 1 again and run it. then wait at least a couple of minutes.
ps: this situation works mine i hope yours too. i am also a beginner. Thanks!
Thanks. This could help
Thank you very much, dear Mr. Ahmet.
I did the project carefully 1-2 times
Arduino esp32 side works perfectly.
But it does not write any data to the Spreadsheet side.
I gave all permissions, what could be the problem?
what error shown in the serial monitor
@@AhmadLogs HTTP Status Code: 403 in my case. Despite giving "anyone" permission, Google is being a little ****.
My DHT is working well and I can see Temp and humidity in Serial Monitor. I receive HTTP code 200, but there is no info in the Sheet. I have repeated all the process several times with the same result. What i'm making wrong? CAn you help me with that?
first, test your google sheet url using web browser
@@AhmadLogs Hi, can you show how to test the sheet in Web browser please?
Sir.,
With GPS parameters (lang,lat,speed etc) can we able add more data's which are measured with different sensors and add them to gps.?
Yes, you can
@@AhmadLogs how's it possible sir.,? I needed it for my project work..
@@akshaydodamani7265 tell me your project requirements
I figured it out sir., Tnqs for ur spending quality of time to reply. 😍
Dear Mr Ahmed, i received the status code 200, but when i check the scripts execution it shows the request is failed, so the google sheet doesn't append any data. Can you please shows me what i've done wrong on this project. Thx A lot.
I think there is a issue with the google sheet server. so just try again after 3 to 4 hours
Hi Mr. Ahmad. The video is really smooth & helpful. One small question (with reference to 0:32 from current video). I am not getting readings in after each second. Its collecting data after 7secs only (even after changing value of SendInterval to 0). could you please help. I want to collect data in milliseconds.
it is just because the program is wait for the response from the google sheet. after getting the successful response back. then it will send the next data. I have just speed up the video that's why it looks the data is transferred very fast.
@@AhmadLogs Thanks for the information. Is there any way to speedup this responses (to get milisecond of data)?
@@shaikhatifbadshahsvnit4167 it required fast internet connection. I have use a different code in my latest video about google sheet and the performance is much batter then this project. you must check that
Assalam o alaikum Ahmed bhai I did this carefully and receive data on google sheet but only when esp32 is connected with PC or laptop but couldn't get the data on google sheet when only esp 32 is powered by battery, please guide what could be the error?
If your ESP32 is only able to send data to your Google Sheet when it's connected to a computer and not when it's powered by a battery, it's possible that the power supply you're using is not providing enough current for the ESP32 to function properly. Try using a power supply with a higher current rating or a battery with a higher capacity. Double-check your wiring and review your code for any potential issues.
Hi mr Admad, i can put temperature sensor on it?
yes.
'class HTTPClient' has no member named 'setFollowRedirects' < how to solve this error message
what version of esp32 board package you have installed.
use some old version of esp32 board package.
Hi friend, The code in my case returns HTTP Status Code: -1
Any ideas?
did you find the solution? i got same issue
error with tiny gps++.h pls help
can you show us how to do the same thing but using sim800l module please?
not sure. but I will try
@@AhmadLogs Using gprs instead of wifi
@@funnycats9738 will try in future
@@AhmadLogs thank you so much
Sure, for an IoT projects using gprs is most versatile than using wifi, because with gprs project can be placed anywhere.
I would request using a library to handle connection rather than using AT commands
For this project, esp32 needed any WIFI.....?
yes. WIFI is must
@@AhmadLogs can you show us the code?
@@bagussatya3888 please check the description of the video. I have update the code download link
@@AhmadLogs thank you
please nothing work "no new data received" were is the problem please u know??
what is the output in serial monitor?
@@AhmadLogs output data input G12 G14
@@cyrinechabbah237 have you tested your gps module. give me full details about your project
GPS module sim 808 and esp32-WROM-32
@@AhmadLogs Haw can i test the gps module please?
He bro nice video 👍👍... But in my case this is not working
What happened?
Node MCU ESP8266 sim800l 2Relay control with Blynk Home automation system next video
will try
Thank you so much
@@gohilbharat8200 so nice of you
I am getting no new data received can u plz help
It shows no new data Recieved in serial monitor
is your gps module working fine?
@@AhmadLogs it’s working fine
Wt to do sir now
@@mrkiranbadiger5553 what is the led status of your gps module
@@AhmadLogs when I check only with gps test it gives coordinates but when I connect to esp32 and run it it gives no new data recieved
@@mrkiranbadiger5553 it is strange