Extract order details from LINE messages and photos to Google Sheets with OpenAI
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 8 nodes and runs on Line Messaging events (message). Along the way it connects Google Sheets, OpenAI Chat Model and Line Messaging (community).
How it runs
Trigger: On Line Messaging events (message).
- Route by Message Type (Switch): routes items into 2 branches
- AI Agent: runs an AI agent, with model: OpenAI GPT-4o; 1 tool (Append Row to Google Sheets); memory: Simple Memory
- Download LINE Image (Line Messaging Data): uses Line Messaging Data
- Reply via LINE (Line Messaging): uses Line Messaging
Services it uses
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 - Order Extractor1 (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) AI Agent - Order Extractor1 (v1.7) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (8)
- Google Sheets Tool
n8n-nodes-base.googleSheetsTool - Line Messaging
@aotoki/n8n-nodes-line-messaging.lineMessaging - Line Messaging Data
@aotoki/n8n-nodes-line-messaging.lineMessagingData - Switch
n8n-nodes-base.switch - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Simple Memory
@n8n/n8n-nodes-langchain.memoryBufferWindow - Line Messaging Trigger
@aotoki/n8n-nodes-line-messaging.lineMessagingTrigger
From the author
Extract order details from LINE messages and photos to Google Sheets with OpenAI Automatically extract order information from text messages or handwritten memo photos sent via LINE, confirm with the user, and append to a Google Sheets tracking sheet. How it…