8
n8n 中文网amn8n.com

自动化博客撰写与社交媒体推广代理

高级

这是一个Design, AI, Marketing领域的自动化工作流,包含 79 个节点。主要使用 Set, Code, Gmail, Merge, Notion 等节点,结合人工智能技术实现智能自动化。 使用GPT-4、Perplexity和WordPress自动化SEO博客创建+社交媒体

前置要求
  • Google 账号和 Gmail API 凭证
  • Notion API Key
  • Twitter API 凭证
  • 可能需要目标 API 的认证凭证
  • Google Sheets API 凭证
  • OpenAI API Key
  • Facebook Graph API 凭证
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
  "id": "To13kL7p4OV8nDaZ",
  "meta": {
    "instanceId": "740c1df6d3b1b6ea8a9d2223701f6904173f9e3cf7381cd181644b043420ba09",
    "templateCredsSetupCompleted": true
  },
  "name": "自动化博客撰写与社交媒体推广代理",
  "tags": [],
  "nodes": [
    {
      "id": "0b195040-295a-4cff-91d7-6a5121105df9",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2180,
        540
      ],
      "parameters": {
        "content": "确保您的表名与实际知识库结构匹配"
      },
      "typeVersion": 1
    },
    {
      "id": "79ed8c8f-9b55-4a57-8309-44180d5d3e43",
      "name": "当点击\"测试工作流\"时",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -2540,
        -60
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "cdbacaac-baad-441d-9f5d-fe5e98d2628f",
      "name": "当被另一个工作流执行时",
      "type": "n8n-nodes-base.executeWorkflowTrigger",
      "position": [
        -1300,
        2260
      ],
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "d32d67c4-a62a-4705-b7de-2943d13c32c6",
      "name": "Notion",
      "type": "n8n-nodes-base.notion",
      "position": [
        -1060,
        2260
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "3ff83c0a-7a5b-4b52-a1b6-eea59c648d3f",
      "name": "聚合",
      "type": "n8n-nodes-base.aggregate",
      "position": [
        -840,
        2260
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "5d0e19f5-0230-4d74-8745-738cc19d7934",
      "name": "编辑字段",
      "type": "n8n-nodes-base.set",
      "position": [
        -620,
        2260
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "e72f8aba-fd75-4d42-9ab8-db91ae89b822",
      "name": "便签6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1460,
        2100
      ],
      "parameters": {
        "content": "确保您的表名与实际知识库结构匹配"
      },
      "typeVersion": 1
    },
    {
      "id": "33b0326a-0682-441e-8cb0-6c77493edd25",
      "name": "便签9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1580,
        1240
      ],
      "parameters": {
        "content": "确保您的表名与实际知识库结构匹配"
      },
      "typeVersion": 1
    },
    {
      "id": "2d57129b-7472-4cd7-b67b-adbbb744c2de",
      "name": "OpenAI 4.1 mini4",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        -1500,
        1520
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "1646be1c-baae-442f-b567-b5bfe3ca4cd4",
      "name": "编写创建图像的提示词",
      "type": "@n8n/n8n-nodes-langchain.chainLlm",
      "position": [
        -1520,
        1340
      ],
      "parameters": {},
      "typeVersion": 1.6
    },
    {
      "id": "5b432eb8-0954-49d2-bde7-dcde79120698",
      "name": "OpenAI",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "onError": "continueErrorOutput",
      "position": [
        -1080,
        1340
      ],
      "parameters": {},
      "typeVersion": 1.8
    },
    {
      "id": "71799dbd-e9dc-4ed2-875d-f2ef2e2bb817",
      "name": "上传图片到Wordpress2",
      "type": "n8n-nodes-base.httpRequest",
      "onError": "continueRegularOutput",
      "position": [
        -780,
        1340
      ],
      "parameters": {},
      "retryOnFail": false,
      "typeVersion": 4.2,
      "alwaysOutputData": false
    },
    {
      "id": "dbf10b1c-4e59-4693-936e-8176fd7022d4",
      "name": "设置Wordpress文章图片2",
      "type": "n8n-nodes-base.httpRequest",
      "onError": "continueRegularOutput",
      "position": [
        -580,
        1340
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "32e44406-845d-404f-89d4-1bd3e3e5c314",
      "name": "便签4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -160,
        -160
      ],
      "parameters": {
        "content": "确保您的表名与实际知识库结构匹配"
      },
      "typeVersion": 1
    },
    {
      "id": "80cb12c0-b42e-43ca-97ff-bbce1f914509",
      "name": "Wordpress",
      "type": "n8n-nodes-base.wordpress",
      "position": [
        660,
        20
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "16c65a59-d52f-4581-ace2-8e81e6730965",
      "name": "便签8",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        540,
        -60
      ],
      "parameters": {
        "content": "确保您的表名与实际知识库结构匹配"
      },
      "typeVersion": 1
    },
    {
      "id": "6a958569-b7ae-4b08-9c8d-f2d6029c546c",
      "name": "便签5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -700,
        -160
      ],
      "parameters": {
        "content": "确保您的表名与实际知识库结构匹配"
      },
      "typeVersion": 1
    },
    {
      "id": "83a63492-805e-4cb8-a56a-dd99956c5a9a",
      "name": "清理链接",
      "type": "n8n-nodes-base.set",
      "position": [
        -400,
        20
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "11cac099-dee9-4e35-b0fa-d3c0059376b2",
      "name": "清理HTML",
      "type": "n8n-nodes-base.set",
      "position": [
        300,
        20
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "94586cfc-55bf-4b8d-a555-84b146b0b0d3",
      "name": "简单记忆",
      "type": "@n8n/n8n-nodes-langchain.memoryBufferWindow",
      "position": [
        -1800,
        220
      ],
      "parameters": {},
      "typeVersion": 1.3
    },
    {
      "id": "da517ec6-05c6-4ecb-bded-a69abf798322",
      "name": "Google Sheets",
      "type": "n8n-nodes-base.googleSheetsTool",
      "position": [
        -1680,
        220
      ],
      "parameters": {},
      "typeVersion": 4.5
    },
    {
      "id": "85aabbbb-1d1e-4300-bcce-c6b63b0cfb77",
      "name": "获取品牌简报",
      "type": "@n8n/n8n-nodes-langchain.toolWorkflow",
      "position": [
        -1560,
        220
      ],
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "f590fc01-77ee-4021-8ea5-b1c079e3c944",
      "name": "Structured Output Parser1",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        -1420,
        220
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "23168360-e347-4c51-8e0e-cc36bf4a5f2d",
      "name": "创意生成器",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        -1780,
        20
      ],
      "parameters": {},
      "typeVersion": 1.8
    },
    {
      "id": "5a646f02-27c6-4c04-bf01-17f88dd26edf",
      "name": "便签2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2400,
        -160
      ],
      "parameters": {
        "content": "确保您的表名与实际知识库结构匹配"
      },
      "typeVersion": 1
    },
    {
      "id": "0ab7454b-656a-4a9e-964e-3b59a5ed4003",
      "name": "Perplexity研究1",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -620,
        20
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "7750794d-8136-4aaa-ae0a-d209fc26ebc8",
      "name": "添加WordPress摘要",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        460,
        880
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "e68ff086-815a-48f9-94f6-6448c72aea59",
      "name": "摘要生成器",
      "type": "@n8n/n8n-nodes-langchain.chainLlm",
      "position": [
        60,
        880
      ],
      "parameters": {},
      "typeVersion": 1.6
    },
    {
      "id": "89403509-49ab-4873-bd82-51f58e9fa371",
      "name": "更新博客文章列表",
      "type": "n8n-nodes-base.googleSheets",
      "onError": "continueRegularOutput",
      "position": [
        260,
        1460
      ],
      "parameters": {},
      "typeVersion": 4.5
    },
    {
      "id": "d60dd82c-6678-4032-b902-5dc044243cc8",
      "name": "更新基础文章",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        460,
        1460
      ],
      "parameters": {},
      "typeVersion": 4.5
    },
    {
      "id": "b329dd58-c343-4ade-901a-cbdc1a64de34",
      "name": "Markdown",
      "type": "n8n-nodes-base.markdown",
      "position": [
        20,
        1460
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "e4a89855-7e35-43fe-b57f-788eed6a2a25",
      "name": "计划触发器",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -2560,
        160
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "bca75a23-9fdf-4109-8698-5323a5153800",
      "name": "内容撰写器",
      "type": "@n8n/n8n-nodes-langchain.chainLlm",
      "position": [
        -20,
        20
      ],
      "parameters": {},
      "typeVersion": 1.6
    },
    {
      "id": "fe63dd4c-b87b-40a4-96e0-9bb00b6db258",
      "name": "OpenAI 4.1 mini",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        -20,
        240
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "74bc8252-9756-4a39-a991-eb5d78467bf6",
      "name": "OpenAI 4.1 mini2",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        80,
        1040
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "1de78a9d-d136-46f2-b781-be8c7dad3612",
      "name": "OpenAI 4.1 mini3",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        -1940,
        220
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "bae29b85-a213-408a-8b3b-42a435633f15",
      "name": "分类重写",
      "type": "n8n-nodes-base.code",
      "position": [
        -960,
        40
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "85e44c71-f5af-4e09-80c1-569a1980a3c6",
      "name": "上传图片到Wordpress",
      "type": "n8n-nodes-base.httpRequest",
      "onError": "continueRegularOutput",
      "position": [
        -660,
        740
      ],
      "parameters": {},
      "retryOnFail": false,
      "typeVersion": 4.2,
      "alwaysOutputData": false
    },
    {
      "id": "bbaa6459-5eca-4daf-9bc1-793c1b50dca2",
      "name": "在Wordpress文章上设置图片",
      "type": "n8n-nodes-base.httpRequest",
      "onError": "continueRegularOutput",
      "position": [
        -440,
        740
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "90e0ee6d-8cef-45bc-a163-9fdc49b7a742",
      "name": "从Pexcel获取图片",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -1100,
        740
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "a457647e-7552-48a5-ab2f-2328036b2995",
      "name": "下载图像",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -880,
        740
      ],
      "parameters": {},
      "typeVersion": 4.2,
      "alwaysOutputData": true
    },
    {
      "id": "5e966ddc-e579-4be3-9696-933f19c57f2f",
      "name": "编写搜索图片的提示词",
      "type": "@n8n/n8n-nodes-langchain.chainLlm",
      "position": [
        -1500,
        740
      ],
      "parameters": {},
      "typeVersion": 1.6
    },
    {
      "id": "7ac845e0-3ec3-43f3-8545-d44f50fa7140",
      "name": "OpenAI 4.1 mini1",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        -1500,
        940
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "4d2917c3-b6a2-4f3d-a694-95c2385a62a1",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1580,
        600
      ],
      "parameters": {
        "content": "确保您的表名与实际知识库结构匹配"
      },
      "typeVersion": 1
    },
    {
      "id": "a3541b48-3a65-468b-8091-792649a745ef",
      "name": "便签3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -60,
        540
      ],
      "parameters": {
        "content": "确保您的表名与实际知识库结构匹配"
      },
      "typeVersion": 1
    },
    {
      "id": "f40e6bfe-c6ab-40f0-afe8-848d297181ba",
      "name": "便签7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -60,
        1260
      ],
      "parameters": {
        "content": "确保您的表名与实际知识库结构匹配"
      },
      "typeVersion": 1
    },
    {
      "id": "fe9d95f1-49b0-4577-b79b-f3fc82a88de5",
      "name": "社交媒体内容",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        2580,
        420
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "99b24a6f-ee0a-49a7-b2c6-2cf016b242c5",
      "name": "gpt-4.1 mini",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        2280,
        420
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "c500b909-1949-4862-9a47-021fce4d601a",
      "name": "社交媒体内容创建器",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        2320,
        160
      ],
      "parameters": {},
      "retryOnFail": true,
      "typeVersion": 1.7
    },
    {
      "id": "1bfd8b2b-5c4c-4ced-b7bb-d08affd9a439",
      "name": "上传媒体到Instagram",
      "type": "n8n-nodes-base.facebookGraphApi",
      "position": [
        1820,
        1200
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "06c54ed2-3abf-4237-936e-6f8d25c4b7be",
      "name": "在IG发布帖子",
      "type": "n8n-nodes-base.facebookGraphApi",
      "position": [
        1980,
        1200
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "73de50b2-f249-4188-9f2e-e55400fb2dad",
      "name": "Facebook帖子1",
      "type": "n8n-nodes-base.facebookGraphApi",
      "onError": "continueRegularOutput",
      "position": [
        1840,
        1600
      ],
      "parameters": {},
      "typeVersion": 1,
      "alwaysOutputData": true
    },
    {
      "id": "a8da9f48-3b83-4fac-905d-209e44311268",
      "name": "编辑字段1",
      "type": "n8n-nodes-base.set",
      "position": [
        4620,
        -60
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "6d3ab439-1af8-4331-982d-b06df191ba9a",
      "name": "合并3",
      "type": "n8n-nodes-base.merge",
      "position": [
        4700,
        140
      ],
      "parameters": {},
      "typeVersion": 3.1
    },
    {
      "id": "44cf4d27-05df-4512-8958-f0fa66d95afe",
      "name": "合并4",
      "type": "n8n-nodes-base.merge",
      "position": [
        4720,
        520
      ],
      "parameters": {},
      "typeVersion": 3.1
    },
    {
      "id": "6c3284e9-ed1a-4a1e-a2e7-409cc379eced",
      "name": "编辑字段2",
      "type": "n8n-nodes-base.set",
      "position": [
        4560,
        360
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "06547676-59d7-416e-85ca-e85666a72125",
      "name": "X",
      "type": "n8n-nodes-base.twitter",
      "position": [
        1840,
        1980
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "f00830b5-9035-439c-be46-cc24e0446f72",
      "name": "便签18",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1580,
        1840
      ],
      "parameters": {
        "content": "确保您的表名与实际知识库结构匹配"
      },
      "typeVersion": 1
    },
    {
      "id": "eaa1c88a-3629-4d0d-95a6-4fed7cb2c278",
      "name": "合并",
      "type": "n8n-nodes-base.merge",
      "position": [
        2660,
        1440
      ],
      "parameters": {},
      "typeVersion": 3.1
    },
    {
      "id": "ff7d2733-84a9-4e1a-8068-7f4f5f136ac0",
      "name": "Gmail",
      "type": "n8n-nodes-base.gmail",
      "position": [
        3740,
        1540
      ],
      "webhookId": "916ba034-43a5-46e7-a35c-fd1498db9d12",
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "60857340-ea45-409c-84bc-5a186b276990",
      "name": "添加到数据库",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        3220,
        1440
      ],
      "parameters": {},
      "typeVersion": 4.5
    },
    {
      "id": "8107eb68-f038-4cb4-bc93-804ac901662e",
      "name": "便签12",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        3580,
        400
      ],
      "parameters": {
        "content": "确保您的表名与实际知识库结构匹配"
      },
      "typeVersion": 1
    },
    {
      "id": "78edbe8a-b901-4344-b949-b6ec2f214524",
      "name": "便签13",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        3560,
        20
      ],
      "parameters": {
        "content": "确保您的表名与实际知识库结构匹配"
      },
      "typeVersion": 1
    },
    {
      "id": "05de5f97-fda8-42ed-829d-e844f3fc6a74",
      "name": "便签14",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1240,
        1000
      ],
      "parameters": {
        "content": "确保您的表名与实际知识库结构匹配"
      },
      "typeVersion": 1
    },
    {
      "id": "18335555-0037-4d9c-81ea-9d632fdb5d04",
      "name": "便签15",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2160,
        -60
      ],
      "parameters": {
        "content": "确保您的表名与实际知识库结构匹配"
      },
      "typeVersion": 1
    },
    {
      "id": "e33d1e93-b242-4383-ae25-01506b2de480",
      "name": "便签16",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2920,
        -80
      ],
      "parameters": {
        "content": "确保您的表名与实际知识库结构匹配"
      },
      "typeVersion": 1
    },
    {
      "id": "9ec1629d-50f1-4bf3-850d-241725b6b66d",
      "name": "便签17",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2480,
        1140
      ],
      "parameters": {
        "content": "确保您的表名与实际知识库结构匹配"
      },
      "typeVersion": 1
    },
    {
      "id": "24e2edc5-5f05-4ab2-9846-dc1e24e2b52e",
      "name": "聚合1",
      "type": "n8n-nodes-base.aggregate",
      "position": [
        2880,
        1440
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "23e18303-51fd-4c8a-9575-b0a2b8606a4d",
      "name": "便签19",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        3560,
        1140
      ],
      "parameters": {
        "content": "确保您的表名与实际知识库结构匹配"
      },
      "typeVersion": 1
    },
    {
      "id": "dc4fd5e8-e07e-4c42-9ad8-8c9cfbaec989",
      "name": "便签 10",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2660,
        -220
      ],
      "parameters": {
        "content": "确保您的表名与实际知识库结构匹配"
      },
      "typeVersion": 1
    },
    {
      "id": "f19e24ac-8fc0-4b86-b87f-d435ff80a71a",
      "name": "便签 11",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1160,
        -220
      ],
      "parameters": {
        "content": "确保您的表名与实际知识库结构匹配"
      },
      "typeVersion": 1
    },
    {
      "id": "b7725230-33b0-4dae-82f8-e2ef31c465da",
      "name": "编辑字段3",
      "type": "n8n-nodes-base.set",
      "position": [
        1620,
        140
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "4b55a423-64b2-4f76-b824-5810653d6977",
      "name": "OpenAI1",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        3900,
        120
      ],
      "parameters": {},
      "typeVersion": 1.8
    },
    {
      "id": "1d0c17cf-52e4-4bde-bb6f-d77b854890a9",
      "name": "OpenAI2",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        3920,
        500
      ],
      "parameters": {},
      "typeVersion": 1.8
    },
    {
      "id": "0bd64785-617b-4ba5-ab5c-bcda09c6f08c",
      "name": "帖子图片Cloudinary1",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        4200,
        500
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "97c1ee7e-6d3f-4239-97cf-69f3cba626df",
      "name": "帖子图片Cloudinary",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        4180,
        120
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "1017a22d-4611-4372-8754-d27ae44cf105",
      "name": "便签20",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        5140,
        -220
      ],
      "parameters": {
        "content": "确保您的表名与实际知识库结构匹配"
      },
      "typeVersion": 1
    },
    {
      "id": "d371b329-85a8-493d-88f7-225f0eef0321",
      "name": "便签21",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -3420,
        -220
      ],
      "parameters": {
        "content": "确保您的表名与实际知识库结构匹配"
      },
      "typeVersion": 1
    },
    {
      "id": "29dec5f4-f490-4900-877b-19089e282775",
      "name": "便签22",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1240,
        -160
      ],
      "parameters": {
        "content": "确保您的表名与实际知识库结构匹配"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "2d63b6f6-0a30-41cc-a909-e5bdd02affe9",
  "connections": {
    "X": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 2
          }
        ]
      ]
    },
    "Merge": {
      "main": [
        [
          {
            "node": "Aggregate1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Merge3": {
      "main": [
        [
          {
            "node": "Upload media to Instagram",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Merge4": {
      "main": [
        [
          {
            "node": "Facebook Post1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Notion": {
      "main": [
        [
          {
            "node": "Aggregate",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI": {
      "main": [
        [
          {
            "node": "Upload Image to Wordpress2",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Write prompt to search image",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI1": {
      "main": [
        [
          {
            "node": "Post image Cloudinary",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI2": {
      "main": [
        [
          {
            "node": "Post image Cloudinary1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Markdown": {
      "main": [
        [
          {
            "node": "Update list of blog post",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Aggregate": {
      "main": [
        [
          {
            "node": "Edit Fields",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Wordpress": {
      "main": [
        [
          {
            "node": "Write prompt to create image",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Aggregate1": {
      "main": [
        [
          {
            "node": "Add too Data Bank",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Edit Fields1": {
      "main": [
        [
          {
            "node": "Merge3",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Edit Fields2": {
      "main": [
        [
          {
            "node": "Merge4",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Edit Fields3": {
      "main": [
        [
          {
            "node": "Social Media Content Creator",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Idea creator": {
      "main": [
        [
          {
            "node": "Category rewrite",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "gpt-4.1 mini": {
      "ai_languageModel": [
        [
          {
            "node": "Social Media Content Creator",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Cleanup HTML ": {
      "main": [
        [
          {
            "node": "Wordpress",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Cleanup Links": {
      "main": [
        [
          {
            "node": "Content writer",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets": {
      "ai_tool": [
        [
          {
            "node": "Idea creator",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Simple Memory": {
      "ai_memory": [
        [
          {
            "node": "Idea creator",
            "type": "ai_memory",
            "index": 0
          }
        ]
      ]
    },
    "Content writer": {
      "main": [
        [
          {
            "node": "Cleanup HTML ",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Download Image": {
      "main": [
        [
          {
            "node": "Upload Image to Wordpress",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Facebook Post1": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Excerpt creator": {
      "main": [
        [
          {
            "node": "WordPress excerpt add",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI 4.1 mini": {
      "ai_languageModel": [
        [
          {
            "node": "Content writer",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "get brand brief": {
      "ai_tool": [
        [
          {
            "node": "Idea creator",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Category rewrite": {
      "main": [
        [
          {
            "node": "Perplexity Research1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI 4.1 mini1": {
      "ai_languageModel": [
        [
          {
            "node": "Write prompt to search image",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI 4.1 mini2": {
      "ai_languageModel": [
        [
          {
            "node": "Excerpt creator",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI 4.1 mini3": {
      "ai_languageModel": [
        [
          {
            "node": "Idea creator",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI 4.1 mini4": {
      "ai_languageModel": [
        [
          {
            "node": "Write prompt to create image",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "Idea creator",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Update base post": {
      "main": [
        [
          {
            "node": "Edit Fields3",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Add too Data Bank": {
      "main": [
        [
          {
            "node": "Gmail",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Publish Post on IG": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Perplexity Research1": {
      "main": [
        [
          {
            "node": "Cleanup Links",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Social Media Content": {
      "ai_outputParser": [
        [
          {
            "node": "Social Media Content Creator",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "Get Image from Pexcel": {
      "main": [
        [
          {
            "node": "Download Image",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Post image Cloudinary": {
      "main": [
        [
          {
            "node": "Merge3",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "WordPress excerpt add": {
      "main": [
        [
          {
            "node": "Markdown",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Post image Cloudinary1": {
      "main": [
        [
          {
            "node": "Merge4",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Update list of blog post": {
      "main": [
        [
          {
            "node": "Update base post",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Structured Output Parser1": {
      "ai_outputParser": [
        [
          {
            "node": "Idea creator",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "Upload Image to Wordpress": {
      "main": [
        [
          {
            "node": "Set Image on Wordpress Post",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Upload media to Instagram": {
      "main": [
        [
          {
            "node": "Publish Post on IG",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Upload Image to Wordpress2": {
      "main": [
        [
          {
            "node": "Set Image on Wordpress Post2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set Image on Wordpress Post": {
      "main": [
        [
          {
            "node": "Excerpt creator",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set Image on Wordpress Post2": {
      "main": [
        [
          {
            "node": "Excerpt creator",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Social Media Content Creator": {
      "main": [
        [
          {
            "node": "Edit Fields2",
            "type": "main",
            "index": 0
          },
          {
            "node": "Edit Fields1",
            "type": "main",
            "index": 0
          },
          {
            "node": "X",
            "type": "main",
            "index": 0
          },
          {
            "node": "OpenAI1",
            "type": "main",
            "index": 0
          },
          {
            "node": "OpenAI2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Write prompt to create image": {
      "main": [
        [
          {
            "node": "OpenAI",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Write prompt to search image": {
      "main": [
        [
          {
            "node": "Get Image from Pexcel",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "When Executed by Another Workflow": {
      "main": [
        [
          {
            "node": "Notion",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "When clicking ‘Test workflow’": {
      "main": [
        [
          {
            "node": "Idea creator",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流?

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

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

高级 - 设计, 人工智能, 营销

需要付费吗?

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

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

适合高级用户,包含 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 查看

分享此工作流