🔬 Extract Thai bank slip data from LINE using SpaceOCR and save to Google Sheets

⚡ 2,625 views · 🔬 Document Extraction & Analysis

Description

Who is this for?

This workflow is ideal for businesses, accountants, and finance teams who receive bank slip images via LINE and want to automate the extraction of transaction details. It eliminates manual data entry and speeds up financial tracking.

What problem does this workflow solve? Many businesses receive bank transfer slips via LINE from customers, but manually recording transaction details into spreadsheets is time-consuming and error-prone. This workflow automates the entire process, extracting structured data from the bank slips and storing it in Google Sheets for seamless record-keeping.

What this workflow does:

• Receives bank slip images from LINE BOT
• Extracts transaction details (sender, receiver, amount, transaction ID) using SpaceOCR
• Automatically logs extracted data into Google Sheets
• Works with Standard Bank Slips & PromptPay transactions
• Eliminates manual data entry and reduces errors

Setup Instructions:

1. Prerequisites

• A LINE BOT with Messaging API enabled
• A SpaceOCR API Key (Get from https://spaceocr.com/)
• A Google Sheets account to store extracted data
• An n8n instance running (Cloud or Self-hosted)

2. Setup Google Sheets

Create a Google Sheet with the following structure:

A (Date) B (Time) C (Sender) D (Receiver) E (Bank Name) F (Amount) G (Transaction ID)

• Ensure your Google Sheets API is enabled and connected to n8n.

For an example of the required format, check this Google Sheets template: Google Sheets Template

3. Configure n8n Workflow

1. Webhook Node (Receives bank slip from LINE BOT)

• Set method: POST
• Set Path: /line-webhook

2. HTTP Request (Download Image from LINE Message)

• Retrieves image URL from the LINE message payload

3. SpaceOCR Node (Extract Text from Bank Slip)

• Input: image URL from LINE
• API Key: Your SpaceOCR API Key

4. Google Sheets Node (Save Transaction Data)

• Select your Google Sheet
• Map extracted data (sender, receiver, amount, etc.) to the respective columns

4. Deploy & Test

Activate the workflow in n8n Set Webhook URL in LINE Developer Console Send a test bank slip image to the LINE BOT Check Google Sheets for extracted transaction data

🔗 Nodes Used

Google Sheets, HTTP Request, Webhook, Google Drive

📥 Import

Download workflow.json and import into n8n: Workflow menu → Import from File

📖 Importing guide · 🔑 Credential setup