Extract data from Thai Government letters with Mistral OCR and store in Google Sheets
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 16 nodes and runs when an HTTP POST request hits its webhook URL (plus 1 other trigger). Along the way it connects Google Drive, Google Sheets and OpenAI Chat Model. It also calls api.line.me over HTTP.
How it runs
Trigger: When an HTTP POST request hits its webhook URL (plus 1 other trigger).
- Get Line File (HTTP Request): calls an HTTP API
- Download File (Drive) (Google Drive): download
- Set Line Data (Edit Fields (Set)): sets 3 fields: source, fileName, fileId
- Set Drive Data (Edit Fields (Set)): sets 3 fields: source, fileName, fileId
- Merge: merges the data from its input branches
- Check File Type (If): checks a condition and branches into true / false
- Extract text IMG (Mistral AI): uses Mistral AI
- Extract text PDF (Mistral AI): uses Mistral AI
- Information Extractor: extracts structured fields from text with AI, with model: OpenAI Chat Model
- Write to Google Sheet (Google Sheets): append
…plus 3 more steps. See the full node list below.
Services it uses
HTTP calls to: api.line.me
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (11)
- Webhook
n8n-nodes-base.webhook - HTTP Request
n8n-nodes-base.httpRequest - Edit Fields (Set)
n8n-nodes-base.set - Google Drive Trigger
n8n-nodes-base.googleDriveTrigger - Google Drive
n8n-nodes-base.googleDrive - Merge
n8n-nodes-base.merge - If
n8n-nodes-base.if - Google Sheets
n8n-nodes-base.googleSheets - Information Extractor
@n8n/n8n-nodes-langchain.informationExtractor - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Mistral AI
n8n-nodes-base.mistralAi
From the author
LINE OCR Workflow to Extract and Save Thai Government Letters to Google Sheets This template automates the extraction of structured data from Thai government letters received via LINE or uploaded to Google Drive. It uses Mistral AI for OCR and OpenAI for…