Back to Projects
SuperBot: Administrative Automation Tool

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.