Automated Receipt Processing from LINE to Google Sheets

This n8n workflow automates the process of capturing receipt images sent via LINE Messenger, extracting transaction details through OCR, and logging the data into Google Sheets and Google Drive. The workflow begins with a webhook triggered by a LINE message containing an image. The image URL is fetched and uploaded to Google Drive for storage. An OCR API then processes the image to extract vital transaction data such as transaction type, date, sender and receiver details, transaction ID, amount, and fees. The extracted data is parsed and organized with custom code, handling different transaction types like PromptPay and standard bank transfers. Finally, the information is stored in a designated Google Sheet, enabling seamless record-keeping and automation for financial tracking or expense management.