RFID Attendance System using NodeMCU and Google Sheets
Вставка
- Опубліковано 11 вер 2024
- 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...
UA-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'm amazed!!!!!
It worked in just one go!!!
Thanks! ♥
great
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!
You satisfy all our curiosity. thanks.
So nice of you
connect the buzzer to pin D2
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🙏
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
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.
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
Sir did you use buzzer in hardware cause in circuit diagram there is buzzer shown in it
Am,azing , love it ♥
Thank you
thanks
Total clear. Thanx ❤️
superb explanation sir
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
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..."
URl is not able to connect what should I do???
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 ua-cam.com/video/Bgs_3F5rL5Q/v-deo.html
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. ua-cam.com/video/M9Sci4nsTEk/v-deo.html
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
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?
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?
Its really a hard work if we have hundreds of name card holder and must upload to MCU one by one
Nice job !!!!!
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 display student ID in Google Sheets
Sir the code i am getting is 400, what to do?? Please help
Will this work with a microsoft excel
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
My googlesheet didn't show certificate valid
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?
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
Show MFRC522 file is not found
How can i solve it.
very nice and good project
thanks
Can we use Arduino UNO instead of Node MCU? If yes what would be the changes in connections
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 ?
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
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 ua-cam.com/video/wQGqydQUwRw/v-deo.html
Very nice.....
thanks
There for showing output in serial monitor but connection failed on serial monitor,
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 ?
How can changes on goggle sheet updates frigerprint not detected sir
Hi
Can I increase the range of this module upto 1meter?
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. ua-cam.com/video/Bgs_3F5rL5Q/v-deo.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) ua-cam.com/video/M9Sci4nsTEk/v-deo.html
i love u babygirl for showing me this
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
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.
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??
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 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.
Hlo sir good experiment output will be tacken but today checking in a experiment my fingerprint data change there what we do
sir iam getting this error
[HTTPS] begin...
[HTTPS] GET...
[HTTPS] GET... failed, error: connection failed
check version 4
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.
bro its not working i need your help...??
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
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.
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.
how can we make this in billing system? can you sent code? items,quantity,cost
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
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
Hello Sir , Rfid data code after expiry. Please suggest me
but this project is not about fingerprint
Thanks
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, great video. How plus more members?
how to enter multiple user details at a time
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.
I have a problem in final, it write:" HTTPS get: code 200" without results in sheet
just try again
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
is this still working on arduino IDE 2.3.0?
what is the solution for key expire?
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
Am getting this error in the serial monitor
[HTTPS] GET... failed, error: connection failed
Anyone help with this
did your code work
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
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.
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 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..:)
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
TypeError: Cannot read properties of undefined (reading 'toString') (line 37, file "Code") after entering name
watch
version 4: ua-cam.com/video/S3DmT-LmKug/v-deo.html
version 3: ua-cam.com/video/Bgs_3F5rL5Q/v-deo.html
version 2: ua-cam.com/video/M9Sci4nsTEk/v-deo.html
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
Im getting an error: Script function not found
I think you did not add the script code in the google app script
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 🙏💐
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
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
@@electronicscentre6326 you must watch the version two of this video. it might be helpful. ua-cam.com/video/M9Sci4nsTEk/v-deo.html
We have an issue of IP request after being and get ...will u plz tell what to do now
give me some more detail
[Https]Get....error:connection failed .......please tell me how can i fix it
trying
Means?
@@newpunjab2429 trying to update the code
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.
please make a video to store attendance data in php mysql database
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
Can we connect multiple node mcu to single google sheet .
yes, you can
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
my problem is:" [HTTPS] GET... code: 302"; Why?
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
Fingerprint field vlue will be changing
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??
I need a full explanation of the code
I had one error when saveing the code the error is like syntax is missing
watch the following video ua-cam.com/video/Bgs_3F5rL5Q/v-deo.html
Sir, code compile krne pe error aa rha h "d3 was not declared in this scope "" plz help
use pin 0 instead of D3
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.
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.
How to run this project without buzzer.
just remove the buzzer no need to change the code.