Support student questions via LINE using Gemini, Google Drive, and Slack
Needs changesWhat this workflow does
This AI workflow has 9 nodes and runs when an HTTP POST request hits its webhook URL. Along the way it connects Google Sheets and Google Gemini Chat Model. It also calls api.line.me over HTTP.
How it runs
Trigger: When an HTTP POST request hits its webhook URL.
- Acknowledge LINE (Respond to Webhook): sends the response back to the webhook caller
- Set Config (Edit Fields (Set)): sets 7 fields: userId, replyToken, userMessage…
- Load Chat History (Google Sheets): read rows
- Aggregate: combines items into one
- Study Agent (AI Agent): runs an AI agent, with model: Gemini Model; 1 tool (Search Materials Tool)
- Reply via LINE (HTTP Request): calls api.line.me (POST)
Services it uses
HTTP calls to: api.line.me
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- AI Agent v1 (old agent modes) in Study Agent (v1.7): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) Study Agent (v1.7) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (9)
- Webhook
n8n-nodes-base.webhook - Respond to Webhook
n8n-nodes-base.respondToWebhook - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - Aggregate
n8n-nodes-base.aggregate - AI Agent
@n8n/n8n-nodes-langchain.agent - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Call n8n Workflow Tool
@n8n/n8n-nodes-langchain.toolWorkflow - HTTP Request
n8n-nodes-base.httpRequest
From the author
Who is this for This workflow is built for tutoring schools, cram schools, and independent teachers who want to offer students 24/7 Q&A support via LINE — Japan's most widely used messaging app. No coding knowledge is required to set it up. What this workflow…