Get Started
Back to Templates

Extract Thai Bank Slip Data from LINE using SpaceOCR and Save to Google Sheets

Created by

Created by: Jaruphat J. || jaruphatj

Jaruphat J.

Last update

Last update 4 months ago

Categories

Share

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