Introduction: Attendance System With Storing Data on Google Spreadsheet Using RFID and Arduino Ethernet Shield
Hello Guys,
Here we come up with very exciting project and that is how to send rfid data to google spreadsheet using Arduino. In short we are going to make an attendance system based on rfid reader which will save attendance data in real time to google spreadsheet.
Step 1: Software Used:
These are the software we have used for this project:
1. Arduino IDE: You can download the latest Arduino IDE from this link:
https://www.arduino.cc/en/Main/Software
2. Google Drive: you need to use some of the apps from your google drive and first one is google sheet and another one will be google app script, where you need to write your google script.
3. Pushingbox: this tool you need to use to push data from your arduino to google sheet, as directly you can not send data from arduino to google sheet, so this is the third party tool which you need to use. You can just go to this page and just log in with google.
Step 2: Components Used:
1) Arduino UNO:
Arduino/Genuino Uno is a microcontroller board based on the ATmega328P (datasheet). It has 14 digital input/output pins (of which 6 can be used as PWM outputs), 6 analog inputs, a 16 MHz quartz crystal, a USB connection, a power jack, an ICSP header and a reset button.
2) Ethernet Shield:
The Arduino Ethernet Shield 2 connects your Arduino to the internet in mere minutes. Just plug this module onto your Arduino Board, connect it to your network with an RJ45 cable and follow a few simple steps to start controlling your world through the internet. As always with Arduino, every element of the platform – hardware, software and documentation – is freely available and open-source. This means you can learn exactly how it's made and use its design as the starting point for your own circuits. Hundreds of thousands of Arduino Boards are already fueling people’s creativity all over the world, every day.
3) RFID RC522 Reader with Tag:
There are cheap RFID modules that can read and write Mifare's tags and being sold at several web stores, like eBay and included with many "starter kits" nowadays. Simply search RFID-RC522 (MF-RC522). The microcontroller and card reader uses SPI for communication (chip supports I2C and UART protocols but not implemented on library). The card reader and the tags communicate using a 13.56MHz electromagnetic field.
Step 3: Circuit Diagram:
Circuit Diagram of this project is given above.
You need to connect ethernet shield first as shown in above image then you need to make the rfid connection
below is the connection pins for arduino and rfid reader
RFID-RC522 Arduino UNO Arduino Mega
RST 9 9
SDA(SS) 4/10 4/53
MOSI 11 51
MISO 12 50
SCK 13 52
VCC 3.3 v 3.3v
GND GND GND
IRQ is not connected
Please make sure one thing that we are using two SPI devices so SDA(SS) is already used with Ethernet shield so we have to use separate pin for SDA(SS) in case of RFID-RC522 so that there will not be any conflict between two SPI devices
Step 4: Library:
You need to install one library for rfid rc522. You can get the library from this link
Step 5: Code:
You can get the source code of this project from our github page. Here is the github link for that
Step 6: Video of Project:
The whole Project Description is given in above video
If you have any doubt regarding this project feel free to comment us below.
And if you want to learn more about embedded system you can visit our youtube channel
Please visit and like our Facebook Page for frequent updates.
Thanks & Regards,
Embedotronics Technologies