获取Discord服务器中具有特定角色的所有成员
高级
这是一个Other, Building Blocks领域的自动化工作流，包含 16 个节点。主要使用 If, Set, Merge, Filter, Discord 等节点。 获取Discord服务器中具有特定角色的所有成员
前置要求
- •Discord Bot Token 或 Webhook
- •HTTP Webhook 端点（n8n 会自动生成）
- •Google Sheets API 凭证
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "257476b1ef58bf3cb6a46e65fac7ee34a53a5e1a8492d5c6e4da5f87c9b82833",
"templateId": "2105"
},
"nodes": [
{
"id": "3abfbefa-0a41-4dd2-a79b-99aa02447a6f",
"name": "当点击\"测试工作流\"时",
"type": "n8n-nodes-base.manualTrigger",
"position": [
380,
240
],
"parameters": {},
"typeVersion": 1
},
{
"id": "5233daa6-9b3f-4048-8187-b78decac0bbd",
"name": "删除 ID",
"type": "n8n-nodes-base.googleSheets",
"position": [
1900,
380
],
"parameters": {
"operation": "delete",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1lj15jPOKrfS0-EAnCmths4-SVXwQJ78eBnq8C4DFRx4/edit#gid=0",
"cachedResultName": "Last Member"
},
"documentId": {
"__rl": true,
"mode": "url",
"value": "={{ $('Setup: Edit this to get started').first().json['Google Sheets URL'] }}"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "9",
"name": "Nik's Google"
}
},
"executeOnce": true,
"typeVersion": 4.2,
"alwaysOutputData": true
},
{
"id": "d3be48cd-9652-43ea-9bbf-d9d3a6c972ae",
"name": "保存 ID",
"type": "n8n-nodes-base.googleSheets",
"position": [
2040,
380
],
"parameters": {
"columns": {
"value": {
"ID": "={{ $('Merge').last().json.user.id }}"
},
"schema": [
{
"id": "ID",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "ID",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"ID"
]
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1lj15jPOKrfS0-EAnCmths4-SVXwQJ78eBnq8C4DFRx4/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "url",
"value": "={{ $('Setup: Edit this to get started').first().json['Google Sheets URL'] }}"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "9",
"name": "Nik's Google"
}
},
"typeVersion": 4.2
},
{
"id": "a8cb3b10-1143-4467-936c-36ea29c3489a",
"name": "获取 ID",
"type": "n8n-nodes-base.googleSheets",
"position": [
920,
240
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1lj15jPOKrfS0-EAnCmths4-SVXwQJ78eBnq8C4DFRx4/edit#gid=0",
"cachedResultName": "Last Member"
},
"documentId": {
"__rl": true,
"mode": "url",
"value": "={{ $('Setup: Edit this to get started').first().json['Google Sheets URL'] }}"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "9",
"name": "Nik's Google"
}
},
"typeVersion": 4.2,
"alwaysOutputData": true
},
{
"id": "82bdeec7-5ff5-4ed5-8c57-f3007bd7f81e",
"name": "合并",
"type": "n8n-nodes-base.merge",
"position": [
1520,
240
],
"parameters": {},
"typeVersion": 2.1
},
{
"id": "19247435-e0b0-4eac-8807-cb9e4ac532ab",
"name": "检查是否还有更多成员",
"type": "n8n-nodes-base.if",
"position": [
1740,
240
],
"parameters": {
"options": {},
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "11bd5681-d979-40a8-ba0c-8c697532cf0d",
"operator": {
"type": "number",
"operation": "lt"
},
"leftValue": "={{ $input.all().length }}",
"rightValue": 100
}
]
}
},
"typeVersion": 2
},
{
"id": "9845c82b-942e-4265-be8c-c4b1a9199b1e",
"name": "我们完成了",
"type": "n8n-nodes-base.noOp",
"position": [
2040,
160
],
"parameters": {},
"typeVersion": 1
},
{
"id": "86bf2fe1-22b3-4563-a4b7-b3603f96cada",
"name": "检查是否有 ID",
"type": "n8n-nodes-base.if",
"position": [
1100,
240
],
"parameters": {
"options": {},
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "8cabfe61-be13-462f-a8ce-99ba5304fa10",
"operator": {
"type": "string",
"operation": "exists",
"singleValue": true
},
"leftValue": "={{ $json.ID }}",
"rightValue": ""
}
]
}
},
"executeOnce": true,
"typeVersion": 2
},
{
"id": "96324abb-2464-418a-850f-c6f8d3ce209f",
"name": "筛选仅包含具有角色的成员",
"type": "n8n-nodes-base.filter",
"position": [
1740,
-80
],
"parameters": {
"options": {},
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "cac0aeae-ff45-4717-b11e-4e19995649fe",
"operator": {
"type": "number",
"operation": "gt"
},
"leftValue": "={{ $json.roles.filter(role => role === $('Setup: Edit this to get started').first().json['Role ID']).length }}",
"rightValue": 0
}
]
}
},
"typeVersion": 2
},
{
"id": "bc012053-c619-479b-8bcb-9325c209d999",
"name": "获取前 100 名成员",
"type": "n8n-nodes-base.discord",
"position": [
1300,
260
],
"parameters": {
"guildId": {
"__rl": true,
"mode": "id",
"value": "={{ $('Setup: Edit this to get started').first().json['Discord ID'] }}"
},
"options": {
"simplify": true
},
"resource": "member"
},
"credentials": {
"discordBotApi": {
"id": "M7ApR1tTlF4HFHn4",
"name": "Discord Bot account"
}
},
"typeVersion": 2
},
{
"id": "7214e807-5a51-438d-9db8-32821307f4ea",
"name": "获取最后 ID 之后的下 100 名成员",
"type": "n8n-nodes-base.discord",
"position": [
1300,
80
],
"parameters": {
"after": "={{ $('Get ID').first().json.ID }}",
"guildId": {
"__rl": true,
"mode": "id",
"value": "={{ $('Setup: Edit this to get started').first().json['Discord ID'] }}"
},
"options": {
"simplify": true
},
"resource": "member"
},
"credentials": {
"discordBotApi": {
"id": "M7ApR1tTlF4HFHn4",
"name": "Discord Bot account"
}
},
"typeVersion": 2
},
{
"id": "158d3e7a-cc8c-4ab3-b59f-5a2251c79613",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
517,
-60.44028103044491
],
"parameters": {
"color": 5,
"width": 350.3145253526498,
"height": 491.3512880562059,
"content": "## 设置"
},
"typeVersion": 1
},
{
"id": "11926dbb-a5e0-48f9-8453-7dc21ecf6717",
"name": "设置：编辑此处以开始",
"type": "n8n-nodes-base.set",
"position": [
640,
240
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "7c8cce4f-1330-425a-baff-4c40320f2335",
"name": "Role ID",
"type": "string",
"value": "<Enter your roleID here>"
},
{
"id": "8533b358-d8e6-4eba-9159-f6bdd2e0df65",
"name": "Google Sheets URL",
"type": "string",
"value": "<Enter your Sheets URL here>"
},
{
"id": "bb87e6f5-def9-4625-818a-ce6ff7b44ed7",
"name": "Discord ID",
"type": "string",
"value": "<Enter your server/guild ID here>"
}
]
}
},
"typeVersion": 3.3
},
{
"id": "334377fc-ddb8-4c0d-9ddc-f6949b98578c",
"name": "Webhook",
"type": "n8n-nodes-base.webhook",
"disabled": true,
"position": [
380,
420
],
"webhookId": "b40c1140-75a7-481e-b8c7-789eef1f8bac",
"parameters": {
"path": "discord-template",
"options": {},
"responseMode": "responseNode"
},
"typeVersion": 1.1
},
{
"id": "8fac2863-a046-4ce7-8391-72486141ea98",
"name": "发送响应",
"type": "n8n-nodes-base.respondToWebhook",
"position": [
1960,
-80
],
"parameters": {
"options": {},
"respondWith": "allIncomingItems"
},
"typeVersion": 1
},
{
"id": "10677a2d-9bcb-4b51-8cab-a49c7f16a8d7",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
1900,
-180
],
"parameters": {
"color": 7,
"height": 265.6674473067916,
"content": "您可以根据您的用例替换此节点。在我的案例中，我已向所有用户发送了私信"
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"Merge": {
"main": [
[
{
"node": "Check if we have more members left",
"type": "main",
"index": 0
},
{
"node": "Filter to only include members with role",
"type": "main",
"index": 0
}
]
]
},
"Get ID": {
"main": [
[
{
"node": "Check if we have an ID",
"type": "main",
"index": 0
}
]
]
},
"SaveID": {
"main": [
[
{
"node": "Get ID",
"type": "main",
"index": 0
}
]
]
},
"Webhook": {
"main": [
[
{
"node": "Setup: Edit this to get started",
"type": "main",
"index": 0
}
]
]
},
"Delete ID": {
"main": [
[
{
"node": "SaveID",
"type": "main",
"index": 0
}
]
]
},
"Get First 100 Members": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 1
}
]
]
},
"Check if we have an ID": {
"main": [
[
{
"node": "Get next 100 Members after last ID",
"type": "main",
"index": 0
}
],
[
{
"node": "Get First 100 Members",
"type": "main",
"index": 0
}
]
]
},
"When clicking \"Test workflow\"": {
"main": [
[
{
"node": "Setup: Edit this to get started",
"type": "main",
"index": 0
}
]
]
},
"Setup: Edit this to get started": {
"main": [
[
{
"node": "Get ID",
"type": "main",
"index": 0
}
]
]
},
"Check if we have more members left": {
"main": [
[
{
"node": "We're done",
"type": "main",
"index": 0
}
],
[
{
"node": "Delete ID",
"type": "main",
"index": 0
}
]
]
},
"Get next 100 Members after last ID": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 0
}
]
]
},
"Filter to only include members with role": {
"main": [
[
{
"node": "Send Response",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 其他, 构建模块
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
在可视化参考库中探索n8n节点
在可视化参考库中探索n8n节点
If
Ftp
Set
+93
113 节点I versus AI
其他
并行子工作流执行后等待全部完成模式
并行子工作流执行后等待全部完成模式
If
Set
Code
+8
18 节点Hubschrauber
其他
Bitrix24开放频道RAG聊天机器人应用工作流示例
Bitrix24 AI驱动的开放频道RAG聊天机器人
If
Set
Merge
+18
34 节点Ferenc Erb
其他
基于AI的潜在客户信息增强（Bright Data MCP和Google Sheets）
基于AI的潜在客户信息增强：使用Bright Data MCP和Google Sheets
If
Set
Wait
+19
51 节点Cyril Nicko Gaspar
销售
潜在客户开发与邮件工作流
使用Google Maps、SendGrid和AI自动化B2B潜在客户开发与邮件营销
If
Set
Code
+21
141 节点Ezema Kingsley Chibuzo
潜在客户开发
灵活新闻聚合器 - 多源集成、AI分析和可设置频道
多源新闻策展系统，集成Mistral AI分析、摘要和自定义频道
If
Set
Xml
+32
120 节点Hybroht
内容创作
