RFID Attendance System using ESP8266 and Google Sheets Version 4

Hello friends today I am going to share with you the latest version of my RFID attendance system this version comes with some exciting new features including time in and timeout tracking as well as the ability to support multiple gate entries let's start with the time in feature when an employee arrives at the office he will scan his RFID Card at the entry gate and the system will record the exact time of his arrival along with his IDE let me show you how it works first I will scan my RFID Card using the RFID reader after a while the system displays a message on the LCD screen indicating that my attendance has been recorded you can also check the Google sheet as you can see the system has recorded my arrival time along with my ID if you check the timeout field here you can see the timeout field is currently empty which means that the person is inside the building when same person leaves the building he will again scan his RFID Card and the system will record the exit time of his departure in the time Outfield let me demonstrate I will again scan the same RFID Card using the RFID reader here you can see the exit time is stored in the timeout field this way you can monitor the arrival and exit time of the employees or students I have also added support for multiple gate entry this feature enable employees to use multiple gates to enter or exit the building the system will also store the corresponding gate number separately in the Google sheet let me demonstrate it here I have two readers installed on two different Gates first I will scan my RFID Card at gate number one wait for some time here you can see my attendance has been recorded along with gate number one now let's scan another RFID Card at gate number two wait for some time here you can see the attendance has been recorded but this time the gate number 2 is stored in Google Sheets this way we can record the attendance of the employees entering through a particular gate to complete this project you will need node MCU LCD display mfrc522 reader module an RFID tags make sure you have already stored data on tags like person ID name and some other data if you don't know how to store data on RFID tags you can watch my previous video where I explain it in detail I will provide a link to that video in the description below all the code and related files for this project are available on my GitHub account you can find the download link in the description of the video let's first have a look at wiring diagram here I have connected the reader module and LCD display to the node MCU you need to connect all the components carefully as per wiring diagram remember take your time and double check your connections to avoid any errors I have used breadboard and jumper wires to connect the components the breadboard allows for easy prototyping without the need for soldering next you will need to create a Google sheet so create a blank sheet here enter the fields names to store incoming data from node MCU such as ID time in timeout gate number and some other data next open the app script from the extension menu the script editor will open here we will enter some code so go to our code folder here openscript.txt file select and copy all the code now move back to the Google script editor and paste the code here now we will enter the sheet ID here you can get it from your Google sheet I have highlighted the sheet ID you just copy it then move back to the script editor and paste the sheet ID here next enter your country time zone it is required for accurate time next here I have created the date and time stamp for the attendance system then I am reading data from the node MCU including the person's ID name and gate number next the following block of code search for the person ID if the person's ID is found then this block of code checks if the timeout field for that person is empty if it is empty it means that the person is currently inside the building in this case the Code records the exit time of the person in the timeout field and sends a status message back to the node MCU if the person is not inside the building the code skips the previous if statement and Records the entry time of the person in the time in field along with person ID and other relevant data then click on save button to save the code now the code is ready for deployment so click on deploy then new deployment the deployment window will appear here you just follow the steps to create a deployment ID after creating the deployment ID you just copy it it will be used in the Arduino code so go to the code folder here open the RFID attendance dot Inno file here first we will enter the deployment ID that we have copied in the previous step next you will need to enter the gate number of your building in the code if you have a single gate building then you won't need to modify the code simply upload it to the node MCU and the system will be ready to use however if you have multiple gates in your building you'll need to specify the gate number in the code for example if you have a two gate building then you will need to install two separate RFID systems on each gate you will also need to upload the code on both systems so when you upload the code to the first system set the gate number variable to gate 1. similarly when you upload the code to the second system set the gate number variable to gate 2. this way you can use the same code for multiple gates in your building next enter your Wi-Fi credentials the last thing you need to modify is the sheet name you can get the sheet name from your Google sheet you can find it from the bottom right corner of your sheet you must need to type the same sheet name here in the code before uploading the code you need to install some libraries the first one is the HTTP redirect Library it is required to upload data to Google Sheets the other two libraries will be used for LCD and mfrc522 reader module you can easily install these libraries using the add zip libraries feature of Arduino IDE install the libraries one by one you can see the message the library has been installed follow the same process to install the remaining two libraries before uploading the code make sure you must have installed the esp8266 board with the version 2.6.3 now the code is ready hit upload button to upload the code to node MCU once you have uploaded the code the system will automatically try to connect to your Wi-Fi router once it's connected it will then attempt to connect to your Google sheet when it's successfully connected to your Google sheet the LED light on the Node MCU will start blinking rapidly and you'll see a message on the LCD screen that says scan your tag this means that the system is now ready to record attendance and you can simply scan your RFID tag to record attendance that's it for today if you have any questions or comments please leave them below and don't forget to check out my other videos for more cool projects thanks for watching bye

Channel: Ahmad Logs

Views: 48,163

Keywords: rfid card attendance system, rfid attendance system google sheets, rfid based attendance system, google sheets attendance, rfid solutions, rfid rc522, rfid reader and writer, rfid card reader, rfid access control system, rfid attendance system using nodemcu, attendance monitoring system nodemcu, esp8266 rfid attendance system, nodemcu iot project

Id: S3DmT-LmKug

Length: 9min 23sec (563 seconds)

Published: Fri Mar 10 2023