Line chatbot with Google Sheets memory and Gemini AI
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: AI Agent v1 (old agent modes). 1 breaking item(s) found. Static check, last run 2026-10-19.
What 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 Gemini Chat Model and Google Sheets. It also calls api.line.me over HTTP.
How it runs
Trigger: When an HTTP POST request hits its webhook URL.
- Edit Fields (Edit Fields (Set)): sets 3 fields: body.events[0].message.text, body.events[0].replyToken, body.events[0].source.userId
- Get History (Google Sheets): uses Google Sheets
- Prepare Prompt (Edit Fields (Set)): sets 1 field: Prompt
- AI Agent: runs an AI agent, with model: Google Gemini Chat Model
- Split History (Code): runs custom JavaScript code
- Save History (Google Sheets): append or update
- 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 AI Agent (v1.8): 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) AI Agent (v1.8) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (7)
- Webhook
n8n-nodes-base.webhook - AI Agent
@n8n/n8n-nodes-langchain.agent - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code
From the author
Main Use Case This workflow enables automated, AI-assisted replies to users messaging a LINE Official Account, while storing and referencing chat history from Google Sheets to maintain context. Ideal for businesses or support teams that want to provide smart,…