8
n8n 中文网amn8n.com

使用 Dumpling AI + GPT-4 根据用户名筛选 TikTok 网红

中级

这是一个Content Creation, Multimodal AI领域的自动化工作流,包含 9 个节点。主要使用 Switch, FormTrigger, HttpRequest, GoogleSheets, OpenAi 等节点。 使用 Dumpling AI + GPT-4 根据用户名筛选 TikTok 网红

前置要求
  • 可能需要目标 API 的认证凭证
  • Google Sheets API 凭证
  • OpenAI API Key
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
  "id": "hAq4tv014k8txJGa",
  "meta": {
    "instanceId": "a1ae5c8dc6c65e674f9c3947d083abcc749ef2546dff9f4ff01de4d6a36ebfe6",
    "templateCredsSetupCompleted": true
  },
  "name": "使用 Dumpling AI + GPT-4 根据用户名筛选 TikTok 网红",
  "tags": [],
  "nodes": [
    {
      "id": "fcbf3d68-d5d3-48b6-8980-09f2ec1815a8",
      "name": "通过 TikTok 用户名表单触发",
      "type": "n8n-nodes-base.formTrigger",
      "position": [
        -656,
        -240
      ],
      "webhookId": "4830822b-7f78-4387-9a3b-99e73db0d9a7",
      "parameters": {
        "options": {},
        "formTitle": "Tiktok User",
        "formFields": {
          "values": [
            {
              "fieldLabel": "Tik Tok Username"
            }
          ]
        }
      },
      "typeVersion": 2.3
    },
    {
      "id": "76fbe780-3739-49db-bce8-982db09856f3",
      "name": "获取 TikTok 个人资料(Dumpling AI)",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -432,
        -240
      ],
      "parameters": {
        "url": "https://app.dumplingai.com/api/v1/get-tiktok-profile",
        "method": "POST",
        "options": {},
        "jsonBody": "={ \"handle\": \"{{ $json['Tik Tok Username'] }}\" }",
        "sendBody": true,
        "specifyBody": "json",
        "authentication": "genericCredentialType",
        "genericAuthType": "httpHeaderAuth"
      },
      "credentials": {
        "httpHeaderAuth": {
          "id": "RLFzAcGRepr5eXZB",
          "name": "Dumpling AI-n8n"
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "6be1336b-21d2-4da6-8f98-bfe5d2b26bbf",
      "name": "评估资料资格(GPT-4)",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        -208,
        -240
      ],
      "parameters": {
        "modelId": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-4.1",
          "cachedResultName": "GPT-4.1"
        },
        "options": {},
        "messages": {
          "values": [
            {
              "role": "system",
              "content": "=You are analyzing a TikTok user profile. Check the following conditions:\n\n1. The user must have at least 40 videos.  \n2. The user must have at least 100000 followers.  \n3. The user must have a heart count (total likes) greater than 300000.  \n\nIf all three conditions are met, output exactly: \"Qualified for influencer outreach\".  \nIf any condition is not met, output exactly: \"Not qualified\".\n"
            },
            {
              "content": "=\n  video_count: {{ $json.stats.videoCount }},\n  follower_count\": {{ $json.stats.followerCount }}\n  heart_count\": {{ $json.stats.heartCount }}\n\n "
            }
          ]
        }
      },
      "credentials": {
        "openAiApi": {
          "id": "dd8NvMC6rvx8RITo",
          "name": "OpenAi account 2"
        }
      },
      "typeVersion": 1.8
    },
    {
      "id": "a9c9d2ac-a201-42b1-b43a-03986b111fc1",
      "name": "检查用户是否已存在",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        144,
        -240
      ],
      "parameters": {
        "options": {},
        "filtersUI": {
          "values": [
            {
              "lookupValue": "={{ $('Get TikTok Profile (Dumpling AI)').item.json.user.id }}",
              "lookupColumn": "User ID "
            }
          ]
        },
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1TE8Llr1PfaKs0OhH3TMr73nwcohKyGaGVXwsaEEMHgY/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1TE8Llr1PfaKs0OhH3TMr73nwcohKyGaGVXwsaEEMHgY/edit?usp=drivesdk",
          "cachedResultName": "TikTOK"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "GaJqJHuS5mQxap7q",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.7,
      "alwaysOutputData": true
    },
    {
      "id": "4e20d033-ec7f-40d1-8bc1-ab0741894d8d",
      "name": "根据存在性进行路由",
      "type": "n8n-nodes-base.switch",
      "position": [
        368,
        -240
      ],
      "parameters": {
        "rules": {
          "values": [
            {
              "outputKey": "Does not exist",
              "conditions": {
                "options": {
                  "version": 2,
                  "leftValue": "",
                  "caseSensitive": true,
                  "typeValidation": "strict"
                },
                "combinator": "and",
                "conditions": [
                  {
                    "id": "43a01054-c765-4719-bfe8-db2219f1db55",
                    "operator": {
                      "type": "number",
                      "operation": "equals"
                    },
                    "leftValue": "={{ Object.keys($json).length }}",
                    "rightValue": 0
                  }
                ]
              },
              "renameOutput": true
            },
            {
              "outputKey": "Exists",
              "conditions": {
                "options": {
                  "version": 2,
                  "leftValue": "",
                  "caseSensitive": true,
                  "typeValidation": "strict"
                },
                "combinator": "and",
                "conditions": [
                  {
                    "id": "bc4b7e5a-1ddb-4a41-9f2f-8bd928d9872b",
                    "operator": {
                      "type": "number",
                      "operation": "gte"
                    },
                    "leftValue": "={{ Object.keys($json).length }}",
                    "rightValue": 1
                  }
                ]
              },
              "renameOutput": true
            }
          ]
        },
        "options": {}
      },
      "typeVersion": 3.3
    },
    {
      "id": "70df6b45-8521-406b-9009-c80c26169fea",
      "name": "将新 TikTok 用户添加到表格",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        672,
        -320
      ],
      "parameters": {
        "columns": {
          "value": {
            "User ID ": "={{ $('Get TikTok Profile (Dumpling AI)').item.json.user.id }}",
            "Qualifed?": "={{ $('Evaluate Profile Qualification (GPT-4)').item.json.message.content }}",
            "Heart Count": "={{ $('Get TikTok Profile (Dumpling AI)').item.json.stats.heartCount }}",
            "Video Count": "={{ $('Get TikTok Profile (Dumpling AI)').item.json.stats.videoCount }}",
            "Tik Tok user": "={{ $('Get TikTok Profile (Dumpling AI)').item.json.user.uniqueId }}",
            "Follower Count": "={{ $('Get TikTok Profile (Dumpling AI)').item.json.stats.followerCount }}",
            "Following Count": "={{ $('Get TikTok Profile (Dumpling AI)').item.json.stats.followingCount }}"
          },
          "schema": [
            {
              "id": "Tik Tok user",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Tik Tok user",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "User ID ",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "User ID ",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Follower Count",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Follower Count",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Following Count",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Following Count",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Heart Count",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Heart Count",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Video Count",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Video Count",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Qualifed?",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Qualifed?",
              "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/1TE8Llr1PfaKs0OhH3TMr73nwcohKyGaGVXwsaEEMHgY/edit#gid=0",
          "cachedResultName": "Tik TOK ID"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1TE8Llr1PfaKs0OhH3TMr73nwcohKyGaGVXwsaEEMHgY/edit?usp=drivesdk",
          "cachedResultName": "TikTOK"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "GaJqJHuS5mQxap7q",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.7
    },
    {
      "id": "dc2c7d9f-d364-4756-975e-6fdb95df41b4",
      "name": "更新表格中的现有 TikTok 用户",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        608,
        -112
      ],
      "parameters": {
        "columns": {
          "value": {
            "User ID ": "={{ $('Get TikTok Profile (Dumpling AI)').item.json.user.id }}",
            "Qualifed?": "={{ $('Evaluate Profile Qualification (GPT-4)').item.json.message.content }}",
            "Video Count": "={{ $('Get TikTok Profile (Dumpling AI)').item.json.stats.heartCount }}",
            "Tik Tok user": "={{ $('Get TikTok Profile (Dumpling AI)').item.json.user.uniqueId }}",
            "Follower Count": "={{ $('Get TikTok Profile (Dumpling AI)').item.json.stats.followerCount }}",
            "Following Count": "={{ $('Get TikTok Profile (Dumpling AI)').item.json.stats.followingCount }}"
          },
          "schema": [
            {
              "id": "Tik Tok user",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Tik Tok user",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "User ID ",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "User ID ",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Follower Count",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Follower Count",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Following Count",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Following Count",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Heart Count",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Heart Count",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Video Count",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Video Count",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Qualifed?",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Qualifed?",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "User ID "
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "appendOrUpdate",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1TE8Llr1PfaKs0OhH3TMr73nwcohKyGaGVXwsaEEMHgY/edit#gid=0",
          "cachedResultName": "Tik TOK ID"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1TE8Llr1PfaKs0OhH3TMr73nwcohKyGaGVXwsaEEMHgY/edit?usp=drivesdk",
          "cachedResultName": "TikTOK"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "GaJqJHuS5mQxap7q",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.7
    },
    {
      "id": "c05eccd1-f75c-4c88-b593-4e4ae4a4812b",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -704,
        -592
      ],
      "parameters": {
        "width": 768,
        "height": 592,
        "content": "## 🧠 获取 TikTok 个人资料并通过 AI 评估"
      },
      "typeVersion": 1
    },
    {
      "id": "bc173c53-c336-40c7-b0fd-94d86d746869",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        96,
        -592
      ],
      "parameters": {
        "color": 4,
        "width": 672,
        "height": 592,
        "content": "## 📄 检查 Google Sheets 并保存结果"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {
    "Trigger on TikTok Username Form": [
      {
        "json": {
          "formMode": "test",
          "submittedAt": "2025-09-27T07:48:33.738+10:00",
          "Tik Tok Username": "jess.find.me"
        }
      }
    ]
  },
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "307c922e-3067-4d31-bfa1-b7eb07966aa5",
  "connections": {
    "Route Based on Existence": {
      "main": [
        [
          {
            "node": "Add New TikTok User to Sheet",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Update Existing TikTok User in Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Check if User Already Exists": {
      "main": [
        [
          {
            "node": "Route Based on Existence",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Trigger on TikTok Username Form": {
      "main": [
        [
          {
            "node": "Get TikTok Profile (Dumpling AI)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get TikTok Profile (Dumpling AI)": {
      "main": [
        [
          {
            "node": "Evaluate Profile Qualification (GPT-4)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Evaluate Profile Qualification (GPT-4)": {
      "main": [
        [
          {
            "node": "Check if User Already Exists",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流?

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

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

中级 - 内容创作, 多模态 AI

需要付费吗?

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

工作流信息
难度等级
中级
节点数量9
分类2
节点类型6
难度说明

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

外部链接
在 n8n.io 查看

分享此工作流