AutomationMart
Home/Browse/Log LINE invoice photos to Google Sheets with OCR.space and Gemini AI
n8n

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

n8nn8n15 modulesv1.0
Google SheetsGemini

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
Log LINE invoice photos to Google Sheets with OCR.space and Gemini AI workflow diagram

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.

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 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

Receive instant email alerts whenever cells are updated in Google Sheets, ensuring you stay informed about important changes in your spreadsheets.

Free

Interactive knowledge base chat with Supabase RAG using AI 📚💬

Google Drive File Ingestion to Supabase for Knowledge Base 📂💾 Overview 🌟 This n8n workflow automates the process of ingesting files from Google Drive into a Supabase database, preparing them for a knowledge base system. It supports text-based files (PDF, DOCX, TXT, etc.) and tabular data (XLSX, CSV, Google Sheets), extracting content, generating embeddings, and storing data in structured tables. This is a foundational workflow for building a company knowledge base that can be queried via a chat

Free

AI-powered lead enrichment with Bright Data MCP and Google Sheets

HubSpot Lead Enrichment with Bright Data MCP This template enables natural-language-driven automation using Bright Data's MCP tools, triggered directly by new leads in HubSpot. It dynamically extracts and executes the right tool based on lead context—powered by AI and configurable in N8N. --- ❓ What Problem Does This Solve? Manual lead enrichment is slow, inconsistent, and drains valuable time. This solution automates the

Free

Automate ITSM ticket classification and resolution using Gemini, Qdrant and ServiceNow

Who’s it for This template is ideal for IT support teams, internal helpdesk automation engineers, and developers building intelligent ticketing systems. It helps streamline ITSM workflows by automatically classifying user queries, retrieving relevant knowledge base entries, and triggering incident creation in ServiceNow. How it works / What it does This workflow uses Google Gemini and Qdrant to power an intelligent ITSM assistant. When a user submits a query via chat: The Text Classifier

Free

Add abandoned checkouts from Shopify to Google Sheets

Recover lost sales and enhance your e-commerce strategy by tracking abandoned checkouts in Shopify. This template automatically adds details of abandoned checkouts to a Google Sheets spreadsheet, allowing you to analyze customer behavior and follow up effectively. With this streamlined workflow, you can easily identify trends and implement targeted strategies to convert those potential sales into completed transactions.

Free

Auto-generate LinkedIn posts from articles with Dumpling AI and GPT-4o

Who is this for? This workflow is ideal for social media managers, personal brand strategists, ghostwriters, and founders who want to post regularly on LinkedIn without spending hours writing from scratch. It’s also useful for marketing agencies and assistants looking to automate consistent post creation using curated articles as source material. --- 🧩 What problem does this workflow solve? Manually reading multiple articles, extracting key insights, and writing a clean, professional LinkedIn po

Free

Generate text-to-video & image-to-video content with Seedance 1 Lite AI

Generate Text-to-Video & Image-to-Video Content with Seedance 1 Lite AI Built with n8n + Replicate This workflow takes a prompt (and optional seed), sends it to Bytedance’s seedance-1-lite model, waits for processing, and returns a generated video. --- ⚡ Section 1: Start & Authenticate ▶️ On clicking ‘execute’ → Manual trigger to start the workflow. 🔑 Set API Key → Stores your Replicate API key so all requests are authorized. Benefit: Keeps your API credentials secure and reusable. --- 🛠️ Sect

Free

Daily business idea insights aggregator from IdeaBrowser to Google Docs

This automation runs daily at 8:00 AM to automatically collect and organize business idea insights from IdeaBrowser.com into a structured Google Docs document. The workflow performs the following actions: Data Collection: Fetches the "idea of the day" content from ideabrowser.com/idea-of-the-day using authenticated HTTP requests. Content Processing: Extracts the base idea path and generates links to all related insight pages including value ladder, market analysis, proof signals, execution plans

Free

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.

Log in to review
Free
No ratings yet

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.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free