使用 TikTok、Airtable 和 Apify 归档热门 TikTok 标签

• •Airtable API Key

{
  "meta": {
    "instanceId": "6493d417e13567dbe50b02d0e6eea87fdb5934d9207730b096adeb482873eda1",
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "eae8bb8d-38e3-4215-bcaa-0cbf37ad689d",
      "name": "开始：每月计划",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        0,
        360
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "field": "months"
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "166350e8-b294-4426-8be0-162c58030b81",
      "name": "1. 运行 TikTok 标签抓取器",
      "type": "n8n-nodes-apify.apify",
      "position": [
        220,
        360
      ],
      "parameters": {
        "build": "",
        "memory": {},
        "actorId": {
          "__rl": true,
          "mode": "list",
          "value": "iegmveuLh4C0XH7Hc",
          "cachedResultUrl": "https://console.apify.com/actors/undefined/input",
          "cachedResultName": "tiktok-trending-hashtags-analytics"
        },
        "maxItems": 100,
        "resource": "Actors",
        "webhooks": "",
        "operation": "Run actor",
        "customBody": "{\n    \"country\": \"US\",\n    \"result_type\": \"top100\",\n    \"top100_new_on_board\": false,\n    \"top100_period\": \"30\"\n}",
        "useCustomBody": true,
        "requestOptions": {}
      },
      "credentials": {
        "apifyApi": {
          "id": "P2sbylUrTu44kyCw",
          "name": "Apify account sigma"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "40f9c3b6-7bc8-4ddd-9944-12c02a71945b",
      "name": "2. 获取抓取的标签数据",
      "type": "n8n-nodes-apify.apify",
      "position": [
        440,
        360
      ],
      "parameters": {
        "omit": "",
        "clean": true,
        "fields": "",
        "unwind": "",
        "flatten": "",
        "resource": "Datasets",
        "datasetId": "={{ $json.data.defaultDatasetId }}",
        "operation": "Get items",
        "attachment": false,
        "requestOptions": {}
      },
      "credentials": {
        "apifyApi": {
          "id": "P2sbylUrTu44kyCw",
          "name": "Apify account sigma"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "29c2b157-cb90-42a5-9bf4-8fc3540fe0a4",
      "name": "3. 将标签拆分为项目",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        660,
        360
      ],
      "parameters": {
        "options": {},
        "fieldToSplitOut": "data"
      },
      "typeVersion": 1
    },
    {
      "id": "386898b1-0ea3-41dc-ac70-a5189e5e7fd2",
      "name": "4. 保存标签到 Airtable",
      "type": "n8n-nodes-base.airtable",
      "position": [
        880,
        360
      ],
      "parameters": {
        "base": {
          "__rl": true,
          "mode": "list",
          "value": "appwEOGxCbXgEGwjT",
          "cachedResultUrl": "https://airtable.com/appwEOGxCbXgEGwjT",
          "cachedResultName": "Creative Ideation"
        },
        "table": {
          "__rl": true,
          "mode": "list",
          "value": "tblwu2gVIYLTwN1yq",
          "cachedResultUrl": "https://airtable.com/appwEOGxCbXgEGwjT/tblwu2gVIYLTwN1yq",
          "cachedResultName": "Trending Hashtags"
        },
        "columns": {
          "value": {
            "ID": "={{ $json.hashtag_id }}",
            "Name": "={{ $json.hashtag_name }}",
            "Rank": "={{ $json.rank }}",
            "Status": "Added",
            "Country": "={{ $json.country_info.value }}",
            "Industry": "={{ $json.industry_info.value }}",
            "Date Added": "={{$now}}",
            "Video Views": "={{ $json.video_views }}",
            "Publish Count": "={{ $json.publish_cnt }}"
          },
          "schema": [
            {
              "id": "ID",
              "type": "string",
              "display": true,
              "removed": false,
              "readOnly": false,
              "required": false,
              "displayName": "ID",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Name",
              "type": "string",
              "display": true,
              "removed": false,
              "readOnly": false,
              "required": false,
              "displayName": "Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Country",
              "type": "string",
              "display": true,
              "removed": false,
              "readOnly": false,
              "required": false,
              "displayName": "Country",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Industry",
              "type": "string",
              "display": true,
              "removed": false,
              "readOnly": false,
              "required": false,
              "displayName": "Industry",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Date Added",
              "type": "dateTime",
              "display": true,
              "removed": false,
              "readOnly": false,
              "required": false,
              "displayName": "Date Added",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Status",
              "type": "options",
              "display": true,
              "options": [
                {
                  "name": "Added",
                  "value": "Added"
                },
                {
                  "name": "Scraped",
                  "value": "Scraped"
                },
                {
                  "name": "",
                  "value": ""
                }
              ],
              "removed": false,
              "readOnly": false,
              "required": false,
              "displayName": "Status",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Publish Count",
              "type": "number",
              "display": true,
              "removed": false,
              "readOnly": false,
              "required": false,
              "displayName": "Publish Count",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Video Views",
              "type": "number",
              "display": true,
              "removed": false,
              "readOnly": false,
              "required": false,
              "displayName": "Video Views",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Rank",
              "type": "number",
              "display": true,
              "removed": false,
              "readOnly": false,
              "required": false,
              "displayName": "Rank",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {
          "typecast": true
        },
        "operation": "create"
      },
      "credentials": {
        "airtableTokenApi": {
          "id": "zCSIQRPMWSjY2aVg",
          "name": "Airtable Personal Access Token account"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "6dd6e4f6-6d32-4e7f-b1b8-c3cd20eb7e79",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1080,
        -40
      ],
      "parameters": {
        "width": 660,
        "height": 1500,
        "content": "## 使用 Apify 将热门 TikTok 标签归档到 Airtable"
      },
      "typeVersion": 1
    }
  ],
  "pinData": {},
  "connections": {
    "Start: Monthly Schedule": {
      "main": [
        [
          {
            "node": "1. Run TikTok Hashtag Scraper",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "2. Get Scraped Hashtag Data": {
      "main": [
        [
          {
            "node": "3. Split Hashtags into Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "4. Save Hashtag to Airtable": {
      "main": [
        []
      ]
    },
    "3. Split Hashtags into Items": {
      "main": [
        [
          {
            "node": "4. Save Hashtag to Airtable",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "1. Run TikTok Hashtag Scraper": {
      "main": [
        [
          {
            "node": "2. Get Scraped Hashtag Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}