LINE Bot - Google Sheets Record Receipt

Name: LINE Bot - Google Sheets Record Receipt
Rating: 5.0 (1 reviews)
Author: Free N8N

Beginner

0 nodes connected

detail.loadingPreview

Free N8N Temples

49 views

0 downloads

Integrationsautomationgoogle sheetslineocrreceiptwebhook

Automatically records LINE BOT message receipts into Google Sheets.

🚀Ready to Deploy This Workflow?

⚡Deploy on Zeabur 🎁Get $200 Credit on DigitalOcean

About This Workflow

Overview

This workflow utilizes a LINE webhook to capture incoming messages, processes them to extract transaction details, uploads any associated images to Google Drive, and finally records the extracted information into a Google Sheet.

Key Features

Receives messages and images via LINE webhook.
Extracts image content and URL.
Uploads images to Google Drive.
Performs OCR for text extraction from images.
Parses and structures transaction data.
Appends transaction data to a Google Sheet.

How To Use

Set up a LINE Official Account and obtain the necessary webhook token.
Configure the LINE Chat Bot node with your LINE webhook path.
Set up Google Drive and Google Sheets credentials in n8n.
Configure the Upload image to Google Drive and Record in Google Sheets nodes with your credentials and desired sheet/folder.
Ensure your environment variables (API_BASE_URL, BASE_URL, WEBHOOK_URL) are correctly set for image processing and Google Drive integration.
Configure the Image slip URL in Line and Send Image URL to OCR Space for Text Extraction nodes with the correct API endpoints for your OCR service.

Apps Used

automation

google sheets

line

ocr

receipt

webhook

Workflow JSON

{
  "id": "139b9ecd-1b2a-4972-b5e4-8511a4b2b517",
  "name": "LINE Bot - Google Sheets Record Receipt",
  "nodes": 0,
  "category": "Integrations",
  "status": "active",
  "version": "1.0.0"
}

Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.