VLM Run による領収データ抽出
これはFinance分野の自動化ワークフローで、9個のノードを含みます。主にSet, GoogleDrive, GoogleSheets, VlmRun, GoogleDriveTriggerなどのノードを使用。 VLM Run と Google を利用して領収データを抽出・整理し、費用追跡に使用
- •Google Drive API認証情報
- •Google Sheets API認証情報
カテゴリー
{
"id": "vfk3hMIpK3VPTTuT",
"meta": {
"instanceId": "0a7ae129a7d703150135f6cc24d0469f20ffd22b5ed59c23ee3e0608264e6d98",
"templateCredsSetupCompleted": true
},
"name": "Extract Receipt using VLM Run copy",
"tags": [
{
"id": "DSKBDwtewArNjZx4",
"name": "vlm-run",
"createdAt": "2024-09-20T20:26:05.335Z",
"updatedAt": "2024-09-20T20:26:05.335Z"
},
{
"id": "uTgcE1NFbi2QAwzR",
"name": "Expense Management",
"createdAt": "2025-06-18T16:03:15.024Z",
"updatedAt": "2025-06-18T16:03:15.024Z"
},
{
"id": "ASVb4TB6jxrNFOUQ",
"name": "Finance Automation",
"createdAt": "2025-06-18T16:03:26.652Z",
"updatedAt": "2025-06-18T16:03:26.652Z"
},
{
"id": "2Ng8DrDYZnO5sfgp",
"name": "Receipt Processing",
"createdAt": "2025-06-18T16:03:34.870Z",
"updatedAt": "2025-06-18T16:03:34.870Z"
},
{
"id": "70j7DkEvdoMovcLY",
"name": "VLM",
"createdAt": "2025-06-18T16:03:39.271Z",
"updatedAt": "2025-06-18T16:03:39.271Z"
}
],
"nodes": [
{
"id": "d6f247e6-7a83-485f-90e4-b9b20e5771bf",
"name": "🧾 ワークフロー概要",
"type": "n8n-nodes-base.stickyNote",
"position": [
400,
140
],
"parameters": {
"color": 7,
"width": 400,
"height": 680,
"content": "## 🧾 AI Receipt Data Extraction Workflow\n\n**Overview:**\nAutomates receipt processing for expense management. Upload receipts to Google Drive → VLM Run extracts data → Saves to spreadsheet.\n\n**Key Features:**\n- 📁 Auto-monitors Google Drive folder\n- 🤖 Extracts merchant, amount, date, currency\n- 📊 Saves structured data to Google Sheets\n- 📱 Mobile-friendly uploads\n\n**Perfect for:**\n- Business expense reporting\n- Personal finance tracking\n- Accounting automation\n- Travel expenses\n\n**Requirements:**\n- VLM Run API\n- Google Drive & Sheets OAuth2"
},
"typeVersion": 1
},
{
"id": "a2726bd4-a23e-49de-b980-ad55531ce5c8",
"name": "📁 入力処理ドキュメント",
"type": "n8n-nodes-base.stickyNote",
"position": [
820,
140
],
"parameters": {
"color": 7,
"width": 400,
"height": 680,
"content": "## 📁 Input Processing\n\n**Monitors & downloads receipt files from Google Drive.**\n\n**Process:**\n1. Watches designated Drive folder\n2. Auto-triggers on new uploads\n3. Downloads files for AI processing\n\n**Supported Formats:**\n- Images (JPG, PNG, WEBP)\n- PDF documents\n- Mobile camera uploads\n- Scanned receipts"
},
"typeVersion": 1
},
{
"id": "b6bbc513-a0cd-4656-91ea-ecd9f9c712aa",
"name": "🤖 AI抽出ドキュメント",
"type": "n8n-nodes-base.stickyNote",
"position": [
1240,
140
],
"parameters": {
"width": 400,
"height": 680,
"content": "## 🤖 VLM Run Receipt Extraction\n\n**Uses VLM Run node to extract structured data from receipt images/PDFs.**\n\n**Extracts:**\n- Merchant name\n- Customer info\n- Total amount\n- Currency\n- Transaction date\n\n**Features:**\n- Handles poor quality images\n- Various receipt formats\n- OCR text recognition"
},
"typeVersion": 1
},
{
"id": "9424db8a-1b60-4cde-83e4-205b1b8e61a8",
"name": "📊 保存ドキュメント",
"type": "n8n-nodes-base.stickyNote",
"position": [
1660,
140
],
"parameters": {
"color": 7,
"width": 420,
"height": 680,
"content": "## 📊 Data Storage\n\n**Structures and stores extracted data in Google Sheets.**\n\n**Features:**\n- Clean, organized format\n- Centralized expense database\n- Auto-appends new entries\n- Analysis-ready data\n\n**Data Fields:**\n- Customer name\n- Merchant name\n- Amount & currency\n- Transaction date\n\n**Benefits:**\n- Real-time tracking\n- Easy exports\n- Mobile access"
},
"typeVersion": 1
},
{
"id": "5b7f6bad-f405-4dac-8615-52f429ea4477",
"name": "領収書アップロードの監視",
"type": "n8n-nodes-base.googleDriveTrigger",
"notes": "Monitors Google Drive folder for new receipt uploads and triggers processing automatically.",
"position": [
880,
620
],
"parameters": {
"event": "fileCreated",
"options": {},
"pollTimes": {
"item": [
{
"mode": "everyMinute"
}
]
},
"triggerOn": "specificFolder",
"folderToWatch": {
"__rl": true,
"mode": "list",
"value": "1reWORwI1tMa-eGB75NCXq9eRw4CiQIhX",
"cachedResultUrl": "https://drive.google.com/drive/folders/1reWORwI1tMa-eGB75NCXq9eRw4CiQIhX",
"cachedResultName": "n8n"
}
},
"credentials": {
"googleDriveOAuth2Api": {
"id": "RoAWJpYkuErAB6eo",
"name": "n8n - Google Drive account"
}
},
"typeVersion": 1
},
{
"id": "d8bc3603-c454-4095-8334-d8a87bd44472",
"name": "領収書ファイルのダウンロード",
"type": "n8n-nodes-base.googleDrive",
"notes": "Downloads receipt files from Google Drive for AI processing.",
"position": [
1080,
620
],
"parameters": {
"fileId": {
"__rl": true,
"mode": "id",
"value": "={{ $json.id }}"
},
"options": {
"binaryPropertyName": "data"
},
"operation": "download"
},
"credentials": {
"googleDriveOAuth2Api": {
"id": "RoAWJpYkuErAB6eo",
"name": "n8n - Google Drive account"
}
},
"typeVersion": 3
},
{
"id": "082c9002-59ba-41d2-b1e4-b3f0bf5a565f",
"name": "VLM Run領収書パーサー",
"type": "@vlm-run/n8n-nodes-vlmrun.vlmRun",
"notes": "Uses VLM AI to extract merchant name, amount, currency, and date from receipt images.",
"position": [
1400,
620
],
"parameters": {
"domain": "document.receipt"
},
"credentials": {
"vlmRunApi": {
"id": "YOpUDKYZ0pZumyyO",
"name": "n8n - VLM Run account"
}
},
"typeVersion": 1
},
{
"id": "1ea57ced-38c2-48e8-96ae-b733fc059f44",
"name": "領収書データのフォーマット",
"type": "n8n-nodes-base.set",
"notes": "Transforms AI-extracted receipt data into clean, structured format for spreadsheet storage.",
"position": [
1720,
620
],
"parameters": {
"values": {
"string": [
{
"name": "Customer",
"value": "={{ $json.response.customer_name }}"
},
{
"name": "Merchant",
"value": "={{ $json.response.merchant_name }}"
},
{
"name": "Amount",
"value": "={{ $json.response.total }}"
},
{
"name": "Currency",
"value": "={{ $json.response.currency }}"
},
{
"name": "Date",
"value": "={{ $json.response.transaction_date }}"
}
]
},
"options": {},
"keepOnlySet": true
},
"typeVersion": 1
},
{
"id": "b36dea02-0a86-4e78-839d-daae319aaaff",
"name": "経費データベースへの保存",
"type": "n8n-nodes-base.googleSheets",
"notes": "Automatically saves extracted receipt data to Google Sheets for expense tracking.",
"position": [
1900,
620
],
"parameters": {
"columns": {
"value": {
"Date": "={{ $json.Date }}",
"Amount": "={{ $json.Amount }}",
"Currency": "={{ $json.Currency }}",
"Customer": "={{ $json.Customer }}",
"Merchant": "={{ $json.Merchant }}"
},
"schema": [
{
"id": "Customer",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Customer",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Merchant",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Merchant",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Amount",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Amount",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Currency",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Currency",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Date",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Date",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Customer"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/11_VjMdhv_JN2eSRZiw_t0dIN-yShkn2jlCDwiG8eb14/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "11_VjMdhv_JN2eSRZiw_t0dIN-yShkn2jlCDwiG8eb14",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/11_VjMdhv_JN2eSRZiw_t0dIN-yShkn2jlCDwiG8eb14/edit?usp=drivesdk",
"cachedResultName": "Receipt Data"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "ZjcHQereIQBGqp7Z",
"name": "n8n - Google Sheets account"
}
},
"typeVersion": 4.6
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "e5449041-5940-4a1e-a337-e75f34d86e9e",
"connections": {
"1ea57ced-38c2-48e8-96ae-b733fc059f44": {
"main": [
[
{
"node": "b36dea02-0a86-4e78-839d-daae319aaaff",
"type": "main",
"index": 0
}
]
]
},
"d8bc3603-c454-4095-8334-d8a87bd44472": {
"main": [
[
{
"node": "082c9002-59ba-41d2-b1e4-b3f0bf5a565f",
"type": "main",
"index": 0
}
]
]
},
"082c9002-59ba-41d2-b1e4-b3f0bf5a565f": {
"main": [
[
{
"node": "1ea57ced-38c2-48e8-96ae-b733fc059f44",
"type": "main",
"index": 0
}
]
]
},
"5b7f6bad-f405-4dac-8615-52f429ea4477": {
"main": [
[
{
"node": "d8bc3603-c454-4095-8334-d8a87bd44472",
"type": "main",
"index": 0
}
]
]
}
}
}このワークフローの使い方は?
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか?
中級 - 財務
有料ですか?
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス(OpenAI APIなど)は別途料金が発生する場合があります。
関連ワークフロー
Shahrear
@shahrearI’m Shahrear, a Software Engineer with over 5 years of experience in full-stack development and workflow automation. I specialize in building intelligent, scalable automations using n8n, helping teams streamline operations and boost productivity. I’m also an expert in developing custom n8n nodes, with published work on npm - including the @vlm-run/n8n-nodes-vlmrun package. https://github.com/vlm-run/n8n-nodes-vlmrun
このワークフローを共有