RFID Attendance System using NodeMCU and Google Sheets

hello friends here i have connected an rfid reader module to the node mcu when a cardholder scan his rfid card then his attendance data will be stored in the google sheets automatically such as attendance date time and card holder name so let's understand how i have created this project first go to the description of this video here click on this link soon my github account will open here you can see all the files that are required for this project such as code and wiring diagram next step is to create a google sheet for that login to google sheets using your google account here create a blank sheet the sheet is created next we will use first column for date second column will be used for attendance time and the third column will be used to store the name of the card holder next go to extensions and then app script here we will write code for our google sheet the code is available on my github account here open sheet.js file select all the code and then copy it now move back to the script editor and paste the code here next we will make some changes in the code first enter your sheet id here you can get the sheet id from the google sheet that we have already created here in the address bar of the web browser you can see i have highlighted the sheet id just copy it then move back to the script editor and paste the sheet id here next enter your country time zone here you can search your country time zone from google search results next here i have created the date and time for the attendance system next i am reading the cardholder name from nodemcu and below this block of code just store the date time and cardholder name in google spreadsheet and the last thing click on save button to save the code now the code is ready we will deploy this code by clicking on new deployment here click on settings and then select web app then select anyone from who has access now click on deploy button to deploy the code then click on authorize access and then select your google account then click on advance then go to untitled project unsaved then click on allow button soon the web app url will be created you just copy this url this url will be used to store data in our google sheet first we will test this url so enter the url in the address bar of the web browser next enter the question mark then name and then equals the last thing enter any name you want to store in the column c and then press enter here you can see the name is stored in column c let's verify it from the google sheet here you can see the name is updated in column c along with the date and time so we will use this url in the code and nodemcu will use this url to send the attendance data to google sheet next let's take a look at wiring diagram here i have connected the rfid module to nodemcu and i have also used a buzzer the buzzer will beep automatically when you scan an rfid tag i have already connected all the components as per circuit diagram my buzzer is get damaged so i will not use buzzer in demonstration let's move to the coding of the project first we need to store the cardholder name in the rfid card for that open this file cardholdername.ino here select and copy all the code then go to arduino ide and paste the code here save it with some name now first store the cardholder name in the rfid card for that here i have write the name ahmad logs and this code will store the ahmad logs on rfid card you can write any name that you want to store in the rfid card make sure the maximum length of name is 16 characters and blank spaces are not allowed in the name so i have used underscore instead of blank space now i will upload the code to nodemcu the code is uploaded now open serial monitor here you can see the message scan your card so bring the card close to the rfid reader here you can see the card is detected and below you can see the name ahmad logs is stored on rfid card successfully so this way you can store names on each ri fd card next we will make a program that will read the data from the card and then that data will be sent to google sheets so again go to my github account here you can see the file rfid attendance dot no just open it select and copy all the code and then go to arduino ide and paste the code here and then save the file with some name so this is the main program that will send data to google spreadsheet here first you need to install mfrc 502 library this library is required to work with rfid reader module you can install it from the library manager here search for mfrc 522 here you can see the library is installed i am using version 1.4.1 next i have defined rst pin and sda pin for rfid reader next i have defined the buzzer pin as d2 next below here enter your google sheet url so entered the url that we have tested before make sure you must have written the question mark then name and then equals at the end of the url next here you need to enter the fingerprint of your google sheet this fingerprint is required for secure https connection to the google sheet server you can get the fingerprint from our spreadsheet here you can see a lock icon just click on it then connection is secure then certificate is valid and a dialog box will appear here click on details tab now scroll down to the end here you can see the thumb print this thumbprint variable holds the fingerprint data that we have used in the code keep in mind you cannot use this fingerprint lifetime each fingerprint has an expiry date so before the expiry date you need to update the fingerprint in the code next i have used this fingerprint in the code here i have split this fingerprint in one byte paths and then i have put each byte in the fingerprint array like this next enter your wi-fi ssid and password next here i have defined a string variable cardholder name when we scan the rfid card then the cardholder name will be stored in this variable below is the rest of the code i will not explain all the code if you have any issue then tell me in the comments i will try to solve it now the code is ready just go to the tools menu and select the board as node mcu then click on upload button to upload the code after uploading the code open serial monitor here first the project will connect to the wi-fi network you can see the connection is successful now scan the rfid tag here you can see the name stored in the tag and then blur you can see the status code 302 it's mean the data is sent to the google sheet successfully now go to the google sheet here you can see the name attendance time and date is stored successfully next i have another rfid tag and i have already stored a name on it here you can see the status code 302 it's mean the data is stored in the google sheet that's all this is for today if you have any question then comment below see you in the next video bye

Channel: Ahmad Logs

Views: 67,392

Keywords: rfid attendance system using nodemcu, google sheets nodemcu, rfid attendance system using google sheets, google sheets esp8266, attendance monitoring system nodemcu, rfid based attendance system, nodemcu rfid attendance system, esp8266 rfid attendance system, iot attendance system, iot based attendance system, nodemcu iot project, google sheets, nodemcu attendance system

Id: aNjkNmHRx4o

Length: 9min 26sec (566 seconds)

Published: Wed Feb 23 2022