8
n8n 中文网amn8n.com

WordPress、OpenAI与Perplexity的自动化SEO博客发布

高级

这是一个Content Creation, Multimodal AI领域的自动化工作流,包含 43 个节点。主要使用 Set, Limit, SplitOut, Aggregate, Wordpress 等节点。 WordPress、OpenAI与Perplexity的自动化SEO博客发布

前置要求
  • 可能需要目标 API 的认证凭证
  • Google Sheets API 凭证
  • OpenAI API Key
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
  "meta": {
    "instanceId": "c66762406062d6f96baac676fbcb1ad043cf6c0875d0fc4a63da087ec2d9f92e",
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "dd335175-435e-4498-8e7b-5183815fe84e",
      "name": "OpenAI 聊天模型",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        -1792,
        864
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "88960c7f-f600-44ef-ad3a-f6698b0304e7",
      "name": "拆分输出",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        -1088,
        640
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "1e7c2559-32ae-4f8d-8205-11f5ba7baeef",
      "name": "遍历项目",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        -880,
        640
      ],
      "parameters": {},
      "typeVersion": 3
    },
    {
      "id": "08788160-c86a-4f60-b5bb-867e66e722f8",
      "name": "发布图片到 Cloudinary2",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -432,
        832
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "4fc4c555-050c-46c5-b1ac-b0ea7eac25f4",
      "name": "设置输出图片",
      "type": "n8n-nodes-base.set",
      "position": [
        -224,
        832
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "ee711c54-eb53-4bcd-9fa6-a17dfe75ab6b",
      "name": "结构化输出解析器 1",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        -1536,
        864
      ],
      "parameters": {},
      "typeVersion": 1.3
    },
    {
      "id": "6825aea6-7b1f-4bbd-99f3-a2c1abbaf92b",
      "name": "OpenAI 聊天模型4",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        -1488,
        992
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "aaeadb07-e6dc-481b-b608-e476ea52f089",
      "name": "聚合",
      "type": "n8n-nodes-base.aggregate",
      "position": [
        -48,
        624
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "dcfcb3d4-7210-420d-851f-053fd798da91",
      "name": "文章撰写器",
      "type": "@n8n/n8n-nodes-langchain.chainLlm",
      "position": [
        160,
        624
      ],
      "parameters": {},
      "retryOnFail": false,
      "typeVersion": 1.7
    },
    {
      "id": "f3a197b2-29d3-4322-8f5a-a0c549f0ca18",
      "name": "生成图片1",
      "type": "@n8n/n8n-nodes-langchain.googleGemini",
      "disabled": true,
      "position": [
        -672,
        928
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "7226e7d9-c945-499f-8b97-1f26ecbe1025",
      "name": "OpenAI 聊天模型1",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        240,
        848
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "4869b64e-325c-41e1-92f4-bf0a87fb073f",
      "name": "设置输入数据/凭据",
      "type": "n8n-nodes-base.set",
      "position": [
        -2016,
        640
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "4c7d3e6f-f4fd-4d53-9279-6d754d9b9d89",
      "name": "限制",
      "type": "n8n-nodes-base.limit",
      "position": [
        -2240,
        640
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "91e1913f-a2f9-4de5-8e64-3e7198b97166",
      "name": "定时触发器",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -2688,
        640
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "8af1cb8c-8769-4c81-b07f-c3f47b92dd32",
      "name": "在Perplexity中向模型发送消息",
      "type": "n8n-nodes-base.perplexityTool",
      "position": [
        -1664,
        864
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "b2730379-076d-4159-88ab-349ab41658c4",
      "name": "从数据库获取数据",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -2464,
        640
      ],
      "parameters": {},
      "typeVersion": 4.7
    },
    {
      "id": "f3cd4ba9-2b5c-4845-a18e-cb8658fcff16",
      "name": "在 WordPress 文章1 上设置图片",
      "type": "n8n-nodes-base.httpRequest",
      "onError": "continueRegularOutput",
      "disabled": true,
      "position": [
        2256,
        1584
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "fdfb023b-4406-431f-a6b4-bc935a55bd6f",
      "name": "WordPress 摘要添加1",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        736,
        624
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "bbdbb0d8-f4b5-4c9d-b899-633d7516aa71",
      "name": "OpenAI 4.1 mini4",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "disabled": true,
      "position": [
        1312,
        1808
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "efce7b6b-8ad0-48f3-bb5b-f4157cdb6549",
      "name": "在表格中追加或更新行",
      "type": "n8n-nodes-base.googleSheets",
      "disabled": true,
      "position": [
        2480,
        1584
      ],
      "parameters": {},
      "typeVersion": 4.7
    },
    {
      "id": "0f6717f2-2251-4bff-a6d7-25fce471dfe0",
      "name": "创建帖子",
      "type": "n8n-nodes-base.wordpress",
      "position": [
        544,
        624
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "41046d75-8036-499b-b981-ebf0b6689558",
      "name": "上传图片到 WordPress",
      "type": "n8n-nodes-base.httpRequest",
      "disabled": true,
      "position": [
        2032,
        1584
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "4a0fcee6-ab7d-4b7a-b86b-dc9e5bf3de40",
      "name": "内容规划器",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        -1744,
        640
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "125d0d99-28b3-45c8-906a-14770aab1328",
      "name": "从 Pexels 获取图片",
      "type": "n8n-nodes-base.httpRequest",
      "disabled": true,
      "position": [
        1584,
        1584
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "62078278-c135-4efa-ba95-dff9c7c94b20",
      "name": "编写查询到 Pexels",
      "type": "@n8n/n8n-nodes-langchain.chainLlm",
      "disabled": true,
      "position": [
        1232,
        1584
      ],
      "parameters": {},
      "typeVersion": 1.6
    },
    {
      "id": "4f125342-aca8-4f9d-90b1-c216670e4e2d",
      "name": "从 Pexels 下载图片",
      "type": "n8n-nodes-base.httpRequest",
      "disabled": true,
      "position": [
        1808,
        1584
      ],
      "parameters": {},
      "typeVersion": 4.2,
      "alwaysOutputData": true
    },
    {
      "id": "22934586-b284-408f-a062-170c1efeca2e",
      "name": "OpenAI 4.1 mini5",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        1424,
        928
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "5f80a9ac-00c7-4bb5-82d2-22ee50a332d0",
      "name": "编写查询到图片 AI 生成器",
      "type": "@n8n/n8n-nodes-langchain.chainLlm",
      "position": [
        1344,
        704
      ],
      "parameters": {},
      "typeVersion": 1.6
    },
    {
      "id": "c391978e-0293-44c9-9ca3-8e3f0d29f790",
      "name": "生成图像",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        1696,
        704
      ],
      "parameters": {},
      "typeVersion": 1.8
    },
    {
      "id": "aa07d937-0efc-4b5a-a41a-49c07b1d9613",
      "name": "在 WordPress 文章2 上设置图片",
      "type": "n8n-nodes-base.httpRequest",
      "onError": "continueRegularOutput",
      "position": [
        2160,
        704
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "a03b946c-e50d-4689-a46e-fd1bcc002e81",
      "name": "上传图片到 WordPress1",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1936,
        704
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "51e51946-f732-4073-8877-3b2e4576c49c",
      "name": "在表格1中追加或更新行",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2384,
        704
      ],
      "parameters": {},
      "typeVersion": 4.7
    },
    {
      "id": "5df16502-5937-4e30-9f3f-3b9fccd61aeb",
      "name": "生成图片2",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        -672,
        736
      ],
      "parameters": {},
      "typeVersion": 1.8
    },
    {
      "id": "4db7d406-2736-47ba-9bf4-f9914c7df679",
      "name": "生成图片3",
      "type": "@n8n/n8n-nodes-langchain.googleGemini",
      "disabled": true,
      "position": [
        1696,
        912
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "63766081-778c-4f1c-a5d7-6430811d7522",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2800,
        16
      ],
      "parameters": {
        "content": "Emelia 触发器"
      },
      "typeVersion": 1
    },
    {
      "id": "17156bd7-e918-4f2b-9093-bd1a84f9a973",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1856,
        16
      ],
      "parameters": {
        "content": "Emelia 触发器"
      },
      "typeVersion": 1
    },
    {
      "id": "29c1eab0-a65b-44db-82aa-67235d46a3d7",
      "name": "便签2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1136,
        16
      ],
      "parameters": {
        "content": "Emelia 触发器"
      },
      "typeVersion": 1
    },
    {
      "id": "5e10f73b-c6bc-43c8-a9f4-6c88255dc063",
      "name": "便签3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        128,
        16
      ],
      "parameters": {
        "content": "Emelia 触发器"
      },
      "typeVersion": 1
    },
    {
      "id": "daa3f6e4-369d-4a14-a451-4886a50580a5",
      "name": "便签说明4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        512,
        16
      ],
      "parameters": {
        "content": "Emelia 触发器"
      },
      "typeVersion": 1
    },
    {
      "id": "a446d3c3-7630-40f8-a5e5-b72a5e2e2648",
      "name": "便签说明5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1104,
        336
      ],
      "parameters": {
        "content": "Emelia 触发器"
      },
      "typeVersion": 1
    },
    {
      "id": "fa97b9df-d8a2-411d-b59d-4ff9355086da",
      "name": "便签 6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1104,
        1136
      ],
      "parameters": {
        "content": "Emelia 触发器"
      },
      "typeVersion": 1
    },
    {
      "id": "005fe413-2519-42f6-873a-633fae01f29b",
      "name": "便签 7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        960,
        16
      ],
      "parameters": {
        "content": "Emelia 触发器"
      },
      "typeVersion": 1
    },
    {
      "id": "ba1c7661-237f-4e33-b983-23c1b86b6efd",
      "name": "## 为什么选择 4o 模型?👆",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -3696,
        16
      ],
      "parameters": {
        "content": "Emelia 触发器"
      },
      "typeVersion": 1
    }
  ],
  "pinData": {},
  "connections": {
    "Limit": {
      "main": [
        [
          {
            "node": "Set input data/credintenials",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Aggregate": {
      "main": [
        [
          {
            "node": "Article wrtiter",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split Out": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Create a post": {
      "main": [
        [
          {
            "node": "WordPress excerpt add1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Content planer": {
      "main": [
        [
          {
            "node": "Split Out",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Article wrtiter": {
      "main": [
        [
          {
            "node": "Create a post",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Items": {
      "main": [
        [
          {
            "node": "Aggregate",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Generate an image1",
            "type": "main",
            "index": 0
          },
          {
            "node": "Generate an image2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get data databse": {
      "main": [
        [
          {
            "node": "Limit",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI 4.1 mini4": {
      "ai_languageModel": [
        [
          {
            "node": "Write query too pexels",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI 4.1 mini5": {
      "ai_languageModel": [
        [
          {
            "node": "Write query too image AI generator",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "Get data databse",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set Output Image": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Generate an image": {
      "main": [
        [
          {
            "node": "upload image to wordpress1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "Content planer",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Generate an image1": {
      "main": [
        [
          {
            "node": "Post image Cloudinary2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Generate an image2": {
      "main": [
        [
          {
            "node": "Post image Cloudinary2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Generate an image3": {
      "main": [
        [
          {
            "node": "upload image to wordpress1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model1": {
      "ai_languageModel": [
        [
          {
            "node": "Article wrtiter",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model4": {
      "ai_languageModel": [
        [
          {
            "node": "Structured Output Parser1",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Get Image from Pexels": {
      "main": [
        [
          {
            "node": "Download Image form Pexels",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Post image Cloudinary2": {
      "main": [
        [
          {
            "node": "Set Output Image",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "WordPress excerpt add1": {
      "main": [
        [
          {
            "node": "Write query too image AI generator",
            "type": "main",
            "index": 0
          },
          {
            "node": "Write query too pexels",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Write query too pexels": {
      "main": [
        [
          {
            "node": "Get Image from Pexels",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Structured Output Parser1": {
      "ai_outputParser": [
        [
          {
            "node": "Content planer",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "upload image to wordpress": {
      "main": [
        [
          {
            "node": "Set Image on Wordpress Post1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Download Image form Pexels": {
      "main": [
        [
          {
            "node": "upload image to wordpress",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "upload image to wordpress1": {
      "main": [
        [
          {
            "node": "Set Image on Wordpress Post2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set Image on Wordpress Post1": {
      "main": [
        [
          {
            "node": "Append or update row in sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set Image on Wordpress Post2": {
      "main": [
        [
          {
            "node": "Append or update row in sheet1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set input data/credintenials": {
      "main": [
        [
          {
            "node": "Content planer",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Message a model in Perplexity": {
      "ai_tool": [
        [
          {
            "node": "Content planer",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Write query too image AI generator": {
      "main": [
        [
          {
            "node": "Generate an image",
            "type": "main",
            "index": 0
          },
          {
            "node": "Generate an image3",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流?

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

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

高级 - 内容创作, 多模态 AI

需要付费吗?

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

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

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

作者
LukaszB

LukaszB

@lukaszb

AI Automation Expert | Web & Mobile App Integrator With 2+ years of experience, I build smart automations, web & mobile app workflows, and scalable platforms using tools like n8n, Make, and more. I help businesses reduce operational costs, save time, and scale faster with AI-powered solutions. For business enquiries, send me an email at kontakt@lumizone.pl

外部链接
在 n8n.io 查看

分享此工作流