LINE BOT - Google Sheets Record Receipt

This workflow is ideal for:

• Small Business Owners: Who need to automate financial record-keeping from transactions received via LINE.
• Accountants: Looking for efficient ways to record and manage transaction data without manual entry.
• Developers: Interested in integrating LINE messaging with Google Sheets for data management.
• Finance Professionals: Who require a streamlined process for capturing and analyzing transaction details from images.

This workflow addresses the challenge of manually recording transaction details from image slips received via LINE. It automates the process by:

• Extracting Image Content: Automatically retrieves images sent through LINE, eliminating the need for manual downloads.
• Data Extraction via OCR: Utilizes OCR technology to extract key information such as transaction amount, date & time, sender and receiver details, and transaction ID from the images.
• Automated Record Keeping: Directly records the extracted data into Google Sheets, ensuring accurate and timely financial records without human error.

The workflow consists of the following steps:

1. LINE Webhook Trigger: The process starts when an image slip is sent via LINE, triggering the webhook.
2. Extract Image URL: The URL of the image is extracted from the webhook data.
3. Download Image: The image is retrieved and converted to binary format for further processing.
4. Upload to Google Drive: The binary image is uploaded to Google Drive, allowing for easy access and storage.
5. Send Image to OCR API: The URL of the uploaded image is sent to the OCR API for text extraction.
6. Extract Transaction Details: The extracted text is processed to identify and structure important transaction details such as amount, fees, and transaction ID.
7. Record in Google Sheets: Finally, the structured transaction data is appended to a designated Google Sheets document for record-keeping.