IoT RFID Attendance System using Google Sheets (NodeMCU IoT Series - Tutorial 10) | हिंदी में
ฝัง
- เผยแพร่เมื่อ 9 พ.ค. 2024
- Welcome to NodeMCU IoT Series. In this Series we are going to discuss every part of NodeMCU Board, it's Programming, What's the role of NodemCU in IoT and How to develop IoT Applications/IoT Projects using NodeMCU.
In this video, we'll learn, How to send data to Google Sheets from NodeMCU ESP8266. We'll also learn about RFID and its interfacing with NodeMCU and at the end, we'll create a Project that will be IoT RFID Attendance System using NodeMCU.
इस वीडियो में हम सीखेंगे, NodeMCU ESP8266 से Google Sheets को डेटा कैसे भेजें। हम RFID और NodeMCU के साथ इसके इंटरफेसिंग के बारे में भी जानेंगे और अंत में हम एक प्रोजेक्ट बनाएंगे जो NodeMCU का उपयोग करके IoT RFID अटेंडेंस सिस्टम होगा।
Video contents:
00:00 Introduction of the Project
01:13 Downloading required files
01:55 Creating Google Sheet
02:41 Writing code for Google Sheet
04:35 Deploying Google Sheet API
05:08 Testing Google Sheet API
06:11 Circuit diagram explanation
07:21 Code for writing data into RFID Card
09:04 Project code explanation
16:01 Project output
🛒 Buy NodeMCU ESP8266: amzn.to/36oHJEA
🛒 Buy MFRC522 RFID Card Module: amzn.to/3rVwJtr
🛒 Buy 5V Buzzer: amzn.to/3G8zVXK
🛒 Buy Basic Electronics Starter Kit: amzn.to/2zb2HdT
👩💻 Code: github.com/himanshus2847/IoT-...
NodeMCU IoT Series:
▶ Previous Video: • Tweet on Twitter by us...
Links of all Previous videos of NodeMCU IoT Series:
▶ Watch Part 01 (Getting started with NodeMCU):
• Getting started with N...
▶ Watch Part 02 (Connect NodeMCU to WiFi):
• How to connect NodeMCU...
▶ Watch Part 03 (Running a Webserver on NodeMCU):
• How to make NodeMCU a ...
▶ Watch Part 04 (NodeMCU Access Point):
• NodeMCU ESP8266 WiFi A...
▶ Watch Part 05 (NodeMCU HTML Webpage):
• Controlling devices fr...
▶ Watch Part 06 (Sending data to ThingSpeak):
• Sending data from Node...
▶ Watch Part 07 (HTTP GET Request using NodeMCU):
• How to send HTTP GET R...
▶ Watch Part 08 (COVID-19 LIVE Data Tracker Project):
• COVID-19 Live Outbreak...
▶ Watch Part 09 (Tweet on Twitter by using HTTP POST Request):
• Tweet on Twitter by us...
✔ Subscribe E&E: bit.ly/2Xn1Ss2
Links for Playlist:
▶ Arduino Series (हिंदी में):
• Arduino Series (हिंदी ...
▶ NodeMCU IoT Series (हिंदी में):
• NodeMCU IoT Series (हि...
----------------------------------------------------------------------------------
For more info about us visit:
(हमारे बारे में अधिक जानकारी के लिए):
Email Id: 2idiotsofengineering@gmail.com
Facebook: engineersNelectronics
Instagram: / engineerselectronics
Twitter: / engnelectronics
Blog: engineersnelectronics.blogspot.in
GitHub: github.com/himanshus2847
Channel: / engineerselectronics
----------------------------------------------------------------------------------
Thank You!
Engineers & Electronics
#NodeMCU #IoTTutorials #NodeMCUIoTSeries #IOTAttendanceSystem #IOTProject - วิทยาศาสตร์และเทคโนโลยี
Please bro be regular
Beacuse I only like your videos on youtube I really like your way of understanding and explaining.
Bhaiya thank you very much for uploading this video after long time. I am very very very eager for your next video.
thank you for extremely detailed information and pointers
Bahat din ke badd 😔.... Arduino series also in pause.. 🙏🙏 resume please sir..
And this is a good project ☺️👍❤️❤️
Bhaiyya aapke videos bohot ache lagte hai aap our bohot sare programs related videos dalo 👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻
Your video came very late, we are very eagerly waiting for your video, thank you for the video, love you from heart
Please upload regular videos
Big fan
Such a simple explanation
Sir, I am one of your subscribers. I want to know how to program a led and IR sensor so that when sensor value remains high then led should be on for 500milliseconds and then off so long as the value of IR becomes low. When the value of IR becomes low then again led should blink as the above mentioned pattern. And this I want to continue infinite times. In other words whenever the value of IR becomes high or low it should be blink for a half second and then it should be off until any change detected
I am waiting for your help sir. And I want to say you that you teach very well. I am a 15 year old boy and I know arduino basics cuz I have seen your every video based on arduino.
But the program like I want is not told by you that's why I asking you.
Please give the full program sir
Good to see you after long Time
thanks ...very well explained ..helped a lot
Best video best iot project ❤️
This is great, Can we do this on ms excel? Also, can we add other columns and details like in or out on the excel?
Bohot jabardst video hai bhai 👍🏻
Bro ak number full sahi hai🤩
Plz start a series on drone with Arduino UNO plz and your all videos are very knowledgeable thanks 🙏👍
Hi
Can I increase the range of this module upto 1meter?
Bonne présentation, merci beaucoup...
He'llo bro itne din Kahan the Bhai ap ? Please upload Regular video I am big fan of you from Singapore
Thanks you so much brother 🥰🥰
Great idea bro🎉
Keep it up bro
Finally After a year
Big fan bro,,,,,,❤️❤️❤️❤️❤️❤️🚶
Thank you bro❤❤
Bro gjb hai 🤘✨
now there is no such as thumbprint or finger print then what should we do now ???? and what fingerprint should we put in code
Will you also please make any video on how to write a rfid card. Pleas also tell which type of rfid card is to be used in this project ?
Bhai is this project related to major project ya minor project
THANK YOU
nice explanation
thank you verry much
i am working on project now i have 1 month left for rfid finger validation code to expire so i want to update after next month what should i do
VERY NICE EXPLAINANTION .., BUT SOME TIME GOOGLE SHEET IS UNABLE TO WRITE DATA FROM OUTSIDE , SO I TRIED IT WITH MY SQL AND IT IS WORKING PERFECTLY
Cam you share how to use it with my sql
@@yadwindersingh9494 I will post a video soon on my channel , please stay tune and subscribe me
Authentication failed for Write: Timeout in communication. I am getting this on serial monitor .Please help me
Sir is project me finger print sensor bi add Karna ho to kia kre us ki programming kese hogi
bhiia hum multiple cards me deta kaise de aur to aur wo fingerprint kaya bar ak k liyea hume badal na hai ? and fingerprint ka part hume samaj nehi aya thoda bata denge pls ?
Nice 👍
v good
Thanks for the video !!
I appreciate your efforts very much as you explained everything in detail.
But could you tell me one thing that I am getting code=400 basically an error of sorts ,so how can I resolve it
yes you have allow everyone in deploy
🆒 Thank you so much for uploading this video.
👍👍👍👍👍
Sharing with community 🇵🇰
Hey can we use ESP32 instead of ESP8266
Super bro
Ethernet base students attendance system with rfid and fingerprint with i2c display
Can we use Arduino Uno instead of node MCU?
Can u give the details of jumper wires please
Sir kya aapp meri thodi help kr skte ho ... Mere project me node mcu esp8266 use kr rhi hu .... Please sir reply mi
Multiple employees k liye program bhi many times krna hoga,,different rfid card me name add krne k liye...
Thank you for this video!!! ☺👍
Can we add one thing that a door lock which unlocks only when any card gets scanned so that we can mount it on main door/cabin's door of office or clg lab to monitor in and out of employee/student/teacher.
If yes then plz tell me how to do that ⁉
Authentication failed for Write: Timeout in communication. I am getting this on serial monitor .Please help me
is it a project for ece students
Sir pls tell me that data updates only one coloum always in sheet
Sir mere pas node MCU ESP32S model hai wo chalega kyais project ke liye
Hello hope you are doing well
how to resolve this error while uploading the code
warning: espcomm_sync failed
error: espcomm_open failed
error: espcomm_open failed
Please make A toutrial on drone pid flight controller using arduino
Wifi Esp8266 and arduino uno ko relay ke sath control krke programming krke home automation ka video banaiye please.... Apke channel pr sb video hai lekin wifi esp8266 pr nhi hai...
Can u add 16*2 lcd with I2C IN THIS PROJECT
Jaise isme hmne google sheet pe data post kiya hai nodmcu ki help se waise hi get method ke liye bhi video bnao k google sheet se google sheet k kisi cell me kya likha hai vo get kaise kr skte hai
I'll facing some problem while connecting ESP01 to Arduino Uno board along with 5 volt water pump both esp01 and water pumpare not working together if we give a power to both one is working while another stop working
Sir please tell me how to operate Bluetooth and switch together.
I have created code but switch condition overwrite my code because when bluetooth send data then print on serial monitor but when i add switch code on it its continued looping the data and overwrite my bluetooth data
Please help me
Can I store the Name and roll number at the same time?
bhai main aapki Video dekh kar Ek bahut hi Kamal Ka project banaya hai mein aapko Jarur dikhaunga aur Mera Bhi Ek TH-cam channel hai.
Sir kuch bhi scan kar sakte hai kya
Please reply sir
Yrr ap ya bta sakty ho k apna kn kn say hardware use kia h
Can I asks for assistance in integrating it this with MLX90614? Just want to try it as I'm so frustrated about it now.
How about using atmega32? What will be the changes??
Sir, Thank you very much for this valuable video. You have any such project which can record attendance of the students and as soon as the card is swipe a message should be sent on his parents mobile...
hey bro u have an error on code ?
Sir how can we add multiple rfid cards with this program.
can i use this for camu pplacement project
Kya hum Arduino uno use nahi kar skate???
how can we add data class wise like if student is in class 5 data will store in class 5 spread sheet if in class 8 it will store in 8 class sheet
I want to purchase the ready system
Bro is there any limit for no of card? Like if i want this 2 make for my whole class nd 150 is required will it work ? If it'll work will the speed of the working will be slow ? Nd which one will be the best module this one or em-18?
MFRC522 is best and it will surely work for 150 or more students
Hi sir...mene apko crazy fans he...mene ap se arduino ka bohut kuch sikha..mene ek request kortahu...ap sound module ek video banana..jo video me dekhana DO and AO read korke..mera pass ky037& max9814 module he.lekin eye DO read hotahe..A0 read nhi hora.
Mene chatahu mera eye module 4-5 feet dur se kohi sound or admi badd korego to sat sat exact sound A0 read korna.esee liya konsa module or sensor chaiye...?
Write time out erros occurs while compiled and uploaded 😢pls help me to figure it out?
HELLO , I AM REALLY DISAPPOINTED THAT YOU HAVE STOPPED ARDUINO PROGRAMMING SERIES. YOU POSTED YOUR LAST VIDEO 4 MONTHS BACK.
PLS CONTINUE ARDUINO SERIES AND POST VIDEOS EVERY WEAK
Bro D4 not declared in the scope error occur while programing.... Please hlep me...
I have SECUREYE SB100CB. Can I use this with these code to save the data into google sheet ?
Sir I have a problem with the project. Everything is done but the data is not storing on google sheet. Display message "Connection refused". Please help me in this project
Please make a video on child location monitoring system
Bahi muje drill machines ki counting ko google sheets per send karna ha
Is ka code or connection kase hoga
Hi sir main ek project develop kar raha hun.
Jismein Bluetooth kar mei GSM model lagakar kar se message ya call kiya ja sake
*Kar mein ultrasonic sensor lagakar ultrasonic sensor ki value gsm model ko output dena hai kya aap thodi si madad karenge please
Hello I want to make home automation system for my home.
I want to connect all devices ( fans bulbs night bulbs Fridge and inverter). In my home I have 15 electric board for on off fans and bulbs 💡. In TH-cam only one board automation system available. I should not use node mcu for every electric boards. My question is we can connect all electric boards only one node mcq / Resberry pi.
In home automation system Function
Manual Control
App control
And
Own Ai and set timer to on off fans and bulbs 💡
Please share me own suggestion
koi aisa project bnaiye jisme SD card me bhi data store ho aur SD card me saved Excel se employee ka naam read kre aur display kare screen me aur sath me google excel me data share kre SD card se.
can you please make survellience robotic car using esp32 cam and app make in android studio
Kya hum ghar ke appliances ko kahi bhi kisi bHi location par control kar sakte hai .... Home automation ke jariye
Yes if programmed well
Bhaiya aapne kitne dino ke baad video banaya hai.
Good
Bhaiyaa aapko drone ki programming aati hai kya?
Tumhari insta profile I'd send Karo plz
how to code own mobile app for controlling rc car etc,
Mere computer me arduino ke Bord me Node mcu so nhi kr rha koi anydesk pe sport kr sakta hai...
Sir RFID is not reading the card... No response in serial monitor.... Please help sir
Any solution?
sir is computer compulsory?
when I open serial monitor... it doesn't shows anything... what exactly should be the plroblem...please help me out bhaiyaa
Bhai ek madad kr do please tumne kis course ki shuruat kaise ki pahle programing python java or kya jo bhi sikha abhi tk usko step by step ek video bna do Bhai 🥺🙏
Bro Mujhe bhi aisa ak project create karna hey, kay ap help karenge. Kuch Material Online Currently unavailable hey. Plz
Dear sir mujhe arduino Ek project banana hai Ek pin ko input Karke is per signal receive karna hai aur yah input signal Ek Bar Aake Chala Jata Hai Oriya signal output pen per continue billing Hoke dikhata Rahe ki yah signal aaya tha Kis Tarah Se program Likhenge
i got 400 status code, since i have done exactly what is mentioned in this video, need help!!
Plesse sir,,
Esp32 par home automation ka video banayea please sir..
hi i have an little issue in my code can you please help me with it
Bhai eak video banaao jisme esp8266 ke wifi se sevo motor ko control karne ka without using blynk
Hello sir can you help me? For code mess billing excel sheet and aurdino ? Reply please 😭🥺