基于聊天的财务报表分析，使用GPT-4和PostgreSQL处理损益表和资产负债表

Name: 基于聊天的财务报表分析，使用GPT-4和PostgreSQL处理损益表和资产负债表
Rating: 4.5 (10 reviews)
Author: Zain Ali

中级

这是一个Document Extraction, Multimodal AI领域的自动化工作流，包含 7 个节点。主要使用 PostgresTool, Agent, ChatTrigger, LmChatOpenAi, MemoryBufferWindow 等节点。基于聊天的财务报表分析，使用GPT-4和PostgreSQL处理损益表和资产负债表

前置要求

•PostgreSQL 数据库连接信息
•OpenAI API Key

使用的节点 (7)

分类

文档提取

多模态 AI

工作流预览

可视化展示节点连接关系，支持缩放和平移

AI Agent

P_L_报告

资产负债表

简单记忆

OpenAI 聊天模型

当收到聊天消息时

React Flow

导出工作流

复制以下 JSON 配置到 n8n 导入，即可使用此工作流

{
  "id": "okpWKYL7NWpYys9Q",
  "meta": {
    "instanceId": "b50483b2122f6dc268662b45507d575d939570ea8e1e086601ebb3b6273c1cfd"
  },
  "name": "财务分析师智能体",
  "tags": [],
  "nodes": [
    {
      "id": "9d80bab4-d014-4e2c-9f9c-15cb29f49545",
      "name": "AI Agent",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        416,
        192
      ],
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "f3cd7b4d-0e89-403f-b505-4f9fdce05f30",
      "name": "P_L_报告",
      "type": "n8n-nodes-base.postgresTool",
      "position": [
        608,
        400
      ],
      "parameters": {},
      "typeVersion": 2.6
    },
    {
      "id": "09825591-c77e-4635-a635-282a3cc0d98c",
      "name": "资产负债表",
      "type": "n8n-nodes-base.postgresTool",
      "position": [
        752,
        400
      ],
      "parameters": {},
      "typeVersion": 2.6
    },
    {
      "id": "7da3e4a5-0861-493e-a427-9cecf010de3d",
      "name": "简单记忆",
      "type": "@n8n/n8n-nodes-langchain.memoryBufferWindow",
      "position": [
        480,
        400
      ],
      "parameters": {},
      "typeVersion": 1.3
    },
    {
      "id": "d6e2fec8-9910-496f-a630-113ee0e94eb2",
      "name": "OpenAI 聊天模型",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        336,
        400
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "ee289e2e-716f-49b5-aaf0-80737e1692bc",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -16,
        -32
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "4da765c4-d0b7-46dd-b197-d0179bdf1c92",
      "name": "当收到聊天消息时",
      "type": "@n8n/n8n-nodes-langchain.chatTrigger",
      "position": [
        176,
        192
      ],
      "webhookId": "aef942c6-87aa-4dd8-9ea1-4b9b4140d843",
      "parameters": {},
      "typeVersion": 1.3
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "8783b3c8-e1bb-4505-8de7-50dfa925535f",
  "connections": {
    "9d80bab4-d014-4e2c-9f9c-15cb29f49545": {
      "main": [
        []
      ]
    },
    "f3cd7b4d-0e89-403f-b505-4f9fdce05f30": {
      "ai_tool": [
        [
          {
            "node": "9d80bab4-d014-4e2c-9f9c-15cb29f49545",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "7da3e4a5-0861-493e-a427-9cecf010de3d": {
      "ai_memory": [
        [
          {
            "node": "9d80bab4-d014-4e2c-9f9c-15cb29f49545",
            "type": "ai_memory",
            "index": 0
          }
        ]
      ]
    },
    "09825591-c77e-4635-a635-282a3cc0d98c": {
      "ai_tool": [
        [
          {
            "node": "9d80bab4-d014-4e2c-9f9c-15cb29f49545",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "d6e2fec8-9910-496f-a630-113ee0e94eb2": {
      "ai_languageModel": [
        [
          {
            "node": "9d80bab4-d014-4e2c-9f9c-15cb29f49545",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "4da765c4-d0b7-46dd-b197-d0179bdf1c92": {
      "main": [
        [
          {
            "node": "9d80bab4-d014-4e2c-9f9c-15cb29f49545",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}

常见问题