Mastodonへの投稿 - AmazonおよびSHLink英語版

中級

これはAI, Marketing分野の自動化ワークフローで、11個のノードを含みます。主にSet, Merge, HttpRequest, GoogleSheets, ManualTriggerなどのノードを使用、AI技術を活用したスマート自動化を実現。 AmazonアフィリエイトリンクをMastodonにAIによる説明とShlinkを使用して公開する

前提条件
  • ターゲットAPIの認証情報が必要な場合あり
  • Google Sheets API認証情報
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
  "id": "aqVSJsVRHr4lAZVM",
  "meta": {
    "instanceId": "30c75264a206eec49d4c38a892fd65da80b5ccd70231d5bfaa83c4000c45aa34",
    "templateCredsSetupCompleted": true
  },
  "name": "Mastodon Posting - Amazon und SHLink English",
  "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": "## Send Amazon Affiliate to Mastodon\n### Monitor the Links with https://shlink.io/\n"
      },
      "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": "Basic LLM Chain",
      "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 Chat Model",
      "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 Update",
      "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": {
    "1c2c5f36-c4df-4c1d-937b-b03839406173": {
      "main": [
        [
          {
            "node": "6cecfaee-3882-488e-9e9c-28fec3a59b6b",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "6cecfaee-3882-488e-9e9c-28fec3a59b6b": {
      "main": [
        [
          {
            "node": "faa25555-7a35-45dc-98f2-7c7743bdee7d",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "aaf70202-fdf6-4aee-8956-603b24c25faa": {
      "main": [
        [
          {
            "node": "30120e03-e058-4e91-b8a5-c073cb60dbcd",
            "type": "main",
            "index": 0
          },
          {
            "node": "736afabe-8479-46d9-8092-7e3db488b4a7",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "5d58cd9a-be4b-4116-be1a-915c22f37018": {
      "main": [
        [
          {
            "node": "aaf70202-fdf6-4aee-8956-603b24c25faa",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "a87e93ae-aed5-4f95-957e-4640721c29be": {
      "main": [
        [
          {
            "node": "5d58cd9a-be4b-4116-be1a-915c22f37018",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "30120e03-e058-4e91-b8a5-c073cb60dbcd": {
      "main": [
        [
          {
            "node": "1c2c5f36-c4df-4c1d-937b-b03839406173",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "736afabe-8479-46d9-8092-7e3db488b4a7": {
      "main": [
        [
          {
            "node": "1c2c5f36-c4df-4c1d-937b-b03839406173",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "9323a3cb-7668-448d-8292-652ead0deb8a": {
      "ai_languageModel": [
        [
          {
            "node": "30120e03-e058-4e91-b8a5-c073cb60dbcd",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "9f4f98cc-df3d-49e5-a371-818bd2c2ef94": {
      "main": [
        [
          {
            "node": "a87e93ae-aed5-4f95-957e-4640721c29be",
            "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で表示

このワークフローを共有

カテゴリー

カテゴリー: 34