Automated Extraction of Thai Bank Slip Data from LINE to Google Sheets

Overview

This workflow automates the extraction of transaction details from Thai bank slip images received via LINE chat. Leveraging OCR technology, it streamlines data capture and storage in Google Sheets for efficient record-keeping.

Key Features

• Receives bank slip images through a LINE chatbot webhook.
• Downloads and converts the image to binary format for processing.
• Uploads the image to Google Drive for secure storage.
• Sends the image URL to SpaceOCR for accurate text extraction.
• Parses and extracts key transaction details such as amount, date, and account information.
• Automatically records the extracted data into a designated Google Sheet.

Benefits

• Eliminates manual data entry, reducing errors and saving significant administrative time.
• Ensures real-time, accurate logging of financial transactions.
• Centralizes transaction records for easy access and reporting.
• Enhances operational efficiency for finance and accounting teams.

Use Cases

• Financial teams automating receipt and reconciliation of payment slips.
• Businesses tracking customer payments received via bank transfers.
• Organizations needing a digital archive of transaction slips for compliance or auditing.

Integrations

• LINE (chatbot/webhook)
• Google Drive
• Google Sheets
• SpaceOCR (OCR API)