RFID Attendance System using NodeMCU and Google Sheets
ฝัง
- เผยแพร่เมื่อ 10 ก.พ. 2025
- 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/ahm...
TH-cam:
www.youtube.co...
--------------------------------------------------------------------------------------------------------------------
Download Code
--------------------------------------------------------------------------------------------------------------------
github.com/ahm...
--------------------------------------------------------------------------------------------------------------------
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!
Thanks a lot I have been searching for a while. for sure this is the best video to explain the project.
I'm amazed!!!!!
It worked in just one go!!!
Thanks! ♥
great
This is a great project however I am having trouble setting up the time zone. I have changed it in my calendar, my google account and in the code but it always returns GMT
Kya Is ke liye Laptop yah PC Online rehna jruri hai?
Yah fir Jab PC on krege kuch time badh toh data PC mei apne aap store rahe ga.
You satisfy all our curiosity. thanks.
So nice of you
connect the buzzer to pin D2
Sir request, can you make a video combination of buzzer and lcd 12c.
btw your videos is very helpful thanks very much sir.
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
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
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🙏
Am,azing , love it ♥
Thank you
thanks
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..."
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?
Sir did you use buzzer in hardware cause in circuit diagram there is buzzer shown in it
superb explanation sir
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?
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
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 ?
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.
I am unable to find the thumb print, the certificate is valid is not the same interface
how can i add subject too
Its really a hard work if we have hundreds of name card holder and must upload to MCU one by one
Total clear. Thanx ❤️
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.
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
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
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
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?
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?
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
Will this work with a microsoft excel
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 🙏💐
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
Can we use Arduino UNO instead of Node MCU? If yes what would be the changes in connections
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.
Below errors occured, Please help
#define SS_PIN D4
MFRC522 mfrc522(SS_PIN, RST_PIN);
#define RST_PIN D3
MFRC522 mfrc522(SS_PIN, RST_PIN);
#define BUZZER D2
pinMode(BUZZER, OUTPUT);
#define BUZZER D2
digitalWrite(BUZZER, HIGH);
Compilation error: 'D4' was not declared in this scope
We have an issue of IP request after being and get ...will u plz tell what to do now
give me some more detail
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
Is ther any synopsis u have prepared on this topic
It would be a bit help full to make this
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
URl is not able to connect what should I do???
Can we connect multiple node mcu to single google sheet .
yes, you can
How can changes on goggle sheet updates frigerprint not detected sir
Hello Sir , Rfid data code after expiry. Please suggest me
but this project is not about fingerprint
Thanks
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
is this still working on arduino IDE 2.3.0?
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! 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.
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
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 ?
very nice and good project
thanks
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.
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
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
Hi
Can I increase the range of this module upto 1meter?
Nice job !!!!!
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
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.
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
Hlo sir good experiment output will be tacken but today checking in a experiment my fingerprint data change there what we do
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.
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?
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
my googlesheet cant access. its already AVAILABLE TO Anyone.
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
Fingerprint field vlue will be changing
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
Show MFRC522 file is not found
How can i solve it.
problem:
cannot get thumprint directly by doing as shown above in the video
solution:
when going into details you will find SHA-256 fingerprint and below it you will find export and after that while saving change save as type and click all files option and then open the saved file and you will get the thumbprint as shown in the video
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 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
Very nice.....
thanks
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??
There for showing output in serial monitor but connection failed on serial monitor,
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
Script function does not found : doget
How to resolve this.??
search for "doget" in the script.gs file. and let me know if it is there
Its my fault sir.. Thank you...It work now..
@@akshadakhadangle4589 so nice of you
Hard resetting via rts pin??
Https get...failed , error: connection failed..
This msg is displayed on serial monitor....what to do sir??
Hi, great video. How plus more members?
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
Hii,
Can you lend this project for a week ?
I will pay for this .
Sir when I scan I got code 302 but thier no name is printing in Google sheet please help me 🥺
turn off ur firewall it worked..:)
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.
how can we make this in billing system? can you sent code? items,quantity,cost
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
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
Sir....one last help plz.....rfid card scan krne pe serial monitor pe read card successfully show ho rha h aur code 302 bhi but Google spreadsheet pr kuch print nhi ho rha h
kia ap ny web app url ko manually test kia hy?
@@AhmadLogs haa sir manuaally krne pe toh print ho rha h naam sheet pe
@@Lofihub_music you must watch the version two of this video. it might be helpful. th-cam.com/video/M9Sci4nsTEk/w-d-xo.html
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.
hello sir,, i dont know what happening with this,,, im try but im fail,, in moment deploy, google tell me to fix in gdrive,, so,, i wanna ask something,,, how i can fix it
thanks sir
check version 2 and version 3 of the project
v2 - th-cam.com/video/M9Sci4nsTEk/w-d-xo.html
v3 - th-cam.com/video/Bgs_3F5rL5Q/w-d-xo.html
@@AhmadLogs thanks sir
Amazing, please where WE Can buy material ? I'm from morocco
from amazon, or aliexpress
Sir please tell me why the fingerprint or server error occured in google sheet....
Error : Connection Failed.....!!
I will check it
My googlesheet didn't show certificate valid
NodeMcu (Main Code) ko code run karne par WifisecurebearConnectionssl.h : No such File directry ka error a raha hai usko kaise theek kare.
use the same version as I did
Oh-ooh-whoa-oh-oh-oh-oh
Oh-ooh-whoa-oh-oh-oh-oh
Oh-ooh-whoa-oh, oh-oh-oh-oh
You know you love me (yo), I know you care (uh-huh)
Just shout whenever (yo), and I'll be there (uh-huh)
You are my love (yo), you are my heart (uh-huh)
And we will never, ever, ever be apart (yo, uh-huh)
Are we an item? (Yo) girl, quit playin' (uh-huh)
"We're just friends" (yo), what are you sayin'? (Uh-huh)
Said, "There's another" (yo), and looked right in my eyes (uh-huh)
My first love broke my heart for the first time, and I was like (yo, uh-huh)
"Baby, baby, baby, oh"
Like, "Baby, baby, baby, no"
Like, "Baby, baby, baby, oh"
I thought you'd always be mine, mine
"Baby, baby, baby, oh"
Like, "Baby, baby, baby, no"
Like, "Baby, baby, baby, oh"
I thought you'd always be mine, mine
Oh, for you, I would've done whatever (uh-huh)
And I just can't believe we ain't together (yo, uh-huh)
And I wanna play it cool (yo), but I'm losin' you (uh-huh)
I'll buy you anything (yo), I'll buy you any ring (uh-huh)
And I'm in pieces (yo), baby, fix me (uh-huh)
And just shake me 'til you wake me from this bad dream (yo, uh-huh)
I'm goin' down (oh), down, down, down (uh-huh)
And I just can't believe, my first love won't be around, and I'm like
"Baby, baby, baby, oh"
Like, "Baby, baby, baby, no"
Like, "Baby, baby, baby, oh"
I thought you'd always be mine, mine
"Baby, baby, baby, oh"
Like, "Baby, baby, baby, no"
Like, "Baby, baby, baby, oh"
I thought you'd always be mine, mine (Luda!)
When I was 13, I had my first love
There was nobody that compared to my baby
And nobody came between us, nor could ever come above
She had me goin' crazy
Oh, I was starstruck
She woke me up daily
Don't need no Starbucks (woo)
She made my heart pound
And skip a beat when I see her in the street and
At school on the playground
But I really wanna see her on the weekend
She knows she got me dazin'
'Cause she was so amazin'
And now, my heart is breakin'
But I just keep on sayin'
"Baby, baby, baby, oh"
Like, "Baby, baby, baby, no"
Like, "Baby, baby, baby, oh"
I thought you'd always be mine, mine
"Baby, baby, baby, oh"
Like, "Baby, baby, baby, no"
Like, "Baby, baby, baby, oh"
I thought you'd always be mine, mine
I'm gone (yeah, yeah, yeah, yeah, yeah, yeah)
Now, I'm all gone (yeah, yeah, yeah, yeah, yeah, yeah)
Now, I'm all gone (yeah, yeah, yeah, yeah, yeah, yeah)
Now, I'm all gone (gone, gone, gone)
I'm gone
9544381481 call me daddy, papa, papi,appy,kundi,puri mole plssss call ok
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 enter multiple user details at a time
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.
I have a problem in final, it write:" HTTPS get: code 200" without results in sheet
just try again
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 after compilation of my code it's failing to send data to the Google sheets ..
It's showing the name of card holder properly but in the end it's showing
[HTTPS] GET.....failed, error:
connection failed
I think it is a server error. just try again and if still the same error then let me know.
Yes sir still it's showing the same ... I hve change d the fingerprints as well and have tried using 2 other nodemcu as well
@@soumyadeepkarmakar6412 OK. try it without the fingerprint.
1. just comment out the line number 119 like this //client->setFingerprint(fingerprint);
2. and un comment the line number 122 like this client->setInsecure();
and then upload the code. and give it a try.
Yes sir now it's working thank you
@@soumyadeepkarmakar6412 So nice of you