8
n8n 中文网amn8n.com

首席财务官预测智能体

高级

这是一个AI, IT Ops领域的自动化工作流，包含 16 个节点。主要使用 Set, Code, Stripe, Supabase, GoogleSheets 等节点，结合人工智能技术实现智能自动化。 基于Stripe数据的GPT-4与Google表格自动化收入预测

前置要求
  • •Stripe API Key
  • •Supabase URL 和 API Key
  • •Google Sheets API 凭证
  • •OpenAI API Key
  • •Pinecone API Key

使用的节点 (16)

Set
Code
Stripe
Supabase
StickyNote
GoogleSheets
Agent
ScheduleTrigger
LmChatOpenAi
EmbeddingsOpenAi
VectorStorePinecone
OutputParserStructured

分类

人工智能
IT 运维
工作流预览
可视化展示节点连接关系，支持缩放和平移
React Flow
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
  "id": "mHSoMMyypmRzfVZn",
  "meta": {
    "instanceId": "84ad02d6104594179f43f1ce9cfe3a81637b2faedb57dafcb9e649b7542988db"
  },
  "name": "首席财务官预测智能体",
  "tags": [],
  "nodes": [
    {
      "id": "b946638e-ba68-4d73-816e-00f3a63d138f",
      "name": "结构化输出解析器",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        1420,
        220
      ],
      "parameters": {
        "jsonSchemaExample": "{\n  \"forecast\": {\n    \"June 2025\": \"$X,XXX.XX\",\n    \"July 2025\": \"$X,XXX.XX\",\n    \"August 2025\": \"$X,XXX.XX\"\n  },\n  \"trend\": \"Increasing / Decreasing / Stable\",\n  \"confidence\": \"High / Medium / Low\",\n  \"insights\": \"Short explanation of why this trend is predicted.\"\n}"
      },
      "typeVersion": 1.2
    },
    {
      "id": "d80c3670-e8c8-43ee-ba12-2e0e18b99862",
      "name": "OpenAI Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        1180,
        220
      ],
      "parameters": {
        "model": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-4o-mini"
        },
        "options": {}
      },
      "credentials": {
        "openAiApi": {
          "id": "wYwTjEv45IzlAOAu",
          "name": "OpenAi account 2"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "bb75cafb-9dad-4952-89af-0658c4d88aa4",
      "name": "Pinecone 向量存储",
      "type": "@n8n/n8n-nodes-langchain.vectorStorePinecone",
      "position": [
        1200,
        400
      ],
      "parameters": {
        "mode": "retrieve-as-tool",
        "options": {},
        "toolName": "Sales_data",
        "pineconeIndex": {
          "__rl": true,
          "mode": "list",
          "value": "new",
          "cachedResultName": "new"
        },
        "toolDescription": "The data about stripe sales"
      },
      "credentials": {
        "pineconeApi": {
          "id": "PSI5CiZnLRSkEgJg",
          "name": "PineconeApi account"
        }
      },
      "typeVersion": 1.1
    },
    {
      "id": "7d370700-89d9-4163-8070-4a0c643531ca",
      "name": "Embeddings OpenAI",
      "type": "@n8n/n8n-nodes-langchain.embeddingsOpenAi",
      "position": [
        1140,
        600
      ],
      "parameters": {
        "options": {}
      },
      "credentials": {
        "openAiApi": {
          "id": "wYwTjEv45IzlAOAu",
          "name": "OpenAi account 2"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "81de1ecf-75de-44fd-9e62-c381e907c1e1",
      "name": "运行每日预测",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        0,
        0
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "triggerAtHour": 9
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "9ce2e0e4-8784-4ed9-9499-b5f54241d04e",
      "name": "获取 Stripe 收费记录",
      "type": "n8n-nodes-base.stripe",
      "position": [
        220,
        0
      ],
      "parameters": {
        "resource": "charge",
        "operation": "getAll",
        "returnAll": true
      },
      "typeVersion": 1
    },
    {
      "id": "c115eb0c-6877-46db-bf03-55e48527dbc5",
      "name": "汇总销售数据",
      "type": "n8n-nodes-base.code",
      "position": [
        440,
        0
      ],
      "parameters": {
        "jsCode": "const charges = items.map(item => item.json);\nconst summary = charges.reduce((acc, charge) => {\n  const date = new Date(charge.created * 1000).toISOString().split(\"T\")[0];\n  acc[date] = (acc[date] || 0) + charge.amount / 100;\n  return acc;\n}, {});\nreturn [{ json: { summary } }];\n"
      },
      "typeVersion": 2
    },
    {
      "id": "fb33581a-9f41-49d7-a722-a68dfe5bc265",
      "name": "准备数据",
      "type": "n8n-nodes-base.set",
      "position": [
        660,
        0
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "6aa7f5d2-3aa4-4d4c-85df-0d56bb7b6c9e",
              "name": "summary",
              "type": "string",
              "value": "={{ $json.summary }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "d3458681-2654-4e22-8b2d-1711b60ed592",
      "name": "预测智能体",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        1240,
        0
      ],
      "parameters": {
        "text": "=You are a CFO AI Agent. Based on the following Stripe sales data:\n\n{{ $json.summary }}\n\nAnalyze the trends, identify any patterns (growth, decline, seasonality), and forecast expected daily or weekly revenue for the next 3 months.",
        "options": {},
        "promptType": "define",
        "hasOutputParser": true
      },
      "typeVersion": 1.9
    },
    {
      "id": "325e4952-868c-460a-aa78-2e718477cc78",
      "name": "将预测保存至 Supabase",
      "type": "n8n-nodes-base.supabase",
      "position": [
        2100,
        -160
      ],
      "parameters": {
        "dataToSend": "autoMapInputData"
      },
      "typeVersion": 1
    },
    {
      "id": "9fd6efab-edc6-49be-9516-f2d36e1995b2",
      "name": "在 Google Sheets 中记录预测",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2100,
        120
      ],
      "parameters": {
        "columns": {
          "value": {
            "trend": "={{ $json.output.trend }}",
            "forecast": "={{ $json.output.forecast }}",
            "insights": "={{ $json.output.insights }}",
            "confidence": "={{ $json.output.confidence }}"
          },
          "schema": [
            {
              "id": "forecast",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "forecast",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "trend",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "trend",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "confidence",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "confidence",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "insights",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "insights",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/108tyyL--yUCbDk4drB__eztLSwjlxcmoRkqYsFnMLrY/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "108tyyL--yUCbDk4drB__eztLSwjlxcmoRkqYsFnMLrY",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/108tyyL--yUCbDk4drB__eztLSwjlxcmoRkqYsFnMLrY/edit?usp=drivesdk",
          "cachedResultName": "CFO Forecasting"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "K5yYfUnKFTqaRn6A",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "241e625d-7019-4919-9f93-137461ad94bf",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -40,
        -1820
      ],
      "parameters": {
        "color": 3,
        "width": 840,
        "height": 2120,
        "content": "## 1️⃣ **🔁 数据获取与预处理**"
      },
      "typeVersion": 1
    },
    {
      "id": "f60c6c15-8449-457a-aaad-2ebca8d75318",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        940,
        -1880
      ],
      "parameters": {
        "color": 6,
        "width": 840,
        "height": 2680,
        "content": "## 2️⃣ **🤖 AI 智能体预测**"
      },
      "typeVersion": 1
    },
    {
      "id": "8e9b2ea7-58bb-4f62-a69c-eed70032019c",
      "name": "便签 2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1920,
        -1220
      ],
      "parameters": {
        "color": 5,
        "width": 460,
        "height": 1560,
        "content": "## 3️⃣ **📦 存储与报告**"
      },
      "typeVersion": 1
    },
    {
      "id": "7d1186c9-cba1-4876-a405-fa67773b8dad",
      "name": "### 替换 Airtable 连接",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1840,
        -1800
      ],
      "parameters": {
        "color": 4,
        "width": 1300,
        "height": 320,
        "content": "======================================="
      },
      "typeVersion": 1
    },
    {
      "id": "2b9e9108-8084-4e3f-a620-5bee07040bc3",
      "name": "便签 4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1840,
        -1460
      ],
      "parameters": {
        "color": 4,
        "width": 1289,
        "height": 4778,
        "content": "# 📊 首席财务官预测智能体 – 工作流文档"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {
    "Fetch Stripe Charges": [
      {
        "json": {
          "id": "ch_1NxXy2LzPp3ZhRAbCD123456",
          "amount": 3500,
          "object": "charge",
          "status": "succeeded",
          "created": 1716940800,
          "currency": "usd",
          "customer": {
            "id": "cus_N8U1xX5TVgB1vW",
            "name": "Jane Doe",
            "email": "jane.doe@example.com"
          },
          "description": "Pro plan subscription",
          "amount_captured": 3500,
          "amount_refunded": 0,
          "payment_method_details": {
            "card": {
              "brand": "visa",
              "last4": "4242"
            },
            "type": "card"
          }
        }
      },
      {
        "json": {
          "id": "ch_1NxXy3LzPp3ZhRAbCD654321",
          "amount": 1299,
          "object": "charge",
          "status": "succeeded",
          "created": 1717027200,
          "currency": "usd",
          "customer": {
            "id": "cus_N8U9YT5TWzA7LM",
            "name": "John Smith",
            "email": "john.smith@example.com"
          },
          "description": "Add-on purchase",
          "amount_captured": 1299,
          "amount_refunded": 0,
          "payment_method_details": {
            "card": {
              "brand": "mastercard",
              "last4": "5555"
            },
            "type": "card"
          }
        }
      }
    ]
  },
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "56196260-ac1a-4ef1-87c1-d5a8e1eb438f",
  "connections": {
    "Prepare data": {
      "main": [
        [
          {
            "node": "Forecaster agent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Summarize Sales": {
      "main": [
        [
          {
            "node": "Prepare data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Forecaster agent": {
      "main": [
        [
          {
            "node": "Save Forecast to Supabase",
            "type": "main",
            "index": 0
          },
          {
            "node": "Log Forecast in Google Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Embeddings OpenAI": {
      "ai_embedding": [
        [
          {
            "node": "Pinecone Vector Store",
            "type": "ai_embedding",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "Forecaster agent",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Run Daily Forecast": {
      "main": [
        [
          {
            "node": "Fetch Stripe Charges",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fetch Stripe Charges": {
      "main": [
        [
          {
            "node": "Summarize Sales",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Pinecone Vector Store": {
      "ai_tool": [
        [
          {
            "node": "Forecaster agent",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Structured Output Parser": {
      "ai_outputParser": [
        [
          {
            "node": "Forecaster agent",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流？

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

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

高级 - 人工智能, IT 运维

需要付费吗？

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

相关工作流推荐

COO任务优先级排序
基于GPT-4和Pinecone Memory的AI驱动Asana任务优先级排序
Asana
Postgres
Agent
+7
15 节点Yaron Been
人工智能
CFO 费用审核智能体
使用GPT-4、Airtable和Pinecone向量数据库的自动化费用审批系统
Airtable
Agent
Airtable Trigger
+7
15 节点Yaron Been
人工智能
宠物店 4
🐶 宠物店预约 AI 代理
If
Set
Code
+41
187 节点Bruno Dias
人工智能
Upwork 职位聚合与通知器
自动化职位搜索：Upwork 机会聚合与 AI 驱动通知器
Set
Gmail
Http Request
+6
13 节点Yaron Been
其他
自动化论坛监控_via_Bright_data
使用Bright Data和n8n的论坛监控自动化
Set
Code
Html
+6
17 节点Yaron Been
人工智能
Upwork职位聚合与通知器
Upwork职位聚合器，含OpenAI摘要和多渠道通知
Set
Gmail
Http Request
+6
13 节点Yaron Been
其他
工作流信息
难度等级
高级
节点数量16
分类2
节点类型12
难度说明

适合高级用户，包含 16+ 个节点的复杂工作流

作者
Yaron Been

Yaron Been

@yaron-nofluff

Building AI Agents and Automations | Growth Marketer | Entrepreneur | Book Author & Podcast Host If you need any help with Automations, feel free to reach out via linkedin: https://www.linkedin.com/in/yaronbeen/ And check out my Youtube channel: https://www.youtube.com/@YaronBeen/videos

外部链接
在 n8n.io 查看 →

分享此工作流