Automate LINE Message Image to Google Sheets with OCR
detail.loadingPreview
Seamlessly capture images sent via LINE, extract transaction details using OCR, and automatically record them into your Google Sheets. This workflow streamlines data entry and enhances record-keeping accuracy.
About This Workflow
This n8n workflow revolutionizes how you manage information received through LINE. It begins by triggering upon receiving a message via a LINE webhook. If the message contains an image, the workflow fetches the image content, converts it into a usable binary format, and then uploads it to Google Drive for safekeeping. Leveraging the power of OCR (Optical Character Recognition) via SpaceOCR API, the workflow extracts key transaction details from the image. Finally, all parsed information, including transaction type, amount, dates, and sender/receiver details, is meticulously recorded into a Google Sheet, eliminating manual data entry and reducing errors.
Key Features
- LINE Message Integration: Instantly captures images sent via your LINE bot.
- Automated Image Handling: Downloads and processes image content from LINE.
- Cloud Storage: Uploads received images to Google Drive for archival.
- Intelligent Data Extraction: Utilizes OCR to pull specific transaction details from images.
- Google Sheets Synchronization: Automatically logs extracted data into your Google Sheet.
How To Use
- Set up LINE Webhook: Configure your LINE bot to send messages to the n8n webhook node (
Line Chat Bot). - Configure Image Retrieval: Ensure the
Image slip URL in Linenode correctly references the message ID to construct the image content URL. - Set up HTTP Request: Authorize the
Get image to Binarynode with your LINE channel access token for accessing image content. - Integrate Google Drive: Connect your Google Drive account to the
Upload image to Google Drivenode and specify your desired folder. - Configure OCR: Set up the OCR node (implied but not explicitly shown in the snippet, likely requires an API key and configuration for SpaceOCR or similar) to parse the image from Google Drive or directly from the HTTP request output.
- Map Data to Google Sheets: Configure the
Record in Google Sheetsnode by mapping the OCR output fields to your Google Sheet columns. Ensure your Google Sheets connection is authorized.
Apps Used
Workflow JSON
{
"id": "cb3be1b3-231b-423a-ad27-fe11a87fefd1",
"name": "Automate LINE Message Image to Google Sheets with OCR",
"nodes": 18,
"category": "Operations",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: cb3be1b3-231b...
About the Author
Free n8n Workflows Official
System Admin
The official repository for verified enterprise-grade workflows.
Statistics
Related Workflows
Discover more workflows you might like
Google Sheets to Icypeas: Automated Bulk Domain Scanning
This workflow streamlines the process of performing bulk domain scans by integrating your Google Sheets data directly with the Icypeas platform. Automate the submission of company names from your spreadsheet to Icypeas for comprehensive domain information, saving valuable time and effort.
Dynamic Bible Scripture Retrieval Workflow
This n8n workflow provides a robust solution for dynamically querying and retrieving Bible scriptures from the getBible.net API. It takes structured JSON input for references, translation, and version, returning the corresponding passages in a standardized API response format.
Instant WooCommerce Order Notifications via Telegram
When a new order is placed on your WooCommerce store, instantly receive detailed notifications directly to your Telegram chat. Stay on top of your e-commerce operations with real-time alerts, including order specifics and a direct link to view the order.