Sleeper NFL球员同步
中级
这是一个Engineering领域的自动化工作流,包含 8 个节点。主要使用 Airtable, Function, HttpRequest, ManualTrigger 等节点。 每日从Sleeper API同步NFL球员数据到Airtable,用于梦幻橄榄球
前置要求
- •Airtable API Key
- •可能需要目标 API 的认证凭证
分类
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
"id": "ZhfmOgJPvGSVYbW6",
"meta": {
"instanceId": "a809fd627b2613fd5f594e594dc09461e003791f4f2685c28c38bd6e7412da94",
"templateCredsSetupCompleted": true
},
"name": "Sleeper NFL球员同步",
"tags": [
{
"id": "WmTFiLJ95HFPXqRi",
"name": "Sleeper App",
"createdAt": "2025-07-17T22:48:15.153Z",
"updatedAt": "2025-07-17T22:48:15.153Z"
},
{
"id": "cAqEn4DEnwzPtps3",
"name": "NFL",
"createdAt": "2025-07-17T22:48:26.719Z",
"updatedAt": "2025-07-17T22:48:26.719Z"
},
{
"id": "hjgJG0lktWIfajF6",
"name": "Sports Analytics",
"createdAt": "2025-07-17T22:49:59.440Z",
"updatedAt": "2025-07-17T22:49:59.440Z"
},
{
"id": "k8b9jCXWemqmcw96",
"name": "Fantasy Football",
"createdAt": "2025-07-17T22:48:36.489Z",
"updatedAt": "2025-07-17T22:48:36.489Z"
}
],
"nodes": [
{
"id": "0580f014-506f-458d-bbbc-0ac9717a379b",
"name": "获取Sleeper NFL球员",
"type": "n8n-nodes-base.httpRequest",
"position": [
432,
384
],
"parameters": {
"url": "https://api.sleeper.app/v1/players/nfl",
"options": {}
},
"typeVersion": 1
},
{
"id": "6c24acb9-97de-44c4-a906-b7b68b366777",
"name": "将球员对象转换为数组",
"type": "n8n-nodes-base.function",
"position": [
656,
384
],
"parameters": {
"functionCode": "const output = [];for (const [key, value] of Object.entries(items[0].json)) { output.push({ json: value });}return output;"
},
"typeVersion": 1
},
{
"id": "12a20f2f-18f0-4757-9454-0850afe7bfd8",
"name": "筛选活跃幻想球员",
"type": "n8n-nodes-base.function",
"position": [
880,
384
],
"parameters": {
"functionCode": "return items.filter(item => { const pos = item.json.position; const name = item.json.full_name; const team = item.json.team; return name && team && ['QB','RB','WR','TE'].includes(pos);});"
},
"typeVersion": 1
},
{
"id": "5100e689-8ecb-46e0-a2b0-96e9c320737e",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-208,
0
],
"parameters": {
"color": 4,
"width": 480,
"height": 364,
"content": "## Sleeper NFL球员每日同步"
},
"typeVersion": 1
},
{
"id": "0bf4ef61-74b8-47ab-9f18-6ef070bd8681",
"name": "便签 1",
"type": "n8n-nodes-base.stickyNote",
"position": [
1056,
-48
],
"parameters": {
"color": 6,
"width": 400,
"height": 400,
"content": "请确保设置您的Airtable访问令牌。这样您就可以选择要映射到的基础和表格。"
},
"typeVersion": 1
},
{
"id": "7ef0fab5-0d99-4cb4-ba72-45fa6e6d1e8c",
"name": "便签 2",
"type": "n8n-nodes-base.stickyNote",
"position": [
768,
80
],
"parameters": {
"height": 272,
"content": "筛选活跃幻想球员节点将把所有活跃的NFL球员拉取到您的表格中,包含以下输出:"
},
"typeVersion": 1
},
{
"id": "a8b8de6c-395d-4d7b-b6bc-2b9012e4432d",
"name": "当点击\"执行工作流\"时",
"type": "n8n-nodes-base.manualTrigger",
"position": [
192,
384
],
"parameters": {},
"typeVersion": 1
},
{
"id": "a963e97b-746f-4319-ade1-66aec84ddd93",
"name": "创建或更新记录",
"type": "n8n-nodes-base.airtable",
"position": [
1088,
384
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": ""
},
"table": {
"__rl": true,
"mode": "list",
"value": ""
},
"columns": {
"value": {},
"schema": [],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "upsert"
},
"typeVersion": 2.1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "943e1390-ee18-4212-a1f9-b578045882a7",
"connections": {
"0580f014-506f-458d-bbbc-0ac9717a379b": {
"main": [
[
{
"node": "6c24acb9-97de-44c4-a906-b7b68b366777",
"type": "main",
"index": 0
}
]
]
},
"12a20f2f-18f0-4757-9454-0850afe7bfd8": {
"main": [
[
{
"node": "a963e97b-746f-4319-ade1-66aec84ddd93",
"type": "main",
"index": 0
}
]
]
},
"6c24acb9-97de-44c4-a906-b7b68b366777": {
"main": [
[
{
"node": "12a20f2f-18f0-4757-9454-0850afe7bfd8",
"type": "main",
"index": 0
}
]
]
},
"a8b8de6c-395d-4d7b-b6bc-2b9012e4432d": {
"main": [
[
{
"node": "0580f014-506f-458d-bbbc-0ac9717a379b",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流?
复制上方的 JSON 配置代码,在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」,粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景?
中级 - 工程
需要付费吗?
本工作流完全免费,您可以直接导入使用。但请注意,工作流中使用的第三方服务(如 OpenAI API)可能需要您自行付费。
相关工作流推荐
使用Bright Data网络爬虫进行结构化批量数据提取
使用Bright Data和Webhook通知的异步批量网络爬取
If
Set
Wait
+
If
Set
Wait
16 节点Ranjan Dailata
工程
Google趋势数据提取,使用Bright Data和Google Gemini进行摘要生成
使用Bright Data和Google Gemini的Google趋势数据提取与摘要生成
Set
Gmail
Function
+
Set
Gmail
Function
16 节点Ranjan Dailata
工程
AI智能助手:与Supabase存储和Google Drive文件对话
AI智能助手:与Supabase存储和Google Drive文件对话
If
Set
Wait
+
If
Set
Wait
62 节点Mark Shcherbakov
工程
与Supabase存储中文件对话的AI智能体
与Supabase存储中文件对话的AI智能体
If
Merge
Switch
+
If
Merge
Switch
33 节点Mark Shcherbakov
工程
AI智能助手与Airtable对话及数据分析
AI智能助手与Airtable对话及数据分析
If
Set
Merge
+
If
Set
Merge
41 节点Mark Shcherbakov
工程
基于 Bright Data MCP 的 AI Telegram 数据提取机器人
集成 Bright Data MCP 的 AI Telegram 数据提取机器人
If
N8n
Wait
+
If
N8n
Wait
21 节点Cyril Nicko Gaspar
工程
工作流信息
难度等级
中级
节点数量8
分类1
节点类型5
作者
Patrick Jennings
@patjennings916Accountant/CPA guy that's nice with a little no-code. Serving up templates in all kinds of fields for the n8n community.
外部链接
在 n8n.io 查看 →
分享此工作流