Extract data from Thai Government letters with Mistral OCR and store in Google Sheets

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 information extraction, saving results to a Google Sheet.

---

Who’s it for?

- Thai government agencies or teams receiving official documents via LINE or Google Drive - Automation developers working with document intake and OCR - Anyone needing to extract fields from Thai scanned letters and store structured info

---

What it does

This n8n workflow: 1. Receives documents from two sources: - LINE webhook (via Messaging API) - Google Drive (new file trigger) 2. Checks file type (PDF or image) 3. Runs OCR with Mistral AI (Document or Image model) 4. Uses OpenAI to extract key metadata such as: - bookid - subject - recipient (to) - signatory - date, contact info, etc. 5. Stores structured data in Google Sheets 6. Replies to LINE user with extracted info or moves files into archive folders (Drive)