Arduino: Log sensor data in the cloud

Tutorial about logging data in google spreadsheet. With an wemos arduino and help from javascript.

big thanks to Trieu Le:

[IFaTaLiTyl]

Note: The location where you can open the Script Editor has changed.
Previously it was at "Tools -> Script Editor" as shown in the video (2:01).
Now it is located at "Extensions -> Apps Script".

[mrfrogtoyou]

Awesome. Thankyou for your efforts and clean explanation.

[FelixTechnix]

Adding client.setInsecure(); at the beginning of the void sendData(int tem, int hum){ } solved my problem with not connecting to google ;)

[fkon]

I struggled to get the javascript working until I disabled the new Chrome V8 execution under the "Run" menu but now it works. Probably some parts of the script that would need to be adjusted for compatibility with the new execution.

[stepic_]

where did you find last version of the library aware of the command setInsecure()?

[IDC]

I love the detail. However, I am missing something. I only get a failed connection to my spreadsheet in spite of the fact the tests from the javascript work perfectly. While I appreciate the free info, can you offer any followup to what appears to be a rampant misconfiguration?

[Burgyste]

Respect, great work, "client.setInsecure(); "had to be added in setup (to get it the programm to run ) after that data is being send, the reply text in serieller Monitor = Headers received, esp8266/Arduino CI has failed, reply was 250, what am I doing wrong & how can I correct it?.

[kushagraasthana]

Thank you so much, I had tried so many solutions and yours worked. Thank you!!

[devyanisarode]

What if my arduino is connected to this computer on which excel is generated via wifi? And not physically through any serial communication?

[idgearmarine]

One of the best and clearest explanations of this. Very good job on the video! Thanks so much.

[yhansilva]

Awesome, this explanation was simple and clean. Thanks a lot ;)

[marnixyoutube]

Hoi Hoi, klopt het dat je ook meerdere arduinos kan koppelen vanaf verschillende locaties en netwerken? Of is het alleen mogelijk om meerder arduinos te koppelen binnen het zelfde wifi netwerk?

[tomsblumbergs]

Great tutorial but i get "esp8266/Arduino CI has failed".
Could someone help?

[rakeshsancheti]

Hi, I'm getting Script.google.com connection error, can you help clarify this

[paulatownsend]

Hey, Good tutorial But .... I have a connection failure with google sheets. The serial monitor shows a wifi connection and IP address along with TEMP and HUM values. The script for the sheet works as you showed and I can add in Temp and Hum values on the URL which then shows in the spreadsheet - It's just the connection between the nodemcu linked to a mac (firewall turned off) and the google sheet. Any advice ?

[koenkoen]

Hey, thanks voor je duidelijk video. Wanneer ik dit doe werkt alles perfect, alleen genereerd hij niet de juiste data. Hij geeft elke keer deze output in het arduino_data bestand: datum - 2147483647 - 2147483647. Heb jij enig idee wat ik verkeerd doe?

[mrkk]

i am getting error in output as :
Temp = 46 HUM= 24
connecting to script.google.com
connection failed

[tijs]

Hallo Bas,
Kan ik ook een mail naar uw sturen? ik heb namelijk een vraag over bluetooth en helaas kan ik via YouTube geen foto's sturen om het duidelijk uit te leggen.
Graag hoor ik van u.
Met vriendelijke groet,
Tijs

[edwardd]

Hello, many thanks for your insight.
I'm trying to use this application with Arduino uno+ LOLIN D1 R2 Mini Board. i am using my mobile hotspot connects to the internet but it keeps telling me "connection failed" meaning it doesn't connect to script.google.com.


Can look at my Arduino code and see if you help me, please.

[dave-in-nj]

thanks. hard to say how much this this helped