Extract Thai Gov Letters: Mistral OCR to Google Sheets

This n8n workflow streamlines processing Thai government letters received through LINE Messaging API or Google Drive uploads. It triggers on new files, performs OCR with Mistral AI's document/image models to convert scans to text, and leverages OpenAI to intelligently extract key fields like book_id, subject, recipient, signatory, date, contact info, and more.

Benefits include massive time savings for manual data entry, high accuracy for Thai language documents, seamless integration across platforms, and automatic archiving/replies to keep processes hands-free. Ideal for teams handling high volumes of official docs, reducing errors and enabling quick data analysis in Sheets.

Use cases: Thai agencies processing training certificates, notifications, or approvals; HR/L&D teams logging government-mandated learning docs; automation devs building document pipelines. Setup requires Google Sheets template, credentials for Drive/Sheets/LINE/OpenAI/Mistral, and env vars like LINE token.

Extracts fields: book_id, date, subject, to, attach, detail, signed_by, position, phone, email, download_url. Supports PDF/images, replies with summary to LINE users.