8
n8n 中文网amn8n.com

Reddit自由职业工作监控与Google表格跟踪和Telegram警报

中级

这是一个Lead Generation领域的自动化工作流,包含 11 个节点。主要使用 Set, Code, Filter, SplitOut, Telegram 等节点。 Reddit自由职业工作监控与Google表格跟踪和Telegram警报

前置要求
  • Telegram Bot Token
  • 可能需要目标 API 的认证凭证
  • Google Sheets API 凭证
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
  "meta": {
    "instanceId": "b6731f6e46273cffeac6b5188a5b3bcb0840c00108e73b48ae2b799ac6e8e081",
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "f1342627-4d31-4f16-a020-cda26f14748c",
      "name": "每 5 分钟运行一次",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        240,
        120
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "2ae99530-e45a-46b4-9a88-24fb5c54bf8b",
      "name": "查找自由职业需求帖子",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        460,
        120
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "80f04d39-58c3-4342-9729-ba9f073db667",
      "name": "提取帖子元数据",
      "type": "n8n-nodes-base.set",
      "position": [
        680,
        120
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "541383f1-5ed9-4033-978b-442276908247",
      "name": "确保需求是有偿的",
      "type": "n8n-nodes-base.filter",
      "position": [
        1260,
        340
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "f75740b3-480f-42bd-9033-192c9817be3f",
      "name": "获取帖子 UTC 时间",
      "type": "n8n-nodes-base.set",
      "position": [
        2060,
        560
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "61ed2ab7-9cb3-4f70-ab00-0afa578f1b42",
      "name": "检查现有行",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1480,
        340
      ],
      "parameters": {},
      "executeOnce": true,
      "typeVersion": 4.6,
      "alwaysOutputData": true
    },
    {
      "id": "ab92c8aa-79f3-45b6-8651-2cfea0372e8b",
      "name": "筛选唯一帖子",
      "type": "n8n-nodes-base.code",
      "position": [
        1700,
        340
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "853ef1e0-a238-4e4c-ab5e-459d9a75233b",
      "name": "保存到表格",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2280,
        560
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "71efa8e6-8e1a-4042-ae9f-2d41f195c93c",
      "name": "在 Telegram 中通知用户",
      "type": "n8n-nodes-base.telegram",
      "position": [
        2500,
        560
      ],
      "webhookId": "b033adda-57ee-46ee-97e2-96de0b3e598e",
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "da33c131-b34b-402a-8ecd-20432a3cabd6",
      "name": "将数组拆分为单独帖子",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        900,
        120
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "c2aac5ed-06d3-4582-99da-bb4b1da7d845",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -780,
        0
      ],
      "parameters": {
        "content": "Emelia 触发器"
      },
      "typeVersion": 1
    }
  ],
  "pinData": {},
  "connections": {
    "Save in sheets": {
      "main": [
        [
          {
            "node": "Inform User in telegram",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get UTC of Post": {
      "main": [
        [
          {
            "node": "Save in sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Check present Rows": {
      "main": [
        [
          {
            "node": "Filter Unique Posts",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter Unique Posts": {
      "main": [
        [
          {
            "node": "Get UTC of Post",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Run Every 5 Minutes": {
      "main": [
        [
          {
            "node": "Look for freelance requirement posts",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract Post Metadata": {
      "main": [
        [
          {
            "node": "Seperate array into individual posts",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Make sure the requirement is paid": {
      "main": [
        [
          {
            "node": "Check present Rows",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Look for freelance requirement posts": {
      "main": [
        [
          {
            "node": "Extract Post Metadata",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Seperate array into individual posts": {
      "main": [
        [
          {
            "node": "Make sure the requirement is paid",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流?

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

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

中级 - 潜在客户开发

需要付费吗?

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

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

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

外部链接
在 n8n.io 查看

分享此工作流