n8n templatesn8n templates

LINE BOT - Google Sheets Record Receipt

This workflow automates the processing of transaction receipt images received by a LINE chatbot. By uploading the images to Google Drive and using OCR technology to recognize the information within them, the system can accurately extract transaction details and automatically record the data in Google Sheets. This process significantly enhances the efficiency and accuracy of manual data entry, addressing the challenge of structuring image information for storage. It is suitable for scenarios where efficient management of transaction receipts is needed, such as in finance departments, individuals, and small businesses.

Workflow Diagram
LINE BOT - Google Sheets Record Receipt Workflow diagram

Workflow Name

LINE BOT - Google Sheets Record Receipt

Key Features and Highlights

This workflow enables the automated receipt of transaction receipt images from a LINE chatbot, uploading them to Google Drive, invoking OCR services to extract transaction information from the images, and automatically recording the parsed detailed transaction data into Google Sheets. Core highlights include automated image acquisition and processing, accurate OCR text extraction, and custom code for parsing transaction details, significantly improving the efficiency and accuracy of manual data entry.

Core Problems Addressed

  • Manual organization and entry of transaction receipt information is tedious and error-prone;
  • Receipt image data is difficult to store in a structured format directly;
  • Parsing diverse transaction formats (e.g., standard bank transfers and PromptPay) is complex;
  • Cross-platform automated workflows are needed to enable seamless data transfer and storage.

Application Scenarios

  • Automated processing of transaction receipts sent via LINE by customers or suppliers in corporate finance departments;
  • Automatic organization of bank transfer and PromptPay payment records for individuals or small businesses;
  • Any scenario requiring conversion of transaction receipt images into structured tabular data.

Main Workflow Steps

  1. Receive transaction receipt image messages sent by users through the LINE chatbot webhook;
  2. Construct the image URL and retrieve the binary image data via HTTP request;
  3. Upload the image to a designated Google Drive folder for storage;
  4. Use the OCR Space API to perform text recognition on the image URL stored in Google Drive;
  5. Parse the OCR returned text using a custom JavaScript code node to extract key fields such as transaction type, date/time, sender and receiver information, transaction ID, amount, and fees;
  6. Append the parsed transaction data to a specified Google Sheets document for automatic recording and archiving.

Involved Systems and Services

  • LINE Chat Bot (Webhook interface for message reception)
  • Google Drive (Image storage)
  • OCR Space API (Image text recognition)
  • Google Sheets (Transaction data recording)

Target Users and Value

  • Finance personnel and accountants, reducing manual input and verification workload;
  • Business operations managers, enabling real-time access and aggregation of transaction data;
  • Developers and automation enthusiasts, facilitating easy integration of OCR and data processing workflows;
  • Small and medium enterprises and freelancers, improving receipt management efficiency and reducing error risks.

By integrating multiple platforms and intelligent parsing, this workflow delivers a highly efficient and automated solution for transaction receipt processing, greatly enhancing data handling convenience and accuracy.