IoT based RFID Attendance system using ESP8266 and Google sheet / PN532 RFID

this video is brought to you by ultim365 via the world designs electronics and octopod the fastest search engine for electronic parts in today's episode you will learn how to make an iot based and out time tracking system using the node MCU esp826655 audio the pn532 NFC RFID module and i2c supported SSD 1306 or LED display module and Google spreadsheet the reason I selected pn53 to RFID module is that it's low cost and low power RFID module and it supports multiple interfaces Hsu high speed uart i2c and SPI in my previous video I have already explained how to use all these three interfaces in this video I am going to use the i2c interface because my OLED display module is also in i2c supported device so using the i2c interface I can the wiring so using only two pins on the Node MCU esp8265m audio I can communicate with both the modules as usual I'm using the same esp8266 development board it doesn't matter if you don't have this development board you can do all the connections on a breadboard anyway let me show you all the connections the SDA and scl pins of the pn532 RFID module all connected with the note MCO esp8265m module D1 and D2 pins D1 is the scl and D2 is the SDA likewise the SDA and scl pins of the SD 1306 OLED display module are connected with the same pins D1 and D2 on the Node MCU Mario so using these two pins we can communicate with both the modules and this is only possible because of the i2c addresses these modules have different i2c addresses the VCC and ground prints of the oi ability display module and the RFID module are connected with 3.3 volt and ground pins of the nodemcu module if you face any difficulty in doing all these connections then you can follow this circuit diagram you can download it from our website electronicclinic.com I will provide a link in the description one more thing that I would like to talk about is is I said earlier the pn532 supports multiple interfaces which are uart i2c and SPI for selecting any of these interfaces you will need to accordingly adjust the toggle switches since I'm using i2c interface so that's why Channel 1 is on and channel 2 is off as usual before I'm going to explain how to set up your Google spreadsheet and how to connect it within our MCO esp8266 Wi-Fi module first let's watch this project in action right now my node MCU esp82665i module and laptop all connected to the Wi-Fi let me also tell you it's not not necessary to use the same Wi-Fi network you can use different Wi-Fi networks it's an iot project you can monitor the employees of students and out time from any part of the world anyway on the Google spreadsheet I can monitor the date time name of the employer or a student the ID and the N Out status I'm going to swipe the RFID it takes and you will practically see how it works foreign [Music] foreign [Music] foreign foreign module is optional if you remove this it won't have any effect on the project but it but it's good to use a display because without the display you will be confused and you won't be sure if the card is successfully swiped right now on the OLED display module you can see the message waiting this means you can swipe the RFID take when it reads the RFID you take the message success is printed on the OLED display module I'm sure by now you might have got an idea of how does this system work so without any further delay let's get started the components and tools used in this project can be purchased from Amazon the component's purchase links are given in the description ultim365 lets you hold the fastest design reviews ever share your designs from anywhere and with anyone with a single click it's easy leave a comment taking your teammate and they will instantly receive an email with a link to the design anyone you invite can open the design using a web browser using the browser interface you are able to comment markup cross probe inspect and more comments are attached directly to the project making them viewable with an ultimate designer as well as through the browser interface design share and manufacture all in the same space with nothing extra to install or configure connect to the platform directly from Altium designer without changing how you all already designed Electronics ultim 365 requires no additional licenses and comes included with your subscription plan get real-time component insights as you design with octopod built into LTM 365. octopart is the fastest search engine for electronic parts and gives you the most update part data like specs data sheets gate models and how much the part costs at different amounts Etc right in the design environment so you can focus on your designs links to the ultim designer Altium 365 and octopod are given in the description you will need to carefully set up your Google spreadsheet or Google sheet for logging the required data if you miss anything you won't be able to get it connected to your node MCU aspa2665m audio I'm not using Google spreadsheet for the first time I have used it in so many other projects too so for more information on Google spreadsheet watch my previous videos I'll find links in the description for now you can follow the same exact steps [Music] [Music] foreign [Music] you can download this Google script from the article [Music] foreign [Music] [Music] foreign [Music] [Music] the deployment copy the deployment ID and paste it in the code next to the gscripted ID you can download this code from the article I have added a link in the description foreign [Music] ly you can click on the upload button for the node MCU asp-8266 WiFi port and libraries installation you can watch my getting started videos on the Google spreadsheet pin 532 RFID module and SSD 1306 or LED display module or you can directly download these libraries from the article [Music] foreign [Music] has been successfully uploaded after uploading the code next I opened the serial Monitor and started to swipe the RFID takes in order to find the take IDs right now I'm using only two RFID takes [Music] anyway I edit both the take IDs in the programming and again uploaded the code foreign [Music] spreadsheet in order to check if I can receive the date time Name ID and status as soon as I swipe the RFID dig I received the data so this is how easily you can send anything from the node MCU esp826 to Google spreadsheet from any part of the world so that's all for now support me on patreon for more videos I hope you liked today's episode like and share this video with your friends see you in the next episode and thanks for watching

Channel: Electronic Clinic

Views: 4,852

Keywords: esp8266, esp8266 project, pn532, pn532 rfid module, nfc rfid module, pn532 nfc rfid module, google spreadsheet, google sheet, esp8266 google sheet, google sheet time tracker, google sheet attendance tracker, google sheet employee time tracker, google sheet student time tracker, time tracker, rfid based attendance, electronic clinic, google spreadsheet and rfid, rfid project, in out time tracking, iot project, esp8266 rfid google sheet, rfid module pn532, arduino, nodemcu, google

Id: 2WcPirVmEz0

Length: 11min 5sec (665 seconds)

Published: Sat Feb 18 2023