Extract order details from LINE messages and photos to Google Sheets with OpenAI

Go to Workflow
0 views
Built by daisuke daisuke
Created on June 20, 2026

Description

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 works

Receives text or image messages from LINE Messaging API
Routes messages by type — text goes directly to the AI Agent, images are first downloaded via LINE API
The AI Agent (GPT-4o) analyzes the input, extracts order details, and asks the user for confirmation
Once approved, the order is appended as a new row in Google Sheets

Setup steps

LINE Messaging API: Create a LINE channel and set the webhook URL to this workflow's trigger endpoint
OpenAI Credentials: Set up your OpenAI API key in n8n Credentials
Google Sheets Credentials: Set up Google Sheets OAuth2 in n8n Credentials
Configure Spreadsheet: Open the "Append Row to Google Sheets" node and set your Spreadsheet ID and sheet name
Activate the workflow

Nodes Used (3)

AI Agent
@n8n/n8n-nodes-langchain.agent
OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi
Simple Memory
@n8n/n8n-nodes-langchain.memoryBufferWindow