8
n8n 中文网amn8n.com

Mastodon发布 - Amazon和SHLink英文版

中级

这是一个AI, Marketing领域的自动化工作流,包含 11 个节点。主要使用 Set, Merge, HttpRequest, GoogleSheets, ManualTrigger 等节点,结合人工智能技术实现智能自动化。 使用AI描述和Shlink跟踪将Amazon联盟链接发布到Mastodon

前置要求
  • 可能需要目标 API 的认证凭证
  • Google Sheets API 凭证
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
  "id": "aqVSJsVRHr4lAZVM",
  "meta": {
    "instanceId": "30c75264a206eec49d4c38a892fd65da80b5ccd70231d5bfaa83c4000c45aa34",
    "templateCredsSetupCompleted": true
  },
  "name": "Mastodon 发布 - Amazon 和 SHLink 英文版",
  "tags": [],
  "nodes": [
    {
      "id": "9f4f98cc-df3d-49e5-a371-818bd2c2ef94",
      "name": "当点击\"执行工作流\"时",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -740,
        160
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "6cecfaee-3882-488e-9e9c-28fec3a59b6b",
      "name": "Mastodon",
      "type": "n8n-nodes-the-mastodon.mastodon",
      "position": [
        440,
        140
      ],
      "parameters": {
        "status": "={{ $json.text }}\n{{ $('Get Picture').item.json.SHLink }}",
        "additionalFields": {
          "mediaIds": "={{ $('Picture to Mastodon').item.json.id }}",
          "sensitive": false,
          "visibility": "public"
        }
      },
      "credentials": {
        "mastodonOAuth2Api": {
          "id": "FYQLTvQOMqtpQfIq",
          "name": "Mastodon account 2"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "91304e37-f846-45ef-8e77-d3606572c8ba",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -780,
        -40
      ],
      "parameters": {
        "color": 5,
        "width": 1640,
        "height": 420,
        "content": "## 发送 Amazon 联盟链接到 Mastodon"
      },
      "typeVersion": 1
    },
    {
      "id": "5d58cd9a-be4b-4116-be1a-915c22f37018",
      "name": "Google Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -380,
        160
      ],
      "parameters": {
        "options": {
          "returnFirstMatch": true
        },
        "filtersUI": {
          "values": [
            {
              "lookupValue": "NO",
              "lookupColumn": "Send"
            }
          ]
        },
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1y2Gt9VyMOt_Pf8DOz1IqQ5x9cDHFTToJvr6qijT1V4g/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1y2Gt9VyMOt_Pf8DOz1IqQ5x9cDHFTToJvr6qijT1V4g",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1y2Gt9VyMOt_Pf8DOz1IqQ5x9cDHFTToJvr6qijT1V4g/edit?usp=drivesdk",
          "cachedResultName": "Amazon Affiliate"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "xWrU0UpSxhg1BdCs",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "a87e93ae-aed5-4f95-957e-4640721c29be",
      "name": "设置参数",
      "type": "n8n-nodes-base.set",
      "notes": "Mastodon Parameters",
      "position": [
        -560,
        160
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "918a80b9-90fc-4f80-a4f5-1c97409e5014",
              "name": "mostodon_instance",
              "type": "string",
              "value": "https://mastodon.social/api/v2/media"
            },
            {
              "id": "5a587f92-815c-4726-81bc-2eaba1f08e0e",
              "name": "mastodon_token",
              "type": "string",
              "value": "XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX"
            }
          ]
        }
      },
      "notesInFlow": true,
      "typeVersion": 3.4
    },
    {
      "id": "30120e03-e058-4e91-b8a5-c073cb60dbcd",
      "name": "基础 LLM 链",
      "type": "@n8n/n8n-nodes-langchain.chainLlm",
      "position": [
        -60,
        20
      ],
      "parameters": {
        "text": "=Create a two-line technical ad copy based on this product page: {{ $json[\"Amazon Link\"] }} suppress \"Here is an ad copy\" in the output!",
        "batching": {},
        "promptType": "define"
      },
      "typeVersion": 1.7
    },
    {
      "id": "9323a3cb-7668-448d-8292-652ead0deb8a",
      "name": "OpenRouter聊天模型",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenRouter",
      "position": [
        -80,
        240
      ],
      "parameters": {
        "model": "perplexity/sonar",
        "options": {}
      },
      "credentials": {
        "openRouterApi": {
          "id": "ckIpKRUnrvlSyJGS",
          "name": "OpenRouter account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "1c2c5f36-c4df-4c1d-937b-b03839406173",
      "name": "合并",
      "type": "n8n-nodes-base.merge",
      "position": [
        260,
        140
      ],
      "parameters": {
        "mode": "combine",
        "options": {},
        "combineBy": "combineByPosition"
      },
      "typeVersion": 3.2,
      "alwaysOutputData": true
    },
    {
      "id": "aaf70202-fdf6-4aee-8956-603b24c25faa",
      "name": "获取图片",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -220,
        160
      ],
      "parameters": {
        "url": "={{ $json.PicURL }}",
        "options": {}
      },
      "typeVersion": 4.2
    },
    {
      "id": "736afabe-8479-46d9-8092-7e3db488b4a7",
      "name": "图片发布到 Mastodon",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        40,
        160
      ],
      "parameters": {
        "url": "={{ $('Set Parameter').item.json.mostodon_instance }}",
        "method": "POST",
        "options": {},
        "sendBody": true,
        "contentType": "multipart-form-data",
        "sendHeaders": true,
        "bodyParameters": {
          "parameters": [
            {
              "name": "file",
              "parameterType": "formBinaryData",
              "inputDataFieldName": "data"
            }
          ]
        },
        "headerParameters": {
          "parameters": [
            {
              "name": "Authorization",
              "value": "=Bearer {{ $('Set Parameter').item.json.mastodon_token }}"
            }
          ]
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "faa25555-7a35-45dc-98f2-7c7743bdee7d",
      "name": "Google 更新",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        620,
        140
      ],
      "parameters": {
        "columns": {
          "value": {
            "Send": "YES",
            "SHLink": "={{ $('Google Sheets').item.json.SHLink }}"
          },
          "schema": [
            {
              "id": "SHLink",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "SHLink",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Amazon Link",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Amazon Link",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Description",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Description",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "PicURL",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "PicURL",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Send",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Send",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "row_number",
              "type": "string",
              "display": true,
              "removed": true,
              "readOnly": true,
              "required": false,
              "displayName": "row_number",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "SHLink"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "update",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1y2Gt9VyMOt_Pf8DOz1IqQ5x9cDHFTToJvr6qijT1V4g/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1y2Gt9VyMOt_Pf8DOz1IqQ5x9cDHFTToJvr6qijT1V4g",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1y2Gt9VyMOt_Pf8DOz1IqQ5x9cDHFTToJvr6qijT1V4g/edit?usp=drivesdk",
          "cachedResultName": "Amazon Affiliate"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "xWrU0UpSxhg1BdCs",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.6,
      "alwaysOutputData": true
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "1862c012-395a-4de2-ab61-6b7ee18154d0",
  "connections": {
    "Merge": {
      "main": [
        [
          {
            "node": "Mastodon",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Mastodon": {
      "main": [
        [
          {
            "node": "Google Update",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Picture": {
      "main": [
        [
          {
            "node": "Basic LLM Chain",
            "type": "main",
            "index": 0
          },
          {
            "node": "Picture to Mastodon",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets": {
      "main": [
        [
          {
            "node": "Get Picture",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set Parameter": {
      "main": [
        [
          {
            "node": "Google Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Basic LLM Chain": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Picture to Mastodon": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "OpenRouter Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "Basic LLM Chain",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "When clicking ‘Execute workflow’": {
      "main": [
        [
          {
            "node": "Set Parameter",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流?

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

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

中级 - 人工智能, 营销

需要付费吗?

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

工作流信息
难度等级
中级
节点数量11
分类2
节点类型9
难度说明

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

作者
Joachim Hummel

Joachim Hummel

@jhummel

Automation consultant with 30+ years of IT experience. Specialized in building efficient workflows with n8n for freelancers and small to medium-sized businesses.

外部链接
在 n8n.io 查看

分享此工作流