IoT RFID Attendance System using Google Sheets (NodeMCU IoT Series - Tutorial 10) | हिंदी में

Подписаться 71 тыс.

Просмотров 108 тыс.

50% 1

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

Наука

Опубликовано:

26 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 253

@musicduniyacreation587 2 года назад

Bhaiya thank you very much for uploading this video after long time. I am very very very eager for your next video.

@RealtyElectronics 2 года назад

Please bro be regular Beacuse I only like your videos on youtube I really like your way of understanding and explaining.

@sykamerkar 2 года назад

thank you for extremely detailed information and pointers

@meshramg370 2 года назад

Bohot jabardst video hai bhai 👍🏻

@dignagpakhare2138 Год назад

Bro ak number full sahi hai🤩

@meshramg370 2 года назад

Bhaiyya aapke videos bohot ache lagte hai aap our bohot sare programs related videos dalo 👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻

@khurramshahzad-tw7vm 2 года назад

Good to see you after long Time

@thrillgaming6234 5 месяцев назад

thanks ...very well explained ..helped a lot

@confusedidiot3509 2 года назад

Such a simple explanation

@shreechandansamal5206 2 года назад

Bahat din ke badd 😔.... Arduino series also in pause.. 🙏🙏 resume please sir.. And this is a good project ☺️👍❤️❤️

@indianarduinoprojects8753 2 года назад

Please upload regular videos Big fan

@gep8639 2 года назад

Your video came very late, we are very eagerly waiting for your video, thank you for the video, love you from heart

@SameerShaikh-tf2xu 2 года назад

Best video best iot project ❤️

@AllAroundScience_ys 2 года назад

Bro gjb hai 🤘✨

@vishwasvishu1895 2 года назад

Great idea bro🎉

@azzattar8422 Год назад

Bonne présentation, merci beaucoup...

@rahulkhandelwal5359 2 года назад

Keep it up bro

@rehanazim7813 2 года назад

Finally After a year

@mayurjivatode482 2 года назад

Thanks you so much brother 🥰🥰

@techwithnagendra6369 2 года назад

Super bro

@khanshaista9303 9 месяцев назад

Thank you bro❤❤

@imakeAppleservicecenter Год назад

thank you verry much

@laxmikantkathale4927 3 месяца назад

THANK YOU

@cricktick20 2 года назад

Big fan bro,,,,,,❤️❤️❤️❤️❤️❤️🚶

@triumph9371 2 года назад

nice explanation

@electronicsyogesh7552 2 года назад

Nice 👍

@shivankjoshi8363 Год назад

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?

@maazshaik6514 2 года назад

He'llo bro itne din Kahan the Bhai ap ? Please upload Regular video I am big fan of you from Singapore

@sanjaykumargupta8852 Год назад

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

@purushottamkurade9829 2 года назад

Plz start a series on drone with Arduino UNO plz and your all videos are very knowledgeable thanks 🙏👍

@electronicsocietyofindia 3 месяца назад

v good

@YPTechDATIA 2 года назад

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

@yadwindersingh9494 2 года назад

Cam you share how to use it with my sql

@YPTechDATIA 2 года назад

@@yadwindersingh9494 I will post a video soon on my channel , please stay tune and subscribe me

@Cloudninja1 2 года назад

Authentication failed for Write: Timeout in communication. I am getting this on serial monitor .Please help me

@mr.techinventor3463 2 года назад

Good

@girishpanchal9072 Год назад

Hi Can I increase the range of this module upto 1meter?

@blkkobra Год назад

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 ?

@harshagarwal465 2 года назад

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

@KARANSHARMA-vk3uf 2 года назад

yes you have allow everyone in deploy

@indianarduinoprojects8753 2 года назад

Please make A toutrial on drone pid flight controller using arduino

@TechnoEveryday 2 года назад

🆒 Thank you so much for uploading this video. 👍👍👍👍👍 Sharing with community 🇵🇰

@chaitanyaashtekar9690 2 года назад

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 ⁉

@Cloudninja1 2 года назад

Authentication failed for Write: Timeout in communication. I am getting this on serial monitor .Please help me

@imyogaholic 2 года назад

Multiple employees k liye program bhi many times krna hoga,,different rfid card me name add krne k liye...

@mukundakavaliya6215 2 года назад

Ethernet base students attendance system with rfid and fingerprint with i2c display

@a_03_nikhilanjikhane29 4 месяца назад

now there is no such as thumbprint or finger print then what should we do now ???? and what fingerprint should we put in code

@newpunjab2429 2 года назад

Can u add 16*2 lcd with I2C IN THIS PROJECT

@crazyzone4064 Год назад

Can we use Arduino Uno instead of node MCU?

@udaypreethigudela4447 2 года назад

Bhai is this project related to major project ya minor project

@indianarduinoprojects8753 2 года назад

Bhaiyaa aapko drone ki programming aati hai kya?

@purushottamkurade9829 2 года назад

Tumhari insta profile I'd send Karo plz

@abaykrishna9630 Год назад

Hey can we use ESP32 instead of ESP8266

@rohandhar1093 2 года назад

Please make a video on child location monitoring system

@AsianTitans 2 года назад

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

@blkkobra Год назад

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...

@mrparmar5468 9 месяцев назад

hey bro u have an error on code ?

@yadwindersingh9494 2 года назад

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

@rkambojroboteks9262 Год назад

bhai main aapki Video dekh kar Ek bahut hi Kamal Ka project banaya hai mein aapko Jarur dikhaunga aur Mera Bhi Ek RU-vid channel hai.

@uniqueautomationelectronic5696 11 месяцев назад

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

@pragatibhat366 Год назад

How about using atmega32? What will be the changes??

@muhammadismailmehtab 2 года назад

Sir is project me finger print sensor bi add Karna ho to kia kre us ki programming kese hogi

@enrorisays Год назад

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 ?

@shourj_o 2 года назад

Can I store the Name and roll number at the same time?

@mahaveerprasad8326 Год назад

Sir pls tell me that data updates only one coloum always in sheet

@movietech8660 Год назад

Yrr ap ya bta sakty ho k apna kn kn say hardware use kia h

@samiatahir5559 2 года назад

Sir how can we add multiple rfid cards with this program.

@sidramsaybane3353 2 года назад

Sir mere pas node MCU ESP32S model hai wo chalega kyais project ke liye

@pranjalbhujade8223 2 года назад

Sir kya aapp meri thodi help kr skte ho ... Mere project me node mcu esp8266 use kr rhi hu .... Please sir reply mi

@uvaishwarsii 2 года назад

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...

@ashishkumar-pm9tr 2 года назад

Bhaiya aapne kitne dino ke baad video banaya hai.

@sagnikchatterjee8122 2 года назад

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?

@EngineersElectronics 2 года назад

MFRC522 is best and it will surely work for 150 or more students

@hardik1703 2 года назад

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

@hamzamalik444 2 года назад

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

@ansharahsameen16 Год назад

Can u give the details of jumper wires please

@johnklienemarclimsiaco4639 2 года назад

Can I asks for assistance in integrating it this with MLX90614? Just want to try it as I'm so frustrated about it now.

@gauravsaini4821 2 года назад

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

@sibgatullahkazi5775 Год назад

I have SECUREYE SB100CB. Can I use this with these code to save the data into google sheet ?

@MohitAutomation 2 года назад

Please sir, Esp32 par home automation ka video banaya..

@RaviRanjan-zx7jw 2 года назад

please upload more video

@arduinoprojecttutorial6774 2 года назад

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...?

@musicalnaturebyneet4858 Год назад

is it a project for ece students

@spiderman-ws5ei 3 месяца назад

can i use this for camu pplacement project

@MohitAutomation 2 года назад

Please sir, ESP32 Par home automation ka video banaya..

@ahamadbembrekar2182 Год назад

Sir kuch bhi scan kar sakte hai kya Please reply sir

@Sigmatrainer.7042 3 месяца назад

Kya hum Arduino uno use nahi kar skate???

@harshkolambkar5893 Год назад

hi i have an little issue in my code can you please help me with it

@handlennj 2 года назад

can you please make survellience robotic car using esp32 cam and app make in android studio

@adarshcjaneesh2255 Год назад

Bro D4 not declared in the scope error occur while programing.... Please hlep me...

@jsgamer7067 2 года назад

millis() function in arduino sensors

@rugneshvora209 Год назад

Please make raspberry Pi pico video tutorials 😇

@dhanmanibasumatary3455 2 года назад

how to code own mobile app for controlling rc car etc,

@abhijitpaul1739 2 года назад

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

@ranjanpanda4 2 года назад

I need your support to flash node mcu, i wanto upload this code in my node mcu

@rakeshranjan8118 2 года назад

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 🥺🙏

@neerajmanga3204 Месяц назад

Sir pls one more vedio banaye Wifi car with esp8266 with l298n motir driver using blynk application with buttons control pls

@gayatrivaswani4818 Год назад

please explain xl sheet thumbprint thing in updated version of google excel sheets

@mayurshinde2337 Год назад

did you get the solution?

@RajKumar-up5je 2 года назад

Bhai eak video banaao jisme esp8266 ke wifi se sevo motor ko control karne ka without using blynk

@gurpreets012 2 года назад

Kya hum ghar ke appliances ko kahi bhi kisi bHi location par control kar sakte hai .... Home automation ke jariye

@manishavasantraoshirsathe1884 2 года назад

Yes if programmed well

@chandansona8488 2 года назад

i have a arduino and rc522 reader pl send me code of rfid and link of spreed sheet and gui interface

@crazyvlogofficial4453 4 дня назад

Bhaiya isme ek or option ke add kaise kare jaise time in and time out please Bata do yaa video Bana do please 🙏

@gaganenggtoolstome431 Год назад

Bahi muje drill machines ki counting ko google sheets per send karna ha Is ka code or connection kase hoga

@technicaljav1526 2 года назад

Finally remembers his youtube password😎

@EngineersElectronics 2 года назад

😂😂😂

@Its_hackerz_mind-kp4ml 5 месяцев назад

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

@deepakprajapati6795 2 года назад

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

@tylermorgan9838 8 месяцев назад

i got 400 status code, since i have done exactly what is mentioned in this video, need help!!

@technicaltejo Год назад

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 RU-vid 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