Arduino: Log sensor data in the cloud
ฝัง
- เผยแพร่เมื่อ 23 ก.พ. 2018
- Tutorial about logging data in google spreadsheet. With an wemos arduino and help from javascript.
big thanks to Trieu Le:
lethanhtrieu.likesyou.org/2017...
link to arduino sketch: create.arduino.cc/editor/LogM...
Link to JavaScript: create.arduino.cc/editor/LogM... - วิทยาศาสตร์และเทคโนโลยี
![คบซ้อน - วงL.กฮ. [ Official MV ]](http://i.ytimg.com/vi/5MtesqJ0I1c/mqdefault.jpg)
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".
Awesome, this explanation was simple and clean. Thanks a lot ;)
Thank you so much, I had tried so many solutions and yours worked. Thank you!!
Awesome. Thankyou for your efforts and clean explanation.
mrfrogtoyou yeah!
Excelente.
Saludos desde El Salvador.
thanks. hard to say how much this this helped
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.
Very helpful video and example code, thank you!
Legend!! Well played
Amazing channel! Subscribed :DD
a tip : you can watch movies on Flixzone. Been using it for watching a lot of movies recently.
@Rudy Jacoby definitely, I've been watching on Flixzone} for years myself :)
where did you find last version of the library aware of the command setInsecure()?
One of the best and clearest explanations of this. Very good job on the video! Thanks so much.
Very helpful. Thank you very much
Really interesting - thanks. I had no idea you could use scripts with Google Drive documents
great work dude thanks
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?
Nice work!
great tutorial. thanks!
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.
Great tutorial but i get "esp8266/Arduino CI has failed".
Could someone help?
Hi friend
Query, what should I do to upload a 3 column data log? I'm from Chile
hello it was very helpful for me but i have a question i dont use dht11 and i just want ıse simple sensor. void send data line has many string command how can i change the code for my simple sensor.
Is it possible for me to replace the ESP 8266 library with others Wifi Sheild
Cool!! Thank you.
how to increase the printing of values on the spread sheet because i want large data to be printed on sheet in less time
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 ?
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?
it will be usefull to filter those reading errors on js side
Nice video. first of all, I want to say thanks for preparing this video. it's really clear. However, I was wondering if you could help me to figure out how I add more data to the excel.
Hallo Bas,
Kan ik ook een mail naar uw sturen? ik heb namelijk een vraag over bluetooth en helaas kan ik via TH-cam geen foto's sturen om het duidelijk uit te leggen.
Graag hoor ik van u.
Met vriendelijke groet,
Tijs
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?.
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?
Nee ik zou niet weten waar dat getal vandaan komt. Geeft de arduino in de serial monitor wel de juiste temperatuur waardes door?
Thanks so much for sharing this. Can you please share your Libraries
sorry i dont understand if i have to upload this code on arduino board or esp8266 board ?
Thank you for the video. I tried it and getting a certificate error.
connecting to script.google.com
certificate doesn't match
I was able to get this to work for me. I do not fully understand the way to make scrips. do you know if there is a way to take two values, say temperature1 and temperature2 and then write a value in column 4 to be the difference between temperature1 and temperature2 ?
the script is in the javascript language. There are lots of tutorials all over the internet. personaly I love the "thenewboston" changel here on TH-cam
Nice tutorial thanks! however it works for a few lines (at most 6) and then stops writing. I have put a periodicity of 10s and in reality it gives something more like a 30s to a minute. The recorded data are integers and not floats as it should be. Due to these issues I think I will favor a more uptodate method.
Bro I think u are blind u can change it in the Arduino code lol.
Im try many time but i cant do this?????
Adding client.setInsecure(); at the beginning of the void sendData(int tem, int hum){ } solved my problem with not connecting to google ;)
Did u get 401 error? I cant connect to the https
Can you give your code here, i hve same problem
Solved mine too, thanks.
Getting error when trying to use this function
Distance_4:107:8: error: 'class axTLS::WiFiClientSecure' has no member named 'setInsecure'
client.setInsecure();
exit status 1
'class axTLS::WiFiClientSecure' has no member named 'setInsecure'
@@vishalalex I had the same problem when compiling
did you solve it?
Hello, many thanks for your tuto.
I'm trying to use this application with arduino uno+ etherne shield. and I can't find the equivalent of client.verify(...).
Can you help me please.
Were you able to find an equivalent?
thanks dude
client.setInsecure(); the code will work well after adding client.setInsecure(); at the void setup
Where you adding Vat Sun ? I have same issue, Thanks
I have followed exaclty but my esp8266 will not connect. The script works. I have copied the script ID
how to sending attendance data from Arduino to sheet docs with SIM999
Good Way but how many bytes can this file save?
What if my arduino is connected to this computer on which excel is generated via wifi? And not physically through any serial communication?
Thank you so much for this video.
Where can I find a discription of the replay code (Serial Monitor)?
reply was:
==========
238
==========
ReferenceError: "setup" is not defined. (line 47, file "Code", project "Ardunio data set") How to remove this error.
the code you gave is failing at client.connect(host, httpsPort) line,, its returning me 0, and printing "Connection failed"
me too, do you solve that problem? dude
@@haoranchen5629 no idea
Hi, I'm getting Script.google.com connection error, can you help clarify this
Can this work with mkr1000
the tutorial is really very precise and to the point but responding to the comments is also appreciated. i followed you tut but there their is an error of connection failure ... any idea why
Install version 2.4.2 of the esp8266 on the board manager
@@Spavocado share link
nice............super.............awesomeeeeeeeeeeeee
what to do if I want to send more than 2 values, I'm asking this bcoz I tried improving the code and it didn't work!
i have same issue
which is this is it esp32?
connection failed
error
its not updating
Super, but need Adafruit...h
can you please provide circuit diagram
can you please provide the circuit connection for the above code
Go to the arduino board manager, search for esp8266 and install version 2.4.2.
Is it possible to send real time data on one cell update contioneously if possible then how? Plz help
Yes, you can use firebase like I do. Or if you don't have programming experience use Blynk.
Could you help me with Google firebase program ?
Orange Juice Covers could you help me with the firebase program . Email Id : njohn1033@gmail.com
i am getting error in output as :
Temp = 46 HUM= 24
connecting to script.google.com
connection failed
same error i am also getting
Go to the arduino board manager, search for esp8266 and install version 2.4.2.
@@RAM-xr5ve Go to the arduino board manager, search for esp8266 and install version 2.4.2.
Go to the arduino board manager, search for esp8266 and install version 2.4.2.
@@tomscietvirs2379
last version is 2.7.1 and dont work , say connection failed, please help me
Please can you send the libraries
hi, I searched for such a tutorial for a very long time and I was super happy finding this one.
All of the code works, but when it enters the loop where it tries to connect to google drive it keeps failing. It would be great if someone has an idea what could be wrong here :)
Thanks for the video like and subscribe.
convert the google drive link as sharable
will this work with arduino UNO, without esp8266 (I'm connecting arduino to pc directly)???
No in your case save the output in a CSV file. And look for a python script whats send it to the cloud
Hello!!! Awesome tutorial but, it is not working, during the test to load values direct on navigator, I receive the following error: >>> ReferenceError: "setup" is not defined. (line 67, file "Code", project "arduino_data")
boa tarde, linha 67 ? vc tá usando o codigo Java ? a Macro não tem toda essa quantidade de linhas..
erase void loop and vois setup
I got the same error, do you fix it? How?
Hey my esp-01 chip is able to connect to Wifi but it shows connection failed for the google script. I am trying to upload random values(not from DHT11).
Serial Monitor shows -
........
WiFi connected
IP address:
Temp = 11.00 HUM= 4.00
connecting to script.google.com
connection failed
Temp = 18.00 HUM= 2.00
connecting to script.google.com
connection failed
Temp = 17.00 HUM= 5.00
connecting to script.google.com
connection failed
Temp = 16.00 HUM= 9.00
connecting to script.google.com
connection failed
#logMaker360 Please help-
I have the same problem... any idea to solve it? thanks
@@Mohamm-ed Install version 2.4.2 of the esp8266 on the board manager
@@Spavocado thanks very much for helping
I keep getting this error message:
Document 1ATcUwy3hg18lMbKtZDswrmN8wX2TIWh0rc4SocpGFIg32AZBEmwEokxv is missing (perhaps it was deleted, or you don't have read access?)
Even though I have made my spreadsheet fully public and editable. And the doc ID it gives is not the same as my spreadsheet. Anybody else have this problem?
Is there any need of physical device Arduino?
Not if your data source comes from else where
@@logmaker3609 sir I have a doubt. we are using our own database means Google drive. Can we use another database in aws services like (dyanamodb or RDS) ?
It's not work it shows "connection failed
".
Please give me solution how to solve it.
Go to the arduino board manager, search for esp8266 and install version 2.4.2.
Thank you so much! Are you Vietnamese?
Hi, plz suggest me because it is showing me connection to script. Google.Com failed
Me too...
me too. have you solve it??
Sadly not
@@Mohamm-ed Go to the arduino board manager, search for esp8266 and install version 2.4.2.
@@jakobkatrasnik8684 Go to the arduino board manager, search for esp8266 and install version 2.4.2.
Hi,
i am using an Arduino Nano with a wifi shield ESP-07 to send data to google sheets with the presented scripts, with some modifications.
I am not able to get this working to make this job to send data to google sheets.
Does anybody have some experience, should it be feasible with a slightly modified script?
I have tried, and i get it running by commenting out the ESP8266Wifi lib and WiFiClientSecure.h, because it is not found.
I used WiFiEsp.h instead. The shield did connect to google, but with the CI has failed error message, probably as it was a not secure connection. Message from serial monitor:
connecting to script.google.com
[WiFiEsp] Connecting to script.google.com
requesting URL: /macros/s/xxxxx....modified here for privacy ....rdy7HqmxBF8fmnD4IpVmLHsn68nFSX0vhv/exec?temperature=21&humidity=85
request sent
esp8266/Arduino CI has failed
reply was:
==========
==========
closing connection
I am fighting since severly days to get it done.
I would appreciate, if anybody has some suggestions/help?
connection failed
Doesn´t work, connection failed!
Install version 2.4.2 of the esp8266 on the board manager
Hi, I am having trouble using the code on an Arduino UNO WiFi Rev 2, can anyone help me?
What is the problem?
@@logmaker3609 I'm not sure exctly, but I had to change libraries as the uno wifi uses WiFiNINA, and although there are no errors and the serial prints 'connected' nothing is written in the google sheet
@@armandcerisier1564 if you can't discripe your problem in a clear way than I can't help you
Sorry about that, I have found the solution! Thanks for your answers!
is this ture