8
n8n 中文网amn8n.com

多平台社交媒体内容创建器(含GoToHuman审批)

高级

这是一个自动化工作流,包含 17 个节点。主要使用 Set, Switch, GoogleSheets, ManualTrigger, SplitInBatches 等节点。 使用Sonnet 4.5、GoToHuman审批和Sheets创建多平台社交媒体内容

前置要求
  • Google Sheets API 凭证
  • Anthropic API Key

分类

-
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
  "id": "JSvf2fGBwstKgIxn",
  "meta": {
    "instanceId": "a4bfc93e975ca233ac45ed7c9227d84cf5a2329310525917adaf3312e10d5462",
    "templateCredsSetupCompleted": true
  },
  "name": "多平台社交媒体内容创建器(含 GoToHuman 审批)",
  "tags": [],
  "nodes": [
    {
      "id": "ffe2762d-5976-4570-ae33-a2378aedd91a",
      "name": "点击\"执行工作流\"时",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -672,
        0
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "c9d4ea50-4ae8-43cd-8038-83efa23e2f40",
      "name": "发送审核请求并等待响应",
      "type": "@gotohuman/n8n-nodes-gotohuman.gotoHuman",
      "position": [
        880,
        16
      ],
      "webhookId": "fd27b9c5-2c32-4b4a-8124-a3caac5ab43d",
      "parameters": {
        "fields": {
          "value": {
            "text": "={{ $json.text }}"
          },
          "schema": [
            {
              "id": "text",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "text (text)",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "text"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "metaSelect": "keyValue",
        "metaKeyValues": {
          "metaArray": [
            {
              "key": "PLATFORM",
              "value": "={{ $('Loop Over Items').item.json.PLATFORM }}"
            }
          ]
        },
        "additionalFields": {},
        "reviewTemplateID": {
          "__rl": true,
          "mode": "list",
          "value": "vw7nJ9pL8yxzYiLypbD4",
          "cachedResultName": "n8n-test (vw7nJ9pL8yxzYiLypbD4)"
        }
      },
      "credentials": {
        "gotoHumanApi": {
          "id": "OeQshMhfsAzR0dF0",
          "name": "gotoHuman account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "38e95143-17a2-4195-8047-5fd890dc8ea8",
      "name": "Switch",
      "type": "n8n-nodes-base.switch",
      "position": [
        1152,
        16
      ],
      "parameters": {
        "rules": {
          "values": [
            {
              "outputKey": "approved",
              "conditions": {
                "options": {
                  "version": 2,
                  "leftValue": "",
                  "caseSensitive": true,
                  "typeValidation": "loose"
                },
                "combinator": "and",
                "conditions": [
                  {
                    "id": "9c70c304-7f5e-4007-a65e-cec67253d220",
                    "operator": {
                      "type": "string",
                      "operation": "equals"
                    },
                    "leftValue": "={{ $json.response }}",
                    "rightValue": "approved"
                  }
                ]
              },
              "renameOutput": true
            },
            {
              "outputKey": "rejected",
              "conditions": {
                "options": {
                  "version": 2,
                  "leftValue": "",
                  "caseSensitive": true,
                  "typeValidation": "loose"
                },
                "combinator": "and",
                "conditions": [
                  {
                    "id": "7a745692-2cfb-4341-bb66-302e8adc424a",
                    "operator": {
                      "name": "filter.operator.equals",
                      "type": "string",
                      "operation": "equals"
                    },
                    "leftValue": "={{ $json.response }}",
                    "rightValue": "rejected"
                  }
                ]
              },
              "renameOutput": true
            }
          ]
        },
        "options": {},
        "looseTypeValidation": true
      },
      "typeVersion": 3.2
    },
    {
      "id": "681b2555-e9ce-4a7e-8ff9-5bd4301fc946",
      "name": "遍历项目",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        -144,
        0
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 3
    },
    {
      "id": "1600d02f-593b-4546-b6f2-7f6cf5401ca0",
      "name": "在表格中更新行",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        896,
        560
      ],
      "parameters": {
        "columns": {
          "value": {
            "POST": "={{ $json.responseValues.text.value }}",
            "APPROVED": "x",
            "row_number": "={{ $('Loop Over Items').item.json.row_number }}"
          },
          "schema": [
            {
              "id": "DATE",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "DATE",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "IDEA",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "IDEA",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "PLATFORM",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "PLATFORM",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "POST",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "POST",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "APPROVED",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "APPROVED",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "row_number",
              "type": "number",
              "display": true,
              "removed": false,
              "readOnly": true,
              "required": false,
              "displayName": "row_number",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "row_number"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "update",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1WLdKRpPxwLzvD27uHZIlY5Lcc5i-79PmapcWyYzJevI/edit#gid=0",
          "cachedResultName": "Foglio1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1WLdKRpPxwLzvD27uHZIlY5Lcc5i-79PmapcWyYzJevI",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1WLdKRpPxwLzvD27uHZIlY5Lcc5i-79PmapcWyYzJevI/edit?usp=drivesdk",
          "cachedResultName": "Editorial Plan"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "JYR6a64Qecd6t8Hb",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.7
    },
    {
      "id": "ab083a38-be9b-4b12-b22a-0031d00d1972",
      "name": "社交媒体内容创建器",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        208,
        16
      ],
      "parameters": {
        "text": "={{ $json.IDEA }}",
        "options": {
          "systemMessage": "=You are an expert social media content creator specializing in transforming post ideas into platform-optimized, engaging content. Your role is to take a provided post concept and generate the actual social media post for the specified platform.\n\n**YOUR CAPABILITIES:**\n- Transform conceptual ideas into compelling, ready-to-publish social media content\n- Platform: {{ $json.PLATFORM }}\n- Adapt tone, format, and structure to match specific platform requirements\n- Create engaging hooks that stop scrollers and drive engagement\n- Write persuasive copy that converts browsers into customers\n- Optimize content for platform's algorithm and user behavior\n\n**INPUT YOU'LL RECEIVE:**\n- Post idea/concept with key messaging\n- Brand/product information\n- Target audience (if specified)\n\n**YOUR OUTPUT MUST INCLUDE:**\n- **Platform-optimized post text** (respecting character limits)\n\n**PLATFORM-SPECIFIC ADAPTATIONS:**\n- **Instagram**: Visual-first, story-driven, 2-3 hashtag clusters, engaging captions\n- **Facebook**: Conversation-starter, community-focused, longer form acceptable\n- **LinkedIn**: Professional tone, value-driven, industry insights\n- **X.com**: Concise, witty, thread-worthy, trending topic integration\n\n**WRITING STYLE:**\n- Hook readers within the first 5 words\n- Use active voice and present tense\n- Include sensory details and emotional triggers\n- Balance promotional content with value/entertainment\n- Create urgency without being pushy\n- Write in a conversational, human tone\n\n**ENGAGEMENT OPTIMIZATION:**\n- Ask questions to drive comments\n- Use inclusive language (\"we\", \"us\", \"our community\")\n- Include interactive elements (polls, challenges, user-generated content prompts)\n- Create shareable moments\n- End with clear next steps\n\n**BRAND SAFETY:**\n- Maintain brand voice consistency\n- Avoid controversial topics unless brand-relevant\n- Ensure claims are truthful and substantiated\n- Respect cultural sensitivities\n- Follow platform community guidelines\n\nWhen you receive a post idea and platform specification, generate complete, ready-to-publish content that maximizes engagement while achieving the stated marketing objectives. It just generates the content of the post without preambles or explanations"
        },
        "promptType": "define"
      },
      "typeVersion": 2.2
    },
    {
      "id": "a0559667-622f-4ec1-964e-e90691b6d73a",
      "name": "计划触发器",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -672,
        -208
      ],
      "parameters": {
        "rule": {
          "interval": [
            {}
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "d1670f5c-950a-4164-90f5-e4e31c92b5ad",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -688,
        -784
      ],
      "parameters": {
        "color": 3,
        "width": 848,
        "height": 208,
        "content": "## 基于 AI 的多平台社交媒体内容创建器(含人工参与循环 GoToHuman 审核)"
      },
      "typeVersion": 1
    },
    {
      "id": "62fded1a-d57d-46ea-aa44-ea86b572e4ec",
      "name": "设置文本",
      "type": "n8n-nodes-base.set",
      "position": [
        608,
        16
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "aea250ad-ce2a-4ded-b867-39ca31f99a0f",
              "name": "text",
              "type": "string",
              "value": "={{ $json.output }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "1429d8b1-0dd8-475d-95ff-b5471b1215ad",
      "name": "设置新提示",
      "type": "n8n-nodes-base.set",
      "position": [
        1136,
        288
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "ff2f93fa-799d-422e-8db2-a807de13b9e7",
              "name": "IDEA",
              "type": "string",
              "value": "={{ $json.responseValues.text.value }}"
            },
            {
              "id": "d7927120-c7f4-4bf1-8f56-c92f4e3b7872",
              "name": "PLATFORM",
              "type": "string",
              "value": "={{ $json.meta.PLATFORM }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "abc634b2-0246-4662-aa4b-06e2226a640c",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -688,
        -560
      ],
      "parameters": {
        "width": 848,
        "height": 112,
        "content": "## 步骤 1"
      },
      "typeVersion": 1
    },
    {
      "id": "10aaabb0-a72d-4496-a23d-3b47fa3b0d81",
      "name": "便签2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -688,
        -432
      ],
      "parameters": {
        "width": 848,
        "height": 176,
        "content": "## 步骤 2"
      },
      "typeVersion": 1
    },
    {
      "id": "44185926-44fb-4810-b541-e9e792ea38c2",
      "name": "获取创意",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -368,
        0
      ],
      "parameters": {
        "options": {},
        "filtersUI": {
          "values": [
            {
              "lookupColumn": "APPROVED"
            }
          ]
        },
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1WLdKRpPxwLzvD27uHZIlY5Lcc5i-79PmapcWyYzJevI/edit#gid=0",
          "cachedResultName": "Foglio1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1WLdKRpPxwLzvD27uHZIlY5Lcc5i-79PmapcWyYzJevI",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1WLdKRpPxwLzvD27uHZIlY5Lcc5i-79PmapcWyYzJevI/edit?usp=drivesdk",
          "cachedResultName": "Editorial Plan"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "JYR6a64Qecd6t8Hb",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.7
    },
    {
      "id": "a0513b14-111e-4462-93cd-5742db306181",
      "name": "便签3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        816,
        -32
      ],
      "parameters": {
        "height": 192,
        "content": "设置您的审核模板"
      },
      "typeVersion": 1
    },
    {
      "id": "78fcb528-e425-4215-a4f6-37c5d92ef7f9",
      "name": "便签4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1072,
        240
      ],
      "parameters": {
        "width": 208,
        "height": 176,
        "content": "设置您的新提示"
      },
      "typeVersion": 1
    },
    {
      "id": "421822b4-07f1-4370-b433-12739f4b5538",
      "name": "便签5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1088,
        -32
      ],
      "parameters": {
        "height": 192,
        "content": "生成的内容是否已批准"
      },
      "typeVersion": 1
    },
    {
      "id": "aa6505dc-0f62-4c4f-a2aa-d3dab4f843ef",
      "name": "Anthropic 聊天模型",
      "type": "@n8n/n8n-nodes-langchain.lmChatAnthropic",
      "position": [
        176,
        208
      ],
      "parameters": {
        "model": {
          "__rl": true,
          "mode": "list",
          "value": "claude-sonnet-4-5-20250929",
          "cachedResultName": "Claude Sonnet 4.5"
        },
        "options": {}
      },
      "credentials": {
        "anthropicApi": {
          "id": "NNTZAD0Gmf7lcniq",
          "name": "Anthropic account"
        }
      },
      "typeVersion": 1.3
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "02682927-5a1a-4041-b0a1-c4064a20ab42",
  "connections": {
    "Switch": {
      "main": [
        [
          {
            "node": "Update row in sheet",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Set new prompt",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set Text": {
      "main": [
        [
          {
            "node": "Send review request and wait for response",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get ideas": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set new prompt": {
      "main": [
        [
          {
            "node": "Social Media Content Creator",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Items": {
      "main": [
        [],
        [
          {
            "node": "Social Media Content Creator",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Update row in sheet": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Anthropic Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "Social Media Content Creator",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Social Media Content Creator": {
      "main": [
        [
          {
            "node": "Set Text",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "When clicking ‘Execute workflow’": {
      "main": [
        [
          {
            "node": "Get ideas",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send review request and wait for response": {
      "main": [
        [
          {
            "node": "Switch",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流?

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

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

高级

需要付费吗?

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

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

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

作者

Full-stack Web Developer based in Italy specialising in Marketing & AI-powered automations. For business enquiries, send me an email at info@n3w.it or add me on Linkedin.com/in/davideboizza

外部链接
在 n8n.io 查看

分享此工作流