8
n8n 中文网amn8n.com

使用GPT-4o、WordPress和LinkedIn发布自动化RSS内容到博客文章

高级

这是一个AI, Marketing领域的自动化工作流,包含 40 个节点。主要使用 If, Set, Code, Wait, Gmail 等节点,结合人工智能技术实现智能自动化。 使用GPT-4o、WordPress和LinkedIn发布自动化RSS内容到博客文章

前置要求
  • Google 账号和 Gmail API 凭证
  • HTTP Webhook 端点(n8n 会自动生成)
  • LinkedIn API 凭证
  • Telegram Bot Token
  • 可能需要目标 API 的认证凭证
  • Google Sheets API 凭证
  • OpenAI API Key
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
  "meta": {
    "instanceId": "3da9aa1165fccd6e57ad278dd59febaa1dfaafc31e0e52a95d11801200f09024",
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "3911f23a-cdfc-498d-93a7-83dea9ff1f0e",
      "name": "由 Github 模型提供支持",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -540,
        1160
      ],
      "parameters": {},
      "description": "Triggers the workflow daily at 7 AM to fetch new RSS content.",
      "typeVersion": 1.2
    },
    {
      "id": "a02d3578-d2e5-4c56-962a-2c4bd7827c47",
      "name": "合并 RSS 源",
      "type": "n8n-nodes-base.merge",
      "position": [
        -40,
        1160
      ],
      "parameters": {},
      "description": "Combines articles from multiple RSS feeds into a single stream.",
      "typeVersion": 3.1
    },
    {
      "id": "90ec495d-4016-4123-b250-7ee377709f5a",
      "name": "日期过滤器",
      "type": "n8n-nodes-base.if",
      "position": [
        160,
        1160
      ],
      "parameters": {},
      "description": "Filters articles published in the last 24 hours.",
      "typeVersion": 2.2
    },
    {
      "id": "2254b24a-dc91-4175-be2b-c512c98514d9",
      "name": "限制文章数量",
      "type": "n8n-nodes-base.limit",
      "position": [
        360,
        1140
      ],
      "parameters": {},
      "description": "Limits to 5 articles to avoid overwhelming the workflow.",
      "typeVersion": 1
    },
    {
      "id": "d87263a2-f61a-41c4-88a0-70029d8f6240",
      "name": "提取内容",
      "type": "n8n-nodes-base.function",
      "position": [
        520,
        1140
      ],
      "parameters": {},
      "description": "Extracts title, description, link, and publication date from RSS items.",
      "typeVersion": 1
    },
    {
      "id": "4f499250-4ed1-47b7-ba25-4b95c2b778e8",
      "name": "获取完整文章",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        680,
        1140
      ],
      "parameters": {},
      "description": "Fetches the full article content from the article URL.",
      "typeVersion": 4.2
    },
    {
      "id": "5567afb2-4a3a-4902-bd8a-3ca7cdac0fe2",
      "name": "提取文章正文",
      "type": "n8n-nodes-base.htmlExtract",
      "position": [
        840,
        1140
      ],
      "parameters": {},
      "description": "Extracts the main article content using a CSS selector.",
      "typeVersion": 1,
      "alwaysOutputData": true
    },
    {
      "id": "f9ad375d-3e7a-4653-bc7f-c532c65cd5df",
      "name": "转换为 Markdown",
      "type": "n8n-nodes-base.function",
      "position": [
        1000,
        1140
      ],
      "parameters": {},
      "description": "Converts HTML article content to Markdown for AI processing.",
      "typeVersion": 1
    },
    {
      "id": "d2053eb0-e1a5-48d4-9337-d71d0c65deac",
      "name": "RSS TheVerge",
      "type": "n8n-nodes-base.rssFeedRead",
      "position": [
        -280,
        1080
      ],
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "c631fb1a-97c8-47cc-a23e-0c5e34d2989a",
      "name": "RSS TechCrunch",
      "type": "n8n-nodes-base.rssFeedRead",
      "position": [
        -300,
        1280
      ],
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "39be1df4-5e78-46c7-b513-99b478b4095d",
      "name": "生成博客文章",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        220,
        1440
      ],
      "parameters": {},
      "typeVersion": 1.9
    },
    {
      "id": "0259e27d-92b9-40a7-9ac5-30a0e1162599",
      "name": "OpenAI 聊天模型1",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        180,
        1640
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "a2f5aa3b-b79f-4383-bc96-9a1a5603db00",
      "name": "设置博客创建日期",
      "type": "n8n-nodes-base.code",
      "position": [
        520,
        1440
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "d38eb963-fd81-4aa1-b981-6ffb18d4597f",
      "name": "设置字段",
      "type": "n8n-nodes-base.set",
      "position": [
        680,
        1440
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "64b1a852-b8e6-4976-9353-c15ce46af8f5",
      "name": "格式化字段以存储",
      "type": "n8n-nodes-base.code",
      "position": [
        840,
        1440
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "65e1577f-975e-48f6-97f4-413114e20d46",
      "name": "通知审核",
      "type": "n8n-nodes-base.gmail",
      "position": [
        380,
        1760
      ],
      "webhookId": "98bd7b8a-4bed-4930-bd85-1282657ddc90",
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "72ab9f93-0221-471d-b14a-340cd4807ba6",
      "name": "准备通知字段",
      "type": "n8n-nodes-base.set",
      "position": [
        180,
        1760
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "39bd3581-8a38-4357-ad2b-ebdf3fd13bd1",
      "name": "添加特色图片",
      "type": "n8n-nodes-base.code",
      "position": [
        1000,
        1440
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "6864a2e9-fb55-4294-a862-b1d7690644ce",
      "name": "初始存储博客文章",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        0,
        1760
      ],
      "parameters": {},
      "typeVersion": 4.5
    },
    {
      "id": "da7b47dc-a5b2-4043-a2fe-9650b4a0386e",
      "name": "生成 SEO 关键词",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        -80,
        1440
      ],
      "parameters": {},
      "typeVersion": 1.8
    },
    {
      "id": "498c1ad6-503f-4c76-b033-f3c9232dd7e7",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -380,
        580
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "15aab31b-8eaf-4c7b-a239-c178f3f3ef79",
      "name": "便签3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        3040,
        580
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "e1654306-c4da-4b1f-9c3d-6f0273c49f73",
      "name": "便签2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1200,
        580
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "298beebf-63bc-470e-8aaa-c342629cb761",
      "name": "更新批准状态",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2000,
        680
      ],
      "parameters": {},
      "typeVersion": 4.5,
      "alwaysOutputData": true
    },
    {
      "id": "14bd1cd7-083e-4d4d-b0cd-5dbdefda51b4",
      "name": "审批 Webhook",
      "type": "n8n-nodes-base.webhook",
      "position": [
        1800,
        680
      ],
      "webhookId": "7f532453-1e01-4ff1-b497-a3ae89646555",
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "4f9137eb-6425-403f-b260-92498147794d",
      "name": "应用博客模板",
      "type": "n8n-nodes-base.code",
      "position": [
        1780,
        1240
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "9072a8b4-1261-4080-8e2a-d51445175292",
      "name": "遍历博客文章",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        2140,
        1240
      ],
      "parameters": {},
      "typeVersion": 3
    },
    {
      "id": "deea3250-6a1c-49ea-8acf-3ca2b2910d07",
      "name": "文章间延迟",
      "type": "n8n-nodes-base.wait",
      "position": [
        2400,
        1260
      ],
      "webhookId": "9b25f8f1-398f-4509-9b4b-21dbbf3ae69f",
      "parameters": {},
      "typeVersion": 1.1,
      "alwaysOutputData": true
    },
    {
      "id": "41d04b54-e5fd-46f6-95df-766e2cf05486",
      "name": "通知拒绝",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1780,
        1420
      ],
      "webhookId": "d5706bbb-0688-4677-aa55-9795e2a726a5",
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "eeab5208-3c13-4299-92f6-f6b9871207ec",
      "name": "等待状态更新",
      "type": "n8n-nodes-base.wait",
      "position": [
        1780,
        1600
      ],
      "webhookId": "45b7af13-f8d5-4588-aa09-294a56ff784b",
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "4b7a842b-5d04-4804-882b-944e9e45eca0",
      "name": "检查状态",
      "type": "n8n-nodes-base.switch",
      "position": [
        1400,
        1420
      ],
      "parameters": {},
      "typeVersion": 3.2
    },
    {
      "id": "c36de3dc-a262-4da6-af79-66882f2eb434",
      "name": "获取行数据",
      "type": "n8n-nodes-base.googleSheetsTrigger",
      "position": [
        1220,
        1420
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "b85ed2c2-f488-406a-9b46-dd77a810fad3",
      "name": "最终存储博客文章",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1980,
        1240
      ],
      "parameters": {},
      "typeVersion": 4.5,
      "alwaysOutputData": true
    },
    {
      "id": "32bcef49-aab7-4a5a-be48-ecb18bd5e0f6",
      "name": "检查是否已发布",
      "type": "n8n-nodes-base.if",
      "position": [
        1580,
        1260
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "2e90d3e7-7ef1-4292-9ea9-e69a21bd4fa1",
      "name": "更新发布状态",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2860,
        1000
      ],
      "parameters": {},
      "typeVersion": 4.5
    },
    {
      "id": "c998be4e-824d-4fb6-a6f5-40b0e9a82e6d",
      "name": "发布到 Wordpress",
      "type": "n8n-nodes-base.wordpress",
      "position": [
        2680,
        1280
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "c1de08f6-3be7-4ba5-b615-8f6e1aad0f4a",
      "name": "发布到 LinkedIn",
      "type": "n8n-nodes-base.linkedIn",
      "position": [
        2700,
        1520
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "9503b253-6524-405f-9a1e-09e229fb7403",
      "name": "完成后通知 Telegram",
      "type": "n8n-nodes-base.telegram",
      "position": [
        2380,
        1100
      ],
      "webhookId": "59b99b7d-d113-40ac-a590-aee1f7633120",
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "154afc0d-da0c-4f31-8de8-ec50aa6ce8a1",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1200,
        880
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "5f36f9aa-a96a-47eb-a39d-e3236ed8e49e",
      "name": "渲染博客副本",
      "type": "n8n-nodes-base.gmail",
      "position": [
        2660,
        1000
      ],
      "webhookId": "a4bff1ec-dc60-4ef2-8dec-3f9a555cfea0",
      "parameters": {},
      "typeVersion": 2.1
    }
  ],
  "pinData": {},
  "connections": {
    "Fetch Row": {
      "main": [
        [
          {
            "node": "Check Status",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set Fields": {
      "main": [
        [
          {
            "node": "Format Fields for Storage",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Date Filter": {
      "main": [
        [
          {
            "node": "Limit Articles",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Check Status": {
      "main": [
        [
          {
            "node": "Check if Already Published",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Notify Rejection",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Wait for Status Update",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "RSS TheVerge": {
      "main": [
        [
          {
            "node": "Merge RSS Feeds",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Limit Articles": {
      "main": [
        [
          {
            "node": "Extract Content",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "RSS TechCrunch": {
      "main": [
        [
          {
            "node": "Merge RSS Feeds",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Extract Content": {
      "main": [
        [
          {
            "node": "Fetch Full Article",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Merge RSS Feeds": {
      "main": [
        [
          {
            "node": "Date Filter",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Approval Webhook": {
      "main": [
        [
          {
            "node": "Update Approve Status",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "RSS TechCrunch",
            "type": "main",
            "index": 0
          },
          {
            "node": "RSS TheVerge",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Add Featured Image": {
      "main": [
        [
          {
            "node": "Store Blog Posts Initial",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fetch Full Article": {
      "main": [
        [
          {
            "node": "Extract Article Body",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Generate Blog Post": {
      "main": [
        [
          {
            "node": "Set Blog Creation Date",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model1": {
      "ai_languageModel": [
        [
          {
            "node": "Generate Blog Post",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Apply Blog Template": {
      "main": [
        [
          {
            "node": "Store Blog Posts Final",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Convert to Markdown": {
      "main": [
        [
          {
            "node": "Generate SEO Keywords",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Delay Between Posts": {
      "main": [
        [
          {
            "node": "Store Blog Posts Final",
            "type": "main",
            "index": 0
          },
          {
            "node": "Post to LinkedIn",
            "type": "main",
            "index": 0
          },
          {
            "node": "Post to Wordpress",
            "type": "main",
            "index": 0
          },
          {
            "node": "Copy of the RenderedBlog",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract Article Body": {
      "main": [
        [
          {
            "node": "Convert to Markdown",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Blog Posts": {
      "main": [
        [
          {
            "node": "NNotify Telegram on Completion",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Delay Between Posts",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Generate SEO Keywords": {
      "main": [
        [
          {
            "node": "Generate Blog Post",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set Blog Creation Date": {
      "main": [
        [
          {
            "node": "Set Fields",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Store Blog Posts Final": {
      "main": [
        [
          {
            "node": "Loop Over Blog Posts",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Wait for Status Update": {
      "main": [
        [
          {
            "node": "Check Status",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Copy of the RenderedBlog": {
      "main": [
        [
          {
            "node": "Update Publish Status",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Store Blog Posts Initial": {
      "main": [
        [
          {
            "node": "Prepare Fields Foor Notification",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Format Fields for Storage": {
      "main": [
        [
          {
            "node": "Add Featured Image",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Check if Already Published": {
      "main": [
        [
          {
            "node": "Apply Blog Template",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Prepare Fields Foor Notification": {
      "main": [
        [
          {
            "node": "Notify for Review",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流?

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

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

高级 - 人工智能, 营销

需要付费吗?

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

工作流信息
难度等级
高级
节点数量40
分类2
节点类型24
难度说明

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

外部链接
在 n8n.io 查看

分享此工作流