8
n8n 中文网amn8n.com

Twitter关键词与公众人物监控

中级

这是一个Marketing领域的自动化工作流,包含 8 个节点。主要使用 Set, Merge, Twitter, Airtable, ScheduleTrigger 等节点。 Twitter关键词与公众人物监控,支持Airtable自动归档

前置要求
  • Twitter API 凭证
  • Airtable API Key

分类

工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
  "id": "lPYVaz2xbN5zFDIL",
  "meta": {
    "instanceId": "cbc68f6c587084f6fe53914a07ed22d475640cb7a6f4ade193e6f0c6d7a06ce8",
    "templateCredsSetupCompleted": true
  },
  "name": "临时",
  "tags": [
    {
      "id": "DaQLpYItTEM2y8Gt",
      "name": "Product",
      "createdAt": "2025-06-17T10:48:17.486Z",
      "updatedAt": "2025-06-17T10:48:17.486Z"
    },
    {
      "id": "6X5c5WbCRWtxJbl2",
      "name": "AI",
      "createdAt": "2025-06-17T10:48:17.367Z",
      "updatedAt": "2025-06-17T10:48:17.367Z"
    },
    {
      "id": "ycHNTMiM8vy98zu1",
      "name": "Building blocks",
      "createdAt": "2025-06-17T10:48:17.563Z",
      "updatedAt": "2025-06-17T10:48:17.563Z"
    },
    {
      "id": "UJ6au0mv063gOupq",
      "name": "Finance",
      "createdAt": "2025-06-17T10:48:17.583Z",
      "updatedAt": "2025-06-17T10:48:17.583Z"
    },
    {
      "id": "CaWiGPzJpyfUHdxp",
      "name": "IT Ops",
      "createdAt": "2025-06-17T10:48:17.388Z",
      "updatedAt": "2025-06-17T10:48:17.388Z"
    },
    {
      "id": "6Uolue5XigSZ2IYx",
      "name": "OpenAI",
      "createdAt": "2025-06-17T10:48:17.508Z",
      "updatedAt": "2025-06-17T10:48:17.508Z"
    },
    {
      "id": "nA8GpDM4XoG5aJ0A",
      "name": "Marketing",
      "createdAt": "2025-06-17T10:48:17.532Z",
      "updatedAt": "2025-06-17T10:48:17.532Z"
    },
    {
      "id": "J4gTJX9lSPm3wByF",
      "name": "Support",
      "createdAt": "2025-06-17T10:48:17.464Z",
      "updatedAt": "2025-06-17T10:48:17.464Z"
    },
    {
      "id": "i294x7TPtUQgJkmv",
      "name": "HR",
      "createdAt": "2025-06-17T10:48:17.426Z",
      "updatedAt": "2025-06-17T10:48:17.426Z"
    }
  ],
  "nodes": [
    {
      "id": "e061d33b-2f23-4cf3-9573-5c4d99950f90",
      "name": "Twitter",
      "type": "n8n-nodes-base.twitter",
      "position": [
        380,
        0
      ],
      "parameters": {
        "limit": 100,
        "operation": "search",
        "searchText": "Narendra Modi",
        "additionalFields": {
          "resultType": "mixed"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "d83d3421-a750-455b-9414-b1eacf042544",
      "name": "设置 Airtable 列表",
      "type": "n8n-nodes-base.set",
      "position": [
        600,
        200
      ],
      "parameters": {
        "values": {
          "number": [
            {
              "name": "Likes",
              "value": "={{$node[\"Twitter\"].json[\"favorite_count\"] ? $node[\"Twitter\"].json[\"favorite_count\"] : 0 }}"
            }
          ],
          "string": [
            {
              "name": "Tweet",
              "value": "={{$node[\"get airtable list\"].json[\"fields\"][\"Tweet\"]}}"
            },
            {
              "name": "Tweet_id",
              "value": "={{$node[\"get airtable list\"].json[\"fields\"][\"Tweet_id\"]}}"
            },
            {
              "name": "Tweet URL",
              "value": "={{$node[\"get airtable list\"].json[\"fields\"][\"Tweet URL\"]}}"
            },
            {
              "name": "Author",
              "value": "={{$node[\"get airtable list\"].json[\"fields\"][\"Author\"]}}"
            },
            {
              "name": "Time",
              "value": "={{$node[\"get airtable list\"].json[\"fields\"][\"Time\"]}}"
            }
          ]
        },
        "options": {
          "dotNotation": false
        },
        "keepOnlySet": true
      },
      "typeVersion": 1
    },
    {
      "id": "878b07b3-322c-4a41-bc4f-28f47a62afe2",
      "name": "获取 Airtable 列表",
      "type": "n8n-nodes-base.airtable",
      "position": [
        380,
        200
      ],
      "parameters": {
        "table": "tbl6rexxFBodzKVoC",
        "operation": "list",
        "application": "app36P08S3Jzki6qJ",
        "additionalOptions": {}
      },
      "typeVersion": 1
    },
    {
      "id": "9f893824-aad9-44c1-9da2-136959ac09fd",
      "name": "设置 Twitter 数据",
      "type": "n8n-nodes-base.set",
      "position": [
        600,
        0
      ],
      "parameters": {
        "values": {
          "number": [
            {
              "name": "Likes",
              "value": "={{$node[\"Twitter\"].json[\"favorite_count\"]}}"
            }
          ],
          "string": [
            {
              "name": "Tweet",
              "value": "={{$node[\"Twitter\"].json[\"text\"]}}"
            },
            {
              "name": "Tweet_id",
              "value": "={{$node[\"Twitter\"].json[\"id\"]}}"
            },
            {
              "name": "Tweet URL",
              "value": "=https://twitter.com/{{$node[\"Twitter\"].json[\"user\"][\"screen_name\"]}}/status/{{$node[\"Twitter\"].json[\"id_str\"]}}"
            },
            {
              "name": "Author",
              "value": "={{$node[\"Twitter\"].json[\"in_reply_to_screen_name\"]}}"
            },
            {
              "name": "Time",
              "value": "={{$node[\"Twitter\"].json[\"created_at\"]}}"
            }
          ]
        },
        "options": {
          "dotNotation": false
        },
        "keepOnlySet": true
      },
      "typeVersion": 1
    },
    {
      "id": "2aee3941-6e08-4893-806e-52b1cd963e68",
      "name": "仅保留新推文",
      "type": "n8n-nodes-base.merge",
      "position": [
        820,
        100
      ],
      "parameters": {
        "mode": "removeKeyMatches",
        "propertyName1": "Tweet_id",
        "propertyName2": "Tweet_id"
      },
      "typeVersion": 1
    },
    {
      "id": "86cd15e4-621f-48c6-90a8-c4bdf136b75c",
      "name": "将新推文追加到 Airtable",
      "type": "n8n-nodes-base.airtable",
      "position": [
        1040,
        100
      ],
      "parameters": {
        "table": "tbl6rexxFBodzKVoC",
        "options": {},
        "operation": "append",
        "application": "app36P08S3Jzki6qJ",
        "addAllFields": "={{true}}"
      },
      "typeVersion": 1
    },
    {
      "id": "edfafc16-bd4a-49d8-bf08-8ed4638fc00b",
      "name": "上午 8 点",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        160,
        100
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "triggerAtHour": 8
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "1fb69414-d14b-42a4-8078-fd69fed9d28d",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -420,
        -420
      ],
      "parameters": {
        "width": 1800,
        "height": 1060,
        "content": "# 🐦 Twitter 到 Airtable 归档器"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "dd98aabf-f750-41cb-8e26-b2196e794bcc",
  "connections": {
    "8 AM": {
      "main": [
        [
          {
            "node": "Twitter",
            "type": "main",
            "index": 0
          },
          {
            "node": "get airtable list",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Twitter": {
      "main": [
        [
          {
            "node": "set twitter data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set_AT_list": {
      "main": [
        [
          {
            "node": "Leave only new tweets",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "set twitter data": {
      "main": [
        [
          {
            "node": "Leave only new tweets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "get airtable list": {
      "main": [
        [
          {
            "node": "Set_AT_list",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Leave only new tweets": {
      "main": [
        [
          {
            "node": "Append new tweets to airtable",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流?

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

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

中级 - 营销

需要付费吗?

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

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

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

外部链接
在 n8n.io 查看

分享此工作流