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

[@welshdave5263]

Nice and simple tutorial, thank you. Now I need to buy that GPS module.

[@AhmadLogs]

Glad it was helpful!

[@JuanGomez-gg8jn]

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

[@longautomation]

Thank you so much !!! I really need

[@AhmadLogs]

Glad it helped!

[@ftu48jp66]

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

[@AhmadLogs]

hmmm.... it is posible. I will try it.

[@Don-np8rc]

Good work, thanks.

[@AhmadLogs]

Thank you too!

[@akshaydodamani7265]

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

[@AhmadLogs]

Yes, you can

[@akshaydodamani7265]

@@AhmadLogs how's it possible sir.,? I needed it for my project work..

[@AhmadLogs]

@@akshaydodamani7265 tell me your project requirements

[@akshaydodamani7265]

I figured it out sir., Tnqs for ur spending quality of time to reply. 😍

[@mrlowkick8279]

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.

[@AhmadLogs]

I think there is a issue with the google sheet server. so just try again after 3 to 4 hours

[@Suradi.Venezuela]

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

[@AhmadLogs]

yes.

[@shaikhatifbadshahsvnit4167]

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.

[@AhmadLogs]

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.

[@shaikhatifbadshahsvnit4167]

@@AhmadLogs Thanks for the information. Is there any way to speedup this responses (to get milisecond of data)?

[@AhmadLogs]

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

[@cyrinechabbah237]

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

[@AhmadLogs]

what is the output in serial monitor?

[@cyrinechabbah237]

@@AhmadLogs output data input G12 G14

[@AhmadLogs]

@@cyrinechabbah237 have you tested your gps module. give me full details about your project

[@cyrinechabbah237]

GPS module sim 808 and esp32-WROM-32

[@cyrinechabbah237]

@@AhmadLogs Haw can i test the gps module please?

[@johnlouielureca3717]

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.

[@johnlouielureca3717]

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!

[@Mohamm-ed]

Thanks. This could help

[@gustavocardona7231]

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?

[@AhmadLogs]

first, test your google sheet url using web browser

[@welshdave5263]

@@AhmadLogs Hi, can you show how to test the sheet in Web browser please?

[@laszlokovacs5297]

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

[@AhmadLogs]

yes

[@abeerjadoon221]

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?

[@AhmadLogs]

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.

[@sekerlibalon1435]

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?

[@AhmadLogs]

what error shown in the serial monitor

[@mathiasbekker211]

@@AhmadLogs HTTP Status Code: 403 in my case. Despite giving "anyone" permission, Google is being a little ****.

[@mrkiranbadiger5553]

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

[@AhmadLogs]

is your gps module working fine?

[@mrkiranbadiger5553]

@@AhmadLogs it’s working fine Wt to do sir now

[@AhmadLogs]

@@mrkiranbadiger5553 what is the led status of your gps module

[@mrkiranbadiger5553]

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

[@AhmadLogs]

@@mrkiranbadiger5553 it is strange

[@Chirukesh]

For this project, esp32 needed any WIFI.....?

[@AhmadLogs]

yes. WIFI is must

[@bagussatya3888]

@@AhmadLogs can you show us the code?

[@AhmadLogs]

@@bagussatya3888 please check the description of the video. I have update the code download link

[@bagussatya3888]

@@AhmadLogs thank you

[@marcova_79]

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

[@muhamadsandhika4525]

did you find the solution? i got same issue

[@jakkapattubtunyaboon9399]

error with tiny gps++.h pls help

[@u-jinnchong5573]

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

[@AhmadLogs]

what version of esp32 board package you have installed. use some old version of esp32 board package.

[@bagussatya3888]

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

[@AhmadLogs]

not sure. but I will try

[@funnycats9738]

@@AhmadLogs Using gprs instead of wifi

[@AhmadLogs]

@@funnycats9738 will try in future

[@bagussatya3888]

@@AhmadLogs thank you so much

[@raymondmichael4987]

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

[@shubhamzendepixitech2608]

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

[@AhmadLogs]

What happened?

[@gohilbharat8200]

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

[@AhmadLogs]

will try

[@gohilbharat8200]

Thank you so much

[@AhmadLogs]

@@gohilbharat8200 so nice of you