Capture LINE receipt expenses with Gemini, Google Drive and Google Sheets

by ryo ✓ · 15 views · created 2026-09-28 · Invoice Processing, AI Summarization

What this workflow does

This workflow has 17 nodes and runs when an HTTP POST request hits its webhook URL. Along the way it connects Google Drive and Google Sheets. It also calls api.line.me and generativelanguage.googleapis.com over HTTP.

How it runs

Trigger: When an HTTP POST request hits its webhook URL.

1. Set LINE Message Data (Edit Fields (Set)): sets 5 fields: messageType, messageId, replyToken…
2. If: checks a condition and branches into true / false
3. Fetch LINE Image Content (HTTP Request): calls an HTTP API
4. Reply with Text Guide (HTTP Request): calls api.line.me (POST)
5. Store Receipt in Google Drive (Google Drive): uses Google Drive
6. Convert Image to Base (Code): runs custom JavaScript code
7. Merge: merges the data from its input branches
8. Submit to Gemini for Analysis (HTTP Request): calls generativelanguage.googleapis.com (POST)
9. Check for Invoice Number (If): checks a condition and branches into true / false
10. Extract Receipt Details (Code): runs custom JavaScript code

…plus 6 more steps. See the full node list below.

Services it uses

Google DriveGoogle Sheets

HTTP calls to: api.line.me, generativelanguage.googleapis.com

Before you upgrade to n8n 3.0

Nodes used (8)

• Webhookn8n-nodes-base.webhook
• Edit Fields (Set)n8n-nodes-base.set
• Ifn8n-nodes-base.if
• HTTP Requestn8n-nodes-base.httpRequest
• Google Driven8n-nodes-base.googleDrive
• Coden8n-nodes-base.code
• Google Sheetsn8n-nodes-base.googleSheets
• Mergen8n-nodes-base.merge

From the author

Quick overview This workflow receives receipt images from LINE, uses Google Gemini to extract structured expense data, verifies Japanese invoice T-numbers via the NTA Web-API, archives the image in Google Drive, logs the expense to Google Sheets, and replies…

View the original on n8n.io → Check your own copy