RFID Attendance System using NodeMCU and Google Sheets

Today, I will show you how to make an RFID based attendance system using NodeMCU ESP8266 and log the attendance data to Google Sheets along with the RFID tag holder name. You can use this system for a company or school who what to log the attendance data in Google Sheets. such as attendance date, attendance time, and student or employee name.

You can also try some other sensors, such as DHT11 Humidity and Temperature sensor, to send the data to google sheets using NodeMCU, by making simple changes in the code. I have used Google Sheets in this project because It is free and easy to use other than a cloud platform. You can also write Google Sheet Scripts to make project as per your requirements.

Parts Required For This Project:
3. RFID Tags
4. Jumper Wire

--------------------------------------------------------------------------------------------------------------------
Useful Video Links
--------------------------------------------------------------------------------------------------------------------
ESP32 Relay Control With Google Sheets

ESP32 GPS Data Logger with Google Sheets

How to Use RFID RC522 with Arduino

--------------------------------------------------------------------------------------------------------------------
Social Media Links
--------------------------------------------------------------------------------------------------------------------
GitHub:
YouTube:

--------------------------------------------------------------------------------------------------------------------
Download Code
--------------------------------------------------------------------------------------------------------------------

--------------------------------------------------------------------------------------------------------------------
Disclaimer
--------------------------------------------------------------------------------------------------------------------
Disclaimer: All videos are for educational purposes and use them wisely. Any video may have a slight mistake, please take decisions based on your research. This video is not forcing anything on you.

#NodeMCU #RFID #NodeMcuProjects

[nara]

Love from India. Your code worked in single trial. Fantastic and thanks a lot.

[josephzajdler]

I managed to get this working as well.
Thank you very much for the excellent video.
It sucks that the fingerprint expires making this a short term project, but very educational.

[chaitanyaashtekar]

I'm
It worked in just one go!!!
Thanks! ♥

[almeeraamsanarachmani]

Firstly, thank you so much for sharing the tutorial. You explained it very well. But I have a question, could we make a google sheet database instead of writing some data (name, student ID, etc) to the RFID tags so the RFID scanner can detect which RFID tag it belongs to? Thank you🙏

[getmedia]

Sir, I really appreciate your work and I'm from Ethiopian Stem center and my name is Ebisa Aschalew
I'm working in great project Which is related to RFID so please post another vedios about RFID

[kali]

Hello thanks for this video. I have this issue with registering name with the card using the first code in the video. After I upload the code there is no message appearing in the serial monitor? What might be the cause? Thank you

[mehmetedu]

You satisfy all our curiosity. thanks.

[Minionlovergirl]

your project is great.I love it .ill be happy if you share how to change the timezone I changed it but I cant seem to see any changes

[rumaisadurrany]

Can we use Arduino UNO instead of Node MCU? If yes what would be the changes in connections

[FalahgsGate]

thanks for bets tutorial but why I got the error" Firmware Version: 0xFF = (unknown)
16:30:57.524 -> WARNING: Communication failure, is the MFRC522 properly connected?
16:30:57.524 -> Scan PICC to see UID, SAK, type, and data blocks..."

[Zakxx]

hii!! thank you for your helpfull video but i have a little problem, so when everything is done and the serial monitor is showing the code: 302 nothing appear on the google sheet. so what problem it might be?

[girishpanchal]

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

[karldavealmeria]

Thank you for the tutorial, but i have troubling connecting it to WIFI. When i open serial monitor all I can see dot (. . . .) continously. PLease help

[brprfdu]

Thank you a lot, sir.I did it and worked so well.We made it in group and when we showed that in school they agreed to fix it in the school.They requested us that, can we make it like each student who shows the card to it, the name may appear in different Google sheets accoding to class wise.eg:if 10-A class students shows his card, the name may be registered on the a sheet named 10-A.Can you help us to do this .I think that you can definitely help us and upload a video on it .Hope you could do do it Faster. Please help us

[godivxb]

Hello! The coding was working just fine but when I scan the RFID card, it doesn’t reflect on the serial monitor 😢 why does it not detect the RFID card? How can I fix this?

[nayana]

Can anybody please help me with
When I connect NodeMCU to my laptop, in device manager it shows FT232R USB UART under other devices with an exclamatory mark[!].
I tried installing FTDI drivers, then it showed USB Serial port(COM3) under Ports(COM & LPT),
when I try to upload code it shows selected port does not exist or your board is not connected.

[omfik]

Its really a hard work if we have hundreds of name card holder and must upload to MCU one by one

[fathifarhatfafa]

tell me what if I want to make an RFID antenna that can only read the ID of the card, so that only the ID of the card is read and entered into Google Sheet and we don't need to register the card
can you help me for the code

[avinashmn]

How can changes on goggle sheet updates frigerprint not detected sir

[xvkvkul]

URl is not able to connect what should I do???