SuperBot: Administrative Automation Tool

July 2024Completed

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

PythonLINE APIGoogle Sheets APIHeroku

Project Milestones

💻

Independent System Development

Achievement

Designed, built, and deployed the entire system independently, from backend logic to LINE chatbot integration.

📊

Google Sheets Integration

Skill

Used Google Sheets as a real-time database to enable collaborative data management.

☁️

Deployment on Heroku

Skill

Learned and applied cloud deployment techniques, making the system publicly accessible.

⚙️

Automating Admin Workflows

Achievement

Automated routine administrative tasks, significantly improving efficiency for teachers and staff.