Automatisches Extrahieren von TikTok-Nutzerdaten mit Dumpling AI und Segmentierung in Airtable
Dies ist ein AI, Marketing-Bereich Automatisierungsworkflow mit 6 Nodes. Hauptsächlich werden If, Airtable, HttpRequest, AirtableTrigger und andere Nodes verwendet, kombiniert mit KI-Technologie für intelligente Automatisierung. Automatisches Erfassen von TikTok-Benutzerdaten durch Dumpling AI und Segmentierung in Airtable
- •Airtable API Key
- •Möglicherweise sind Ziel-API-Anmeldedaten erforderlich
Verwendete Nodes (6)
Kategorie
{
"id": "thlRQfqORNJEz5Wm",
"meta": {
"instanceId": "a1ae5c8dc6c65e674f9c3947d083abcc749ef2546dff9f4ff01de4d6a36ebfe6",
"templateCredsSetupCompleted": true
},
"name": "Auto-Scrape TikTok User Data via Dumpling AI and Segment in Airtable",
"tags": [],
"nodes": [
{
"id": "ff24f466-3350-4259-b8c4-12525f8fffce",
"name": "Überwache neue TikTok-Handles in Airtable",
"type": "n8n-nodes-base.airtableTrigger",
"position": [
-660,
-80
],
"parameters": {
"baseId": {
"__rl": true,
"mode": "id",
"value": ""
},
"tableId": {
"__rl": true,
"mode": "id",
"value": ""
},
"pollTimes": {
"item": [
{
"mode": "everyMinute"
}
]
},
"triggerField": "Tik tok username",
"authentication": "airtableTokenApi",
"additionalFields": {}
},
"credentials": {
"airtableTokenApi": {
"id": "H8PVkBgUPCcUhhRC",
"name": "Airtable Personal Access Token account"
}
},
"typeVersion": 1
},
{
"id": "0f31947a-154a-4902-9cb4-d4b30979539e",
"name": "Erhalte TikTok-Profildaten über Dumpling AI",
"type": "n8n-nodes-base.httpRequest",
"position": [
-440,
-80
],
"parameters": {
"url": "https://app.dumplingai.com/api/v1/get-tiktok-profile",
"method": "POST",
"options": {},
"jsonBody": "={\n \"handle\": \"{{ $json.fields['Tik tok username'] }}\"\n}\n ",
"sendBody": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth"
},
"credentials": {
"httpHeaderAuth": {
"id": "RLFzAcGRepr5eXZB",
"name": "n8n"
}
},
"typeVersion": 4.2
},
{
"id": "ba10cc9a-dede-41e3-9027-93fc07b039a0",
"name": "Prüfe, ob Follower-Anzahl ≥ 100k",
"type": "n8n-nodes-base.if",
"position": [
-220,
-80
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "aa9c64c8-e59d-4f8a-bf9b-e264027bf975",
"operator": {
"type": "number",
"operation": "gte"
},
"leftValue": "={{ $json.stats.followerCount }}",
"rightValue": 100000
}
]
}
},
"typeVersion": 2.2
},
{
"id": "a0556542-a7f6-4e2a-9154-7f862f13f8fd",
"name": "Aktualisiere Datensatz mit grundlegenden TikTok-Statistiken",
"type": "n8n-nodes-base.airtable",
"position": [
0,
-180
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "",
"cachedResultUrl": "https://airtable.com/appPSvSKdA6075xJC",
"cachedResultName": "Testing n8n"
},
"table": {
"__rl": true,
"mode": "list",
"value": "",
"cachedResultUrl": "https://airtable.com/appPSvSKdA6075xJC/tblmqgjEwgIR6rpUZ",
"cachedResultName": "Table 1"
},
"columns": {
"value": {
"ID": "={{ $json.user.id }}",
"id": "={{ $('Watch for New TikTok Handles in Airtable').item.json.id }}",
"heartCount": "={{ $json.stats.heart }}",
"videoCount": "={{ $json.stats.videoCount }}",
"followerCount": "={{ $json.stats.followerCount }}",
"followingCount": "={{ $json.stats.followingCount }}",
"Tik tok username": "={{ $('Watch for New TikTok Handles in Airtable').item.json.fields['Tik tok username'] }}"
},
"schema": [
{
"id": "id",
"type": "string",
"display": true,
"removed": false,
"readOnly": true,
"required": false,
"displayName": "id",
"defaultMatch": true
},
{
"id": "Tik tok username",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Tik tok username",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "ID",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "ID",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "followerCount",
"type": "number",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "followerCount",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "followingCount",
"type": "number",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "followingCount",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "heartCount",
"type": "number",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "heartCount",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "videoCount",
"type": "number",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "videoCount",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "avatarLarger",
"type": "array",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "avatarLarger",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update"
},
"credentials": {
"airtableTokenApi": {
"id": "H8PVkBgUPCcUhhRC",
"name": "Airtable Personal Access Token account"
}
},
"typeVersion": 2.1
},
{
"id": "d3662656-b23e-49d6-8a85-0c9662ea3025",
"name": "Aktualisiere Datensatz mit allen TikTok-Statistiken",
"type": "n8n-nodes-base.airtable",
"position": [
40,
0
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "",
"cachedResultUrl": "https://airtable.com/appPSvSKdA6075xJC",
"cachedResultName": "Testing n8n"
},
"table": {
"__rl": true,
"mode": "list",
"value": "",
"cachedResultUrl": "https://airtable.com/appPSvSKdA6075xJC/tblmqgjEwgIR6rpUZ",
"cachedResultName": "Table 1"
},
"columns": {
"value": {
"ID": "={{ $json.user.id }}",
"id": "={{ $('Watch for New TikTok Handles in Airtable').item.json.id }}",
"heartCount": "={{ $json.stats.heart }}",
"videoCount": "={{ $json.stats.videoCount }}",
"avatarLarger": "={{ $json.user.avatarThumb }}",
"followerCount": "={{ $json.stats.followerCount }}",
"followingCount": "={{ $json.stats.followingCount }}",
"Tik tok username": "={{ $('Watch for New TikTok Handles in Airtable').item.json.fields['Tik tok username'] }}"
},
"schema": [
{
"id": "id",
"type": "string",
"display": true,
"removed": false,
"readOnly": true,
"required": false,
"displayName": "id",
"defaultMatch": true
},
{
"id": "Tik tok username",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Tik tok username",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "ID",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "ID",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "followerCount",
"type": "number",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "followerCount",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "followingCount",
"type": "number",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "followingCount",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "heartCount",
"type": "number",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "heartCount",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "videoCount",
"type": "number",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "videoCount",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "avatarLarger",
"type": "array",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "avatarLarger",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update"
},
"credentials": {
"airtableTokenApi": {
"id": "H8PVkBgUPCcUhhRC",
"name": "Airtable Personal Access Token account"
}
},
"typeVersion": 2.1
},
{
"id": "5db3da72-a48b-4b79-bb28-730ed2529406",
"name": "Notizzettel",
"type": "n8n-nodes-base.stickyNote",
"position": [
-860,
-460
],
"parameters": {
"width": 760,
"height": 360,
"content": "### 📊 TikTok Profile Scraper & Airtable Filter with Dumpling AI\n\nThis workflow takes a list of TikTok profile URLs from Airtable and enriches them using Dumpling AI’s scraping API. It checks each profile's follower count, and only those with more than a set threshold (e.g. 10,000) are saved into a second Airtable base for qualified influencers.\n\n**How it works:**\n1. **Start Manually:** You trigger the workflow manually to begin the scraping process.\n2. **Get TikTok Links from Airtable:** It reads TikTok profile URLs from the source Airtable table.\n3. **Scrape Each Profile with Dumpling AI:** Sends the URL to Dumpling AI’s web scraper API to fetch profile stats.\n4. **Extract Follower Count:** Uses the Edit Fields node to isolate the follower count from the returned data.\n5. **Filter Profiles:** The workflow only continues for profiles with more than 10,000 followers.\n6. **Save to Airtable:** The qualified profiles are stored in a second Airtable table for follow-up or outreach.\n\nThis is perfect for brands, agencies, or marketers who want to automatically qualify TikTok creators before reaching out.\n"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "7b954f02-3201-44d8-bb10-ed0036bb71ed",
"connections": {
"0f31947a-154a-4902-9cb4-d4b30979539e": {
"main": [
[
{
"node": "ba10cc9a-dede-41e3-9027-93fc07b039a0",
"type": "main",
"index": 0
}
]
]
},
"ba10cc9a-dede-41e3-9027-93fc07b039a0": {
"main": [
[
{
"node": "a0556542-a7f6-4e2a-9154-7f862f13f8fd",
"type": "main",
"index": 0
}
],
[
{
"node": "d3662656-b23e-49d6-8a85-0c9662ea3025",
"type": "main",
"index": 0
}
]
]
},
"ff24f466-3350-4259-b8c4-12525f8fffce": {
"main": [
[
{
"node": "0f31947a-154a-4902-9cb4-d4b30979539e",
"type": "main",
"index": 0
}
]
]
}
}
}Wie verwende ich diesen Workflow?
Kopieren Sie den obigen JSON-Code, erstellen Sie einen neuen Workflow in Ihrer n8n-Instanz und wählen Sie "Aus JSON importieren". Fügen Sie die Konfiguration ein und passen Sie die Anmeldedaten nach Bedarf an.
Für welche Szenarien ist dieser Workflow geeignet?
Fortgeschritten - Künstliche Intelligenz, Marketing
Ist es kostenpflichtig?
Dieser Workflow ist völlig kostenlos. Beachten Sie jedoch, dass Drittanbieterdienste (wie OpenAI API), die im Workflow verwendet werden, möglicherweise kostenpflichtig sind.
Verwandte Workflows
Yang
@yangDiesen Workflow teilen