8
n8n 中文网amn8n.com

1个帖子发布到所有平台

高级

这是一个Miscellaneous, Multimodal AI领域的自动化工作流,包含 23 个节点。主要使用 Set, Merge, GoogleSheets, ScheduleTrigger, Blotato 等节点。 使用 Google Sheets、Drive 和 Blotato 的自动化每日发布至 9 个社交平台

前置要求
  • Google Sheets API 凭证
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
  "id": "IsEN5SyZ7lz4zsGY",
  "meta": {
    "instanceId": "e232d38e020fdf3e4c5aac7fdf84cd849e91ffb2c1ad80af1a4b16753ff64418",
    "templateCredsSetupCompleted": true
  },
  "name": "1个帖子发布到所有平台",
  "tags": [],
  "nodes": [
    {
      "id": "b203144c-fc13-47ed-815c-d034615e2ec4",
      "name": "获取 Google Drive ID",
      "type": "n8n-nodes-base.set",
      "position": [
        -576,
        928
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "a1750d20-2f6e-4826-80b8-654d0985120d",
              "name": "final_google_drive_url",
              "type": "string",
              "value": "={{ $('Ready to Post Image/Video').item.json['Media URL (google drive)'].match(/https:\\/\\/drive\\.google\\.com\\/file\\/d\\/([A-Za-z0-9_-]+)/i)[1] }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "3816e08f-ca5f-4dc1-a376-0455edc6bad0",
      "name": "准备发布的图片/视频",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -816,
        928
      ],
      "parameters": {
        "options": {
          "returnFirstMatch": true
        },
        "filtersUI": {
          "values": [
            {
              "lookupValue": "Ready to Post",
              "lookupColumn": "Status"
            }
          ]
        },
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1v5S7F9p2apfWRSEHvx8Q6ZX8e-d1lZ4FLlDFyc0-ZA4/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1v5S7F9p2apfWRSEHvx8Q6ZX8e-d1lZ4FLlDFyc0-ZA4",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1v5S7F9p2apfWRSEHvx8Q6ZX8e-d1lZ4FLlDFyc0-ZA4/edit?usp=drivesdk",
          "cachedResultName": "1_post_everywhere"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "NngJvVwUfIhrtQY2",
          "name": "Google - Blotato"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "fa56ad76-9c08-42cd-b2c2-4053895fb730",
      "name": "上传图片/视频到 BLOTATO",
      "type": "@blotato/n8n-nodes-blotato.blotato",
      "position": [
        -336,
        928
      ],
      "parameters": {
        "mediaUrl": "=https://drive.google.com/uc?export=download&id={{ $json.final_google_drive_url }}",
        "resource": "media"
      },
      "credentials": {
        "blotatoApi": {
          "id": "zI14DNda55rFeyY8",
          "name": "Blotato - Brand"
        }
      },
      "typeVersion": 2
    },
    {
      "id": "dd641212-cc0e-4259-95fa-8dbea48c1fe4",
      "name": "Tiktok [BLOTATO]",
      "type": "@blotato/n8n-nodes-blotato.blotato",
      "onError": "continueErrorOutput",
      "maxTries": 2,
      "position": [
        240,
        240
      ],
      "parameters": {
        "options": {},
        "platform": "tiktok",
        "accountId": {
          "__rl": true,
          "mode": "list",
          "value": "199",
          "cachedResultUrl": "https://backend.blotato.com/v2/accounts/199",
          "cachedResultName": "sabrina_ramonov"
        },
        "postContentText": "={{ $('Ready to Post Image/Video').item.json.Caption }}",
        "postContentMediaUrls": "={{ $('Upload Image/Video to BLOTATO').item.json.url }}"
      },
      "credentials": {
        "blotatoApi": {
          "id": "zI14DNda55rFeyY8",
          "name": "Blotato - Brand"
        }
      },
      "retryOnFail": false,
      "typeVersion": 2,
      "waitBetweenTries": 3000
    },
    {
      "id": "ad80ba63-740a-4522-bee7-7ecd3237fe3d",
      "name": "每3小时检查一次",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -1056,
        928
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "field": "hours",
              "hoursInterval": 3
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "cf740889-604b-4494-b565-11c472b689c0",
      "name": "Linkedin [BLOTATO]",
      "type": "@blotato/n8n-nodes-blotato.blotato",
      "onError": "continueErrorOutput",
      "position": [
        240,
        400
      ],
      "parameters": {
        "options": {},
        "platform": "linkedin",
        "accountId": {
          "__rl": true,
          "mode": "list",
          "value": "4590",
          "cachedResultUrl": "https://backend.blotato.com/v2/accounts/4590",
          "cachedResultName": "Sabrina Ramonov 🍄"
        },
        "postContentText": "={{ $('Ready to Post Image/Video').item.json.Caption }}",
        "postContentMediaUrls": "={{ $('Upload Image/Video to BLOTATO').item.json.url }}"
      },
      "credentials": {
        "blotatoApi": {
          "id": "zI14DNda55rFeyY8",
          "name": "Blotato - Brand"
        }
      },
      "typeVersion": 2
    },
    {
      "id": "261a582e-fc1a-44c6-91d7-da34bfe631b2",
      "name": "Facebook [BLOTATO]",
      "type": "@blotato/n8n-nodes-blotato.blotato",
      "onError": "continueErrorOutput",
      "position": [
        240,
        560
      ],
      "parameters": {
        "options": {},
        "platform": "facebook",
        "accountId": {
          "__rl": true,
          "mode": "list",
          "value": "369",
          "cachedResultUrl": "https://backend.blotato.com/v2/accounts/369",
          "cachedResultName": "Sabrina Ramonov"
        },
        "facebookPageId": {
          "__rl": true,
          "mode": "list",
          "value": "161711670360847",
          "cachedResultUrl": "https://backend.blotato.com/v2/accounts/369/subaccounts/161711670360847",
          "cachedResultName": "Blotato"
        },
        "postContentText": "={{ $('Ready to Post Image/Video').item.json.Caption }}",
        "postContentMediaUrls": "={{ $('Upload Image/Video to BLOTATO').item.json.url }}"
      },
      "credentials": {
        "blotatoApi": {
          "id": "zI14DNda55rFeyY8",
          "name": "Blotato - Brand"
        }
      },
      "typeVersion": 2
    },
    {
      "id": "b721aba5-845d-44b7-ba80-fa8d79094a3f",
      "name": "Instagram [BLOTATO]",
      "type": "@blotato/n8n-nodes-blotato.blotato",
      "onError": "continueErrorOutput",
      "maxTries": 2,
      "position": [
        240,
        720
      ],
      "parameters": {
        "options": {},
        "accountId": {
          "__rl": true,
          "mode": "list",
          "value": "28",
          "cachedResultUrl": "https://backend.blotato.com/v2/accounts/28",
          "cachedResultName": "sabrina_ramonov"
        },
        "postContentText": "={{ $('Ready to Post Image/Video').item.json.Caption }}",
        "postContentMediaUrls": "={{ $('Upload Image/Video to BLOTATO').item.json.url }}"
      },
      "credentials": {
        "blotatoApi": {
          "id": "zI14DNda55rFeyY8",
          "name": "Blotato - Brand"
        }
      },
      "retryOnFail": true,
      "typeVersion": 2,
      "waitBetweenTries": 5000
    },
    {
      "id": "2be9a129-4ed0-4a3b-9faa-4ef7cfaab7a7",
      "name": "Twitter [BLOTATO]",
      "type": "@blotato/n8n-nodes-blotato.blotato",
      "onError": "continueErrorOutput",
      "position": [
        240,
        880
      ],
      "parameters": {
        "options": {},
        "platform": "twitter",
        "accountId": {
          "__rl": true,
          "mode": "list",
          "value": "38",
          "cachedResultUrl": "https://backend.blotato.com/v2/accounts/38",
          "cachedResultName": "Sabrina_Ramonov"
        },
        "postContentText": "={{ $('Ready to Post Image/Video').item.json.Caption }}",
        "postContentMediaUrls": "={{ $('Upload Image/Video to BLOTATO').item.json.url }}"
      },
      "credentials": {
        "blotatoApi": {
          "id": "zI14DNda55rFeyY8",
          "name": "Blotato - Brand"
        }
      },
      "typeVersion": 2
    },
    {
      "id": "f6527ebf-0f51-4301-aa83-8cb0bddef948",
      "name": "Youtube [BLOTATO]",
      "type": "@blotato/n8n-nodes-blotato.blotato",
      "onError": "continueErrorOutput",
      "position": [
        240,
        1040
      ],
      "parameters": {
        "options": {},
        "platform": "youtube",
        "accountId": {
          "__rl": true,
          "mode": "list",
          "value": "111",
          "cachedResultUrl": "https://backend.blotato.com/v2/accounts/111",
          "cachedResultName": "Sabrina Ramonov 🍄"
        },
        "postContentText": "={{ $('Ready to Post Image/Video').item.json.Caption }}",
        "postContentMediaUrls": "={{ $('Upload Image/Video to BLOTATO').item.json.url }}",
        "postCreateYoutubeOptionTitle": "={{ $('Ready to Post Image/Video').item.json.Title }}"
      },
      "credentials": {
        "blotatoApi": {
          "id": "zI14DNda55rFeyY8",
          "name": "Blotato - Brand"
        }
      },
      "typeVersion": 2
    },
    {
      "id": "c6566c09-9366-4d8c-afb4-073b0013954d",
      "name": "Threads [BLOTATO]",
      "type": "@blotato/n8n-nodes-blotato.blotato",
      "onError": "continueErrorOutput",
      "position": [
        240,
        1200
      ],
      "parameters": {
        "options": {},
        "platform": "threads",
        "accountId": {
          "__rl": true,
          "mode": "list",
          "value": "3",
          "cachedResultUrl": "https://backend.blotato.com/v2/accounts/3",
          "cachedResultName": "sabrina_ramonov"
        },
        "postContentText": "={{ $('Ready to Post Image/Video').item.json.Caption }}",
        "postContentMediaUrls": "={{ $('Upload Image/Video to BLOTATO').item.json.url }}"
      },
      "credentials": {
        "blotatoApi": {
          "id": "zI14DNda55rFeyY8",
          "name": "Blotato - Brand"
        }
      },
      "typeVersion": 2
    },
    {
      "id": "668aa4c7-0058-472e-9196-a5a41eb0dd19",
      "name": "Bluesky [BLOTATO]",
      "type": "@blotato/n8n-nodes-blotato.blotato",
      "onError": "continueErrorOutput",
      "position": [
        240,
        1360
      ],
      "parameters": {
        "options": {},
        "platform": "bluesky",
        "accountId": {
          "__rl": true,
          "mode": "list",
          "value": "8",
          "cachedResultUrl": "https://backend.blotato.com/v2/accounts/8",
          "cachedResultName": "sabrinaramonov.bsky.social"
        },
        "postContentText": "={{ $('Ready to Post Image/Video').item.json.Caption }}",
        "postContentMediaUrls": "={{ $('Upload Image/Video to BLOTATO').item.json.url }}"
      },
      "credentials": {
        "blotatoApi": {
          "id": "zI14DNda55rFeyY8",
          "name": "Blotato - Brand"
        }
      },
      "typeVersion": 2
    },
    {
      "id": "dcee45da-64dc-48a2-8a41-086b441ba409",
      "name": "Pinterest [BLOTATO]",
      "type": "@blotato/n8n-nodes-blotato.blotato",
      "onError": "continueErrorOutput",
      "position": [
        240,
        1520
      ],
      "parameters": {
        "options": {},
        "platform": "pinterest",
        "accountId": {
          "__rl": true,
          "mode": "list",
          "value": "358",
          "cachedResultUrl": "https://backend.blotato.com/v2/accounts/358",
          "cachedResultName": "sabrina_ramonov"
        },
        "postContentText": "={{ $('Ready to Post Image/Video').item.json.Caption }}",
        "pinterestBoardId": {
          "__rl": true,
          "mode": "id",
          "value": "1234"
        },
        "postContentMediaUrls": "={{ $('Upload Image/Video to BLOTATO').item.json.url }}"
      },
      "credentials": {
        "blotatoApi": {
          "id": "zI14DNda55rFeyY8",
          "name": "Blotato - Brand"
        }
      },
      "typeVersion": 2
    },
    {
      "id": "eb36ef73-5b01-41ec-ae72-138647989dd5",
      "name": "更新状态为\"已发布\"",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        240,
        1744
      ],
      "parameters": {
        "columns": {
          "value": {
            "Status": "Posted",
            "Caption": "={{ $('Ready to Post Image/Video').item.json.Caption }}"
          },
          "schema": [
            {
              "id": "Title",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Title",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Media URL (google drive)",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Media URL (google drive)",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Caption",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Caption",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Status",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Status",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "Caption"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "appendOrUpdate",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1v5S7F9p2apfWRSEHvx8Q6ZX8e-d1lZ4FLlDFyc0-ZA4/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1v5S7F9p2apfWRSEHvx8Q6ZX8e-d1lZ4FLlDFyc0-ZA4",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1v5S7F9p2apfWRSEHvx8Q6ZX8e-d1lZ4FLlDFyc0-ZA4/edit?usp=drivesdk",
          "cachedResultName": "1_post_everywhere"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "LEqYeTjqcTBUQ2W2",
          "name": "Google - Brand"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "57f04d8e-8317-4921-8e74-19526f16e675",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1152,
        304
      ],
      "parameters": {
        "color": 6,
        "width": 1056,
        "height": 1232,
        "content": "# 准备发布"
      },
      "typeVersion": 1
    },
    {
      "id": "c901d211-cf71-49a7-8220-9d2ef799668b",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -880,
        1104
      ],
      "parameters": {
        "color": 2,
        "width": 224,
        "height": 112,
        "content": "# 设置 1"
      },
      "typeVersion": 1
    },
    {
      "id": "c1b490bb-7fd4-4fdb-a72b-22adb7a3871e",
      "name": "便签2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -608,
        1104
      ],
      "parameters": {
        "color": 3,
        "width": 150,
        "height": 112,
        "content": "# 请勿修改"
      },
      "typeVersion": 1
    },
    {
      "id": "438b1381-f384-4365-aaf7-c990e28df071",
      "name": "便签3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        -256
      ],
      "parameters": {
        "color": 4,
        "width": 928,
        "height": 2224,
        "content": "# 发布到所有平台"
      },
      "typeVersion": 1
    },
    {
      "id": "e49dbbe2-fff5-44d5-a878-d8ada23a5d6b",
      "name": "便签4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -416,
        1104
      ],
      "parameters": {
        "color": 2,
        "width": 272,
        "height": 304,
        "content": "# 设置 2"
      },
      "typeVersion": 1
    },
    {
      "id": "c1d94f4b-00e2-47f8-839e-81f104ecfbe9",
      "name": "便签5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1056,
        64
      ],
      "parameters": {
        "color": 7,
        "width": 608,
        "height": 1632,
        "content": "# 平台特定说明"
      },
      "typeVersion": 1
    },
    {
      "id": "5f3b1432-b8e8-49a6-8b64-cd87eb266cc4",
      "name": "便签6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        128,
        32
      ],
      "parameters": {
        "color": 2,
        "width": 320,
        "height": 176,
        "content": "# 设置 3"
      },
      "typeVersion": 1
    },
    {
      "id": "c6bd6077-6d4c-485b-84db-63386a12329c",
      "name": "便签7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        592,
        1104
      ],
      "parameters": {
        "color": 7,
        "width": 288,
        "height": 192,
        "content": "# 最终报告"
      },
      "typeVersion": 1
    },
    {
      "id": "f75a35bc-24a7-4ec8-9165-c17e230e7f34",
      "name": "最终报告",
      "type": "n8n-nodes-base.merge",
      "position": [
        672,
        720
      ],
      "parameters": {
        "numberInputs": 9
      },
      "notesInFlow": false,
      "typeVersion": 3.2
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "a3cc5077-67c4-472e-b9bb-e93b21130696",
  "connections": {
    "Tiktok [BLOTATO]": {
      "main": [
        [],
        [
          {
            "node": "Final Report",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Bluesky [BLOTATO]": {
      "main": [
        [],
        [
          {
            "node": "Final Report",
            "type": "main",
            "index": 7
          }
        ]
      ]
    },
    "Threads [BLOTATO]": {
      "main": [
        [],
        [
          {
            "node": "Final Report",
            "type": "main",
            "index": 6
          }
        ]
      ]
    },
    "Twitter [BLOTATO]": {
      "main": [
        [],
        [
          {
            "node": "Final Report",
            "type": "main",
            "index": 4
          }
        ]
      ]
    },
    "Youtube [BLOTATO]": {
      "main": [
        [],
        [
          {
            "node": "Final Report",
            "type": "main",
            "index": 5
          }
        ]
      ]
    },
    "Facebook [BLOTATO]": {
      "main": [
        [],
        [
          {
            "node": "Final Report",
            "type": "main",
            "index": 2
          }
        ]
      ]
    },
    "Linkedin [BLOTATO]": {
      "main": [
        [],
        [
          {
            "node": "Final Report",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Check Every 3 Hours": {
      "main": [
        [
          {
            "node": "Ready to Post Image/Video",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Google Drive ID": {
      "main": [
        [
          {
            "node": "Upload Image/Video to BLOTATO",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Instagram [BLOTATO]": {
      "main": [
        [],
        [
          {
            "node": "Final Report",
            "type": "main",
            "index": 3
          }
        ]
      ]
    },
    "Pinterest [BLOTATO]": {
      "main": [
        [],
        [
          {
            "node": "Final Report",
            "type": "main",
            "index": 8
          }
        ]
      ]
    },
    "Ready to Post Image/Video": {
      "main": [
        [
          {
            "node": "Get Google Drive ID",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Upload Image/Video to BLOTATO": {
      "main": [
        [
          {
            "node": "Tiktok [BLOTATO]",
            "type": "main",
            "index": 0
          },
          {
            "node": "Linkedin [BLOTATO]",
            "type": "main",
            "index": 0
          },
          {
            "node": "Facebook [BLOTATO]",
            "type": "main",
            "index": 0
          },
          {
            "node": "Instagram [BLOTATO]",
            "type": "main",
            "index": 0
          },
          {
            "node": "Twitter [BLOTATO]",
            "type": "main",
            "index": 0
          },
          {
            "node": "Youtube [BLOTATO]",
            "type": "main",
            "index": 0
          },
          {
            "node": "Threads [BLOTATO]",
            "type": "main",
            "index": 0
          },
          {
            "node": "Bluesky [BLOTATO]",
            "type": "main",
            "index": 0
          },
          {
            "node": "Pinterest [BLOTATO]",
            "type": "main",
            "index": 0
          },
          {
            "node": "Update Status to \"Posted\"",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流?

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

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

高级 - 杂项, 多模态 AI

需要付费吗?

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

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

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

作者
Sabrina Ramonov 🍄

Sabrina Ramonov 🍄

@sabrina-ramonov

- Teach 10M people AI - Sold AI startup for $10M+ - 0 to 1.3M+ followers in 1 year - Solo Founder, Blotato.com - social media API - Learn AI for free: www.sabrina.dev

外部链接
在 n8n.io 查看

分享此工作流