Automates LINE based student Q&A from initial question to escalation and logging.
This AI agent handles LINE questions, looks up past chats in Google Sheets, and retrieves relevant materials from Google Drive. Gemini generates clear explanations and replies directly in LINE. If no confident answer exists, it escalates to Slack and logs every interaction in Sheets for ongoing coaching.
End-to-end automation: from question capture to response and logging.
Read LINE messages and extract student context.
Query Google Sheets for conversation history.
Search Google Drive for relevant study materials.
Generate clear explanations with Gemini.
Reply in LINE with the answer.
Escalate to Slack when content is insufficient and log in Google Sheets.
This AI agent replaces manual back-and-forth by automating lookup, response, and escalation. before → 5 real pain points are highlighted below; after → 5 clear outcomes are achieved.
A simple 3-step flow that non-tech users can follow.
When a student sends a question on LINE, the AI agent reads the message and loads the chat context from the history sheet.
The AI agent searches the Google Sheets history and scans the Google Drive folder for relevant study materials.
If Gemini can answer confidently, the agent replies in LINE; otherwise it escalates to Slack and logs the interaction in Google Sheets.
A typical scenario shows how a question is handled end-to-end.
Scenario: A student asks on LINE about photosynthesis. The agent looks up prior Q&A in Sheets, finds a relevant section in Drive, and returns a clear explanation in LINE within 2 minutes. If no direct match is found, the agent escalates to Slack and logs the interaction for follow-up.
People and teams who run LINE-based tutoring programs.
Receives quick, consistent answers in LINE.
Uses escalation to handle complex questions without blocking students.
Gains visibility into question trends from Google Sheets.
Ensures responses align with current materials in Drive.
Manages escalations to Slack channels efficiently.
Provides scalable LINE-based Q&A for clients.
Core tools connected to the AI agent workflow.
Receives student messages and delivers responses in LINE.
Stores conversation history and resolution status for each student.
Stores and retrieves teaching materials used in responses.
Receives escalation notifications for teacher follow-up.
Generates explanations and answers in natural language.
Situations where the AI agent adds value in education.
Common concerns about the AI agent in this LINE Q&A workflow.
The agent connects to LINE via the LINE Messaging API to receive student messages in real time. It authenticates securely and only reads messages that users send in the LINE bot channel. The flow preserves context from prior messages stored in Google Sheets. The agent responds with the established format and logs the interaction for future reference.
Conversation history, questions, and resolution status are stored in Google Sheets. Materials referenced in Drive are within your own Drive organization. Escalation notes in Slack are sent to your designated channels. Access is controlled by your Google and Slack permissions, and we recommend restricted access for student data.
Answers are generated by Gemini using the student query, the conversation history, and the relevant materials located in Drive. The AI prompts are tuned to match the desired language level. If Gemini cannot confidently answer, the system routes the question to a human in Slack.
A confident answer is one supported by the materials in Drive and conversation history in Sheets, with a clear, concise explanation. If the content relies on interpretation or requires a human review, the AI agent escalates to Slack. The escalation ensures accuracy before sharing with the student.
Escalation messages include the student context and a link to the Sheet entry. A teacher reviews the question and provides a final answer to post back to LINE. The system logs the escalation outcome in Sheets for traceability.
Yes. You can customize Gemini prompts to adjust explanation style, and swap the Drive source or add other repositories for material lookup. The configuration can be changed without code by editing the prompts and mapping rules in the AI agent. This keeps answers aligned with your pedagogy.
If no matching material exists, the agent will escalate to Slack with a summary of the topic and what was attempted. The teacher can add notes or update Drive to enrich future answers. The incident is logged in Google Sheets for follow-up and improvement of materials.
Automates LINE based student Q&A from initial question to escalation and logging.
