8
n8n 中文网amn8n.com

使用GPT-5和fal.ai图像从关键词到WordPress自动化SEO博客流程

高级

这是一个Content Creation, Multimodal AI领域的自动化工作流,包含 96 个节点。主要使用 Set, Code, Wait, Limit, Merge 等节点。 使用GPT-5和fal.ai图像从关键词到WordPress自动化SEO博客流程

前置要求
  • PostgreSQL 数据库连接信息
  • 可能需要目标 API 的认证凭证
  • OpenAI API Key
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
  "meta": {
    "instanceId": "e7ccf4281d5afb175c79c02db95b45f15d5b53862cb6bc357c5e5bc26567f35c"
  },
  "nodes": [
    {
      "id": "b1f3327b-a3e3-4434-ae46-c85bfe219469",
      "name": "编辑字段1",
      "type": "n8n-nodes-base.set",
      "position": [
        5344,
        784
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "eeae3506-93c8-4247-a891-557b37dd8e5d",
      "name": "Markdown",
      "type": "n8n-nodes-base.markdown",
      "position": [
        5168,
        784
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "d69c8069-4278-4ba1-952f-19a0a16417f0",
      "name": "创建帖子",
      "type": "n8n-nodes-base.wordpress",
      "position": [
        5568,
        784
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "23b3d13c-2ded-4f4a-99f9-10f2ef3fda72",
      "name": "初步计划1",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        -208,
        1264
      ],
      "parameters": {},
      "typeVersion": 1.8
    },
    {
      "id": "524a410b-a811-431d-8ae0-f41617dc710f",
      "name": "向模型发送消息1",
      "type": "n8n-nodes-base.perplexity",
      "position": [
        96,
        1264
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "8276b50a-4f4f-47d1-9762-d8aa9d036bba",
      "name": "编辑字段8",
      "type": "n8n-nodes-base.set",
      "position": [
        1392,
        416
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "3ac81125-12ee-4ff8-8264-f852fb0fba4a",
      "name": "拆分输出4",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        1152,
        416
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "dd53ca17-db2e-4b41-8765-3e05a627b9b1",
      "name": "聚合7",
      "type": "n8n-nodes-base.aggregate",
      "position": [
        1616,
        416
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "02c8781f-c5bd-4845-a25e-53d66d6a8848",
      "name": "合并1",
      "type": "n8n-nodes-base.merge",
      "position": [
        2768,
        736
      ],
      "parameters": {},
      "typeVersion": 3.2
    },
    {
      "id": "2f647a88-0457-44c9-af1e-8771cdd5a928",
      "name": "编辑字段13",
      "type": "n8n-nodes-base.set",
      "position": [
        2528,
        400
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "89a0be83-0e75-4e06-8ed4-81c4d81b8e0d",
      "name": "结构化输出解析器3",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        1328,
        128
      ],
      "parameters": {},
      "typeVersion": 1.3
    },
    {
      "id": "1e7385a2-16f9-4e29-a185-85408b4fa487",
      "name": "编辑字段15",
      "type": "n8n-nodes-base.set",
      "position": [
        912,
        -32
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "df16555e-d46d-4ce2-b848-54916522dd42",
      "name": "OpenAI Chat Model8",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        1152,
        128
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "5c0197cf-af2d-4727-a369-9c2ee5a14651",
      "name": "聚合8",
      "type": "n8n-nodes-base.aggregate",
      "position": [
        3008,
        800
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "f9c4f53d-fbdb-46c0-964e-1ca0726cf0c0",
      "name": "介绍1",
      "type": "@n8n/n8n-nodes-langchain.chainLlm",
      "position": [
        3360,
        320
      ],
      "parameters": {},
      "typeVersion": 1.7
    },
    {
      "id": "cd109f1f-f5fc-4297-9380-8300792dd9e6",
      "name": "结论1",
      "type": "@n8n/n8n-nodes-langchain.chainLlm",
      "position": [
        3376,
        1680
      ],
      "parameters": {},
      "typeVersion": 1.7
    },
    {
      "id": "4abd93a7-df00-4c38-91df-f86fa3192e9f",
      "name": "合并3",
      "type": "n8n-nodes-base.merge",
      "position": [
        4416,
        704
      ],
      "parameters": {},
      "typeVersion": 3.2
    },
    {
      "id": "3511876c-d41f-44d3-8f16-2bfa514871b0",
      "name": "聚合9",
      "type": "n8n-nodes-base.aggregate",
      "position": [
        4576,
        768
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "f18a413f-01bd-4edb-9f1f-275eee69fd22",
      "name": "编辑字段16",
      "type": "n8n-nodes-base.set",
      "position": [
        3712,
        384
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "01f83222-ad77-4e6d-b730-d1c20571d6f5",
      "name": "编辑字段19",
      "type": "n8n-nodes-base.set",
      "position": [
        3712,
        864
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "3f3b840d-ea89-473c-a661-2aad59465934",
      "name": "编辑字段21",
      "type": "n8n-nodes-base.set",
      "position": [
        3712,
        1312
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "00588572-a164-4595-92f9-808e856e3fe7",
      "name": "编辑字段22",
      "type": "n8n-nodes-base.set",
      "position": [
        3680,
        1760
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "30cf042e-cc89-4ffa-8165-28ef9ff8172d",
      "name": "帖子标题1",
      "type": "@n8n/n8n-nodes-langchain.chainLlm",
      "position": [
        3360,
        -32
      ],
      "parameters": {},
      "typeVersion": 1.7
    },
    {
      "id": "652d4149-e6cf-453f-8851-a691d4d07ade",
      "name": "代码8",
      "type": "n8n-nodes-base.code",
      "position": [
        4896,
        768
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "a1e7708f-20e4-4723-a275-98bc6e5aabde",
      "name": "编辑字段2",
      "type": "n8n-nodes-base.set",
      "position": [
        4720,
        768
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "ff17bf59-338d-4f36-9699-6ff71fff16dd",
      "name": "编辑字段24",
      "type": "n8n-nodes-base.set",
      "position": [
        5744,
        784
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "e6e56b4d-b7e5-44e2-a82a-f5a209771e11",
      "name": "编辑字段25",
      "type": "n8n-nodes-base.set",
      "position": [
        1296,
        880
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "84a4adbf-3a8b-4d73-92d5-5ba545bcdceb",
      "name": "聚合1",
      "type": "n8n-nodes-base.aggregate",
      "position": [
        1504,
        880
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "661cd282-cbcd-4e03-b666-b64bc3fb8518",
      "name": "便签9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        16,
        1152
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "ec3e672b-f88c-4032-a833-97465f31ff4b",
      "name": "选择博客表1",
      "type": "n8n-nodes-base.postgres",
      "position": [
        -560,
        1264
      ],
      "parameters": {},
      "typeVersion": 2.6
    },
    {
      "id": "091575e9-d5db-4c2b-bfaf-038a6dfe2f14",
      "name": "限制为",
      "type": "n8n-nodes-base.limit",
      "position": [
        -336,
        1264
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "7e500f18-4410-493e-89ac-83fbc0d58c8b",
      "name": "便签 10",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        960,
        352
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "c484bf30-3707-4edd-a77c-aab0bc9b3683",
      "name": "便签11",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        896,
        784
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "27d5909b-18d0-422b-b9a2-62c6c5b8f7b0",
      "name": "博客表1",
      "type": "n8n-nodes-base.postgres",
      "position": [
        1088,
        880
      ],
      "parameters": {},
      "typeVersion": 2.6
    },
    {
      "id": "6fdaabc9-912f-4022-bd92-cc478de1a1f9",
      "name": "为开发创建计划1",
      "type": "@n8n/n8n-nodes-langchain.chainLlm",
      "position": [
        1136,
        -32
      ],
      "parameters": {},
      "typeVersion": 1.7
    },
    {
      "id": "2361fe23-e7b3-4921-8394-0dff968a208f",
      "name": "记录博客链接以供未来内部链接使用1",
      "type": "n8n-nodes-base.postgres",
      "position": [
        5904,
        784
      ],
      "parameters": {},
      "typeVersion": 2.6
    },
    {
      "id": "c8d4265c-32e6-4c47-852d-9fc444864053",
      "name": "便签20",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        3168,
        -256
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "25860983-be9d-49fc-bc73-d14fe9f17adc",
      "name": "便签21",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        4832,
        688
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "6dc21895-bdb9-4de5-a7bb-0c74f112f8a9",
      "name": "便签22",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        816,
        -208
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "29e05935-0e4f-40fd-81a5-390e198d7a42",
      "name": "便签23",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -880,
        1136
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "cd9eab84-3270-4937-a031-a7d55846d61c",
      "name": "常见问题解答部分1",
      "type": "@n8n/n8n-nodes-langchain.chainLlm",
      "position": [
        3328,
        2064
      ],
      "parameters": {},
      "typeVersion": 1.7
    },
    {
      "id": "afa6a4f2-8b7d-4669-a698-1de7088ede25",
      "name": "编辑字段26",
      "type": "n8n-nodes-base.set",
      "position": [
        3712,
        2096
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "1d3a4056-1bd0-4cca-9e53-903603cbe8f1",
      "name": "计划触发器3",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -800,
        1264
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "2f38a2ad-284f-4bbc-a620-5ebf11b1ed0d",
      "name": "OpenAI 聊天模型10",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        3392,
        176
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "d1210cbe-e830-44af-8bd5-590ada0288f3",
      "name": "OpenAI Chat Model11",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        3520,
        544
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "04888440-e99f-455b-967e-72e473500f0f",
      "name": "OpenAI Chat Model12",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        3456,
        992
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "f0c2b1ee-4b14-4de2-8ec0-a2e3a1632f48",
      "name": "OpenAI Chat Model13",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        3552,
        1856
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "b7e4e1e7-609d-44fc-8e1e-c5e07221bed3",
      "name": "OpenAI Chat Model14",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        3584,
        1472
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "cc1d6071-04c3-4083-b372-5a3d489f1650",
      "name": "OpenAI Chat Model15",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        3328,
        2240
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "04767abd-2757-4982-8147-8e538dd100b7",
      "name": "基础LLM链",
      "type": "@n8n/n8n-nodes-langchain.chainLlm",
      "position": [
        1744,
        -128
      ],
      "parameters": {},
      "typeVersion": 1.7
    },
    {
      "id": "114f98b0-59bd-41a6-94c0-4fdf1ebe56be",
      "name": "OpenRouter聊天模型",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenRouter",
      "position": [
        1888,
        16
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "09087fef-8173-4942-abd3-321c800cbcc5",
      "name": "创建图像1",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        2016,
        -128
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "589547c7-24bb-4d8b-ba04-a5c9351c4d56",
      "name": "获取结果1",
      "type": "n8n-nodes-base.httpRequest",
      "onError": "continueErrorOutput",
      "position": [
        2304,
        -128
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "205a8b76-2383-4f47-be3d-7974e52601b7",
      "name": "10 秒1",
      "type": "n8n-nodes-base.wait",
      "position": [
        2176,
        -128
      ],
      "webhookId": "caad73e3-58d8-4fbd-a3e9-c42424f2d1ee",
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "91b8a06d-ff27-4304-bd67-a94472a2fbd7",
      "name": "5 秒1",
      "type": "n8n-nodes-base.wait",
      "position": [
        2336,
        16
      ],
      "webhookId": "5f6bbd1e-a155-48de-b737-a225c6fd7a84",
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "75d2b6e0-afd3-4a76-ae4b-d5ecdc173986",
      "name": "基础LLM链1",
      "type": "@n8n/n8n-nodes-langchain.chainLlm",
      "position": [
        1088,
        1280
      ],
      "parameters": {},
      "typeVersion": 1.7
    },
    {
      "id": "9133b155-54d5-46cf-8aa8-0310480bf6a5",
      "name": "OpenRouter 聊天模型1",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenRouter",
      "position": [
        1040,
        1424
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "37f91081-376a-4106-9533-e6b6a01d2026",
      "name": "编辑字段",
      "type": "n8n-nodes-base.set",
      "position": [
        2112,
        1168
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "22aab6b7-b30e-45ec-892b-9d155acba534",
      "name": "创建图像3",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1424,
        1280
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "8509d3a4-30f9-4d99-a084-dcadee3eeecc",
      "name": "获取结果3",
      "type": "n8n-nodes-base.httpRequest",
      "onError": "continueErrorOutput",
      "position": [
        1760,
        1280
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "752c12bb-a03a-497c-acdb-bac7d1a15156",
      "name": "10 秒3",
      "type": "n8n-nodes-base.wait",
      "position": [
        1584,
        1280
      ],
      "webhookId": "caad73e3-58d8-4fbd-a3e9-c42424f2d1ee",
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "b0d5fa77-5359-4962-bda4-623cf2f3f893",
      "name": "5 秒3",
      "type": "n8n-nodes-base.wait",
      "position": [
        1952,
        1376
      ],
      "webhookId": "5f6bbd1e-a155-48de-b737-a225c6fd7a84",
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "2b0e5bd1-3767-42b1-ba4b-9292ac059f03",
      "name": "开发 2",
      "type": "@n8n/n8n-nodes-langchain.chainLlm",
      "position": [
        3344,
        1216
      ],
      "parameters": {},
      "typeVersion": 1.7
    },
    {
      "id": "7735497f-4c2f-421d-9911-44c208e698c3",
      "name": "开发 1",
      "type": "@n8n/n8n-nodes-langchain.chainLlm",
      "position": [
        3344,
        752
      ],
      "parameters": {},
      "typeVersion": 1.7
    },
    {
      "id": "155f416d-8688-43a1-9c22-71cd329dd06b",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        960,
        1088
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "d7116f04-cd71-4d6e-8af6-a5ae0ed3c9ca",
      "name": "便签 1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1648,
        -256
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "30bb9c95-9253-4a37-9a8a-0b6eeb1ac81c",
      "name": "便签 2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        5088,
        688
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "4cc4e8be-9282-4651-b779-39bdd7dd3f25",
      "name": "聚合2",
      "type": "n8n-nodes-base.aggregate",
      "position": [
        160,
        -1088
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "7e7a1922-e519-49c3-b730-7d2e7b46a95c",
      "name": "编辑字段3",
      "type": "n8n-nodes-base.set",
      "position": [
        16,
        -1088
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "2126a40e-5bf4-44bd-9211-a9ad2023d99a",
      "name": "结构化输出解析器",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        592,
        -864
      ],
      "parameters": {},
      "typeVersion": 1.3
    },
    {
      "id": "b7cb3dfb-aa43-4923-b362-677ba5ecabdb",
      "name": "在表中插入行",
      "type": "n8n-nodes-base.postgres",
      "position": [
        736,
        -896
      ],
      "parameters": {},
      "typeVersion": 2.6
    },
    {
      "id": "4eb84a42-57ee-4ca4-ae66-2698a43c099b",
      "name": "从表中选择行1",
      "type": "n8n-nodes-base.postgres",
      "position": [
        736,
        -1088
      ],
      "parameters": {},
      "typeVersion": 2.6
    },
    {
      "id": "1df5eff6-262d-4b3c-905f-9e41220c4588",
      "name": "从表中选择行2",
      "type": "n8n-nodes-base.postgres",
      "position": [
        960,
        -1296
      ],
      "parameters": {},
      "typeVersion": 2.6
    },
    {
      "id": "0a52569d-6b15-4fa9-b82d-f09804365dba",
      "name": "拆分输出2",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        736,
        -1296
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "0a95ca85-9376-447a-a4b8-8c5cd3a6176c",
      "name": "代码4",
      "type": "n8n-nodes-base.code",
      "position": [
        1120,
        -1296
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "1ea4f919-76ee-4a19-8246-7e12482724f8",
      "name": "代码5",
      "type": "n8n-nodes-base.code",
      "position": [
        960,
        -1088
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "2f7c3566-62d7-48b9-9596-6deb2bf93f65",
      "name": "Sticky Note27",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -816,
        -1648
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "014b8086-4dd9-4896-9635-5b2d16a66c1d",
      "name": "从表中选择行",
      "type": "n8n-nodes-base.postgres",
      "position": [
        1712,
        -1232
      ],
      "parameters": {},
      "typeVersion": 2.6
    },
    {
      "id": "5825a7b8-9004-4208-92ba-278eea4623d4",
      "name": "评分关键词",
      "type": "n8n-nodes-base.code",
      "position": [
        2224,
        -1232
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "81d86f50-1cfb-4921-b5e3-fbd898993699",
      "name": "遍历项目",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        2000,
        -1232
      ],
      "parameters": {},
      "typeVersion": 3
    },
    {
      "id": "15192939-d3e1-4d1a-be9c-a5236b52f499",
      "name": "获取关键词1",
      "type": "n8n-nodes-base.postgres",
      "position": [
        -448,
        -1088
      ],
      "parameters": {},
      "typeVersion": 2.4
    },
    {
      "id": "b0b2791e-f13c-4b80-b29e-568919e34a2c",
      "name": "从 Postgres 表中选择行",
      "type": "n8n-nodes-base.postgresTool",
      "position": [
        464,
        -864
      ],
      "parameters": {},
      "typeVersion": 2.6
    },
    {
      "id": "09cacb1b-a286-450b-aa71-c13b630425c4",
      "name": "计划触发器",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -624,
        -1088
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "3b36067e-ef7f-4a93-83b4-1eeec3125a87",
      "name": "选择关键词、意图等",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        384,
        -1088
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "fe489f6e-1509-471a-b6f6-c6c5d0610258",
      "name": "主要关键词",
      "type": "n8n-nodes-base.postgres",
      "position": [
        1184,
        -1088
      ],
      "parameters": {},
      "typeVersion": 2.6
    },
    {
      "id": "79835988-1d89-4cd6-9e4b-a469bbc08096",
      "name": "已使用的次要关键词",
      "type": "n8n-nodes-base.postgres",
      "position": [
        1392,
        -1296
      ],
      "parameters": {},
      "typeVersion": 2.6
    },
    {
      "id": "a315d8b1-075d-47bc-b2b7-1c877c8e62c2",
      "name": "更新分数",
      "type": "n8n-nodes-base.postgres",
      "position": [
        2432,
        -1152
      ],
      "parameters": {},
      "typeVersion": 2.6
    },
    {
      "id": "e9198617-a284-485d-860e-d069ee677ad1",
      "name": "全部已评分",
      "type": "n8n-nodes-base.noOp",
      "position": [
        2224,
        -1488
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "162e9c9f-fd4f-46c4-937f-9efc4970b71b",
      "name": "便签 16",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1712,
        -1440
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "2f7ca97e-4d94-42d2-aa57-2da271539942",
      "name": "便签 17",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -512,
        -1200
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "a9fc07b9-343b-4073-b0c2-41ae99b535f8",
      "name": "OpenAI 聊天模型1",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        336,
        -864
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "52562268-d02c-4855-a6e7-1963532d71c3",
      "name": "限制2",
      "type": "n8n-nodes-base.limit",
      "position": [
        -240,
        -1088
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "012e1ac7-5295-48da-88af-e678384e502f",
      "name": "便签 3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1600,
        -1584
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "f5767d52-3b36-4026-b556-4a4e86c5be07",
      "name": "便签 4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        496,
        -1440
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "eda20e63-a7e6-47e4-b878-b01a04db03ea",
      "name": "便签 5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2160,
        -1312
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "845f4bd6-bf6d-4e94-8a02-c819a94ff806",
      "name": "便签7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2448,
        -1648
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    }
  ],
  "pinData": {},
  "connections": {
    "Code4": {
      "main": [
        [
          {
            "node": "Used secondary",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Code5": {
      "main": [
        [
          {
            "node": "Primary keywords",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Code8": {
      "main": [
        [
          {
            "node": "Markdown",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "dev 1": {
      "main": [
        [
          {
            "node": "Edit Fields19",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "dev 2": {
      "main": [
        [
          {
            "node": "Edit Fields21",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Intro1": {
      "main": [
        [
          {
            "node": "Edit Fields16",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Limit2": {
      "main": [
        [
          {
            "node": "Edit Fields3",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Merge1": {
      "main": [
        [
          {
            "node": "Aggregate8",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Merge3": {
      "main": [
        [
          {
            "node": "Aggregate9",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Markdown": {
      "main": [
        [
          {
            "node": "Edit Fields1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "limit to ": {
      "main": [
        [
          {
            "node": "Preliminary Plan1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "5 Seconds1": {
      "main": [
        [
          {
            "node": "Get Result1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "5 Seconds3": {
      "main": [
        [
          {
            "node": "Get Result3",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Aggregate1": {
      "main": [
        [
          {
            "node": "Merge1",
            "type": "main",
            "index": 3
          }
        ]
      ]
    },
    "Aggregate2": {
      "main": [
        [
          {
            "node": "Choose keywords, Intent, etc",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Aggregate7": {
      "main": [
        [
          {
            "node": "Merge1",
            "type": "main",
            "index": 2
          }
        ]
      ]
    },
    "Aggregate8": {
      "main": [
        [
          {
            "node": "Intro1",
            "type": "main",
            "index": 0
          },
          {
            "node": "dev 1",
            "type": "main",
            "index": 0
          },
          {
            "node": "dev 2",
            "type": "main",
            "index": 0
          },
          {
            "node": "conclusion1",
            "type": "main",
            "index": 0
          },
          {
            "node": "header post1",
            "type": "main",
            "index": 0
          },
          {
            "node": "FAQ section1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Aggregate9": {
      "main": [
        [
          {
            "node": "Edit Fields2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split Out2": {
      "main": [
        [
          {
            "node": "Select rows from a table2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split Out4": {
      "main": [
        [
          {
            "node": "Edit Fields8",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "10 Seconds1": {
      "main": [
        [
          {
            "node": "Get Result1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "10 Seconds3": {
      "main": [
        [
          {
            "node": "Get Result3",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Edit Fields": {
      "main": [
        [
          {
            "node": "Merge1",
            "type": "main",
            "index": 4
          }
        ]
      ]
    },
    "Get Result1": {
      "main": [
        [
          {
            "node": "Edit Fields13",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "5 Seconds1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Result3": {
      "main": [
        [
          {
            "node": "Edit Fields",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "5 Seconds3",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "blog table1": {
      "main": [
        [
          {
            "node": "Edit Fields25",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "conclusion1": {
      "main": [
        [
          {
            "node": "Edit Fields22",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Edit Fields1": {
      "main": [
        [
          {
            "node": "Create a post",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Edit Fields2": {
      "main": [
        [
          {
            "node": "Code8",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Edit Fields3": {
      "main": [
        [
          {
            "node": "Aggregate2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Edit Fields8": {
      "main": [
        [
          {
            "node": "Aggregate7",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "FAQ section1": {
      "main": [
        [
          {
            "node": "Edit Fields26",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Update score": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "header post1": {
      "main": [
        [
          {
            "node": "Merge3",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Create Image1": {
      "main": [
        [
          {
            "node": "10 Seconds1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Create Image3": {
      "main": [
        [
          {
            "node": "10 Seconds3",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Create a post": {
      "main": [
        [
          {
            "node": "Edit Fields24",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Edit Fields13": {
      "main": [
        [
          {
            "node": "Merge1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Edit Fields15": {
      "main": [
        [
          {
            "node": "create plan for dev1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Edit Fields16": {
      "main": [
        [
          {
            "node": "Merge3",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Edit Fields19": {
      "main": [
        [
          {
            "node": "Merge3",
            "type": "main",
            "index": 2
          }
        ]
      ]
    },
    "Edit Fields21": {
      "main": [
        [
          {
            "node": "Merge3",
            "type": "main",
            "index": 3
          }
        ]
      ]
    },
    "Edit Fields22": {
      "main": [
        [
          {
            "node": "Merge3",
            "type": "main",
            "index": 4
          }
        ]
      ]
    },
    "Edit Fields24": {
      "main": [
        [
          {
            "node": "Log blog link for future internal links1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Edit Fields25": {
      "main": [
        [
          {
            "node": "Aggregate1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Edit Fields26": {
      "main": [
        [
          {
            "node": "Merge3",
            "type": "main",
            "index": 5
          }
        ]
      ]
    },
    "Score Keywords": {
      "main": [
        [
          {
            "node": "Update score",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Basic LLM Chain": {
      "main": [
        [
          {
            "node": "Create Image1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fetch Keywords1": {
      "main": [
        [
          {
            "node": "Limit2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Items": {
      "main": [
        [
          {
            "node": "All scored",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Score Keywords",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Basic LLM Chain1": {
      "main": [
        [
          {
            "node": "Create Image3",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Message a model1": {
      "main": [
        [
          {
            "node": "Split Out4",
            "type": "main",
            "index": 0
          },
          {
            "node": "Edit Fields15",
            "type": "main",
            "index": 0
          },
          {
            "node": "blog table1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "Fetch Keywords1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Preliminary Plan1": {
      "main": [
        [
          {
            "node": "Message a model1",
            "type": "main",
            "index": 0
          },
          {
            "node": "Basic LLM Chain1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger3": {
      "main": [
        [
          {
            "node": "select blog table1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model1": {
      "ai_languageModel": [
        [
          {
            "node": "Choose keywords, Intent, etc",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model8": {
      "ai_languageModel": [
        [
          {
            "node": "create plan for dev1",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "select blog table1": {
      "main": [
        [
          {
            "node": "limit to ",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model10": {
      "ai_languageModel": [
        [
          {
            "node": "header post1",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model11": {
      "ai_languageModel": [
        [
          {
            "node": "Intro1",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model12": {
      "ai_languageModel": [
        [
          {
            "node": "dev 1",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model13": {
      "ai_languageModel": [
        [
          {
            "node": "conclusion1",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model14": {
      "ai_languageModel": [
        [
          {
            "node": "dev 2",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model15": {
      "ai_languageModel": [
        [
          {
            "node": "FAQ section1",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "create plan for dev1": {
      "main": [
        [
          {
            "node": "Basic LLM Chain",
            "type": "main",
            "index": 0
          },
          {
            "node": "Merge1",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "OpenRouter Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "Basic LLM Chain",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "OpenRouter Chat Model1": {
      "ai_languageModel": [
        [
          {
            "node": "Basic LLM Chain1",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Select rows from a table": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Structured Output Parser": {
      "ai_outputParser": [
        [
          {
            "node": "Choose keywords, Intent, etc",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "Select rows from a table1": {
      "main": [
        [
          {
            "node": "Code5",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Select rows from a table2": {
      "main": [
        [
          {
            "node": "Code4",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Structured Output Parser3": {
      "ai_outputParser": [
        [
          {
            "node": "create plan for dev1",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "Choose keywords, Intent, etc": {
      "main": [
        [
          {
            "node": "Insert rows in a table",
            "type": "main",
            "index": 0
          },
          {
            "node": "Select rows from a table1",
            "type": "main",
            "index": 0
          },
          {
            "node": "Split Out2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Select rows from a table in Postgres": {
      "ai_tool": [
        [
          {
            "node": "Choose keywords, Intent, etc",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流?

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

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

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

需要付费吗?

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

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

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

作者

Automation expert & n8n power user. I build advanced workflows combining AI, outbound, and business logic. Grab my templates or reach out for custom builds.

外部链接
在 n8n.io 查看

分享此工作流