Automated Attendance Tracking Bot

Overview

Automated Attendance Tracking Bot is an RPA project developed using UiPath Studio that automates attendance management using Excel integration and email notifications. The bot reads attendance data from an Excel sheet, updates attendance status dynamically, filters attendance records, and automatically sends personalized attendance emails to students.

Features

• Read attendance data from Excel
• Automatically create attendance status columns
• Filter attendance records
• Send automated email notifications using SMTP
• Update attendance status in Excel
• Teacher and subject input support
• Fully automated attendance workflow

Technologies Used

• UiPath Studio
• Excel Automation
• SMTP Email Automation
• DataTable Operations
• RPA (Robotic Process Automation)

Project Structure

• Main_Major.xaml → Main workflow
• project.json → UiPath project configuration
• RPAMajorProject.xlsx → Attendance data file

How to Run

1. Open the project in UiPath Studio
2. Place the Excel file inside the project folder
3. Configure SMTP email credentials
4. Run Main_Major.xaml

Author

Subhasmita Sendh