8
n8n 中文网amn8n.com

使用VLM Run提取收据数据

中级

这是一个Finance领域的自动化工作流，包含 9 个节点。主要使用 Set, GoogleDrive, GoogleSheets, VlmRun, GoogleDriveTrigger 等节点。 利用VLM Run和Google提取并整理收据数据用于费用跟踪

前置要求
  • •Google Drive API 凭证
  • •Google Sheets API 凭证

使用的节点 (9)

Set
StickyNote
GoogleDrive
GoogleSheets
VlmRun
GoogleDriveTrigger

分类

财务
工作流预览
可视化展示节点连接关系，支持缩放和平移
React Flow
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
  "id": "vfk3hMIpK3VPTTuT",
  "meta": {
    "instanceId": "0a7ae129a7d703150135f6cc24d0469f20ffd22b5ed59c23ee3e0608264e6d98",
    "templateCredsSetupCompleted": true
  },
  "name": "使用 VLM Run 提取收据副本",
  "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 收据数据提取工作流"
      },
      "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": "## 📁 输入处理"
      },
      "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 收据提取"
      },
      "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": "## 📊 数据存储"
      },
      "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": {
    "Format Receipt Data": {
      "main": [
        [
          {
            "node": "Save to Expense Database",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Download  Receipt File": {
      "main": [
        [
          {
            "node": "VLM Run Receipt Parser",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "VLM Run Receipt Parser": {
      "main": [
        [
          {
            "node": "Format Receipt Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Monitor Receipt Uploads": {
      "main": [
        [
          {
            "node": "Download  Receipt File",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流？

复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。

这个工作流适合什么场景？

中级 - 财务

需要付费吗？

本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。

相关工作流推荐

提取法律合同数据并使用VLM Run、Google Workspace和Slack发送提醒
提取法律合同数据并使用VLM Run、Google Workspace和Slack发送提醒
Set
Code
Slack
+7
14 节点Shahrear
使用Google Drive、VLM Run和Airtable自动化收据处理用于费用跟踪
通过Google Drive、VLM Run和Airtable实现费用跟踪收据处理的自动化
Set
Airtable
Google Drive
+3
9 节点Shahrear
杂项
建筑蓝图至Google Sheets自动化
使用VLM Run和Google Drive实现建筑蓝图至Google Sheets自动化
Google Drive
Google Sheets
Vlm Run
+2
8 节点Shahrear
AI 摘要总结
文档医嘱提取至Google表格（VLM Run AI）
使用VLM Run AI从文档中提取医嘱至Google表格
Google Drive
Google Sheets
Vlm Run
+2
8 节点Shahrear
AI 摘要总结
医疗保健索赔
使用VLM Run、Google Drive和Sheets提取并处理医疗保健索赔
Google Drive
Google Sheets
Vlm Run
+2
9 节点Shahrear
AI 摘要总结
(Tung) OCR发票提取到电子表格副本
自动发票和收据OCR到Google表格 - 支持云端硬盘、Gmail和Telegram触发
If
Set
Code
+10
25 节点Daniel Ng
财务
工作流信息
难度等级
中级
节点数量9
分类1
节点类型6
难度说明

适合有一定经验的用户，包含 6-15 个节点的中等复杂度工作流

作者
Shahrear

Shahrear

@shahrear

I’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

外部链接
在 n8n.io 查看 →

分享此工作流