ESP32 GPS Data Logger with Google Sheets | Send Data to Google Sheets using ESP32

#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:
--------------------------------------------------------------------------------------------------------------------
Useful Video Links
--------------------------------------------------------------------------------------------------------------------
ESP32 GPS Data to MySQL PHP | ESP32 PHP Web Server

ESP32 SIM800L Firebase

--------------------------------------------------------------------------------------------------------------------
Social Media Links
--------------------------------------------------------------------------------------------------------------------
GitHub:
YouTube:

--------------------------------------------------------------------------------------------------------------------
Download Code
--------------------------------------------------------------------------------------------------------------------

--------------------------------------------------------------------------------------------------------------------
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.

[welshdave]

Nice and simple tutorial, thank you.

Now I need to buy that GPS module.

[JuanGomez-ggjn]

Hi excellent video, I have a question, can I send 10 variables to a spreadsheet in this way?

[laszlokovacs]

Hi Ahmad! Many thanks for this tutorial, but can I do the redirecting with SIM7000 also? Sending data via GSM?

[ftujp]

Can we do it with ultrasonic? If ultrasonic active gps will upload to appsheet?

[johnlouielureca]

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.

[gustavocardona]

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?

[sekerlibalon]

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?

[shaikhatifbadshahsvnit]

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.

[mrlowkick]

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.

[akshaydodamani]

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.?

[abeerjadoon]

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?

[Suradi.Venezuela]

Hi mr Admad, i can put temperature sensor on it?

[u-jinnchong]

'class HTTPClient' has no member named 'setFollowRedirects' < how to solve this error message

[marcova_]

Hi friend, The code in my case returns HTTP Status Code: -1
Any ideas?

[shubhamzendepixitech]

He bro nice video 👍👍... But in my case this is not working

[bagussatya]

can you show us how to do the same thing but using sim800l module please?

[cyrinechabbah]

please nothing work "no new data received" were is the problem please u know??

[gohilbharat]

Node MCU ESP8266 sim800l 2Relay control with Blynk Home automation system next video

[mrkiranbadiger]

I am getting no new data received can u plz help
It shows no new data Recieved in serial monitor