ESP RFID: Google Sheets as a database for rfid cards

ESP: Google Sheets as a database for rfid cards

In this project Google Sheets are used to store access data for rfid cars and for attendence logging

code:

libs:

Aliexpress

[katsuoofficial]

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

[MICHAELJOEREGULACION]

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

[mintz]

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 ??

[arvinaliabimanyu]

I'm having a problem with the arduino code in position

client. setInsecure();

how to solve it?

[kenobz]

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

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

[uniqueautomationelectronic]

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

[calebrobinson]

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

[settlers]

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

[eiki]

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

[Minionlovergirl]

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?

[feruzrajabboyev]

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

[ilikememes]

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?

[undaunted]

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

[mesotime]

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,

[franciscojavierhernandezme]

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

[مريم-مناف-عدنان]

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

[habilisaidi]

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

[مريم-مناف-عدنان]

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.

[Minionlovergirl]

awsome project and explanation love it