8
n8n 中文网amn8n.com

n8napi-检查使用哪个模型的工作流

中级

这是一个AI, IT Ops领域的自动化工作流，包含 12 个节点。主要使用 N8n, Set, Filter, SplitOut, GoogleSheets 等节点，结合人工智能技术实现智能自动化。 检查工作流中使用的AI模型

前置要求
  • •Google Sheets API 凭证

使用的节点 (12)

N8n
Set
Filter
SplitOut
StickyNote
GoogleSheets
ManualTrigger
SplitInBatches

分类

人工智能
IT 运维
工作流预览
可视化展示节点连接关系，支持缩放和平移
React Flow
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
  "id": "I2qMAcQET7isaqYD",
  "meta": {
    "instanceId": "fddb3e91967f1012c95dd02bf5ad21f279fc44715f47a7a96a33433621caa253",
    "templateCredsSetupCompleted": true
  },
  "name": "n8napi-检查使用哪个模型的工作流",
  "tags": [],
  "nodes": [
    {
      "id": "a027dc3c-b3a2-45f6-9126-dbec39f55b39",
      "name": "当点击“测试工作流”时",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -880,
        -40
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "0aafc781-6847-4b5d-8f80-3bd457f16db3",
      "name": "遍历项目",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        -220,
        -40
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 3
    },
    {
      "id": "242d1965-d1e3-4b74-8064-53ea56118e94",
      "name": "编辑字段-设置模型数据",
      "type": "n8n-nodes-base.set",
      "position": [
        460,
        80
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "3c08b3a3-092d-4f88-81ef-7a7b3acf47b2",
              "name": "node_name",
              "type": "string",
              "value": "={{ $json.name }}"
            },
            {
              "id": "9b060fdb-f6a6-444a-a28d-deeacb21b3d3",
              "name": "model",
              "type": "string",
              "value": "={{ $json?.parameters?.model?.value || $json?.parameters?.model ||  $json?.parameters?.modelId?.cachedResultName }}"
            },
            {
              "id": "848c0e23-0aa6-4cf5-8a64-abe38351b63a",
              "name": "workflow_name",
              "type": "string",
              "value": "={{ $('Loop Over Items').item.json.name }}"
            },
            {
              "id": "cf3fea4e-4e22-4bd5-930b-6b8d25afbf9a",
              "name": "workflow_id",
              "type": "string",
              "value": "={{ $('Loop Over Items').item.json.id }}"
            },
            {
              "id": "8a8a2a83-d742-4450-b5ed-2089047076d8",
              "name": "workflow_url",
              "type": "string",
              "value": "={Your-n8n-domain}/workflow/{{ $('Loop Over Items').item.json.id }}/{{ $json.id }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "9693eb8b-4ce5-4d4b-984d-a77098896bc3",
      "name": "Google Sheets-清除表格数据",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -440,
        -220
      ],
      "parameters": {
        "operation": "clear",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1iMh0C-Niu1ko4-u2BHo0cgGeVQKcYHflBzRxtbWJiRI/edit#gid=0",
          "cachedResultName": "data"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1iMh0C-Niu1ko4-u2BHo0cgGeVQKcYHflBzRxtbWJiRI",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1iMh0C-Niu1ko4-u2BHo0cgGeVQKcYHflBzRxtbWJiRI/edit?usp=drivesdk",
          "cachedResultName": "n8n-check-workflow-use-what-ai-model"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "tufEzuSTEveV3tuA",
          "name": "(Personal)Google Sheets account"
        }
      },
      "executeOnce": true,
      "typeVersion": 4.5,
      "alwaysOutputData": false
    },
    {
      "id": "d325597e-b12f-427c-ba18-f69fa6ec9ed4",
      "name": "n8n-获取所有工作流",
      "type": "n8n-nodes-base.n8n",
      "position": [
        -660,
        -40
      ],
      "parameters": {
        "filters": {},
        "requestOptions": {}
      },
      "credentials": {
        "n8nApi": {
          "id": "dXWG3XrAfEA64tjh",
          "name": "n8n account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "f8fba3ae-f4f3-4db3-bd0f-7caa84fd6cee",
      "name": "过滤-获取包含模型 ID 的工作流",
      "type": "n8n-nodes-base.filter",
      "position": [
        -440,
        -40
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "f7433843-53c6-4e77-8f51-c70921342a0f",
              "operator": {
                "type": "string",
                "operation": "contains"
              },
              "leftValue": "={{ $json.nodes.toJsonString() }}",
              "rightValue": "modelId"
            },
            {
              "id": "8a9ff036-dc80-4b55-919b-e2dba22667cf",
              "operator": {
                "type": "string",
                "operation": "notEquals"
              },
              "leftValue": "={{ $json.id }}",
              "rightValue": "={{ $workflow.id }}"
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "727dd95d-c788-4cae-8b25-4ffeff705579",
      "name": "拆分-节点",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        -40,
        80
      ],
      "parameters": {
        "options": {},
        "fieldToSplitOut": "nodes"
      },
      "typeVersion": 1,
      "alwaysOutputData": true
    },
    {
      "id": "5a9d8012-a559-4c06-a3f9-be1a7b8f7ce6",
      "name": "过滤-包含 modelId 的节点",
      "type": "n8n-nodes-base.filter",
      "position": [
        180,
        80
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "or",
          "conditions": [
            {
              "id": "5c06371f-9bc4-4fdd-bac2-9b9cdc28f77c",
              "operator": {
                "type": "string",
                "operation": "exists",
                "singleValue": true
              },
              "leftValue": "={{ $json.parameters.modelId.value.toString() }}",
              "rightValue": ""
            },
            {
              "id": "6888c3a4-c988-48a1-aefc-d359f2ffeef5",
              "operator": {
                "type": "string",
                "operation": "exists",
                "singleValue": true
              },
              "leftValue": "={{ $json.parameters.model.toString() }}",
              "rightValue": ""
            }
          ]
        }
      },
      "typeVersion": 2.2,
      "alwaysOutputData": true
    },
    {
      "id": "d4301765-8855-46fe-b2a2-06b03577a3b9",
      "name": "Google Sheets-保存节点和工作流数据",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        700,
        80
      ],
      "parameters": {
        "columns": {
          "value": {},
          "schema": [
            {
              "id": "node_name",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "node_name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "modelId_value",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "modelId_value",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "modelId_name",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "modelId_name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "workflow_name",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "workflow_name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "workflow_id",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "workflow_id",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "workflow_url",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "workflow_url",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "autoMapInputData",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1iMh0C-Niu1ko4-u2BHo0cgGeVQKcYHflBzRxtbWJiRI/edit#gid=0",
          "cachedResultName": "data"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1iMh0C-Niu1ko4-u2BHo0cgGeVQKcYHflBzRxtbWJiRI",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1iMh0C-Niu1ko4-u2BHo0cgGeVQKcYHflBzRxtbWJiRI/edit?usp=drivesdk",
          "cachedResultName": "n8n-check-workflow-use-what-ai-model"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "tufEzuSTEveV3tuA",
          "name": "(Personal)Google Sheets account"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "78ae0f64-d6fa-46f6-a09f-e0a6bd6d21df",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        380,
        -40
      ],
      "parameters": {
        "width": 260,
        "height": 320,
        "content": "## 在此处更改为您的 n8n 域名"
      },
      "typeVersion": 1
    },
    {
      "id": "2b8853d8-0436-4347-9c44-df45fcacfbd4",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -920,
        -160
      ],
      "parameters": {
        "color": 3,
        "width": 420,
        "height": 320,
        "content": "## 请注意"
      },
      "typeVersion": 1
    },
    {
      "id": "611a6d7f-3955-43b5-b029-e738be2372cd",
      "name": "便签4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -920,
        -440
      ],
      "parameters": {
        "color": 7,
        "width": 340,
        "height": 240,
        "content": "## 由 darrell_tw_ 创建"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "callerPolicy": "workflowsFromSameOwner",
    "executionOrder": "v1",
    "timeSavedPerExecution": 3
  },
  "versionId": "30ea02b5-e1a3-4789-86a3-cdd937e2ce82",
  "connections": {
    "Loop Over Items": {
      "main": [
        [],
        [
          {
            "node": "Split Out-nodes",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split Out-nodes": {
      "main": [
        [
          {
            "node": "Filter-node contain modelId",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "n8n-get all workflow": {
      "main": [
        [
          {
            "node": "Filter-get workflow contain modelid",
            "type": "main",
            "index": 0
          },
          {
            "node": "Google Sheets-Clear Sheet Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Edit Fields-set_model_data": {
      "main": [
        [
          {
            "node": "Google Sheets-Save node and workflow data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter-node contain modelId": {
      "main": [
        [
          {
            "node": "Edit Fields-set_model_data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "When clicking ‘Test workflow’": {
      "main": [
        [
          {
            "node": "n8n-get all workflow",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter-get workflow contain modelid": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets-Save node and workflow data": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流？

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

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

中级 - 人工智能, IT 运维

需要付费吗？

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

相关工作流推荐

模板演示-chatgpt-图片-1-带-drive-和-sheet副本
使用GPT-image-1生成图像并存储到Google Drive，包含成本跟踪
Set
Split Out
Aggregate
+8
16 节点darrell_tw
设计
CSV到HubSpot上传器（动态字段映射与Google Sheets集成）
具有动态字段映射和Google Sheets集成的CSV到HubSpot上传器
If
Set
Code
+10
36 节点PollupAI
人工智能
基于AI的潜在客户信息增强（Bright Data MCP和Google Sheets）
基于AI的潜在客户信息增强：使用Bright Data MCP和Google Sheets
If
Set
Wait
+19
51 节点Cyril Nicko Gaspar
销售
API架构提取器
API架构提取器
If
Set
Code
+22
88 节点Polina Medvedieva
工程
敏捷团队冲刺规划自动化
使用OpenAI、Google日历和Gmail为敏捷团队自动化冲刺规划
If
Set
Code
+17
52 节点Willemijn
产品
我的工作流5
使用AI邮件个性化的自动化LinkedIn潜在客户生成（未完成）
If
Set
Code
+9
37 节点Matthieu
销售
工作流信息
难度等级
中级
节点数量12
分类2
节点类型8
难度说明

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

作者
darrell_tw

darrell_tw

@darrelltw

Martech Engineer with automation. here is my website: https://www.darrelltw.com/

外部链接
在 n8n.io 查看 →

分享此工作流