8
n8n 中文网amn8n.com

使用 Dumpling AI 抓取 TikTok 个人资料和文字记录并保存到 Google Sheets

中级

这是一个AI, IT Ops领域的自动化工作流，包含 6 个节点。主要使用 Set, HttpRequest, GoogleSheets, GoogleSheetsTrigger 等节点，结合人工智能技术实现智能自动化。 使用 Dumpling AI 抓取 TikTok 个人资料和文字记录并保存到 Google Sheets

前置要求
  • •可能需要目标 API 的认证凭证
  • •Google Sheets API 凭证

使用的节点 (6)

Set
StickyNote
HttpRequest
GoogleSheets
GoogleSheetsTrigger

分类

人工智能
IT 运维
工作流预览
可视化展示节点连接关系，支持缩放和平移
React Flow
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
  "id": "Ds5H7wm74GpWPQNC",
  "meta": {
    "instanceId": "a1ae5c8dc6c65e674f9c3947d083abcc749ef2546dff9f4ff01de4d6a36ebfe6",
    "templateCredsSetupCompleted": true
  },
  "name": "使用Dumpling AI抓取TikTok个人资料和文字记录并保存到Google Sheets",
  "tags": [],
  "nodes": [
    {
      "id": "5f9ee78c-393b-4e7b-87e8-d89101bc50bb",
      "name": "监控表格中的新TikTok链接",
      "type": "n8n-nodes-base.googleSheetsTrigger",
      "position": [
        -600,
        -220
      ],
      "parameters": {
        "event": "rowAdded",
        "options": {},
        "pollTimes": {
          "item": [
            {
              "mode": "everyMinute"
            }
          ]
        },
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1DWaAJRixKtThSewdhCxHILsvaAlSzd8kKx6-w3oWqx8/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1DWaAJRixKtThSewdhCxHILsvaAlSzd8kKx6-w3oWqx8/edit?usp=drivesdk",
          "cachedResultName": "Videos"
        }
      },
      "credentials": {
        "googleSheetsTriggerOAuth2Api": {
          "id": "qDzHSzTkclwDHpSR",
          "name": "Google Sheets Trigger account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "c60c56c9-4a52-4640-8c07-236ee8a281ab",
      "name": "从TikTok URL提取用户名",
      "type": "n8n-nodes-base.set",
      "position": [
        -380,
        -220
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "42a565a7-1f01-49b6-a781-ab3d9896828c",
              "name": "USERNAME",
              "type": "string",
              "value": "={{ $json[\"USERNAME Video\"] && $json[\"USERNAME Video\"].match(/@([^\\/]+)/) ? $json[\"USERNAME Video\"].match(/@([^\\/]+)/)[1] : null }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "0f60893c-5cfa-4521-9921-91cf61acbf12",
      "name": "使用Dumpling AI获取TikTok个人资料数据",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -160,
        -220
      ],
      "parameters": {
        "url": "https://app.dumplingai.com/api/v1/get-tiktok-profile",
        "method": "POST",
        "options": {},
        "jsonBody": "={\n  \"handle\": \"{{ $json.USERNAME }}\"\n}\n",
        "sendBody": true,
        "sendQuery": true,
        "sendHeaders": true,
        "specifyBody": "json",
        "authentication": "genericCredentialType",
        "genericAuthType": "httpHeaderAuth",
        "queryParameters": {
          "parameters": [
            {}
          ]
        },
        "headerParameters": {
          "parameters": [
            {}
          ]
        }
      },
      "credentials": {
        "httpHeaderAuth": {
          "id": "RLFzAcGRepr5eXZB",
          "name": "n8n"
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "bbe2ccef-6ce2-4ace-9adb-0ec947dcdc44",
      "name": "使用Dumpling AI获取TikTok视频文字记录",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        60,
        -220
      ],
      "parameters": {
        "url": " https://app.dumplingai.com/api/v1/get-tiktok-transcript",
        "method": "POST",
        "options": {},
        "jsonBody": "={\n  \"videoUrl\": \"{{ $('Watch for New TikTok Links in Sheet').item.json['USERNAME Video'] }}\"\n}\n",
        "sendBody": true,
        "specifyBody": "json",
        "authentication": "genericCredentialType",
        "genericAuthType": "httpHeaderAuth"
      },
      "credentials": {
        "httpHeaderAuth": {
          "id": "RLFzAcGRepr5eXZB",
          "name": "n8n"
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "7785398a-fae6-49fb-9e38-d98e76a9dd71",
      "name": "将个人资料统计数据和文字记录保存到Google表格",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        280,
        -220
      ],
      "parameters": {
        "columns": {
          "value": {
            "Username ": "={{ $(' Extract Username from TikTok URL').item.json.USERNAME }}",
            "Transcript": "={{ $json.transcript }}",
            "Video Count": "={{ $(' Get TikTok Profile Data using Dumpling AI').item.json.stats.videoCount }}",
            "heart count": "={{ $(' Get TikTok Profile Data using Dumpling AI').item.json.stats.heart }}",
            "Follower count": "={{ $(' Get TikTok Profile Data using Dumpling AI').item.json.stats.followerCount }}",
            "USERNAME Video": "={{ $('Watch for New TikTok Links in Sheet').item.json['USERNAME Video'] }}",
            "Following Count": "={{ $(' Get TikTok Profile Data using Dumpling AI').item.json.stats.followingCount }}"
          },
          "schema": [
            {
              "id": "USERNAME Video",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "USERNAME Video",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Username ",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Username ",
              "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": "Transcript",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Transcript",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1DWaAJRixKtThSewdhCxHILsvaAlSzd8kKx6-w3oWqx8/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1DWaAJRixKtThSewdhCxHILsvaAlSzd8kKx6-w3oWqx8/edit?usp=drivesdk",
          "cachedResultName": "Videos"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "GaJqJHuS5mQxap7q",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "f702661a-1495-44df-990d-eb92bbff562f",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -910,
        -620
      ],
      "parameters": {
        "width": 720,
        "height": 560,
        "content": "🎯 工作流目的"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "9b39c10d-bac9-43a4-a31a-cc07b69d7004",
  "connections": {
    " Extract Username from TikTok URL": {
      "main": [
        [
          {
            "node": " Get TikTok Profile Data using Dumpling AI",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Watch for New TikTok Links in Sheet": {
      "main": [
        [
          {
            "node": " Extract Username from TikTok URL",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    " Get TikTok Profile Data using Dumpling AI": {
      "main": [
        [
          {
            "node": "Get TikTok Video Transcript using Dumpling AI",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get TikTok Video Transcript using Dumpling AI": {
      "main": [
        [
          {
            "node": "Save Profile Stats and Transcript to Google Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流？

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

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

中级 - 人工智能, IT 运维

需要付费吗？

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

相关工作流推荐

使用Dumpling AI和Google表格从网站截图提取产品信息
通过Dumpling AI和Google表格从网站截图中提取产品信息
Set
Http Request
Google Sheets
+3
8 节点Yang
人工智能
使用Dumpling AI从Google Drive提取发票数据至Sheets
使用Dumpling AI从Google Drive提取发票数据并保存至Sheets
Code
Split Out
Google Drive
+5
8 节点Yang
人工智能
使用 Dumpling AI 从 URL 抓取书籍，清理 HTML，保存到 Sheets，通过邮件发送 CSV
使用 Dumpling AI 从 URL 抓取书籍，清理 HTML，保存到表格，邮件发送 CSV
Html
Sort
Gmail
+5
11 节点Yang
工程
通过 Dumpling AI 抓取 Google Places 并自动保存到 Google Sheets
通过 Dumpling AI 抓取 Google Places 并自动保存到 Google Sheets
Split Out
Http Request
Google Sheets
+2
6 节点Yang
人工智能
AI新闻简报构建器：使用Dumpling AI抓取网站，GPT-4o摘要
AI新闻简报构建器：Dumpling AI抓取网站，GPT-4o摘要
Set
Code
Gmail
+6
10 节点Yang
人工智能
使用Dumpling AI和GPT-4o从文章自动生成LinkedIn帖子
使用Dumpling AI和GPT-4o从文章自动生成LinkedIn帖子
Set
Http Request
Google Sheets
+4
10 节点Yang
人工智能
工作流信息
难度等级
中级
节点数量6
分类2
节点类型5
难度说明

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

作者
Yang

Yang

@yang
外部链接
在 n8n.io 查看 →

分享此工作流