
SuperBot: Administrative Automation Tool
Project Overview
SuperBot is an administrative automation system designed for educational settings. It helps teachers and administrators save time by automating routine tasks such as:
- Sending class reminders via LINE
- Assigning and tracking homework tasks
- Handling check-ins for teachers and students
- Calculating and exporting attendance hours
I independently developed SuperBot using:
- **Python + LINE API** for chat-based user interaction
- **Google Sheets API** for data storage and real-time synchronization
- **Heroku deployment** for public accessibility
SuperBot significantly reduced manual work, enabling teachers to focus more on teaching while ensuring accurate administrative records.
Key Features
- 1Class reminders and notifications
- 2Homework assignment and tracking
- 3Attendance check-in and timestamp logging
- 4Automated hour calculation and reporting
Technologies Used
Project Milestones
Independent System Development
AchievementDesigned, built, and deployed the entire system independently, from backend logic to LINE chatbot integration.
Google Sheets Integration
SkillUsed Google Sheets as a real-time database to enable collaborative data management.
Deployment on Heroku
SkillLearned and applied cloud deployment techniques, making the system publicly accessible.
Automating Admin Workflows
AchievementAutomated routine administrative tasks, significantly improving efficiency for teachers and staff.