Automated Receipt Processing via LINE Bot and Google Sheets

This n8n workflow automates the process of capturing transaction receipts sent via LINE messaging app, extracting relevant data, and recording it into Google Sheets for record-keeping or further analysis. It starts with a webhook trigger that listens for incoming images from LINE users. Upon receiving an image, the workflow retrieves the image content from LINE’s API, uploads it to Google Drive, then sends the image URL to the OCR Space API to extract text data. Using custom JavaScript code, it intelligently parses the OCR output to identify key transaction details such as transaction type, date, sender and receiver information, transaction ID, amount, and fees, considering variations in receipt formats (standard bank transfer or PromptPay). Finally, the extracted data is appended as a new row in a designated Google Sheet, making this workflow ideal for automating receipt logging, expense tracking, or receipt processing in financial management applications.