8
n8n 中文网amn8n.com

Google表格集成的自动化SEC Form D申报追踪器

中级

这是一个Crypto Trading领域的自动化工作流，包含 11 个节点。主要使用 Xml, Code, HttpRequest, GoogleSheets, ScheduleTrigger 等节点。 Google表格集成的自动化SEC Form D申报追踪器

前置要求
  • •可能需要目标 API 的认证凭证
  • •Google Sheets API 凭证

使用的节点 (11)

Xml
Code
StickyNote
HttpRequest
GoogleSheets
ScheduleTrigger
RemoveDuplicates

分类

加密货币交易
工作流预览
可视化展示节点连接关系，支持缩放和平移
React Flow
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
  "meta": {
    "instanceId": "8d41476c63702cd0f2be55363b48153c5d4820bb18197ca147e7be50ef236112",
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "1f907433-9095-431b-aa67-183adc3480f2",
      "name": "定时计划：每10分钟（工作时间）",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -832,
        -32
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "field": "cronExpression",
              "expression": "*/10 6-21 * * 1-5"
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "c74658c1-167f-4d15-86c5-de80b9ad5dfb",
      "name": "获取SEC表格D申报文件",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -608,
        -32
      ],
      "parameters": {
        "url": "https://www.sec.gov/cgi-bin/browse-edgar?action=getcurrent&CIK=&type=D&company=&dateb=&owner=include&start=0&count=40&output=atom",
        "options": {},
        "sendHeaders": true,
        "headerParameters": {
          "parameters": [
            {
              "name": "User-Agent",
              "value": "iRocket VC matthew@irocket.vc"
            },
            {
              "name": "Accept-Encoding",
              "value": "gzip, deflate"
            }
          ]
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "55a90c03-a9ed-45f6-a80b-d8a0c862e369",
      "name": "解析SEC RSS订阅源",
      "type": "n8n-nodes-base.xml",
      "position": [
        -384,
        -32
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 1
    },
    {
      "id": "7f8b7312-b1ba-45ec-901c-5df83d549f66",
      "name": "提取并格式化申报数据",
      "type": "n8n-nodes-base.code",
      "position": [
        -160,
        -32
      ],
      "parameters": {
        "jsCode": "// Extract the entries array\nconst entries = $('Parse SEC RSS Feed').first().json.feed.entry;\n\n// Map each entry to a flat object\nreturn entries.map(entry => {\n  // Best method: Extract CIK from title (in parentheses)\n  const titleMatch = entry.title.match(/\\((\\d{10})\\)/);\n  const cikNumber = titleMatch ? titleMatch[1].replace(/^0+/, '') : '';\n  \n  // Get the HTML link\n  const htmlLink = entry.link.href;\n  \n  // Convert to TXT link by:\n  // 1. Removing \"-index.htm\" at the end\n  // 2. Adding \".txt\" extension\n  const txtLink = htmlLink.replace('-index.htm', '.txt');\n  \n  return {\n    cikNumber: cikNumber || '',\n    title: entry.title,\n    formType: entry.category.term,\n    filingLinkHtml: htmlLink,\n    filingLinkTxt: txtLink,\n    updated: entry.updated\n  };\n});"
      },
      "typeVersion": 2
    },
    {
      "id": "cb06eac4-66bc-4cc5-a248-5a4453e04382",
      "name": "仅筛选新申报文件",
      "type": "n8n-nodes-base.removeDuplicates",
      "position": [
        64,
        -32
      ],
      "parameters": {
        "options": {},
        "operation": "removeItemsSeenInPreviousExecutions",
        "dedupeValue": "={{ $json.filingLinkTxt }}"
      },
      "typeVersion": 2
    },
    {
      "id": "440e3de1-7b0f-45b9-8c02-709fb539cf03",
      "name": "保存至SEC数据表格",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        288,
        -32
      ],
      "parameters": {
        "columns": {
          "value": {
            "title": "={{ $json.title }}",
            "updated": "={{ $json.updated }}",
            "formType": "={{ $json.formType }}",
            "cikNumber": "={{ $json.cikNumber }}",
            "filingLinkTxt": "={{ $json.filingLinkTxt }}",
            "filingLinkHtml": "={{ $json.filingLinkHtml }}"
          },
          "schema": [
            {
              "id": "cikNumber",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "cikNumber",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "title",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "title",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "formType",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "formType",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "filingLinkHtml",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "filingLinkHtml",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "filingLinkTxt",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "filingLinkTxt",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "updated",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "updated",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1VoGfVpk1mMrqKIc5hsO7peYuLx0SwhsbW7uUeYJCmrU/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1VoGfVpk1mMrqKIc5hsO7peYuLx0SwhsbW7uUeYJCmrU",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1VoGfVpk1mMrqKIc5hsO7peYuLx0SwhsbW7uUeYJCmrU/edit?usp=drivesdk",
          "cachedResultName": "SEC Data"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "V4NHfo08zBK4IW4e",
          "name": "[Naveen]Google Sheets account"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "a4ea4d52-7a65-4858-916c-17043aeed742",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -448,
        -560
      ],
      "parameters": {
        "width": 528,
        "height": 208,
        "content": "🏛️ SEC表格D申报追踪器"
      },
      "typeVersion": 1
    },
    {
      "id": "b49bec0b-28db-4732-acbd-db8664564b3d",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1296,
        -128
      ],
      "parameters": {
        "color": 5,
        "width": 400,
        "height": 288,
        "content": "⏰ 自动化监控"
      },
      "typeVersion": 1
    },
    {
      "id": "9c2363fe-11e2-4de0-99e9-99f3d6a7311f",
      "name": "便签 2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -736,
        176
      ],
      "parameters": {
        "color": 4,
        "width": 352,
        "height": 192,
        "content": "🌐 SEC EDGAR订阅源"
      },
      "typeVersion": 1
    },
    {
      "id": "0f1414da-6905-4fbb-b8fd-86d21849ecea",
      "name": "便签 3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -384,
        -272
      ],
      "parameters": {
        "color": 6,
        "width": 352,
        "height": 192,
        "content": "⚙️ 数据提取"
      },
      "typeVersion": 1
    },
    {
      "id": "80833ab1-2e86-4feb-a757-5c535e2ec1c7",
      "name": "便签 4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        176,
        144
      ],
      "parameters": {
        "color": 7,
        "width": 544,
        "height": 336,
        "content": "📋 Google Sheets输出"
      },
      "typeVersion": 1
    }
  ],
  "pinData": {},
  "connections": {
    "Parse SEC RSS Feed": {
      "main": [
        [
          {
            "node": "Extract & Format Filing Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Save to SEC Data Sheet": {
      "main": [
        []
      ]
    },
    "Filter New Filings Only": {
      "main": [
        [
          {
            "node": "Save to SEC Data Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fetch SEC Form D Filings": {
      "main": [
        [
          {
            "node": "Parse SEC RSS Feed",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract & Format Filing Data": {
      "main": [
        [
          {
            "node": "Filter New Filings Only",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule: Every 10 min (Business Hours)": {
      "main": [
        [
          {
            "node": "Fetch SEC Form D Filings",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流？

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

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

中级 - 加密货币交易

需要付费吗？

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

相关工作流推荐

YouTube RSS到Slack摘要
使用Google Sheets、RapidAPI和GPT-4o-mini将新YouTube视频摘要发送到Slack
If
Set
Xml
+13
40 节点Naveen Choudhary
人工智能
通过Apify和Firecrawl抓取Google Maps商家并提取联系方式
使用Apify和Firecrawl抓取Google Maps商家信息并提取联系方式
If
Code
Wait
+6
18 节点Naveen Choudhary
销售
基于AI的潜在客户评分与个性化回复（JotForm、GPT和Gmail）
基于AI的潜在客户评分与个性化回复：使用JotForm、GPT和Gmail
Code
Gmail
Http Request
+4
15 节点Naveen Choudhary
客户培育
使用ZoomInfo、Serper和Oxylabs到Google Sheets自动化公司数据丰富
通过ZoomInfo、Serper和Oxylabs到Google Sheets自动化公司数据丰富
If
Code
Html
+6
19 节点Naveen Choudhary
潜在客户开发
情感分析机器人
使用Google Gemini和EODHD新闻API实现自动化股票情感分析
If
Code
Http Request
+6
18 节点Raz Hadas
加密货币交易
Alapaca 交易自动化
AI驱动的自动化股票交易：集成Alpaca和Google Sheets
Code
Wait
Merge
+5
19 节点Raz Hadas
加密货币交易
工作流信息
难度等级
中级
节点数量11
分类1
节点类型7
难度说明

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

作者
Naveen Choudhary

Naveen Choudhary

@n8nstein

I create AI-driven n8n workflows that turn repetitive tasks into smooth, hands-off automations. Want to explore an idea? Book a quick consult: https://cal.com/nickchoudhary/30min

外部链接
在 n8n.io 查看 →

分享此工作流