Back to Projects
SuperBot: Administrative Automation Tool

SuperBot: Administrative Automation Tool

July 2024Completed

Why this project exists

The problem

When I started running Superb Education, attendance, homework follow-ups, and repeated schedule questions consumed time I needed for teaching and student support.

The product idea

I built a LINE assistant that students could use in a familiar chat, with Google Sheets behind it to record check-ins, answer routine questions, and keep the admin work moving.

OVERVIEW

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.

WATCH IT IN ACTION

Video Showcase

DESIGN & DECISIONS

Key Features & Design

Problems, approaches & trade-offs

Handle administration in a familiar chat

Independently build a LINE assistant for class reminders, homework tracking and attendance.

Why it matters

Running an education business involves repeated queries and recording that take time from teaching and student support.

Design considerations

Connect chat commands to Google Sheets records and summaries, using an interaction students already know.

THE USER JOURNEY

How it works

  1. Set up classes and tasks

  2. Send reminders through LINE

  3. Collect homework and check-ins

  4. Calculate hours and export records

BUILT WITH

Technologies Used

PythonLINE APIGoogle Sheets APIHeroku

EXPERIENCE & OUTCOMES

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.

<Pierre />

Full-stack developer building mobile apps, web platforms, and AI learning tools from idea to release.

Contact Info

  • b12705058@g.ntu.edu.tw
  • +886 963 779 263

© 2026 Pierre Chen. All rights reserved

Build v2.0.0 • Optimized for innovation