Mastodon Posting - Amazon und SHLink English

{
  "id": "aqVSJsVRHr4lAZVM",
  "meta": {
    "instanceId": "30c75264a206eec49d4c38a892fd65da80b5ccd70231d5bfaa83c4000c45aa34",
    "templateCredsSetupCompleted": true
  },
  "name": "Mastodon Posting - Amazon und SHLink English",
  "tags": [],
  "nodes": [
    {
      "id": "9f4f98cc-df3d-49e5-a371-818bd2c2ef94",
      "name": "When clicking ‘Execute workflow’",
      "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": "Sticky Note",
      "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": "Set Parameter",
      "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": "Merge",
      "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": "Get Picture",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -220,
        160
      ],
      "parameters": {
        "url": "={{ $json.PicURL }}",
        "options": {}
      },
      "typeVersion": 4.2
    },
    {
      "id": "736afabe-8479-46d9-8092-7e3db488b4a7",
      "name": "Picture to 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": {
    "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
          }
        ]
      ]
    }
  }
}