Arduino | Send Data to Google Sheets with LoLin NodeMCU ESP8266 V3 and Pushingbox API
ฝัง
- เผยแพร่เมื่อ 26 เม.ย. 2019
- Arduino | Send Data to Google Sheets with LoLin NodeMCU ESP8266 V3 and Pushingbox API (NodeMCU ESP8266 Cloud Data Logging). In this project video i use LoLin NodeMCU V3 ESP8266, Notepad++ v7.5.9 and Arduino IDE 1.8.9.
Download Code here : drive.google.com/open?id=110h...
For LoLin NodeMCU V3 ESP8266 Getting Started (add boards and libraries NodeMCU ESP8266) / Beginner user LoLin NodeMCU ESP8266 V3 : • Arduino | LoLin NodeMC...
To send data to Google Sheets without Pushingbox API (Without a Third Party) see here: • NodeMCU ESP8266 + Goog...
***********************************************
Thanks for watching & don't forget to like, comment and Subscribe...
***********************************************
For other video tutorials on this channel, please see this playlist:
- Basic4Android (B4A) Tutorials : • Basic4Android (B4A) | ...
- Electronics Tutorials : • 3 LED Flip Flop
- Arduino Tutorials : • Arduino | Scrolling Te...
- Great Cow Basic Tutorials : • Great Cow BASIC with A...
- Bascom Avr Tutorials : • Bascom Avr | How to Se...
- VB .NET Tutorials : • Visual Basic .NET | ...
***********************************************
Download Arduino IDE : www.arduino.cc/en/Main/Software
***********************************************
Pushingbox Home : www.pushingbox.com/index.php
***********************************************
Source of network topology images:
www.iconfinder.com/icons/4736...
icons8.com/icons/set/google-s...
***********************************************
Music Background :
Song: Ikson - Do It (Vlog No Copyright Music)
Music promoted by Vlog No Copyright Music.
Video Link: • Video
Song: Nekzlo - Moments (Vlog No Copyright Music)
Music promoted by Vlog No Copyright Music.
Video Link: • Nekzlo - Moments (Vlog...
Song: Ikson - Harmony (Vlog No Copyright Music)
Music promoted by Vlog No Copyright Music.
Video Link: • Ikson - Harmony (Vlog ...
Ikson - Harmony (Official) : • #57 Harmony (Official)
*********************************************** - วิทยาศาสตร์และเทคโนโลยี
Oh my god... This is really and perfectly what I want to do. Thank you so much.
You're welcome :-)
Great job! Thank you very much👍👍
You're welcome :-)
It’s possible to adjust script so if any value is existing,for example a row have the same data, to now write. So no duplicates of data?
It is working .You are great thank you.
You are welcome :-)
Me funciono Gracias
👍🙂
I searched for weeks to find a way to send data from a NodeMCU to Google Sheets. Errors with other ways, but yours worked perfectly, so THANKYOU!
Regularly the program hangs and I tracked it down to the code stopping at the "return" if it takes longer than 4000ms to send the string to the server. Is there a reason for 4000 or could I change it to 10000 if for what ever reason my system/internet is needing longer?
What a legend
How long this data can keep in ggsheet? thank you
How many months can i use this is there a limit?
Nice job, you are a good boy :))))))))))))))))))))))
Thank you :-)
Good job :-)
Thank you :-)
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
sir, may I request to measure wind speed and direction using a hall effect sensor with a method like this🙏🏻
Thank you
You're welcome :-)
At ~6:27 a test is made, the repy I get is "Script function not found: doGet" and the 2nd test at ~10:30 I receive no reply,how do I fix these problems?
I guess it's possible to create nice interface with buttons etc in google sheet, connect data with MySQl and use it to send data back to NodeMCU ...
in the image at 0:16 you mention the equipment used: "arduino + NodeMCU". It looks like the arduino equipment was present, when in fact it was just misspelled in your image (Peoples need tutorial Arduino + Esp8266 At commands)
In the picture at 00:16 I mention "Arduino + NodeMCU ESP8266". It might be wrong if I only mention "Arduino", maybe I should mention "Arduino IDE".
I mentioned NodeMCU ESP8266 to be more specific (actually more detail is LoLin NodeMCU ESP8266 V3), so viewers know that this is the board I'm using in this video.
NodeMCU is an ESP8266 wifi module
keren bang....
Terima kasih :-)
Super. Thank you. Is it feasible to create button object in google sheet and send value from it back to NodeMCU?
If you want to send data to Google Sheets without a third party, see here: th-cam.com/video/okNECYf2xlY/w-d-xo.html
To send data from Google Sheets to NodeMCU I've never tried it, I'm currently studying it too.
Bang, kalo tanpa LDR light sensor gimana? Soalnya aku cuma ada pushbutton aja
when i try to send data it says cannot connect to the site
probably a thing saying can't establish a secure connection, what to do?
also please provide with the code for nodemcu you used above
I made this tutorial about a year ago, maybe some things have changed, I will check it.
The link to download the code is available on the video description.
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.
is there any tutorial from you that are not using pushing box service ? because pushingbox have limitation of 1000 request
Until now I have not found another way that works well, so I chose to use Pushingbox. But I will still continue to search and try to find the best way. If it's found I will make the video.
@@utehstr i have conduct some research that only using google script . But whenever i try to attempt the code, it never work.i so sad about that.
@@TheDarkforce95 Do not give up. Keep trying. You can also ask about this in the Arduino forum.
Great !! But I had some question .How many sent data limit ?
Thank you :-)
Limits on Google Sheets or PushingBox ?
@@utehstr THE PUSHINGBOX HAVE LIMIT RIGHT ?
PER DAY 100 SIGNAL SENDING
How to change time setting in script
I cannot download the code. it is in a google drive .
can you put a copy into txt file and not an rar file ?
maybe put it on the Arduino forum and post a link ?
I checked and it can be downloaded. 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.
Use 7-Zip.
hello there,
Its working. Thank you for that but i got one problem that once i close the google sheet and reopened it stops receiving Data until then it was fine. Can you help me out?
Hi...
You're welcome :-)
What do you mean by "close the google sheet" ? Sign out or close Google Sheet from your browser tab or others ?
@@utehstr close from the tab.. i think my sensor has sent 102 results to google sheet after that i close it from tab and again opened it but at that time it didn't received any data.. nodemcu is sending data successfully but didn't received at Google sheet
@@utehstr and i also have one more question.. have you send excel file to mail using nodemcu?
I have one excel file in pendrive and i have to send it to mail using wifi. Is it possible from nodemcu?
@@pinkalpatel7501 At the moment I don't know why that happened because I have never experienced it, but I will check it out when I have free time.
I have never sent an excel file to mail using nodemcu and I think that is technically impossible. But maybe you can find references about it somewhere else.
@@utehstr thanks brother. I will look into that.. thanks again
sir can we use GSM 900 with google drive ?
thank you
it should be used because sim900 is supported by GPRS networks
@@utehstr could you please fine this link and tell what's wrong?
drive.google.com/file/d/1_G0gLGzRvd41zrWCrgV34jSBBSMJ4A-V/view
,😍😍😍😍😍😍
Thank you :-)
Is returning "200 Please Login" as response of the PushingBox API in the arduino console, could be some header missing? I've tried the generated URL with postman (or simply copy pasting in the browser) and is working so the problem is in the nodeMCU request, any idea? Thankss
I have never experienced that, so I don't know what the solution is. Try to rework it and watch the video carefully, maybe you missed something because as you can see in the comments column they managed to do it.
Uteh Str ok thank you, it was a problem with my isp firewall blocking for some strange reason the api call. Anyway why can't we simply make a get request to google docs to insert the data without using pushingbox? Thank you very much
@@gabeame4666 Actually it can be done (without pushingbox), because in the past it can be done, but maybe because Google has done some updates so that way is no longer valid at this time, and until now I have not found the best way to do that without pushingbox.
@@utehstr I will do more experiments on this. Thank you again for your answers
@@gabeame4666 You're welcome :-)
your code is in ur drive not accessible
I checked the link and it can be accessed.
Can this work with esp32
I haven't tried it, but it looks like this code doesn't work with esp32.
Hello i look your video.
i do your script but time is no good because this time of Jakarta .For time of paris, how do it ? Thank you
Look here : joda-time.sourceforge.net/timezones.html
@@utehstr thanks you .
But it doesn't help me much.
My hour cell on google sheet is filled with an hour of gmt + 7 while I am in gmt + 1.
How can I change the script in google sheet to have the "time" column which fills with the time of gmt + 1?
@@mehdibh Sorry I can't be of more help because I'm not that good at this problem. Try asking about this in the Google Docs Editors Community or try searching from other sources.
@@utehstr ok thanks