RFID Attendance System using NodeMCU and Google Sheets
ฝัง
- เผยแพร่เมื่อ 22 ก.พ. 2022
- 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:
1. NodeMCU ESP8266 - amzn.to/3Zzm1bJ
2. RFID Reader Module - amzn.to/3mNOtYy
3. RFID Tags
4. Jumper Wire
--------------------------------------------------------------------------------------------------------------------
Useful Video Links
--------------------------------------------------------------------------------------------------------------------
ESP32 Relay Control With Google Sheets
• ESP32 Relay Control Wi...
ESP32 GPS Data Logger with Google Sheets
• ESP32 GPS Data Logger ...
How to Use RFID RC522 with Arduino
• Arduino RFID | How to ...
--------------------------------------------------------------------------------------------------------------------
Social Media Links
--------------------------------------------------------------------------------------------------------------------
GitHub:
github.com/ahmadlogs/
TH-cam:
th-cam.com/users/ahmadlogs?sub...
--------------------------------------------------------------------------------------------------------------------
Download Code
--------------------------------------------------------------------------------------------------------------------
github.com/ahmadlogs/nodemcu/...
--------------------------------------------------------------------------------------------------------------------
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
Love from India. Your code worked in single trial. Fantastic and thanks a lot.
so nice of you
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.
Thank a lot
Hey!...Hello!...can we get in contact?...I am facing an issue!
I'm amazed!!!!!
It worked in just one go!!!
Thanks! ♥
great
Total clear. Thanx ❤️
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🙏
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
You satisfy all our curiosity. thanks.
So nice of you
connect the buzzer to pin D2
superb explanation sir
Can we use Arduino UNO instead of Node MCU? If yes what would be the changes in connections
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
watch it. th-cam.com/video/M9Sci4nsTEk/w-d-xo.html
Am,azing , love it ♥
Thank you
thanks
Hi
Can I increase the range of this module upto 1meter?
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
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
what is the solution for key expire?
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
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?
very nice and good project
thanks
Its really a hard work if we have hundreds of name card holder and must upload to MCU one by one
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..."
Nice job !!!!!
please make a video to store attendance data in php mysql database
how to enter multiple user details at a time
Hi there kind sir. This is awesome. i am yet to try this yet. But wondering if we can do multiple RFID scanners at different locations with same rfid tag? imagine that we scan at location A = Google sheet shows IDName, locationA. Then scan at Location B (different wifi) = Google sheet shows IDName, locationB
Thank you in advance sir
this is a great idea to implement. I will definitely try this. but I have very little time. will try in future. check version 3 of the project th-cam.com/video/Bgs_3F5rL5Q/w-d-xo.html
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?
Hi, great video. How plus more members?
Great vedio!! In my project (i interfaced rfid and gps with esp8266)while scanning rfid card the id number and location of the card is obtained (i am using neo6m gps) i want to send gps loaction if the respective card to the Google sheet.... how can i do it? Please help me with this ..
Thanks in advance.
you might watch my video about send gps data to google sheet. It might be helpful
hii i wanna add ir sensor in this project so that will also count the student that touch their rfid tags. Can you help me ? How do i contact you ?
How can changes on goggle sheet updates frigerprint not detected sir
Thank you for your great tutorial! It seems to be working, but unfortunately I am also getting the "[HTTPS] GET... failed, error: read Timeout error", and it does not seem to update the Google sheet every time. Please let me know if you have update yet :)
Also, how do I stop the ESP blue LED from blinking when it is idle? It is always flashing
I have solved the issue. th-cam.com/video/Bgs_3F5rL5Q/w-d-xo.html
same
thank you for the project sir..
i have question .. is it possible to write more data on the RFID card? for example like phone number and more.. your input is appreciated!
Yes, you can. I will try to make a video on it
@Divya Nacciar Kumaran (UST) th-cam.com/video/M9Sci4nsTEk/w-d-xo.html
That was an amazing and useful video appreciating your work. Also i would like to know how we can use Arduino keypad to allow employee enter how many bags they have manufactured in a day(Consider this as an manufacturing industry) which can be stored in the google sheet.
I would be very glad to see this on your channel
Looking forward for your reply.
will try
@@AhmadLogs thanks!
You would need another input source like from a keypad then make a variable attach the variable output to another column field in Google sheets like he did with name date ect. You could probably just duplicate those lines of code and change the variable inputs.
URl is not able to connect what should I do???
hello... i have a question...can the code on the arduino IDE merge into one... and can the code be mixed with other project code but only using one arduino IDE sketch. right now I'm making a door lock project using Blynk and I want to combine it with your project
yes you can combine both codes if you have little knowledge of programming
Very nice.....
thanks
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
Hi!, your project is amazing but I want to use de timezone of america/chihuahua, I added it to the code but it keeps showing me another time zone, how could I fix it?
I will try to add it in the version 5 of this project
how can we make this in billing system? can you sent code? items,quantity,cost
is this still working on arduino IDE 2.3.0?
Can anybody please help me with this!!!!!
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.
How to display student ID in Google Sheets
My gopglesheet doesn't show certificate is valid only show this site as a valid certificate, issued by a trusted authority,
How can i find thumb print?
i am having a hard time to find a simulation software or even a circuit diagram maker which includes rfid and raspberry pi pico. Can you suggest some?
I also never tried it. can you give me some details what do you want to make
@@AhmadLogs i am currently making RFID attendance system which requires basic components like buzzer green and red led RFID and pico
@@Tetroner ok. I have noted.
what finger print should I use? the public key or the certificate? also, in this video, there's only [20] in your fingerprint, but today I checked there are 32 in the fingerprint detail
Even I'm having the same doubt... I can't figure it out 😭😭
Same problem, previously Google sheet shows sha 1 id include 20 fingerprint... Now it's only showing 32 fingerprint with sha 256... How solve the problem... Any idea ?
Hlo sir good experiment output will be tacken but today checking in a experiment my fingerprint data change there what we do
There for showing output in serial monitor but connection failed on serial monitor,
hi what is the problem. i have the same method use bot RFID-RC522 Not Scanning For the RFID CARD.
I think there is an issue with the connections. try to connect the rc522 to the nodemcu without using the breadboard. I mean connect the jumper wires directly from rc522 to arduino.
Hay mahn osm project❣️ wanna impliment em 18 rfid reader..just nuking the rmf522 code and adding the em 18 part is enoug i guess
I dont have em18 reader module. first I will need to buy it.
Amazing, please where WE Can buy material ? I'm from morocco
from amazon, or aliexpress
Yes now it's working thank you sir ...
sir can you suggest me a way tha how can I display the location of the place in Google sheets..
that's great! I have already created a video on this topic. just find from my channel
Sir I cannot find the video ... Pls can you just paste the link over here...it would be helpful
@@soumyadeepkarmakar6412 th-cam.com/video/wQGqydQUwRw/w-d-xo.html
I need a full explanation of the code
Show MFRC522 file is not found
How can i solve it.
what can i do in order to add another block like class, number and many more
you can update the code for write data to tag to store more data on the tags
about add the IoT project and BLDC controller project hope !
please give me some more details
if using the module from ESP 32 for the proccesor not using ESP 8266 its work or not for the code sir?
as I know you will have to update the code for esp8266
hello sir, may i ask again is it possible to make a system like this but added a feature to know that the student has left the class?
no it is not possible with this project. you need to use some face detection system for your project.
Hi, Love the tutorial, however, can you help me with my problem, I'm Getting the code:302 but the info is not reflecting on the google spreadsheet
have you tested your sheet URL manually.
Also, I put in my timezone Asia/manila but it doesn’t show the correct time
@@adrianarceo1074 how much time difference in google sheets.
also check this link
support.google.com/docs/answer/58515?hl=en&co=GENIE.Platform%3DDesktop#zippy=%2Cchange-locale-and-time-zone
@@AhmadLogs hello sir, I would like to chat with you if you have time, I would like to modify the code a little to suit my needs, update, my code is working now
@@adrianarceo1074 you might ask anything here. I have very little time
Is ther any synopsis u have prepared on this topic
It would be a bit help full to make this
Fingerprint field vlue will be changing
How should i replace the date and accurate time? Cause i did the part it shows wrong code on number 17
watch the part 2 of this video
Can we connect multiple node mcu to single google sheet .
yes, you can
We have an issue of IP request after being and get ...will u plz tell what to do now
give me some more detail
am getting an error while testing the code for the google sheet(stripQuotes is not defined (line 18, file "Code")) can you help me fix this
I have updated the code now. just download the latest copy of the code.
My googlesheet didn't show certificate valid
hi sir, after adding the name to the script url it shown an error of "TypeError: Cannot read properties of null (reading 'getLastRow') (line 35, file 'code')" is there any way i can do to solve this program, as after checking there's no prob i cant find any error from line 35
it strange. you might check the version 3 and version 4 of this project. that might be helpful
I have a problem in final, it write:" HTTPS get: code 200" without results in sheet
just try again
i am unable to compile code because there is no library i am using a esp32 board for this. what changes do i need to make? help me please
very simple. you just delete the line #include. This library is not required for the project
Sir the code i am getting is 400, what to do?? Please help
Hii,
Can you lend this project for a week ?
I will pay for this .
thanks for this very useful tutorial, it's really amazing! sir, may i ask, how to add new user for new rfid card?
just store the data for the student on the card. and scan it. no need to change anything in the code.
@@AhmadLogs so one code is used for one card only??
@@athea5708 write data file must be changed for storing new data on the card. but the main sketch file will never need to change
@@AhmadLogs thank you for the answers, sir. May I ask about bearSSL? what is the function? it is okay if I deleted it?
@@athea5708 it is not used in this project. So, you can delete it.
Hello Sir , Rfid data code after expiry. Please suggest me
but this project is not about fingerprint
Thanks
In serial monitoring, after output, in the end of output, we are getting "failed, error:connection failed" Is it default or what?
Yes same, did the problem got solved?
how to setting time for indonesia Jakarta
watch version 2 of the video
i love u babygirl for showing me this
Sir,I have done everything and when I was scanned the RFID card in serial monitor it was showing read block successfully with code 302 but name was not updated on the Google spreadsheet........
Pls help.........I have to submit my project
have you test the web app url manually?
hi! thank you for this tutorial, nace
i have this error in test
TypeError: Cannot read property 'getLastRow' of null (ligne 22, fille "Code")
add some dummy data in line number 1 in google sheet manually. then test the project again. and let me know
@@AhmadLogs I did the same thing you did, same problem.
@@kamalkamel7559 have you rename your google sheet?
if not then tell me your sheet name. you can check the sheet name from from the bottom right corner of the sheet. like sheet1 or sheet2 or somethings else.
@@AhmadLogs no, I did not rename! should it be renamed?
ok I'll rename it, then if it doesn't work I'll give you the sheets
@@kamalkamel7559 it must be Sheet1
Hello! I tried adding a name to column C, but when I pressed enter it simply shows 'Script function not found: doGet'
Also, it says that the parts are unavailable in Amazon, is there a different product you recommend similar to the video?
Because you're trying to write a name manually to a field that is designated by the script to be updated by the node.
Good afternoon sir I try this project, serial data will br received but Google sheet doesn't get rf data
what output is displaying in the serial monitor
Sir D3 was not declared in this scope btaa rha
d3 is the gpio0. so you use pin 0
Thanks for the Node MCU work, but I'm having trouble when scanning. But it says [HTTPS] GET... failed, error: connection failed. What should I do? can you help me thank you 🙏🥺
check the latest version 4 of this project.
Thank you very much 🙏💐
how can we send data to google sheet ? my code is scan by rfid but it can't update date in google sheet please help
check the serial monitor there must be some error message
hey brother ..got an error in gscript ..saying"line 26 parameter is undefined ..how to resolve
you have made some changes in the script that's why the script showing error.
Bro how to solve d3 was not declared in this scope
please give me some details
Hai car gaming look his setting on 4:59 the board thing it will help hehey
Yes bro I face the same issue how can remove this trouble??
Sir please tell me why the fingerprint or server error occured in google sheet....
Error : Connection Failed.....!!
I will check it
How can I add a feature to allow me to log both check in and check out time?
will update soon
@@AhmadLogs That would be amazing! I also wanted to ask if it was possible to use UID instead of writing and modifying the blocks. My employees already have a RFID tag that they use for our keyless entry system and I fear that modifying the blocks will prevent the keyless system from functioning properly.
@@pspexperts yes you can use uid, I will be okay
@@AhmadLogs thank you! Waiting for the update
Hi, I have the same problem as "kamal kamel" I do not quite understand what I should change could you make screenshots where you can see exactly what to change. Thank you in advance
check this
stackoverflow.com/questions/63046368/find-this-error-in-my-code-typeerror-cannot-read-property-getlastrow-of-null
@@AhmadLogs Ok and what should I do now with the code ?
@@matthiash.454 no need to change in the code. just rename the sheet to sheet1
@@AhmadLogs Thanks for the help it goes but the time is not correct is -1 hr so normally 14:00 displayed 13:00. Where is the error ?
In the time zone I have entered the country and the place but it is missing 1 hour ?
@@AhmadLogs I get an error message when scanning the RFID ?
[HTTPS] begin...
[HTTPS] GET...
[HTTPS] GET.... failed, error: connection failed
How you savedanother name for Another tag
check the complete process here th-cam.com/video/Bgs_3F5rL5Q/w-d-xo.html
TypeError: Cannot read properties of undefined (reading 'toString') (line 37, file "Code") after entering name
watch
version 4: th-cam.com/video/S3DmT-LmKug/w-d-xo.html
version 3: th-cam.com/video/Bgs_3F5rL5Q/w-d-xo.html
version 2: th-cam.com/video/M9Sci4nsTEk/w-d-xo.html
when I open serial monitor... it doesn't shows anything... what exactly should be the plroblem...please help me out sir...
test you rfid reader module first
How to update the thumbprint in this type of error....i.e Connection Failed
I will check the issue and try to solve it
@@AhmadLogs ok please jaldi batadiye ga....!!
How to store five rfid cards and what changes have to be done.
nothing to change
@@AhmadLogs Tab alag alg kaise record hoga...
@@princekumarbhargav8612 sorry you need to change id, name etc.
How to run this project without buzzer.
just remove the buzzer no need to change the code.
can you show how to write data for rifd card ?
I think you need to watch
version2: th-cam.com/video/M9Sci4nsTEk/w-d-xo.html
version3: th-cam.com/video/Bgs_3F5rL5Q/w-d-xo.html
version4: th-cam.com/video/S3DmT-LmKug/w-d-xo.html
if i do in esp32 , does the code same like in video?
@@iddddd900 I thinks you need to update the code. I never tested it for esp32
i have a question what if the name is more than 16 Characters ??
then you need to use two blocks of RFID, and you will be able to store 32 characters.
bro its not working i need your help...??
instead of 302 ,i am geetinf 400 code number in attendance system .what does it mean .how to rectify
400 Bad Request - indicates that the server cannot not process the request, due to the invalid request. for example, issue in request syntax, invalid request message. please verify your web app url
@@AhmadLogs sir time is not getting correct at my excel sheet
@@newpunjab2429 check version 2 of the project for time and date accuracy.
th-cam.com/video/M9Sci4nsTEk/w-d-xo.html
I am getting an error, while compiling it says -> Compilation error: redefinition of 'MFRC522 mfrc522' PLEASE HELP!!
you have added this statement "MFRC522 mfrc522" two times in the code. so just delete one statement
Hi i have error
d3 was not declared in this scope
What should i do?
What do i need to install and add for this on arduino ide
which board you have used?
What board did you pick on arduino ide tools/board
I think i found out yey
@@xplorermom4075 for esp8266 change pin D3 to pin 0 in the code.
I have selected nodemcu
Sir
I have a error in last step
[HTTPS]GET...failed,error: read Timeout
most of the time data is sent successfully, but sometimes this error occurs due to server blocks the request coming from nodemcu.I am trying to sort out the issue.
when i upload the code for writing data in the card it shows "Leaving...
Hard resetting via RTS pin..."
It shows scan a tag to write data in the serial monitor..but nothing happens when i bring the card closer
help please ?
It sounds like you are trying to write data to an RFID card using a NodeMCU board and encountering some issues. Here are some troubleshooting steps you can try:
1. Check your wiring: Ensure that your NodeMCU is properly connected to your RFID reader/writer module. Double-check that the connections are in the correct pins.
2. Verify the code: Make sure that the code you are uploading to the NodeMCU board.
3. Test your RFID reader/writer module: Use an RFID tag or card that you know works to test the reader/writer module. If the module is not working, this may be the source of the issue.
4. Reset the NodeMCU board: Try resetting the NodeMCU board by unplugging it and plugging it back in. This may help resolve any issues with the board.
5. Try a different NodeMCU board: If all else fails, try using a different NodeMCU board to see if the issue persists.
I hope these steps help you resolve your issue. Good luck!
@@AhmadLogs thanks mate , will check it out