发布视频和图片 - Blotato
高级
这是一个AI, Marketing领域的自动化工作流，包含 30 个节点。主要使用 Set, Code, Airtable, FormTrigger, HttpRequest 等节点，结合人工智能技术实现智能自动化。 多平台社交媒体发布器，集成 Blotato、GPT-4 Mini 和 Airtable
前置要求
- •Airtable API Key
- •可能需要目标 API 的认证凭证
- •OpenAI API Key
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "8Sbrzc7Au3ZGf62p",
"meta": {
"instanceId": "bcc0fe85b176c2837affb21bb7d7397fad2549880e73dc1f7a42e76ae94fd996",
"templateCredsSetupCompleted": true
},
"name": "发布视频和图片 - Blotato",
"tags": [
{
"id": "3ys8SQgNTiRr899i",
"name": "social media",
"createdAt": "2025-03-17T08:37:35.227Z",
"updatedAt": "2025-04-07T06:13:46.923Z"
},
{
"id": "zyM31CVcOgUrUm2P",
"name": "blotato",
"createdAt": "2025-04-25T13:38:49.620Z",
"updatedAt": "2025-04-25T13:38:49.620Z"
},
{
"id": "2wv2YbZIQoYNx98Y",
"name": "schedule",
"createdAt": "2025-04-25T13:38:53.789Z",
"updatedAt": "2025-04-25T13:38:53.789Z"
},
{
"id": "PqlvV87F8bOW0yAK",
"name": "publish",
"createdAt": "2025-04-25T13:38:58.944Z",
"updatedAt": "2025-04-25T13:38:58.944Z"
}
],
"nodes": [
{
"id": "53b36edb-e273-4e68-8ae9-7d3de3f7533f",
"name": "[Instagram] 通过Blotato发布",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueErrorOutput",
"position": [
96,
80
],
"parameters": {
"url": "https://backend.blotato.com/v2/posts",
"method": "POST",
"options": {},
"jsonBody": "={\n \"post\": {\n \"target\": {\n \"targetType\": \"instagram\"\n },\n \"content\": {\n \"text\": {{ $('Prepare for Publish').item.json.final_text_short.toJsonString() }},\n \"platform\": \"instagram\",\n \"mediaUrls\": [\"{{ $json.url }}\"]\n },\n \"accountId\": \"{{ $('Prepare for Publish').item.json.instagram_id }}\"\n }\n}",
"sendBody": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth"
},
"credentials": {
"httpHeaderAuth": {
"id": "OEAfX6pMtcbyFBAp",
"name": "Blotato"
}
},
"typeVersion": 4.2
},
{
"id": "6fef0d35-9679-40f6-9224-cfb7c442056b",
"name": "[Facebook] 通过Blotato发布",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueErrorOutput",
"position": [
96,
480
],
"parameters": {
"url": "https://backend.blotato.com/v2/posts",
"method": "POST",
"options": {},
"jsonBody": "={\n \"post\": {\n \"target\": {\n \"targetType\": \"facebook\",\n \"pageId\": \"{{ $('Prepare for Publish').item.json.facebook_page_id }}\"\n },\n \"content\": {\n \"text\": {{ $('Prepare for Publish').item.json.final_text_long.toJsonString() }},\n \"platform\": \"facebook\",\n \"mediaUrls\": [\"{{ $json.url }}\"]\n },\n \"accountId\": \"{{ $('Prepare for Publish').item.json.facebook_id }}\"\n }\n}",
"sendBody": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth"
},
"credentials": {
"httpHeaderAuth": {
"id": "OEAfX6pMtcbyFBAp",
"name": "Blotato"
}
},
"typeVersion": 4.2
},
{
"id": "3f744ee2-988b-45a6-9d88-a718780421cf",
"name": "[Linkedin] 通过Blotato发布",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueErrorOutput",
"position": [
96,
880
],
"parameters": {
"url": "https://backend.blotato.com/v2/posts",
"method": "POST",
"options": {},
"jsonBody": "={\n \"post\": {\n \"target\": {\n \"targetType\": \"linkedin\"\n },\n \"content\": {\n \"text\": {{ $('Prepare for Publish').item.json.final_text_long.toJsonString() }},\n \"platform\": \"linkedin\",\n \"mediaUrls\": [\"{{ $json.url }}\"]\n },\n \"accountId\": \"{{ $('Prepare for Publish').item.json.linkedin_id }}\"\n }\n}",
"sendBody": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth"
},
"credentials": {
"httpHeaderAuth": {
"id": "OEAfX6pMtcbyFBAp",
"name": "Blotato"
}
},
"typeVersion": 4.2
},
{
"id": "7f0ae540-090a-4b13-a094-2ac74e1a14b3",
"name": "[Tiktok] 通过Blotato发布",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueErrorOutput",
"position": [
96,
1280
],
"parameters": {
"url": "https://backend.blotato.com/v2/posts",
"method": "POST",
"options": {},
"jsonBody": "={\n \"post\": {\n \"target\": {\n \"targetType\": \"tiktok\",\n \"isYourBrand\": false,\n \"disabledDuet\": false,\n \"privacyLevel\": \"PUBLIC_TO_EVERYONE\",\n \"isAiGenerated\": true,\n \"disabledStitch\": false,\n \"disabledComments\": false,\n \"isBrandedContent\": false\n },\n \"content\": {\n \"text\": \"{{ $('Prepare for Publish').item.json.final_text_short }}\",\n \"platform\": \"tiktok\",\n \"mediaUrls\": [\"{{ $json.url }}\"]\n },\n \"accountId\": \"{{ $('Prepare for Publish').item.json.tiktok_id }}\"\n }\n}\n",
"sendBody": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth"
},
"credentials": {
"httpHeaderAuth": {
"id": "OEAfX6pMtcbyFBAp",
"name": "Blotato"
}
},
"typeVersion": 4.2
},
{
"id": "2593a621-0d0b-42b3-97ab-bf85785fb33c",
"name": "[Pinterest] 通过Blotato发布",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueErrorOutput",
"position": [
96,
1680
],
"parameters": {
"url": "https://backend.blotato.com/v2/posts",
"method": "POST",
"options": {},
"jsonBody": "={\n \"post\": {\n \"target\": {\n \"targetType\": \"pinterest\",\n \"boardId\": \"{{ $('Prepare for Publish').item.json.pinterested_board_id }}\",\n \"link\": \"https://www.AIwithApex.com/\"\n },\n \"content\": {\n \"text\": {{ $('Prepare for Publish').item.json.final_text_short.toJsonString() }},\n \"platform\": \"pinterest\",\n \"mediaUrls\": [\"{{ $('Upload Image to Blotato').item.json.url }}\"]\n },\n \"accountId\": \"{{ $('Prepare for Publish').item.json.pinterest_id }}\"\n }\n}\n",
"sendBody": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth"
},
"credentials": {
"httpHeaderAuth": {
"id": "OEAfX6pMtcbyFBAp",
"name": "Blotato"
}
},
"typeVersion": 4.2
},
{
"id": "b47da27b-b81f-4736-9c34-cd224d78f29d",
"name": "[Youtube] 通过Blotato发布",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueErrorOutput",
"position": [
96,
280
],
"parameters": {
"url": "https://backend.blotato.com/v2/posts",
"method": "POST",
"options": {},
"jsonBody": "={\n \"post\": {\n \"target\": {\n \"targetType\": \"youtube\",\n \"title\": \"{{ $('Ensure Valid YouTube Title').item.json.message.content.youtube_title }}\",\n \"privacyStatus\": \"public\",\n \"shouldNotifySubscribers\": true\n },\n \"content\": {\n \"text\": {{ $('Prepare for Publish').item.json.final_text_long.toJsonString() }},\n \"platform\": \"youtube\",\n \"mediaUrls\": [\"{{ $json.url }}\"]\n },\n \"accountId\": \"{{ $('Prepare for Publish').item.json.youtube_id }}\"\n }\n}",
"sendBody": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth"
},
"credentials": {
"httpHeaderAuth": {
"id": "OEAfX6pMtcbyFBAp",
"name": "Blotato"
}
},
"typeVersion": 4.2
},
{
"id": "19f17323-45f5-4865-b754-e2d5f8fc6073",
"name": "[Threads] 通过Blotato发布",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueErrorOutput",
"position": [
96,
680
],
"parameters": {
"url": "https://backend.blotato.com/v2/posts",
"method": "POST",
"options": {},
"jsonBody": "={\n \"post\": {\n \"target\": {\n \"targetType\": \"threads\"\n },\n \"content\": {\n \"text\": {{ $('Prepare for Publish').item.json.final_text_short.toJsonString() }},\n \"platform\": \"threads\",\n \"mediaUrls\": [\"{{ $json.url }}\"]\n },\n \"accountId\": \"{{ $('Prepare for Publish').item.json.threads_id }}\"\n }\n}\n",
"sendBody": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth"
},
"credentials": {
"httpHeaderAuth": {
"id": "OEAfX6pMtcbyFBAp",
"name": "Blotato"
}
},
"typeVersion": 4.2
},
{
"id": "adaa3ac1-fa2a-422e-8b70-8c4cc74782ed",
"name": "[Twitter] 通过Blotato发布",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueErrorOutput",
"position": [
96,
1080
],
"parameters": {
"url": "https://backend.blotato.com/v2/posts",
"method": "POST",
"options": {},
"jsonBody": "={\n \"post\": {\n \"target\": {\n \"targetType\": \"twitter\"\n },\n \"content\": {\n \"text\": {{ $('Prepare for Publish').item.json.final_text_short.toJsonString() }},\n \"platform\": \"twitter\",\n \"mediaUrls\": [\"{{ $json.url }}\"]\n },\n \"accountId\": \"{{ $('Prepare for Publish').item.json.twitter_id }}\"\n }\n}\n",
"sendBody": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth"
},
"credentials": {
"httpHeaderAuth": {
"id": "OEAfX6pMtcbyFBAp",
"name": "Blotato"
}
},
"typeVersion": 4.2
},
{
"id": "af2d0a29-73d1-4ee0-84c9-f337a628b3ea",
"name": "[Bluesky] 通过Blotato发布",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueErrorOutput",
"position": [
96,
1480
],
"parameters": {
"url": "https://backend.blotato.com/v2/posts",
"method": "POST",
"options": {},
"jsonBody": "={\n \"post\": {\n \"target\": {\n \"targetType\": \"bluesky\"\n },\n \"content\": {\n \"text\": {{ $('Prepare for Publish').item.json.final_text_short.toJsonString() }},\n \"platform\": \"bluesky\",\n \"mediaUrls\": [\"{{ $('Upload Image to Blotato').item.json.url }}\"]\n },\n \"accountId\": \"{{ $('Prepare for Publish').item.json.bluesky_id }}\"\n }\n}\n",
"sendBody": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth"
},
"credentials": {
"httpHeaderAuth": {
"id": "OEAfX6pMtcbyFBAp",
"name": "Blotato"
}
},
"typeVersion": 4.2
},
{
"id": "08253c79-44f6-471a-b7c9-b84046f16888",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
16,
-40
],
"parameters": {
"color": 2,
"width": 260,
"height": 1880,
"content": "# 发布到社交媒体"
},
"typeVersion": 1
},
{
"id": "dae9e738-c391-47f6-bdf7-87055a5a77f0",
"name": "准备发布",
"type": "n8n-nodes-base.set",
"position": [
-564,
880
],
"parameters": {
"mode": "raw",
"options": {},
"jsonOutput": "={\n \"instagram_id\": \"2244\",\n \"youtube_id\": \"1300\",\n \"tiktok_id\": \"2761\",\n \"facebook_id\": \"2152\",\n \"facebook_page_id\": \"127923797405586\",\n \"threads_id\": \"670\",\n \"twitter_id\": \"1576\",\n \"linkedin_id\": \"1730\",\n \"pinterest_id\": \"447\",\n \"pinterested_board_id\": \"1097611809123639891\",\n \"bluesky_id\": \"1311\",\n \"final_text_long\": {{ $('Airtable').item.json.Script.toJsonString() }},\n \"final_text_short\": {{ $('Airtable').item.json['Text for X'].toJsonString() }}\n}"
},
"typeVersion": 3.4
},
{
"id": "aaa21d7f-e175-4516-8bde-e0b87e6e183d",
"name": "Airtable",
"type": "n8n-nodes-base.airtable",
"position": [
-1160,
880
],
"parameters": {
"id": "={{ $json.airtableID }}",
"base": {
"__rl": true,
"mode": "list",
"value": "appt2yDl6xXXyqboD",
"cachedResultUrl": "https://airtable.com/appt2yDl6xXXyqboD",
"cachedResultName": "Social Media System"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tblM3kDu1qB2FdTOF",
"cachedResultUrl": "https://airtable.com/appt2yDl6xXXyqboD/tblM3kDu1qB2FdTOF",
"cachedResultName": "Media Creation"
},
"options": {}
},
"credentials": {
"airtableTokenApi": {
"id": "YzrajURFsZkojT3x",
"name": "Delete Me Later Please!"
}
},
"typeVersion": 2.1
},
{
"id": "e05d1ede-7d43-4c55-a353-6bc2bd0216d4",
"name": "上传视频到 Blotato",
"type": "n8n-nodes-base.httpRequest",
"position": [
-124,
880
],
"parameters": {
"url": "https://backend.blotato.com/v2/media",
"method": "POST",
"options": {},
"sendBody": true,
"authentication": "genericCredentialType",
"bodyParameters": {
"parameters": [
{
"name": "url",
"value": "={{ $('Airtable').item.json['Video URL'] }}"
}
]
},
"genericAuthType": "httpHeaderAuth"
},
"credentials": {
"httpHeaderAuth": {
"id": "gNaQW1qT8liDV4ls",
"name": "Delete me toooooo!"
}
},
"typeVersion": 4.2
},
{
"id": "92fd39a9-74c1-4cbb-abb3-511f8230cee7",
"name": "上传图片到 Blotato",
"type": "n8n-nodes-base.httpRequest",
"position": [
-344,
880
],
"parameters": {
"url": "https://backend.blotato.com/v2/media",
"method": "POST",
"options": {},
"sendBody": true,
"authentication": "genericCredentialType",
"bodyParameters": {
"parameters": [
{
"name": "url",
"value": "={{ $('Airtable').item.json['Image URL'] }}"
}
]
},
"genericAuthType": "httpHeaderAuth"
},
"credentials": {
"httpHeaderAuth": {
"id": "gNaQW1qT8liDV4ls",
"name": "Delete me toooooo!"
}
},
"typeVersion": 4.2
},
{
"id": "12b8ecfe-f83b-4e32-a8d7-a71b7f5c9fd1",
"name": "确保有效的 YouTube 标题",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
-940,
880
],
"parameters": {
"modelId": {
"__rl": true,
"mode": "list",
"value": "gpt-4.1-mini",
"cachedResultName": "GPT-4.1-MINI"
},
"options": {},
"messages": {
"values": [
{
"content": "=CURRENT_TITLE:\n{{ $json['Media Title'] }}"
},
{
"role": "assistant",
"content": "# TASK\nYou specialize in creating Viral YouTube Short Video Titles. You are to take User's CURRENT_TITLE and re-write it to go viral.\n## Rules\n - Maximum 100 Characters\n - Goal is Virality!\n - Must be valid title for a YouTube Short Video\n# OUTPUT\nOutput must be in JSON format, example:\n{ \"youtube_title\": \"<generated title per instructions>\" }"
}
]
},
"jsonOutput": true
},
"credentials": {
"openAiApi": {
"id": "KzjXYSuzUOCnnvzB",
"name": "OpenAi account"
}
},
"typeVersion": 1.8
},
{
"id": "d83577ae-5aa7-4d47-a67b-30e30fcd2fa4",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1660,
1060
],
"parameters": {
"width": 880,
"height": 360,
"content": "## 快速调试检查"
},
"typeVersion": 1
},
{
"id": "356518e3-1eb6-4cfe-bf77-a5f095553b74",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-880,
1440
],
"parameters": {
"width": 880,
"height": 300,
"content": "## 当前问题（最后更新于2025年4月29日）"
},
"typeVersion": 1
},
{
"id": "503a04c9-a740-4c5d-9f67-143a8dd1422f",
"name": "Airtable：已发布 Instagram",
"type": "n8n-nodes-base.airtable",
"position": [
316,
-20
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "appt2yDl6xXXyqboD",
"cachedResultUrl": "https://airtable.com/appt2yDl6xXXyqboD",
"cachedResultName": "Social Media System"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tblM3kDu1qB2FdTOF",
"cachedResultUrl": "https://airtable.com/appt2yDl6xXXyqboD/tblM3kDu1qB2FdTOF",
"cachedResultName": "Media Creation"
},
"columns": {
"value": {
"id": "={{ $('Airtable').item.json.id",
"Production": "Completed"
},
"schema": [
{
"id": "id",
"type": "string",
"display": true,
"removed": false,
"readOnly": true,
"required": false,
"displayName": "id",
"defaultMatch": true
},
{
"id": "Media Title",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Media Title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Script",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Script",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Script Len",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "Script Len",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Production",
"type": "options",
"display": true,
"options": [
{
"name": "Not Started",
"value": "Not Started"
},
{
"name": "In progress",
"value": "In progress"
},
{
"name": "Ready",
"value": "Ready"
},
{
"name": "Review",
"value": "Review"
},
{
"name": "Completed",
"value": "Completed"
},
{
"name": "Scheduled",
"value": "Scheduled"
},
{
"name": "Published",
"value": "Published"
}
],
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Production",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Video URL",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Video URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Video",
"type": "array",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Video",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Publish Date (from Content Creation)",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "Publish Date (from Content Creation)",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Publish Time (from Content Creation)",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "Publish Time (from Content Creation)",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Test",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "Test",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Content Creation",
"type": "array",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Content Creation",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Scenes",
"type": "array",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Scenes",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Image URL",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Image URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Image",
"type": "array",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Image",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Image Caption",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Image Caption",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Text for X",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Text for X",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Text for LinkedIn",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Text for LinkedIn",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Social Channels",
"type": "array",
"display": true,
"options": [
{
"name": "Blog",
"value": "Blog"
},
{
"name": "Facebook",
"value": "Facebook"
},
{
"name": "Instagram",
"value": "Instagram"
},
{
"name": "LinkedIn",
"value": "LinkedIn"
},
{
"name": "TikTok",
"value": "TikTok"
},
{
"name": "X",
"value": "X"
},
{
"name": "YouTube",
"value": "YouTube"
}
],
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Social Channels",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "n8n Publishing Date",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "n8n Publishing Date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "n8n Publishing Time",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "n8n Publishing Time",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Publishing Log",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Publishing Log",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "House Keeping",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "House Keeping",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "workflowId (from House Keeping)",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "workflowId (from House Keeping)",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "recordID (from House Keeping)",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "recordID (from House Keeping)",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Created Time",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "Created Time",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Modified Time",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "Modified Time",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Record ID",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "Record ID",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update"
},
"credentials": {
"airtableTokenApi": {
"id": "YzrajURFsZkojT3x",
"name": "Delete Me Later Please!"
}
},
"typeVersion": 2.1
},
{
"id": "f42a3763-8906-4278-b8d0-73611a1fae31",
"name": "Airtable：已发布 Instagram1",
"type": "n8n-nodes-base.airtable",
"position": [
316,
180
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "appt2yDl6xXXyqboD",
"cachedResultUrl": "https://airtable.com/appt2yDl6xXXyqboD",
"cachedResultName": "Social Media System"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tblM3kDu1qB2FdTOF",
"cachedResultUrl": "https://airtable.com/appt2yDl6xXXyqboD/tblM3kDu1qB2FdTOF",
"cachedResultName": "Media Creation"
},
"columns": {
"value": {
"id": "={{ $('Airtable').item.json.id",
"Production": "In progress"
},
"schema": [
{
"id": "id",
"type": "string",
"display": true,
"removed": false,
"readOnly": true,
"required": false,
"displayName": "id",
"defaultMatch": true
},
{
"id": "Media Title",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Media Title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Script",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Script",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Script Len",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "Script Len",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Production",
"type": "options",
"display": true,
"options": [
{
"name": "Not Started",
"value": "Not Started"
},
{
"name": "In progress",
"value": "In progress"
},
{
"name": "Ready",
"value": "Ready"
},
{
"name": "Review",
"value": "Review"
},
{
"name": "Completed",
"value": "Completed"
},
{
"name": "Scheduled",
"value": "Scheduled"
},
{
"name": "Published",
"value": "Published"
}
],
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Production",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Video URL",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Video URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Video",
"type": "array",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Video",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Publish Date (from Content Creation)",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "Publish Date (from Content Creation)",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Publish Time (from Content Creation)",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "Publish Time (from Content Creation)",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Test",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "Test",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Content Creation",
"type": "array",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Content Creation",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Scenes",
"type": "array",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Scenes",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Image URL",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Image URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Image",
"type": "array",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Image",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Image Caption",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Image Caption",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Text for X",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Text for X",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Text for LinkedIn",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Text for LinkedIn",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Social Channels",
"type": "array",
"display": true,
"options": [
{
"name": "Blog",
"value": "Blog"
},
{
"name": "Facebook",
"value": "Facebook"
},
{
"name": "Instagram",
"value": "Instagram"
},
{
"name": "LinkedIn",
"value": "LinkedIn"
},
{
"name": "TikTok",
"value": "TikTok"
},
{
"name": "X",
"value": "X"
},
{
"name": "YouTube",
"value": "YouTube"
}
],
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Social Channels",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "n8n Publishing Date",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "n8n Publishing Date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "n8n Publishing Time",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "n8n Publishing Time",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Publishing Log",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Publishing Log",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "House Keeping",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "House Keeping",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "workflowId (from House Keeping)",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "workflowId (from House Keeping)",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "recordID (from House Keeping)",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "recordID (from House Keeping)",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Created Time",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "Created Time",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Modified Time",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "Modified Time",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Record ID",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "Record ID",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update"
},
"credentials": {
"airtableTokenApi": {
"id": "YzrajURFsZkojT3x",
"name": "Delete Me Later Please!"
}
},
"typeVersion": 2.1
},
{
"id": "e6d9834b-a03e-4e98-9e38-a774eec2bc93",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
291,
-300
],
"parameters": {
"color": 2,
"width": 150,
"height": 640,
"content": "# 更新发布状态"
},
"typeVersion": 1
},
{
"id": "fed0373f-7fa5-469c-9972-47d0a9a447a7",
"name": "当点击\"测试工作流\"时",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-1600,
880
],
"parameters": {},
"typeVersion": 1
},
{
"id": "c68f2436-f471-45a6-9292-2410937bd444",
"name": "Airtable 记录 ID",
"type": "n8n-nodes-base.set",
"position": [
-1380,
880
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "ca998655-fcdd-4169-b470-492cf5113b6a",
"name": "=airtableID",
"type": "string",
"value": "=recJBpGmgd7nuLpfe"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "7617f48c-f498-4458-a64c-3fb60938546e",
"name": "便签说明4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-972,
780
],
"parameters": {
"color": 5,
"width": 320,
"height": 260,
"content": "### 可能不需要"
},
"typeVersion": 1
},
{
"id": "054bc64d-3a3c-4ba4-9bcc-e30729bb9c87",
"name": "便签说明5",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2260,
300
],
"parameters": {
"width": 580,
"height": 1880,
"content": "# 如何添加示例表并连接 n8n 到 Airtable"
},
"typeVersion": 1
},
{
"id": "f10bfe19-511e-4211-9d53-b72130bcf0ec",
"name": "便签 6",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1660,
300
],
"parameters": {
"width": 1300,
"height": 100,
"content": "# Blotato 联盟链接，请支持我的工作：https://blotato.com/?ref=max"
},
"typeVersion": 1
},
{
"id": "825d529c-813c-42d3-b100-0dba4a84d7fe",
"name": "便签 7",
"type": "n8n-nodes-base.stickyNote",
"position": [
-644,
420
],
"parameters": {
"color": 5,
"width": 260,
"height": 620,
"content": "## 请填写我！"
},
"typeVersion": 1
},
{
"id": "b27f7a30-aa19-4d0f-a7a0-7e5d5c0a1a2d",
"name": "Pinterest 系统（tm）",
"type": "n8n-nodes-base.formTrigger",
"position": [
-1600,
1940
],
"webhookId": "0724d1b9-05f6-46c2-9b74-e89fd44cbef3",
"parameters": {
"options": {},
"formTitle": "Pinterest System (tm)",
"formFields": {
"values": [
{
"fieldLabel": "Pinterest Board URL",
"placeholder": "https://www.pinterest.com/USERNAME/BOARD_NAME/",
"requiredField": true
}
]
},
"formDescription": "Put in your Pinterest Board Link here, it should look like this:\n\nhttps://www.pinterest.com/USERNAME/BOARD_NAME/\n\nExample:\nhttps://www.pinterest.com/aiwithapex/artificial-intelligence-ai-ai-automation/"
},
"typeVersion": 2.2
},
{
"id": "3a5976ba-fb7d-4e33-a0bd-efbbf212031b",
"name": "获取 Pinterest 看板页面",
"type": "n8n-nodes-base.httpRequest",
"position": [
-1380,
1940
],
"parameters": {
"url": "={{ $json['Pinterest Board URL'] }}",
"options": {},
"jsonHeaders": "{\n \"User-Agent\": \"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/115.0.0.0 Safari/537.36\",\n \"Accept\": \"text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8\",\n \"Accept-Language\": \"en-US,en;q=0.9\",\n \"Accept-Encoding\": \"gzip, deflate, br\",\n \"Connection\": \"keep-alive\",\n \"Referer\": \"https://www.pinterest.com/\"\n}",
"sendHeaders": true,
"specifyHeaders": "json"
},
"typeVersion": 4.2
},
{
"id": "659bb65c-7aaf-4aa4-958b-0f8e5bafaf7e",
"name": "Pinterest 页面侦探",
"type": "n8n-nodes-base.code",
"position": [
-1160,
1940
],
"parameters": {
"jsCode": "// n8n Code Node JavaScript\n\n// Get the first item OBJECT using $input.first() or $items[0]\n// Let's use $input.first() as it's slightly more modern n8n syntax\nconst item = $input.first();\n\n// Check if an item was actually received\nif (!item) {\n console.error(\"No input item received.\");\n // Return an empty array as expected by n8n if no input\n return [];\n}\n\n// Check if the 'json' property exists on the item object\n// (This check might be redundant if the previous node always outputs JSON, but good practice)\nif (!item.json || typeof item.json !== 'object') {\n console.error(\"Input item does not have a 'json' object property.\");\n // Ensure item.json exists before adding error to it\n item.json = item.json || {};\n item.json.error = \"Input item does not have a 'json' object property.\";\n // Return the item INSIDE an array\n return [item];\n}\n\n// Check if 'data' exists within 'json'\n// <<< VERIFY this path 'item.json.data' using the INPUT panel in n8n editor >>>\nif (!item.json.hasOwnProperty('data')) {\n console.error(\"Input item's 'json' property does not have a 'data' key.\");\n item.json.error = \"Input item's 'json' property does not have a 'data' key.\";\n // Return the item INSIDE an array\n return [item];\n}\n\n// Assign the HTML string (adjust path if needed based on INPUT panel)\nconst htmlString = item.json.data;\n\n// Check if HTML string exists and is a string type\nif (typeof htmlString !== 'string') {\n console.error(\"item.json.data is not a string.\");\n item.json.error = \"item.json.data exists but is not a string.\";\n // Return the item INSIDE an array\n return [item];\n}\n\n// Check if HTML string is empty\nif (!htmlString) {\n console.error(\"item.json.data is an empty string or null/undefined.\");\n item.json.error = \"item.json.data is empty or null.\";\n // Return the item INSIDE an array\n return [item];\n}\n// </ END OF INPUT CHECKING >\n\nlet extractedBoardInfo = {};\nlet processingError = null; // Renamed to avoid conflict with built-in 'error'\n\ntry {\n // 1. Find the JSON within the specific script tag using regex\n const regex = /<script id=\"__PWS_INITIAL_PROPS__\" type=\"application\\/json\">(.*?)<\\/script>/s;\n const match = htmlString.match(regex);\n\n if (match && match[1]) {\n const jsonString = match[1];\n // 2. Parse the extracted JSON string\n const parsedData = JSON.parse(jsonString);\n\n // 3. Navigate through the nested structure\n const boardsData = parsedData?.initialReduxState?.boards;\n\n if (boardsData && typeof boardsData === 'object' && Object.keys(boardsData).length > 0) {\n const boardId = Object.keys(boardsData)[0];\n const boardDetails = boardsData[boardId];\n\n if (boardDetails && boardDetails.id) {\n // 4. Extract the desired information\n extractedBoardInfo = {\n boardId: boardDetails.id,\n name: boardDetails.name || null,\n description: boardDetails.description || null,\n url: boardDetails.url || null,\n privacy: boardDetails.privacy || null,\n pinCount: boardDetails.pin_count !== undefined ? boardDetails.pin_count : null,\n followerCount: boardDetails.follower_count !== undefined ? boardDetails.follower_count : null,\n createdAt: boardDetails.created_at || null,\n ownerUsername: boardDetails.owner?.username || null,\n ownerId: boardDetails.owner?.id || null,\n ownerFullName: boardDetails.owner?.full_name || null,\n };\n } else {\n processingError = \"Board data structure invalid within __PWS_INITIAL_PROPS__ JSON.\";\n console.error(processingError);\n }\n } else {\n processingError = \"Boards data not found or empty in __PWS_INITIAL_PROPS__ JSON.\";\n console.error(processingError);\n }\n } else {\n processingError = \"Script tag with id='__PWS_INITIAL_PROPS__' not found or empty in HTML.\";\n console.error(processingError);\n }\n} catch (e) {\n processingError = `Error processing HTML/JSON: ${e.message}`;\n console.error(processingError, e);\n}\n\n// 5. Prepare the final item\nif (Object.keys(extractedBoardInfo).length > 0) {\n item.json.extractedBoardInfo = extractedBoardInfo;\n // Optionally delete the large HTML string if no longer needed\n // delete item.json.data;\n} else {\n // Add error information if extraction failed\n item.json.error = processingError || \"Failed to extract board information for unknown reasons.\";\n item.json.extractedBoardInfo = null;\n}\n\n// Return the modified item INSIDE an array as required by n8n\nreturn [item];"
},
"typeVersion": 2
},
{
"id": "09f00540-3fde-45a8-a20b-7415e81aa777",
"name": "## 为什么选择 4o 模型？👆",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1660,
1800
],
"parameters": {
"color": 4,
"width": 660,
"height": 300,
"content": "# Pinterest 页面侦探"
},
"typeVersion": 1
}
],
"active": true,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "4b3ebaa1-ec81-4de8-9366-633594a1b0ca",
"connections": {
"Airtable": {
"main": [
[
{
"node": "Ensure Valid YouTube Title",
"type": "main",
"index": 0
}
]
]
},
"Airtable Record ID": {
"main": [
[
{
"node": "Airtable",
"type": "main",
"index": 0
}
]
]
},
"Prepare for Publish": {
"main": [
[
{
"node": "Upload Image to Blotato",
"type": "main",
"index": 0
}
]
]
},
"Pinterest System (tm)": {
"main": [
[
{
"node": "Grab Pinterest Board Page",
"type": "main",
"index": 0
}
]
]
},
"Upload Image to Blotato": {
"main": [
[
{
"node": "Upload Video to Blotato",
"type": "main",
"index": 0
}
]
]
},
"Upload Video to Blotato": {
"main": [
[
{
"node": "[Instagram] Publish via Blotato",
"type": "main",
"index": 0
},
{
"node": "[Facebook] Publish via Blotato",
"type": "main",
"index": 0
},
{
"node": "[Linkedin] Publish via Blotato",
"type": "main",
"index": 0
},
{
"node": "[Tiktok] Publish via Blotato",
"type": "main",
"index": 0
},
{
"node": "[Youtube] Publish via Blotato",
"type": "main",
"index": 0
},
{
"node": "[Threads] Publish via Blotato",
"type": "main",
"index": 0
},
{
"node": "[Twitter] Publish via Blotato",
"type": "main",
"index": 0
},
{
"node": "[Bluesky] Publish via Blotato",
"type": "main",
"index": 0
},
{
"node": "[Pinterest] Publish via Blotato",
"type": "main",
"index": 0
}
]
]
},
"Grab Pinterest Board Page": {
"main": [
[
{
"node": "Pinterest Page Sleuth",
"type": "main",
"index": 0
}
]
]
},
"Ensure Valid YouTube Title": {
"main": [
[
{
"node": "Prepare for Publish",
"type": "main",
"index": 0
}
]
]
},
"[Instagram] Publish via Blotato": {
"main": [
[
{
"node": "Airtable: Posted Instagram",
"type": "main",
"index": 0
}
],
[
{
"node": "Airtable: Posted Instagram1",
"type": "main",
"index": 0
}
]
]
},
"When clicking ‘Test workflow’": {
"main": [
[
{
"node": "Airtable Record ID",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 人工智能, 营销
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
WordPress 内容生成器 v3
WordPress 内容生成器 v3
If
Set
Code
+21
102 节点Alex Kim
人工智能
WordPress终极内容生成器 v2 - AlexK1919
WordPress终极内容生成器
If
Set
Code
+17
61 节点Alex Kim
人工智能
使用 AI 创建 LinkedIn 贡献并在 Slack 上通知用户
使用 AI 创建 LinkedIn 贡献并在 Slack 上通知用户
Set
Code
Html
+11
33 节点Darryn
人工智能
发布视频和图片 - 新 Blotato 节点
使用 Blotato 和 Airtable 自动发布内容到 9 个社交平台
Set
Code
Wait
+8
51 节点Max aka Mosheh
社交媒体
AI新闻简报构建器：使用Dumpling AI抓取网站，GPT-4o摘要
AI新闻简报构建器：Dumpling AI抓取网站，GPT-4o摘要
Set
Code
Gmail
+6
10 节点Yang
人工智能
基于AI的YouTube元数据生成器（GPT-4o、Gemini与内容增强）
基于AI的YouTube元数据生成器（GPT-4o、Gemini与内容增强）
Set
Xml
Code
+12
37 节点Amjid Ali
人工智能
工作流信息
难度等级
高级
节点数量30
分类2
节点类型8
作者
Max aka Mosheh
@aiwithapexMax is an IBM-certified AI developer with a BS in Computer Science and 20+ years in software, AI consulting, and leadership. He founded several modest ventures and serves as Board President of RedeemTheOppressed.org. Married with five children, he’s raised over $3.5M for persecuted minorities. Ventures: Motivate-Mate.com | | MusicWithMax.com | VoiceAIBonanza.com | ApexWebServices.com | HeimishGiving.org | ForAfricanJews.org | AI Automation community - https://community.stan.store/apexwebservices
外部链接
在 n8n.io 查看 →
分享此工作流