Log LINE invoice photos to Google Sheets with OCR.space and Gemini AI Workflow Solution

Workflow overview

Why this workflow matters

Supports knowledge capture and document intelligence use cases.

Who is this for Freelancers, small business owners, and accounting teams in Japan who receive invoices and want to eliminate manual data entry into spreadsheets. What this workflow does Send an invoice photo to your LINE bot and the rest is automatic. The workflow fetches the image via LINE Messaging API, runs it through OCR.space to extract raw text, then passes that text to a Gemini AI Agent to parse the key fields — invoice number, date, due date, vendor name, subtotal, tax, and total. The result is appended as a new row in your Google Sheets ledger and a confirmation is sent back to LINE. If the image is not an invoice, a friendly error message is returned instead. How to set up Create a LINE Messaging API channel and get your Channel Access Token Get a free OCR.space API key at ocr.space/ocrapi/freekey Get a free Gemini API key at aistudio.google.com Set up Google Sheets OAuth2 credentials in AlekSystem Enter your LINE token, OCR key, and Spreadsheet ID in the Variables node Set the Webhook URL in LINE Developers to your AlekSystem instance URL Activate the workflow and send an invoice photo to your LINE bot Requirements LINE Messaging API channel and channel access token OCR.space API key (free tier: 25,000 requests/month) Google Gemini API key (free tier: 1,500 requests/day) Google Sheets with OAuth2 credentials configured in AlekSystem How to customize Change SHEET_NAME in the Variables node to file invoices by month. Edit the Gemini prompt to capture extra fields like bank details or line items. Swap OCR.space for Google Cloud Vision API if you need better accuracy on complex layouts.

Best fit

Need another direction?