This project presents a smart real-time tracking system for monitoring the movement and usage of critical medical equipment. It integrates RFID and GPS technologies with Wi-Fi-based data logging to Google Sheets, enabling centralized, live equipment tracking.
The system comprises two independent circuits:
- Uses ESP8266 with RC522 RFID module to scan RFID tags.
- Sends scanned tag data to Google Sheets via Wi-Fi.
- Uses ESP32 with NEO-6M GPS module to capture location data.
- Sends real-time GPS coordinates to Google Sheets.
Both units transmit data to a shared Google Sheet, displaying timestamps, RFID IDs, and clickable map links for location visualization.
| File Name | Description |
|---|---|
| Device.ino | Uploaded to ESP32. Captures GPS data via the NEO-6M module and transmits it with the corresponding RFID tag ID to Google Sheets. |
| RFID.ino | Uploaded to ESP8266. Handles RFID scanning using the RC522 module and sends tag IDs to Google Sheets. |
| Write_to_rfid_tag.ino | Uploaded to ESP8266. Used to program or write data to RFID tags. |
Live Google Sheet - RFID Location Tracking
| Timestamp | Tag ID | Latitude | Longitude | Map Link |
|---|---|---|---|---|
| 2025-04-19 12:32:45 | OxygenTank-283 | 25.5397 | 84.849556 | Open |
- Real-time tracking using GPS-enabled ESP32
- RFID-based identification with ESP8266 + RC522
- Automated data logging to Google Sheets via IFTTT
- Timestamped records with location and tag ID
- Interactive Google Maps links for quick navigation
- Modular architecture for independent operation of scanning and tracking units
| Component | Function |
|---|---|
| ESP32-WROOM | Wi-Fi microcontroller for GPS data handling |
| ESP8266 NodeMCU | Wi-Fi microcontroller for RFID scanning |
| NEO-6M GPS Module | Provides real-time location data |
| RFID-RC522 Module | Scans RFID tags |
| MFRC522 Tags | Equipment identification |
| Power Modules | 3.3V / USB regulated power supply |
| RC522 Pin | ESP8266 Pin |
|---|---|
| SDA | D4 |
| SCK | D5 |
| MOSI | D7 |
| MISO | D6 |
| RST | D3 |
| VCC | 3.3V |
| GND | GND |
The ESP8266 connects to Wi-Fi and transmits the scanned tag ID via IFTTT Webhook.
| NEO-6M Pin | ESP32 Pin |
|---|---|
| TX | GPIO16 |
| RX | GPIO17 |
| VCC | 3.3V |
| GND | GND |
The ESP32 captures and sends GPS coordinates to Google Sheets using a separate IFTTT webhook.
- Arduino IDE – for programming ESP32 and ESP8266
- IFTTT Webhooks – for automated data transfer
- Google Sheets – for real-time data logging and visualization
WiFi.hHTTPClient.hMFRC522.hSPI.hSoftwareSerial.hTinyGPSPlus.h
- RFID Tag Scan: The ESP8266 reads the RFID tag ID using the RC522 module.
- GPS Tracking: The ESP32 captures live coordinates via the NEO-6M GPS module.
- Data Logging: Both devices send data (timestamp, tag ID, latitude, longitude) to Google Sheets using Wi-Fi and IFTTT.
- Live Monitoring: The sheet auto-updates with clickable Google Maps links for easy equipment tracking.
Developed as part of EE341 – Electromagnetic Theory course project at IIT Patna.
A practical initiative bridging healthcare and technology through intelligent, real-time tracking systems.