Automated OCR & Data Logging from LINE and Google Drive

This n8n workflow streamlines the process of capturing images and documents from LINE messages and Google Drive, extracting relevant data through OCR and AI-powered analysis, and logging the information into Google Sheets. The workflow begins with a webhook listening for incoming messages from LINE, where it downloads images or files. Simultaneously, it monitors a specific Google Drive folder for new files. Both sources’ data are combined, and file types are checked to determine the appropriate OCR method, whether for images or PDFs, using Mistral AI. Extracted text is then processed with OpenAI’s language models to identify key data fields like book ID, date, and subject. Finally, the structured data is appended to a Google Sheet, and a response is sent back to LINE confirming the successful logging of information. Practical use cases include automating invoice or document processing received through LINE or Google Drive, reducing manual data entry, and ensuring organized file management.