Automatisches Extrahieren von TikTok-Nutzerdaten mit Dumpling AI und Segmentierung in Airtable

Fortgeschritten

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

Voraussetzungen
  • Airtable API Key
  • Möglicherweise sind Ziel-API-Anmeldedaten erforderlich
Workflow-Vorschau
Visualisierung der Node-Verbindungen, mit Zoom und Pan
Workflow exportieren
Kopieren Sie die folgende JSON-Konfiguration und importieren Sie sie in n8n
{
  "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
          }
        ]
      ]
    }
  }
}
Häufig gestellte Fragen

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.

Workflow-Informationen
Schwierigkeitsgrad
Fortgeschritten
Anzahl der Nodes6
Kategorie2
Node-Typen5
Schwierigkeitsbeschreibung

Für erfahrene Benutzer, mittelkomplexe Workflows mit 6-15 Nodes

Externe Links
Auf n8n.io ansehen

Diesen Workflow teilen

Kategorien

Kategorien: 34