LINE Bot, Google Apps Script, and Google Sheets Teaching Website

Overview

What this site teaches

The goal is not to teach isolated clicks. The site explains how setup, data flow, conversational routing, file management, and AI extensions work together as a teachable and maintainable system.

01

Build the minimum system

Set up a LINE channel, Google Sheet, Google Drive, and Apps Script web app.

02

Read the backend logic

Understand events, routers, prompts, worksheets, and logging instead of treating the bot as a black box.

03

Create useful workflows

Implement file upload, summarization, Q and A, report generation, and information lookup.

04

Extend toward projects

Move from a classroom bot to research, administration, or product-oriented agent workflows.

Site Map

Flow aligned with the original source document

The page order below follows the original Part 1 structure of the teaching document rather than a newly invented layout.

1. Overview

Explain what the LINE assistant can do and why the workflow matters.

2. System architecture

Map the system to message intake, AI reasoning, memory, storage, and orchestration.

3. First-time setup

Complete Sheet, Drive, Apps Script, API key, and Webhook setup in the original order.

4. Admin functions

Review admin tools, rich menu control, and maintenance entry points.

5. Core functions

Cover file Q and A, report generation, Threads posting, search, and practical commands.

Appendix: APIs and extension resources

Collect official docs, public course links, playlists, and practice tasks.

Teaching Assets

Visual explanations matter

This site preserves diagrams and screenshots from the original materials so learners can connect setup steps with actual interfaces and data structures.

A worksheet can function as a memory layer, key registry, and workflow tracker.

Google Drive serves as the file vault and output space for generated reports.

Research Extension

Patent-oriented diagrams are included when needed

The site selectively incorporates figures from the LINEBOT_專利 folder to show how a classroom bot can evolve into a multi-source conversational system with routing, data layers, and structured outputs.