8
n8n 中文网amn8n.com

监控RSS源,使用Jina AI提取全文并保存到Supabase

高级

这是一个自动化工作流,包含 31 个节点。主要使用 If, Set, Wait, Merge, DateTime 等节点。 监控RSS源,使用Jina AI提取全文并保存到Supabase

前置要求
  • Supabase URL 和 API Key
  • 可能需要目标 API 的认证凭证

分类

-
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
  "meta": {
    "instanceId": "8bdf363d6f1444e891759be2b805fdd240d84e9615b1a1f01b8f4c91c2145754",
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "17eee609-c020-476a-84f7-e1630857ffc3",
      "name": "拆分 RSS 源",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        1488,
        832
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 3
    },
    {
      "id": "b9fd679f-23b6-4c6b-8b01-75939ec31cf0",
      "name": "提取完整博客",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        3504,
        512
      ],
      "parameters": {
        "url": "=https://r.jina.ai/http://{{ $json.url.replace('https://','').replace('http://','') }}",
        "options": {
          "response": {
            "response": {
              "responseFormat": "text"
            }
          }
        }
      },
      "retryOnFail": true,
      "typeVersion": 4.2,
      "waitBetweenTries": 5000
    },
    {
      "id": "0bc02fac-e7a7-4d0c-b23a-fc27ab2cb99d",
      "name": "RSS → 项目",
      "type": "n8n-nodes-base.rssFeedRead",
      "onError": "continueRegularOutput",
      "maxTries": 2,
      "position": [
        1968,
        944
      ],
      "parameters": {
        "url": "={{ $json.source_identifier }}",
        "options": {
          "ignoreSSL": false,
          "customFields": ""
        }
      },
      "retryOnFail": true,
      "typeVersion": 1.1
    },
    {
      "id": "a3420738-619a-405e-ae64-57d4129a27b1",
      "name": "遍历项目",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        3008,
        672
      ],
      "parameters": {
        "options": {}
      },
      "retryOnFail": true,
      "typeVersion": 3,
      "waitBetweenTries": 3000
    },
    {
      "id": "22e81a5e-24cd-4b0a-a44d-56b57592eff9",
      "name": "稍等片刻",
      "type": "n8n-nodes-base.wait",
      "position": [
        4592,
        800
      ],
      "webhookId": "c2a01131-b69f-4bd0-beed-80ff681c5ce1",
      "parameters": {
        "amount": 120
      },
      "typeVersion": 1.1
    },
    {
      "id": "f5a87191-24db-4fd9-baae-420950df4dc4",
      "name": "合并3",
      "type": "n8n-nodes-base.merge",
      "position": [
        2416,
        576
      ],
      "parameters": {
        "mode": "combine",
        "options": {},
        "combineBy": "combineByPosition"
      },
      "typeVersion": 3.2
    },
    {
      "id": "edc45dcd-17f2-4c83-8170-a5b34e566558",
      "name": "客户端 ID + 最大内容年龄 + 博客",
      "type": "n8n-nodes-base.merge",
      "position": [
        1856,
        592
      ],
      "parameters": {
        "mode": "combine",
        "options": {},
        "combineBy": "combineAll"
      },
      "typeVersion": 3.2
    },
    {
      "id": "1da9329d-d9d6-417c-b1eb-c3d7021fbf0c",
      "name": "所有数据",
      "type": "n8n-nodes-base.set",
      "position": [
        2064,
        592
      ],
      "parameters": {
        "options": {},
        "includeOtherFields": true
      },
      "typeVersion": 3.4
    },
    {
      "id": "b9c79d85-8a0f-4c6b-92f9-b728a0ca74fe",
      "name": "查找博客的日期和时间",
      "type": "n8n-nodes-base.dateTime",
      "position": [
        2240,
        400
      ],
      "parameters": {
        "date": "={{ $json.pubDate || $json.isoDate }}\n",
        "format": "yyyy-MM-dd",
        "options": {},
        "operation": "formatDate",
        "outputFieldName": "standardizedPubDate"
      },
      "typeVersion": 2
    },
    {
      "id": "c52eec07-e599-4266-b985-f519415f7d62",
      "name": "一些数据",
      "type": "n8n-nodes-base.set",
      "position": [
        3232,
        688
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "f8b53a8d-e3ae-4216-9743-fc6d9d2683e5",
              "name": "url",
              "type": "string",
              "value": "={{ $json.link }}"
            },
            {
              "id": "734ced73-df4d-47b1-a13e-62f15fb2e10c",
              "name": "max_content_age_days",
              "type": "number",
              "value": "={{ $json.max_content_age_days }}"
            },
            {
              "id": "639d26c7-6775-4842-881a-e49a20c8597c",
              "name": "pubDate",
              "type": "string",
              "value": "={{ $json.pubDate }}"
            },
            {
              "id": "ce2015ff-0aa2-40ce-9f4c-739e24bbe7f4",
              "name": "title",
              "type": "string",
              "value": "={{ $json.title }}"
            },
            {
              "id": "88f130fb-0411-466f-8e13-b91420a19c70",
              "name": "creator",
              "type": "string",
              "value": "={{ $json.creator }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "178ffc01-c0ad-4371-8e69-e3cc08f9f55b",
      "name": "一些数据 + 完整博客",
      "type": "n8n-nodes-base.merge",
      "position": [
        3760,
        672
      ],
      "parameters": {
        "mode": "combine",
        "options": {},
        "combineBy": "combineByPosition"
      },
      "typeVersion": 3.2
    },
    {
      "id": "41020247-0f19-4fab-b392-4fb275ea0bc7",
      "name": "计划触发器",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -128,
        576
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "triggerAtHour": 12
            }
          ]
        }
      },
      "retryOnFail": true,
      "typeVersion": 1.2
    },
    {
      "id": "c3454919-cfe0-4d6e-a798-b37a0f86a7a8",
      "name": "max_content_age_days",
      "type": "n8n-nodes-base.set",
      "position": [
        352,
        576
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "41cbc93c-c60a-4fa2-a46c-23a0b887a270",
              "name": "max_content_age_days",
              "type": "number",
              "value": "=60"
            }
          ]
        },
        "includeOtherFields": true
      },
      "typeVersion": 3.4
    },
    {
      "id": "5b2048be-929e-4ae1-a721-d535bf334bb0",
      "name": "分离",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        1088,
        832
      ],
      "parameters": {
        "options": {},
        "fieldToSplitOut": "source_identifier"
      },
      "typeVersion": 1
    },
    {
      "id": "b6885a88-e771-4d1d-a559-63ca33e04c2f",
      "name": "要跟踪的博客",
      "type": "n8n-nodes-base.set",
      "position": [
        768,
        832
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "4465ec7e-d770-4b59-a007-51c5b2731d8e",
              "name": "source_identifier",
              "type": "array",
              "value": "={{ ['https://blog.n8n.io/rss', 'https://zapier.com/blog/feeds/latest/'] }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "6bb217f8-aa4e-4448-854c-a6f93e3facef",
      "name": "Rss 源链接",
      "type": "n8n-nodes-base.set",
      "position": [
        1696,
        1120
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "1c04a980-ba49-4eda-8c32-eb09dbaa448c",
              "name": "source_identifier",
              "type": "string",
              "value": "={{ $json.source_identifier }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "a86fa81a-7c9f-4eec-b036-89775f29d484",
      "name": "Rss 源链接 + 博客",
      "type": "n8n-nodes-base.merge",
      "position": [
        2224,
        1104
      ],
      "parameters": {
        "mode": "combine",
        "options": {},
        "combineBy": "combineAll"
      },
      "retryOnFail": true,
      "typeVersion": 3.2
    },
    {
      "id": "c6b7ffc2-3e87-4cb6-b46e-12ce0ccc341c",
      "name": "过滤掉旧博客",
      "type": "n8n-nodes-base.if",
      "position": [
        2688,
        688
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "bccea370-70ab-478d-a77a-385af6826ae0",
              "operator": {
                "type": "dateTime",
                "operation": "afterOrEquals"
              },
              "leftValue": "={{ $json.pubDate }}",
              "rightValue": "={{ DateTime.now().minus({ days: $json.max_content_age_days }).toFormat('yyyy-MM-dd') }}"
            }
          ]
        }
      },
      "retryOnFail": false,
      "typeVersion": 2.2
    },
    {
      "id": "543e7b13-0a9d-43ae-a790-fb18e909c8bb",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -640,
        144
      ],
      "parameters": {
        "width": 432,
        "height": 944,
        "content": "## 从您选择的网站查找博客,过滤掉旧的,然后提取完整的博客页面"
      },
      "typeVersion": 1
    },
    {
      "id": "7c2264d3-53d4-4e3c-a531-44e283eac324",
      "name": "最终数据",
      "type": "n8n-nodes-base.set",
      "position": [
        3984,
        672
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "f8b53a8d-e3ae-4216-9743-fc6d9d2683e5",
              "name": "url",
              "type": "string",
              "value": "={{ $json.url }}"
            },
            {
              "id": "734ced73-df4d-47b1-a13e-62f15fb2e10c",
              "name": "max_content_age_days",
              "type": "number",
              "value": "={{ $json.max_content_age_days }}"
            },
            {
              "id": "639d26c7-6775-4842-881a-e49a20c8597c",
              "name": "pubDate",
              "type": "string",
              "value": "={{ $json.pubDate }}"
            },
            {
              "id": "ce2015ff-0aa2-40ce-9f4c-739e24bbe7f4",
              "name": "title",
              "type": "string",
              "value": "={{ $json.title }}"
            },
            {
              "id": "88f130fb-0411-466f-8e13-b91420a19c70",
              "name": "creator",
              "type": "string",
              "value": "={{ $json.creator }}"
            },
            {
              "id": "331145fd-4e55-4958-bb74-54c45ff8f678",
              "name": "content_snippet",
              "type": "string",
              "value": "={{ $json.data }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "4a1eae70-85b0-4347-8fda-ff278d2f0b2a",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        272,
        336
      ],
      "parameters": {
        "color": 4,
        "height": 464,
        "content": "## 选择天数"
      },
      "typeVersion": 1
    },
    {
      "id": "5bdadc42-a5a7-41e1-b4f0-7c957a5c2b7c",
      "name": "便签2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        688,
        528
      ],
      "parameters": {
        "color": 4,
        "width": 256,
        "height": 512,
        "content": "## 查找 RSS 源 URL"
      },
      "typeVersion": 1
    },
    {
      "id": "e4d2c25b-3b6b-4a5e-b801-0ae7ac37e806",
      "name": "便签6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1008,
        640
      ],
      "parameters": {
        "width": 256,
        "height": 368,
        "content": "## 将所有网站拆分为独立的项,以便它们逐个进入循环"
      },
      "typeVersion": 1
    },
    {
      "id": "1c03e50f-5fc2-44e7-9f68-3678e1f9236b",
      "name": "便签3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1296,
        768
      ],
      "parameters": {
        "color": 6,
        "width": 1136,
        "height": 544,
        "content": "## 这会逐个循环遍历网站以查找所有博客。"
      },
      "typeVersion": 1
    },
    {
      "id": "6f313a1a-14cd-44d6-86f5-4258f18d4976",
      "name": "便签4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2160,
        256
      ],
      "parameters": {
        "width": 256,
        "height": 320,
        "content": "## 以易于阅读的格式添加\"发布日期\""
      },
      "typeVersion": 1
    },
    {
      "id": "8e880374-0876-40ed-8883-ee5ad59b8c4b",
      "name": "便签5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2608,
        544
      ],
      "parameters": {
        "width": 256,
        "height": 288,
        "content": "## 过滤掉早于您指定日期的博客"
      },
      "typeVersion": 1
    },
    {
      "id": "1cc1da4c-a422-4df2-9b45-341b0c54cdfe",
      "name": "便签7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        3168,
        528
      ],
      "parameters": {
        "width": 224,
        "height": 304,
        "content": "## 收集提取完整博客所需的数据"
      },
      "typeVersion": 1
    },
    {
      "id": "6ebf2bd4-a8c3-4ea0-b2ee-c9261bcea246",
      "name": "便签8",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        3440,
        224
      ],
      "parameters": {
        "color": 4,
        "height": 416,
        "content": "## 提取完整博客"
      },
      "typeVersion": 1
    },
    {
      "id": "615527c9-bc1d-4b88-8fb2-bc9de33c7926",
      "name": "便签9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        3936,
        512
      ],
      "parameters": {
        "width": 224,
        "height": 304,
        "content": "## 格式化最终数据以上传到您的存储位置"
      },
      "typeVersion": 1
    },
    {
      "id": "09a6a6ac-3231-4d59-a5cd-04ad8c87a124",
      "name": "便签 10",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        4224,
        352
      ],
      "parameters": {
        "color": 4,
        "width": 256,
        "height": 496,
        "content": "## 保存您的博客!!!"
      },
      "typeVersion": 1
    },
    {
      "id": "89eee038-b387-415d-b28a-e580010c5afa",
      "name": "将博客数据保存到数据库",
      "type": "n8n-nodes-base.supabase",
      "onError": "continueRegularOutput",
      "position": [
        4304,
        672
      ],
      "parameters": {
        "tableId": "content_queue_1",
        "fieldsUi": {
          "fieldValues": [
            {
              "fieldId": "content_type",
              "fieldValue": "blog"
            },
            {
              "fieldId": "source_url",
              "fieldValue": "={{ $json.url }}"
            },
            {
              "fieldId": "content_snippet",
              "fieldValue": "={{ $json.content_snippet }}"
            },
            {
              "fieldId": "status",
              "fieldValue": "new"
            },
            {
              "fieldId": "published_date",
              "fieldValue": "={{ $json.pubDate }}"
            },
            {
              "fieldId": "creator",
              "fieldValue": "={{ $json.creator }}"
            },
            {
              "fieldId": "title",
              "fieldValue": "={{ $json.title }}"
            }
          ]
        }
      },
      "credentials": {
        "supabaseApi": {
          "id": "oB3fYG1lWHXnOQN6",
          "name": "Content Automation Hub"
        }
      },
      "retryOnFail": true,
      "typeVersion": 1,
      "alwaysOutputData": false
    }
  ],
  "pinData": {},
  "connections": {
    "Merge3": {
      "main": [
        [
          {
            "node": "Filter Out Old Blogs",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "All Data": {
      "main": [
        [
          {
            "node": "Find Date & Time of Blogs",
            "type": "main",
            "index": 0
          },
          {
            "node": "Merge3",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Some data": {
      "main": [
        [
          {
            "node": "Extract the full blog",
            "type": "main",
            "index": 0
          },
          {
            "node": "Some data + Full Blog",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Split Out": {
      "main": [
        [
          {
            "node": "Split RSS Feeds",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "final data": {
      "main": [
        [
          {
            "node": "Save Blog Data to Database",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "RSS → Items": {
      "main": [
        [
          {
            "node": "rss feed links + blogs",
            "type": "main",
            "index": 0
          }
        ],
        []
      ]
    },
    "Rss feed link": {
      "main": [
        [
          {
            "node": "RSS → Items",
            "type": "main",
            "index": 0
          },
          {
            "node": "rss feed links + blogs",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "blogs to track": {
      "main": [
        [
          {
            "node": "Split Out",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Chill for a sec": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Items": {
      "main": [
        [],
        [
          {
            "node": "Some data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split RSS Feeds": {
      "main": [
        [
          {
            "node": "Client ID + Max Content Age + Blogs",
            "type": "main",
            "index": 1
          }
        ],
        [
          {
            "node": "Rss feed link",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "max_content_age_days",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter Out Old Blogs": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "max_content_age_days": {
      "main": [
        [
          {
            "node": "Client ID + Max Content Age + Blogs",
            "type": "main",
            "index": 0
          },
          {
            "node": "blogs to track",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract the full blog": {
      "main": [
        [
          {
            "node": "Some data + Full Blog",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Some data + Full Blog": {
      "main": [
        [
          {
            "node": "final data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "rss feed links + blogs": {
      "main": [
        [
          {
            "node": "Split RSS Feeds",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Find Date & Time of Blogs": {
      "main": [
        [
          {
            "node": "Merge3",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Save Blog Data to Database": {
      "main": [
        [
          {
            "node": "Chill for a sec",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Client ID + Max Content Age + Blogs": {
      "main": [
        [
          {
            "node": "All Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流?

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

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

高级

需要付费吗?

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

工作流信息
难度等级
高级
节点数量31
分类-
节点类型12
难度说明

适合高级用户,包含 16+ 个节点的复杂工作流

作者

On a mission to automate all aspects of social media. Each of my templates covered more in depth in my Skool Community.

外部链接
在 n8n.io 查看

分享此工作流