NodeMCU ESP8266 + Google Spreadsheet | NodeMCU Sends Data to Google Sheets Directly (No Third Party)

[@professormiltin]

Simplesmente incrível a aula! Todos os passos e arquivos já disponibilizados, já estou seguindo e amando a página!

[@obebharoigoni7449]

Pls. how did you setup your router? Can a pc be used as a router to achieve same result?

[@PAULOVARJAL]

Thanks for the project. Shall we move forward? How can we make ESP read the data stored in the Google spreadsheet?

[@arlandmv4053]

You should use a front end app instead.. one that uses the google docs api..

[@delpialos]

after test function doGET() someone have issue data on sheet was wrong , so you must be set column sheet format number only.

[@espindolaclaudio]

Hi, all working correctly, but I have a problem to change de time for update data, currently is 5 seconds, I want 5 minutes... I already tried with delay (from 500 to 30000) but not changes... any sugestion?

[@sandeshkale297]

put delay before the last closing bracket " } " for 5 minute delay must be 300,000 (1000x60x5)

[@ashunegi4760]

I have 40 channels temperature data logger at a time we can connect 40 temperature sensor . So how can I use this system if I want to take 40 temperature sensor data at a time. Please guide me

[@neperic2666]

Hi!! First to thank you. It was very nicely explained. I executed it and it's working fine . I need to add moisture and ultrasonic to the NodeMCU as DHT22.But I am unable to do so. So, please help me in this.

[@karanshethia3560]

For those that are facing problem with the data not being printed on the sheet: Deploy the script again and enter the new GAS id in the sheet. After a couple of tries I got it working. Only concern now is how I increase the time between the delays. I need to take readings every 3 minutes

[@hitenlulla2713]

Use millis()

[@artcraft1252]

Nice video. Please help me to sort out my program issue. After sending data to google some time maybe 6hour or 1day after the loop is hanging sending data to Google.I have to reset the board to get it working again. What can i do to solve this issue?

[@lolzers2154]

Hi, if i subsequently disconnect it from the computer and use a powerbank as the power source, will it still run and transmit data to google sheets? sorry i am still very new to this

[@febou212]

When I test the URL is working well. When I run the program in HiLetGo card + ESP8266, Im able to connect on internet and to see the temp and hum. 19:08:50.698 -> requesting URL: /macros/s/AK***********************************************************4/exec?temperature=23.80&humidity=28 19:08:50.732 -> request sent 19:08:51.275 -> headers received 19:08:51.275 -> esp8266/Arduino CI has failed 19:08:51.275 -> reply was : 2bd 19:08:51.275 -> closing connection 19:08:51.275 -> ========== But, my google sheet still empty. Can you help me ?

[@mehdisajjadi1679]

thank you very much , it worked great , i changed the sensor to DS18b20 easily , and it works great , now i am going to make 2 sensors for it , tnx again

[@utehstr]

You're welcome 🙂 Good job 👍

[@davidhvs99]

Every time I try to run the url with the info, it says that no page was found or that it can open the document. Can someone help me?

[@ArjunKohli]

i tried till before adding digital verify , it is working , getting value on google excel sheet, i am not able to get finger print value so i am trying to till here

[@Burgyste]

Nice job, apart from ""Arduino CI has Failed" and no Data in der Sheet,what is wrong and how to resolve it?

[@srujanainampudi8026]

Will it uploads data into Google sheet by connecting NodeMcu to a battery instead of connecting it to system

[@sandeshkale297]

Yes

[@yabatzy]

Mine says "ReferenceError: stripQuotes is not defined (line 26, file "Code")". What went wrong?

[@dhruvangpatel9116]

esp8266/Arduino CI has failed

[@sagnikmitra5960]

@Uteh Str Following the code, I am not able to get the data in google spreadsheet. Can you help out?

[@zhafyy]

thanks for the tutotial sir. may i know what is wrong when i cannot connect to the host?

[@ytugihjok]

no

[@prffalcao]

the serial monitor displays the right temperature and humidity, but there is a message: "esp8266/arduino CI has failed replay was: 252 closing conection" and no data is print in the spreadsheet. I noticed that almost the same message is in you tuturial, except for the replay that is 22d. Could you help me?

[@YPTechDATIA]

same is here , i think the problem is with new google security policies

[@hayder.ismael]

Great project, Thank you very much. How can I change the time as per my area? I am in the UK. please.

[@utehstr]

var Curr_Time = Utilities.formatDate(Curr_Date, "Asia/Jakarta", 'HH:mm:ss'); Change "Asia/Jakarta" with your time zone. List of time zones see here : en.wikipedia.org/wiki/List_of_tz_database_time_zones

[@ibrahimcankarnibuyuk4854]

CAN WE TRACK MORE THAN ONE DEVICE IN THIS WAY. 3 DEVICES

[@abhishekjoshi3004]

sir i m getting the data into my google sheets but the problem is i m not getting the data of the parameters in one row like first parameter data prints in first row but the 2nd parameter data is printed in the next row next column... All the parameter values are not comming on a single row plz help

[@mrisp9158]

hallo selamat malam, mohon maaf untuk tutorial esp8266 + rfid rc522 via google sheet apakah ada tutorialnya? trima ksihh

[@FadlyMaskom]

Hi, i ran into a problem, the data didn't get into google sheet. I have a serial parser running in esp8266, it connected with google sheet but nothing was received, what could i have missed? I made a serial monitor output of the GET request and copied it to browser and sent it manually and worked, but not with the esp8266 itself. Appreciate your reply, thanks.

[@20ansel]

Did u find a solution to this? Ive been facing the same problem

[@Ziqastory]

Terbaik. Boleh ke kalau nak diplay data for every second?

[@newplan1591]

esp8266/Arduino CI has failed this massage show and no data logging in sheet.plese help me sir

[@JITENDRAMATTOLIA]

SIR, FINALLY THIS ERROR OCCURRED (reply was : HTTP/1.1 302 Moved Temporarily), ALTHOUGH MANUALY COPY PASTE OF URL IN CHROME IS WORKING WELL AND STORING DATA IN SHEET. NOW WHAT TO DO??

[@turkialqahtani5341]

I used this method but I’m getting failed to connect prints on my monitor what does that mean? Am I not connected to internet or is issue connecting to google sheets address?

[@arunhiremath3786]

Hi its nice project... Can same thing can be done on normal excel sheet?

[@utehstr]

Thank you :-) As far as I know this method cannot be done on a normal excel sheet, if you want to use a normal excel sheet you can use a third party application, namely PLX-DAQ, the video can be seen here: kzbin.info/www/bejne/mIK0qaCXq8iqbM0

[@lunsfordppg8395]

Does this still work or does the new Google API make this obsolete? If so, I seem to be having trouble downloading the code from the link. I am trying to get an ESP32 to send data to Google Sheets.

[@bibekganesh8255]

What does it mean " esp8266/arduino CI has failed"? Well it worked. I got values in Googlesheet. Thank you sir

[@karanshethia3560]

Hey! How did it work? I am getting the same error as you. Thank you

[@ammarfahim3100]

Can you elaborate how you got it to work?

[@kumarraunak3884]

Hi!! First to thank you. It was very nicely explained. I executed it and it's working fine . I have one query if you take out sometime to help it will be great help to me. I want to update data from 2 dht11 sensor in same spreadsheet but on two different sheet. What changes do I have to make in the code. Thanks i advance. And please keep doing the good work 👍

[@sukasuka402]

brother, may I request to measure wind speed and direction using a hall effect sensor with a method like this🙏🏻

[@utehstr]

Currently I'm working on other projects, maybe I'll make it later :-)

[@sukasuka402]

@@utehstr oke thank you bro, because i do that projet too but , i have error in my program and it make me confius and little stess thinking about it.. i have to finish my work in the right time.. i hope i can finish that😭

[@crearelectronica]

Hello. Could you help me with a project?

[@arifahramadhani8269]

how about EPS32 ? can i use the same code but different library?

[@utehstr]

I don't know for sure, I haven't tried it using esp32.

[@sangyoonlee777]

Thanks for your video. How can I change the Time Zone? I live in seoul and I changed to "Asia/Seoul" but it didn't work

[@sangyoonlee777]

@phuong mai Thank you so much

[@Kelebihanmod]

connection failed terus munculnya, ada masalah dimana yak , klo di serial monitor temperature dan humidity dah kebaca, hanya gak mau connect ke google script, Terima kasih atas bantuannya

[@ishankadam2084]

why does it show connection failed while connecting to script

[@vitordias3600]

Try change a sharing privacity of your plan, its work for me :) Change for "anyone with this link" and change for editor

[@lucasdifaria1]

I have a problem. The publication occurs only once, that is, only one line, the next time the error occurs 10:14:52.083 -> esp8266/Arduino CI has failed 10:14:52.130 -> reply was : Any suggestions what it could be?

[@20ansel]

Did u find a solution to this? Ive been facing the same problem

[@xiang764]

did you find a solution? Same problem here

[@roadsandtransportation2517]

How to send google sheet data to nodemcu

[@นฤดมธาระ-ง8ข]

I want to collect dust on Google Sheets. Do you have any guidelines to tell me?

[@utehstr]

Look for how to access the sensor you are using, if it is successful then follow the instructions as in the video, you only need to replace the dht11 sensor value in this video with the sensor value you are using.

[@exclusiveyazdesign3079]

Nice project thanks but why it gives me a wrong time ?!

[@utehstr]

Thank you :-) Have you adjusted the utc to your area's utc?

[@exclusiveyazdesign3079]

Uteh Str No sir, I will try to adjusted them thanks

[@hamzarauf320]

Thank you soo much dear for such a great content , every thing is working properly, time is more then 2 hours as compare to my country.... can you guide me how to fix this issue ?

[@karanshethia3560]

Hello. Just change the timeline in the google script code according to your location. In my case it was Asia/Kolkata instead of Asia/Jakarta. It works fine after that

[@karanshethia3560]

Also , since you mentioned that your project is working fine , could you help me out? In my case the temperature and humidity is displayed on the serial monitor but the sheet isn't updated. Thanks

[@3BoxCreation]

Thank You For This Video.. Its Great♥️♥️♥️ Your Google drive link is Notworking. please check it

[@utehstr]

You're welcome. I've checked the google drive link to download the code and the link is fine.

[@tribandrio598]

Pak mau tanya, punya saya datanya gak masuk ke Spreadsheet nya. Saya tes URL nya muncul Tulisan Exception: Argumen tidak valid: id (baris 11, file "Kode"), itu kenapa yaa Pak? Saya ikutin smw step2 yang ada di video

[@juanfernandez4521]

Google bloquea el acceso, incluso después de dar permisos, tiene que autorizar desde el teléfono si le llego la advertencia, pero tambien le llego un correo electrónico para que autorice el acceso. después de autorizar le funcionara.

[@mr.techinventor3463]

I want to send this kind of string and separate at sheet cell "5678964-40-50" how to do please help

[@wagnergabriel8728]

obrigado, sensacional este software, funcionou na primeira tentativa. Brazil

[@harrisonmendoza3099]

cambiaste la zona horaria ? yo he estado mirando y no se como

[@dogukanbicer4228]

How can we arrange the time to suit our own country?

[@utehstr]

Look at this line of code: var Curr_Time = Utilities.formatDate (Curr_Date, "Asia/Jakarta", 'HH: mm: ss'); In the google sheet code. Change "Asia/Jakarta" to be your city or your country. See here the list: en.wikipedia.org/wiki/List_of_tz_database_time_zones

[@ManrichArts]

Nice video. Please how can I add more columns. In a case where I need to read up to 8 values.

[@mariamelsotohy7110]

I tried changing Asia/Jakarta to my country, but it doesn’t work at all

[@marinatorossian542]

Hi! This was really helpful. But I got stuck in the middle of it. Once I try the values in the notepad and put it in the browser an error pops up. It says: Exception: Argument not válid: id (line 9, file"Códe"). Can someone help me?

[@juanfernandez4521]

Google bloquea el acceso, incluso después de dar permisos, tiene que autorizar desde el teléfono si le llego la advertencia, pero también le llego un correo electrónico para que autorice el acceso. después de autorizar le funcionara

[@juanfernandez4521]

recuerde que cada modificación que realice en el SCRIPT, tiene que darle en (Project version->NEW)

[@thatiotguy8837]

Please, Be neat in writing the code and comments!!

[@ปลายฟ้าสงวนพรหม]

I want 2 temperatures out for spreadsheets ,but I can't. Plese help me.

[@ปลายฟ้าสงวนพรหม]

T_T

[@juanfernandez4521]

case 'temperature': rowData[2] = value; // Temperature in column C result = 'Temperature Written on column C'; break; case 'temperature2': rowData[3] = value; // temperature2 in column D result += ' ,Temperature Written on column D'; break; ?temperature=20&temperature2=30

[@YPTechDATIA]

all is good but "Arduino CI has Failed"

[@vicenterubiojuan3933]

When I try to download the code from the drive it says something is damaged, how can I solve that?

[@utehstr]

I save the file on Google Drive in the format .rar, as long as I currently do not have a viewer for the file .rar . So just download the file. The code file is saved in the .rar file format. I created a .rar file using Winrar V5.50, so to extract it, make sure you use the same version of Winrar that I use or the latest version or use the winrar extractor online.

[@MrVicenteRJ]

@@utehstr thank you very much!! Very nice video and assistance, much apreciated!

[@utehstr]

@@MrVicenteRJ You're welcome :-)

[@attariazeddine6603]

Excellent sujet...Bravo ....

[@cristobalgarcia7391]

Thank you very much for sharing your project

[@utehstr]

You're welcome :-)

[@dananjayaendipratama8557]

when I sent data from esp8266 to googlespreadshet 6 months ago the process went well. but now after the google script apperance changed, the data sent by esp8266 could not be displayed on googlespreadshet. do you know the solution of this problem ? are there any different step ?

[@utehstr]

Does your project use the code from this video ?

[@dananjayaendipratama8557]

@@utehstr yes i do. I use the code from this video

[@utehstr]

@@dananjayaendipratama8557 How many times have you changed the google script? Is the first time since you change the google script and then the data is not appearing?

[@dananjayaendipratama8557]

@@utehstr yes it is the first time since i change the google script. Have you ever deploy your code with new apperance of google script ?

[@utehstr]

@@dananjayaendipratama8557 Look at the video description, I've added a video link about how to use the Google Script Editor with the new apperance .

[@mujahidalfattaah5957]

Gan bisa gak ngambil data dr g sheet??

[@mohammedlahmadi122]

Is it working with Arduino WiFi MKR 1010

[@utehstr]

I don't know for sure, I've never tried this project with Arduino WiFi MKR 1010.

[@suotechannel4067]

Sir, after i replace the humidity sensor with temperature sensor DS18B20, it start cant sending the data to google sheet already If I copy the URL and type it manually, it will work, but if run the system it show esp8266/arduino CI has failed, replay was:204 can someone help me..? thanks a lot

[@20ansel]

Did u find a solution to this? Ive been facing the same problem

[@suotechannel4067]

​@@20ansel yea i solve, my prob is solved when i publish the system the part of "who has access to the app", choose the anyone, even anonymous. then it can work already

[@giuliocomerci3277]

Hello! Can I contact you privately?

[@utehstr]

Hello I have replied to your email message.

[@MrIn-qv3ko]

unsupported parameter, kenapa ya

[@squidym1119]

Is it also work on ESP32?

[@utehstr]

I don't know for sure, I haven't tried it using esp32.

[@arypees2465]

Ada maksimal pengiriman jumlah data nggak sih? Misal saya mau ngirim 7 data sensor. Bisa ga ya?

[@utehstr]

Saya memang belum pernah mengirimkan data sebanyak itu (7 data sensor), tapi sepertinya itu masih bisa. Silahkan dicoba 🙂.

[@arypees2465]

@@utehstr sudah tak coba. Bisa Pak/Bu, terimakasih banyak

[@utehstr]

@@arypees2465 👍🙂

[@rezaarinda9673]

@@arypees2465 bagian yang diubah yang mana ya mas agar bisa 7 data? saya coba cuma bisa hingga 3 data. ketika jumlah parameter nya dinaikkin, error dia.

[@arypees2465]

@pokemon geming apakah masih membutuhkan email? Maaf baru terbaca

[@risyawal2004]

How to get code in nodepad++ ?

[@utehstr]

The link to download the code is provided in the video description.

[@lamegastv]

Mantab mas,,, keren,,, akan saya coba ikuti langkah demi langkah,,,

[@utehstr]

Terima kasih :-) Semoga berhasil ya...

[@quiqueol5438]

Thank you very much it served me

[@utehstr]

You're welcome :-)

[@leninht60]

Damn! I want to do this with Micropython

[@yogeshitaliya473]

Nice one

[@utehstr]

Thank you :-)

[@harizhaikal7166]

Alhamdulilah. terima kasih sir!

[@utehstr]

Sama-sama :-)

[@renanpereira2891]

How are you? TypeError: Cannot read property 'parameter' of undefined. Help me?

[@andersschierup1009]

I got the same TypeError. Simply ignore that message, deploy the web app and move on to the URL part at 7:07. It worked for me. What I think is happening is that the doGet part is looking for inputs to the sheet which is coming from the URL. Since nothing is parsed to the sheet, when you run the script, this doGet returns nothing and triggers the error.

[@ghozallimashan1155]

Keren...

[@utehstr]

Terima kasih :-)

[@ELEKHOB]

Nice of project....

[@utehstr]

Thank you :-)

[@ELEKHOB]

I have try it and work.. Thanks for detail explanation...

[@utehstr]

@@ELEKHOB Good job 👍 You're welcome 🙂

[@karthickd5312]

Thank you so much .........!

[@teohsoonyenstudent7722]

Hi, may i know is it possible I send the data to thingspeak and google spreadsheet in a same time

[@justlutfi2890]

yes of course, but you need to make back end service for that. in the backend service, you may sent data to multiple endpoint api

[@justlutfi2890]

to using multiple endpoint in nodemcu, you should use array function

[@djokopudyanto1979]

Mantap Pak..

[@utehstr]

Terima kasih :-)

[@gabrielsadasilveira5580]

Thank you!

[@Horitanluvv]

Thank you🌹💟💟

[@utehstr]

You're welcome 😊

[@МихаилПестов-к5т]

Спасибо ! всё сработало

[@utehstr]

👍🙂

[@haloisan]

thanks, it's work

[@utehstr]

You're welcome 🙂

[@rohantestnumber9462]

Your video is amazing. I have a question for you. If I want to add values to the sheet. How should I modify it? By testing from this code script.google.com/macros/s/AKfycbyLaQ7jVQbtmq8PS-iJ1ReKFjA_QWAHCG_hekv3_tBqbN5fzrqt/exec?temperature=100&humidity=20&rain=30&smoke=30&voltage=40 thank.

[@MrSEDERIK]

+++++ !

[@obebharoigoni7449]

Pls. how did you setup your router? Can a pc be used as a router to achieve same result?

[@sukasuka402]

sir, may I request to measure wind speed and direction using a hall effect sensor with a method like this🙏🏻

[@sabinadhikari2643]

I used the code but It dioesnot write the data in the google sheets

[@caturwardana7335]

same issue

[@sabinadhikari2643]

@@caturwardana7335 I have figured out the problem. If you want the working code I can send you the link

[@hitenlulla2713]

@@sabinadhikari2643 What is the solution?

[@caturwardana7335]

@@sabinadhikari2643 looks good, can i have your link or contact please?

[@victorbanulsramirez5862]

@@caturwardana7335 same issue