8
n8n 中文网amn8n.com

n8n 社区关键词主题跟踪器

中级

这是一个Other领域的自动化工作流，包含 10 个节点。主要使用 Slack, SplitOut, EmailSend, HttpRequest, GoogleSheets 等节点。 通过关键词跟踪 n8n 社区主题并保存到 Google Sheets

前置要求
  • •Slack Bot Token 或 Webhook URL
  • •可能需要目标 API 的认证凭证
  • •Google Sheets API 凭证

使用的节点 (10)

Slack
SplitOut
EmailSend
StickyNote
HttpRequest
GoogleSheets
ScheduleTrigger
GoogleSheetsTrigger

分类

其他
工作流预览
可视化展示节点连接关系，支持缩放和平移
React Flow
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
  "id": "R6tFG45dQydBz63e",
  "meta": {
    "instanceId": "fb2ac1a770dc8dc4bb24d7e6a9ab7e89f53c6b6759adeb7ab76c09a3d8f6f4a9",
    "templateCredsSetupCompleted": true
  },
  "name": "n8n 社区关键词主题跟踪器",
  "tags": [],
  "nodes": [
    {
      "id": "b735226c-ce7f-4daf-8255-45ba80262aa5",
      "name": "Google Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        760,
        0
      ],
      "parameters": {
        "columns": {
          "value": {
            "id": "={{ $json.id }}",
            "url": "=https://community.n8n.io/t/{{ $json.slug }}",
            "date": "={{ $json.created_at }}",
            "title": "={{ $json.title }}",
            "has_solution": "={{ $json.has_accepted_answer }}"
          },
          "schema": [
            {
              "id": "id",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "id",
              "defaultMatch": true,
              "canBeUsedToMatch": true
            },
            {
              "id": "date",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "date",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "title",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "title",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "url",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "url",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "has_solution",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "has_solution",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "id"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "appendOrUpdate",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "",
          "cachedResultName": ""
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "",
          "cachedResultUrl": "",
          "cachedResultName": ""
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "",
          "name": ""
        }
      },
      "notesInFlow": true,
      "typeVersion": 4.5
    },
    {
      "id": "bbcf5797-c3dc-495f-85e9-178755d29c50",
      "name": "计划触发器",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -120,
        0
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "field": "hours"
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "357975bc-9e13-494d-93da-c4238b42b5b3",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        60,
        -220
      ],
      "parameters": {
        "width": 340,
        "height": 420,
        "content": "## 修改查询参数"
      },
      "typeVersion": 1
    },
    {
      "id": "f53b958d-71d4-49cb-9db2-48e8d12301a9",
      "name": "获取主题",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        460,
        0
      ],
      "parameters": {
        "options": {},
        "fieldToSplitOut": "topics"
      },
      "typeVersion": 1
    },
    {
      "id": "6fcd7991-4d3c-4705-a2f6-a85660cad80f",
      "name": "获取最新主题",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        180,
        0
      ],
      "parameters": {
        "url": "https://community.n8n.io/search",
        "options": {
          "response": {
            "response": {
              "responseFormat": "json"
            }
          }
        },
        "sendQuery": true,
        "queryParameters": {
          "parameters": [
            {
              "name": "q",
              "value": "ADD-YOUR-KEYWORD-HERE"
            },
            {
              "name": "order",
              "value": "latest"
            }
          ]
        }
      },
      "notesInFlow": true,
      "typeVersion": 4.2
    },
    {
      "id": "2483ecbc-6795-4fed-bce3-23108bc7087a",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        640,
        -220
      ],
      "parameters": {
        "width": 340,
        "height": 420,
        "content": "## 添加您的 Google Sheets API 凭据"
      },
      "typeVersion": 1
    },
    {
      "id": "4791f99d-7bc2-4d85-8bd3-86a78475aed0",
      "name": "Google Sheets 触发器",
      "type": "n8n-nodes-base.googleSheetsTrigger",
      "position": [
        -80,
        640
      ],
      "parameters": {
        "options": {},
        "pollTimes": {
          "item": [
            {
              "mode": "everyMinute"
            }
          ]
        },
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1DDVOKXbRGM_2lHZSUm4bH_VqAZ9jKBMOARVyf3hE5kI/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1DDVOKXbRGM_2lHZSUm4bH_VqAZ9jKBMOARVyf3hE5kI",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1DDVOKXbRGM_2lHZSUm4bH_VqAZ9jKBMOARVyf3hE5kI/edit?usp=drivesdk",
          "cachedResultName": "n8n Community topic tracker based on keyword"
        }
      },
      "credentials": {
        "googleSheetsTriggerOAuth2Api": {
          "id": "LGzWbSDkVxbOBOBT",
          "name": "Google Sheets Trigger account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "c1d43a4b-f681-40f6-9736-10ee3ad511f2",
      "name": "Slack",
      "type": "n8n-nodes-base.slack",
      "position": [
        220,
        580
      ],
      "webhookId": "aca9b9e2-e9d4-40eb-a2be-bd2a07b31ce8",
      "parameters": {
        "text": "New topics are available in n8n community",
        "otherOptions": {}
      },
      "typeVersion": 2.3
    },
    {
      "id": "cc531378-6341-43ea-87c5-03a048ff74a9",
      "name": "发送邮件",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        220,
        760
      ],
      "parameters": {
        "text": "New topics are available in n8n community.",
        "options": {},
        "emailFormat": "text"
      },
      "credentials": {
        "smtp": {
          "id": "tDSWM9BZ9H2FaedY",
          "name": "SMTP account 2"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "2b025fc2-4e78-4120-9d36-0ca3f4fd5743",
      "name": "便签2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -140,
        360
      ],
      "parameters": {
        "width": 580,
        "height": 600,
        "content": "## 当表格更新时发送消息（可选）"
      },
      "typeVersion": 1
    }
  ],
  "active": true,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "3cd62f18-29c4-4e14-b560-5c96e33650d4",
  "connections": {
    "Get topics": {
      "main": [
        [
          {
            "node": "Google Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "Get latest topics",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get latest topics": {
      "main": [
        [
          {
            "node": "Get topics",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets Trigger": {
      "main": [
        [
          {
            "node": "Slack",
            "type": "main",
            "index": 0
          },
          {
            "node": "Send Email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流？

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

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

中级 - 其他

需要付费吗？

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

相关工作流推荐

在可视化参考库中探索n8n节点
在可视化参考库中探索n8n节点
If
Ftp
Set
+93
113 节点I versus AI
其他
使用Apollo和人工验证发现并丰富决策者信息
使用Apollo和人工验证发现并丰富决策者信息
If
Code
Merge
+10
35 节点Uche Madu
销售
工作搜索自动化
使用 Adzuna API、GPT-3.5 和 Google Sheets 自动化职位搜索与匹配
Set
Gmail
Split Out
+5
12 节点Gerald Denor
其他
自动化 YouTube 订阅通知，集成 RSS 和邮件
自动化 YouTube 订阅通知，集成 RSS 和邮件
If
Filter
You Tube
+7
18 节点Sweenu
其他
YT AI新闻播放列表创建器/AI新闻表单更新器
使用Google Sheets创建每日YouTube播放列表，并在Telegram中接收通知
Filter
You Tube
Split Out
+6
23 节点Dustin
其他
YT睡前故事 - 短视频 - N8N市场
使用OpenAI生成YouTube睡前故事
Set
Code
Wait
+10
43 节点Samautomation.work
其他
工作流信息
难度等级
中级
节点数量10
分类1
节点类型8
难度说明

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

作者
Hostinger

Hostinger

@hostinger

Hostinger aims to make online presence accessible to everyone worldwide – from developers to aspiring bloggers and business owners. With our fast hosting technology, AI-powered Website Builder, and easy-to-operate hPanel you can succeed online faster and easier.

外部链接
在 n8n.io 查看 →

分享此工作流