8
n8n 中文网amn8n.com

带 AI 字幕的自动美食照片分享 – Pinterest 调度器

中级

这是一个Social Media, Multimodal AI领域的自动化工作流，包含 13 个节点。主要使用 If, OpenAi, HttpRequest, GoogleSheets, ScheduleTrigger 等节点。 使用 GPT-3.5 字幕和 Google Sheets 安排美食照片分享到 Pinterest

前置要求
  • •OpenAI API Key
  • •可能需要目标 API 的认证凭证
  • •Google Sheets API 凭证

使用的节点 (13)

If
OpenAi
StickyNote
HttpRequest
GoogleSheets
ScheduleTrigger

分类

社交媒体
多模态 AI
工作流预览
可视化展示节点连接关系，支持缩放和平移
React Flow
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
  "id": "AhLdSHGzYENHBtdk",
  "meta": {
    "instanceId": "dd69efaf8212c74ad206700d104739d3329588a6f3f8381a46a481f34c9cc281",
    "templateCredsSetupCompleted": true
  },
  "name": "带 AI 字幕的自动美食照片分享 – Pinterest 调度器",
  "tags": [],
  "nodes": [
    {
      "id": "adea325f-884b-4fc9-9582-74c97e9c3473",
      "name": "每日帖子调度器",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        0,
        0
      ],
      "parameters": {
        "rule": {
          "interval": [
            {}
          ]
        }
      },
      "typeVersion": 1
    },
    {
      "id": "1866b165-64c4-45ce-b9a5-e19e810272c4",
      "name": "从表格获取美食照片",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        220,
        0
      ],
      "parameters": {
        "resource": "spreadsheet",
        "operation": "get"
      },
      "credentials": {
        "googleApi": {
          "id": "ScSS2KxGQULuPtdy",
          "name": "Google Sheets- test"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "522fc6bc-88a1-4c52-a16e-7a72c9ce8b62",
      "name": "过滤 4 星以上菜品",
      "type": "n8n-nodes-base.if",
      "position": [
        440,
        0
      ],
      "parameters": {
        "conditions": {
          "string": [
            {
              "value1": "{{$node['Google Sheets'].json['Status']}}",
              "value2": "Pending"
            },
            {
              "value1": "{{$node['Google Sheets'].json['Rating']}}",
              "value2": 4,
              "operation": "largerEqual"
            }
          ]
        }
      },
      "typeVersion": 1
    },
    {
      "id": "0818f0bb-a769-4e64-a951-106dcd3b12c6",
      "name": "AI 字幕生成器",
      "type": "n8n-nodes-base.openAi",
      "position": [
        660,
        0
      ],
      "parameters": {
        "model": "gpt-3.5-turbo",
        "prompt": "Generate a concise, engaging Pinterest caption for a food photo based on this customer feedback: '{{$node['Google Sheets'].json['Feedback']}}'. Keep it under 100 characters and include a positive tone.",
        "options": {},
        "requestOptions": {}
      },
      "credentials": {
        "openAiApi": {
          "id": "CDQ16eImh6D4tY15",
          "name": "OpenAi account 2"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "1e7a31cd-e6be-48f1-aad1-6af1c56ccbab",
      "name": "上传到 Pinterest",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        880,
        0
      ],
      "parameters": {
        "url": "https://api.pinterest.com/v5/pins",
        "options": {},
        "requestMethod": "POST",
        "authentication": "headerAuth",
        "jsonParameters": true,
        "bodyParametersJson": "{\"title\":\"{{$node['Google Sheets'].json['Pin Title']}}\",\"description\":\"{{$node['Generate Caption'].json['text']}}\",\"link\":\"{{$node['Google Sheets'].json['Destination URL']}}\",\"board_id\":\"{{$node['Google Sheets'].json['Board ID']}}\",\"media_source\":{\"source_type\":\"image_url\",\"url\":\"{{$node['Google Sheets'].json['Image URL']}}\"}}"
      },
      "credentials": {
        "httpHeaderAuth": {
          "id": null,
          "name": "Pinterest API Token"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "cc06c3aa-e57a-4b01-9614-e2f5a4876dcf",
      "name": "在表格中标记为已发布",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1100,
        0
      ],
      "parameters": {
        "resource": "spreadsheet",
        "operation": "update"
      },
      "credentials": {
        "googleApi": {
          "id": "ScSS2KxGQULuPtdy",
          "name": "Google Sheets- test"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "62bec8d6-0535-425c-8151-af312a20e98e",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -40,
        -260
      ],
      "parameters": {
        "color": 6,
        "width": 180,
        "height": 420,
        "content": "在预定时间（例如，每天一次）触发工作流程，检查是否有新的美食照片需要发布。"
      },
      "typeVersion": 1
    },
    {
      "id": "007ca09a-8d6a-4fa3-b02b-a066cc9a8999",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        400,
        -260
      ],
      "parameters": {
        "color": 3,
        "width": 180,
        "height": 420,
        "content": "仅过滤那些评分高（4 星及以上）且未发布状态的美食条目。"
      },
      "typeVersion": 1
    },
    {
      "id": "107ef438-5954-4230-af66-b12ebaac449f",
      "name": "便签2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        620,
        -260
      ],
      "parameters": {
        "width": 180,
        "height": 420,
        "content": "使用 AI（例如 GPT/OpenAI）为选定的美食照片创建吸引人且相关的字幕。"
      },
      "typeVersion": 1
    },
    {
      "id": "2990e8da-40e2-47aa-959a-b1c70741aec4",
      "name": "便签3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        840,
        -260
      ],
      "parameters": {
        "color": 5,
        "width": 180,
        "height": 420,
        "content": "通过 API 自动将带有生成字幕的美食照片发布到 Pinterest。"
      },
      "typeVersion": 1
    },
    {
      "id": "14b92980-38cc-47bf-8e03-f1d530f276b3",
      "name": "便签4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1060,
        -260
      ],
      "parameters": {
        "color": 3,
        "width": 180,
        "height": 420,
        "content": "更新 Google 表格以反映照片已成功分享。"
      },
      "typeVersion": 1
    },
    {
      "id": "4997f1e2-a34f-4aa3-8580-a63042f4aac9",
      "name": "便签5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        180,
        -260
      ],
      "parameters": {
        "color": 4,
        "width": 180,
        "height": 420,
        "content": "从 Google 表格中检索包含美食照片和元数据（如评分和状态）的行。"
      },
      "typeVersion": 1
    },
    {
      "id": "ba50326f-70f6-4af4-a213-34752536cd40",
      "name": "### 需要帮助？",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        160,
        -520
      ],
      "parameters": {
        "width": 720,
        "height": 140,
        "content": "## 目的：自动将高评分的美食照片从电子表格分享到 Pinterest，并带有 AI 生成的字幕，并将其标记为已发布。"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "71cb591a-be5f-4ed4-adaf-a5df321d922c",
  "connections": {
    "Upload to Pinterest": {
      "main": [
        [
          {
            "node": "Mark as Posted in Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "AI Caption Generator": {
      "main": [
        [
          {
            "node": "Upload to Pinterest",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Daily Post Scheduler": {
      "main": [
        [
          {
            "node": "Fetch Food Photos from Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter 4+ Star Dishes": {
      "main": [
        [
          {
            "node": "AI Caption Generator",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fetch Food Photos from Sheet": {
      "main": [
        [
          {
            "node": "Filter 4+ Star Dishes",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流？

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

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

中级 - 社交媒体, 多模态 AI

需要付费吗？

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

相关工作流推荐

通过WhatsApp、邮件和Twilio SMS发送的食品菜单更新通知器
食品菜单更新通知器
If
Set
Code
+7
22 节点Oneclick AI Squad
社交媒体
AI驱动的Instagram评论自动回复
使用OpenAI和Redis跟踪自动化Instagram评论回复
If
Code
Merge
+6
27 节点Oneclick AI Squad
社交媒体
带跟进与回复追踪的自动邮件群发
带跟进与回复追踪的自动邮件群发
If
Gmail
Switch
+5
11 节点Oneclick AI Squad
社交媒体
Instagram恶意评论审核与自动防御工作流
使用Perspective API和Slack提醒自动审核Instagram评论
If
Set
Cron
+6
15 节点Oneclick AI Squad
社交媒体
X 推文和 Meta Threads 发布器
使用 Late API 和 Google Sheets 自动发布平台优化内容到 X 和 Threads
If
Set
Code
+6
20 节点Fariez
社交媒体
Instagram影响者交付物和合同合规性自动化
使用Claude AI和Slack提醒自动化Instagram影响者合同合规性
If
Set
Code
+8
26 节点Oneclick AI Squad
社交媒体
工作流信息
难度等级
中级
节点数量13
分类2
节点类型6
难度说明

适合有一定经验的用户，包含 6-15 个节点的中等复杂度工作流

作者
Oneclick AI Squad

Oneclick AI Squad

@oneclick-ai

The AI Squad Initiative is a pioneering effort to build, automate and scale AI-powered workflows using n8n.io. Our mission is to help individuals and businesses integrate AI agents seamlessly into their daily operations from automating tasks and enhancing productivity to creating innovative, intelligent solutions. We design modular, reusable AI workflow templates that empower creators, developers and teams to supercharge their automation with minimal effort and maximum impact.

外部链接
在 n8n.io 查看 →

分享此工作流