Log LINE invoice photos to Google Sheets with OCR.space and Gemini AI
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 re
At a glance
Log LINE invoice photos to Google Sheets with OCR.space and Gemini AI is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Google Sheets, Gemini. It's free to download. Follow the 5-step import below to go live in minutes.
- Platform
- n8n
- Connects
- Google Sheets, Gemini
- Modules
- 15
- Price
- Free
- Version
- v1.0

About this workflow
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 1. Create a LINE Messaging API channel and get your Channel Access Token 2. Get a free OCR.space API key at ocr.space/ocrapi/freekey 3. Get a free Gemini API key at aistudio.google.com 4. Set up Google Sheets OAuth2 credentials in n8n 5. Enter your LINE token, OCR key, and Spreadsheet ID in the Variables node 6. Set the Webhook URL in LINE Developers to your n8n instance URL 7. 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 n8n How to customize Change SHEETNAME 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.
How to import this n8n workflow
- 1
Download the workflow JSON file after purchase.
- 2
Open n8n → click the menu → Import from File.
- 3
Select the downloaded JSON and import.
- 4
Set up credentials for each node that requires them.
- 5
Click Execute Workflow to test, then activate.
Setup guide
Setup guide included
Purchase to unlock the full step-by-step guide
Related N8n workflows
Send email notifications for updated cells in Google Sheets
Interactive knowledge base chat with Supabase RAG using AI 📚💬
AI-powered lead enrichment with Bright Data MCP and Google Sheets
Automate ITSM ticket classification and resolution using Gemini, Qdrant and ServiceNow
Add abandoned checkouts from Shopify to Google Sheets
Auto-generate LinkedIn posts from articles with Dumpling AI and GPT-4o
Generate text-to-video & image-to-video content with Seedance 1 Lite AI
Daily business idea insights aggregator from IdeaBrowser to Google Docs
Reviews
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
- JSON blueprint — instant download
- Setup guide PDF included
- 5 downloads · valid 30 days
- Works with n8n
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.
- Configure live on Google Meet / Zoom
- Free follow-up if workflow has defects
- Platform expert assigned to you