ESP RFID: Google Sheets as a database for rfid cards 

Can you make a tutorial like this using Esp8266 mfrc522 and adafruit oled display with database 🙏🙏🙏

C:\Users\sathwik reddy\OneDrive\Desktop\aurdino fid fid.ino:2:10: fatal error: MFRC522.h: No such file or directory 2 | #include | ^~~~~~~~~~~ compilation terminated. exit status 1 Compilation error: MFRC522.h: No such file or directory i got error

We ain't going to learn if we're just going to copy your code. 👎

Can you please help me When I upload the code on arduino ide it said leaving .... Hard resetting via RTS pin Please answer me soon.

Hello sir, I have a problem in reading the card UID (It's actually reading but the reading is in the serial monitor) and if I tap any card or tag the buzzer keep making a sound. How can I fix this problem ??

Nice bro! But... WIN7???

Hello, great tutorial, what do I do for a new account in google sheets, I want to add new information in the list, for example, the customer's phone number

pls reply bro i have project expo

anyboards I'm sorry, I know that I bother you with a lot of questions. But can you tell me how I can send only one column content which is the card number. It is in my possession and stored as a variable. Please tell me how I can send it alone.please

Hi anyboards. First of all great work its a really nice project. i am trying to use your project and i am from portugal and the time zone here is UTC +0 or GMT i already tried both and the time on the google sheets continues to appear the hours that is in CST. Can you help me pleaze.

Sir WiFi name and Password konsa dalna hai?

how can you send text or words to the google sheets from esp8266?? because right now, I can only send float data

Hi Guys on one mac i'm getting an error: In function 'String sendData(String, char*)': warning: ISO C++ forbids converting a string constant to 'char*' [-Wwrite-strings] on other is working like a charm. Why? Help pls

I have tried this program use esp8266. But i wanted to ask to you , why the data have delay when sent data to google spreadsheet. I calculated this delay 6-10 second after tapping rfid card. What the solution for this prgram . Maybe it have delay only 1-2 seconds.. thank you

Hi there, I connected everything accordingly but Arduino IDE error warning: "Communication failure, is the MFRC522 properly connected?" Keeps appearing, please help

HI, can you help me in this!! iam getting this error while compiling >>

hi Anyboards thank you for the tutorial, it's awesome. i've try your code with esp32, sending data to google sheets log file working just fine. But i can't receive any data from google sheets to my esp32. It seems that the function 'sendData' has no return value that can processed next to function 'HandleDataFromGoogle'. i've tried to print this 'sendData' return value to arduino serial monitor but only got a blank value. if you have any suggestion to this problem can you please tell me? Thankyou,

I'm having a problem with the arduino code in position client. setInsecure(); how to solve it?

Exellent work thank you very much

hello sir sorry i got this error any idea on how to solve it 'class BearSSL::WiFiClientSecure' has no member named 'verify'

OMG IT WORKS. THANKS BROOOOOOOOOOOOOOOOOOOOOOOOOOO. THX THX THX. Alhamdulillah..

Very cool! I have a question, can I not make it instantaneous and make it so you need to press a button for it to send on the excel? Will the code change that much?

Thanks.

I tried it and it didn't work nothing was sended to Google sheet Any idea Please

Thanks man, it really helps me!

i am working on project now i have 1 month left for rfid finger validation code to expire so i want to update after next month what should i do

I adapted it to esp32, but no information is coming to esp32

Thanks for your work I have question what is that fingerprint? and we use it for what?

How could I modify this to use NFC cards and a reader plugged directly into my computer to run an attendance system?

I just want to store the rfid scans into google sheets. Can you help me ?

nonsense

Card uid is not appearing on log google spreadsheet when RFID tag is shown. What can I do? Please suggest answer

Thanks, I giveme: Exception: Argument no valid: id (línea 83, archivo "Código"). What is the problem?

Which version of esp8266 should be used ? I mean model number? Your ali express link shows 3 types of boards ?

why is my spreadsheets doesnt have scrip editor

i dont get it if the spreadsheet with UID and names are stored in different sheet then how the nodemcu able to detect the name?

Hello can you help me i got something problem

can you make it again using esp32 ?

I'm getting a error msg scrip not found:doGet() What to do?

BIG THANKS BRO

Hi, may i ask something? If i just want to sent UID to Google Sheets, where parts of the code and script that i have to delete? Thanks,

can i know how to add variable like i want to put Stuednt id

what i need to if nodemcu dont found google sheets at lcd wrote "was not found otB s all we know

hello there i'm having a problem that says 'class BearSSL::WiFiClientSecure' has no member named 'verify any help?

really helpful tutorial, if i wanted to add a column into the use profile sheet for email address and then check if the user-relative to their UID-has provided a valid email address and then allow them to scan if they have provided an email address and deny if they havent how would I do this?thanks

i have a problem "ReferenceError: emailAddress is not defined" this problem at google script . what need i do?

Thx man could you please share the wire diagram

everything works. but can't read data back from the sheet anyone know the solution?

Hi I really like your project and would like bit of more help from you in regards to adding some more features to it. If you can help me then please let me know and I will pay for it. Thanks

i would be happy if you could share your circuit connection diagram

Hi Anyboards Great job on the tutorial. Can u tell me the advantage of using Arduino over just simply hooking up an RFID reader to a computer that runs Google sheet? To me it seems it would result in the same outcome. Thnx in advance

Thank your for this tutorial, this is what what I need for my system .

Hello! Sir How do I remove LCD function?

Cannot read property 'getActiveSheet' of null (baris 46, file "Kode")

Hi , How can I set the time zone according to Turkey?

Hello, currently i have a problem where it doesn't send my data to the spreadsheet. In the serial com, it says The requested URL /1.1 was not found on this server. what can i do to fix this?

Really usefull tutorial.. In my project,when a card is scanned,the location of cardholder will send to google sheet.here i want to add gps url along with rfid datas,how do i add another column in the google sheet for url ? Thanks in advance @anyboards

i can't rename "Who are you?" in program ,how to rename ?? please help me

which library we have to include if we have esp32 instead of esp8266? please tell me it's urgent!!

@anyboards how to give name in uid? And how to send data from Google spreadsheet to LCD of the nodemcu?

Hi. Did you use active or passive buzzer?

can it works without lcd and buzzer?

can i replace rfid with fingerprint sensor ?

Can you please make a video about using RFID and arduino and nodemcu to send data to Google sheet (student attendance system) I need it very soon .its for my graduation project... Thank you

Will it work while Internet is down for some time ? Will it update the data later when internet resume or will loose the information

actually i get the card uid when i add this command Serial.print(uid); everything seems alright but i cant get my card id entered into the spreadsheet.. like u do at 4:41 please help me.. i think its because this error .... when i paste my webapp link in a net tab i get this error from google = Script function not found: doGet this funtion is not present in the code.gs

I got error class bearssl::wifi client secure has no member named verfiy what can do i tried many times

awsome project and explanation love it

hello, what should I do if I want to add another variable in the data to be transmitted on the drive?

Hey i don't know you can change the name associated to the UID in untilted Spread Sheet.

Hello, I made the adaptation to ESP32, but it does not give me feedback on the RFID parameters that are stored in Google Sheets, it only saves them. What would I have to do to read them ... in advance thank you very much

me sale error "no matching function for call to 'LiquidCrystal_I2C::begin()'" que hago??

Is it possible to log IN and OUT entries ?

Can a rfid card be programmed to a remote control that can be pressed from a distance?

Hi, excellent work ! I have no I2C LCD here but only SPi LCD 16x2 or Oled 128X64 SSD1306. Could you help me to adapt the sketch?

Thanks sir, it helps me a lot. And also i want to add sg90 servo can you teach me how?

Good work, can you make a tutorial using the rdm600?

Can I get a circuit diagram for this sir?

Is it possible to read google sheet data from the Arduino side? Thanks

Como puede modificarse para que la lectura sea mas rápida entre usuario y usuario?, se puede?, saludos y gracias por el aporte.

sir only date added in google sheet and in com port wrong parameter show

Thanks man , it was helpful i just modfied by adding servo into this project ,it works ! and can i have a in and out time duration code?

Hi, can I use OLED display instead of LCD display? If yes then what changes has to be made in code. Also how can I give different name for each tag? Please reply as soon as possible

hello can u share the code for esp32 if we want to perform this experiment using esp32

Can i get the esp32 version of this

Thanks Man... It works

how to set the timezone

can i use nodeMCU esp8266

hello i'm working on a project like this and i cannot link the name to each iud please help me

excellent work!! you are awesome! just one thing... how can I add a log out time when they scan it again? i want to use it in my hotel for check in's and check out's... to know how many nights the people stay in.

Hello, I'm not sure if you're gonna respond or not but if you do, it'll really help. I keep getting this error 'class BearSSL::WiFiClientSecure' has no member named 'verify' when trying to compile the code. Any idea how to fix it? If you need more info on the error, I'd be more than happy to email you if you don't mind.

that's really cool, thanks for the knowledge, good job sir