Social-Media-Tags mit Mistral AI basierend auf Twitter- und YouTube-Trends generieren

• •Google Sheets API-Anmeldedaten

{
  "meta": {
    "instanceId": "d2787088d49a05164783f5a9fa37e1730a27b190e51881d2128ba2bcd8c2656e"
  },
  "nodes": [
    {
      "id": "ca4cb366-5e3c-4bb1-a219-11f0a3684089",
      "name": "Merge",
      "type": "n8n-nodes-base.merge",
      "position": [
        760,
        200
      ],
      "parameters": {},
      "typeVersion": 3.1
    },
    {
      "id": "45cf94ce-c524-45c6-96cd-7a95ba14ca1c",
      "name": "Täglicher Auslöser",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -380,
        220
      ],
      "parameters": {
        "rule": {
          "interval": [
            {}
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "49ca40cd-2af0-4023-9398-fcc5f5c44bdc",
      "name": "Extrahieren von twitter-Trends",
      "type": "n8n-nodes-crawl-and-scrape.crawleeNode",
      "position": [
        120,
        120
      ],
      "parameters": {
        "url": "https://trends24.in/",
        "operation": "extractHtml"
      },
      "typeVersion": 1
    },
    {
      "id": "aaf1d402-6524-4c2e-ba77-cf4c778c6de4",
      "name": "Extrahieren von YouTube-Trends",
      "type": "n8n-nodes-crawl-and-scrape.crawleeNode",
      "position": [
        120,
        340
      ],
      "parameters": {
        "url": "https://youtube.trends24.in/",
        "operation": "extractHtml"
      },
      "typeVersion": 1
    },
    {
      "id": "f01f50bf-f46b-485c-9ec7-9abf263a37db",
      "name": "Google Sheets2",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1700,
        220
      ],
      "parameters": {
        "columns": {
          "value": {
            "hastag ": "={{ $json.output.hashtag }}"
          },
          "schema": [
            {
              "id": "hastag ",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "hastag ",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "hastag "
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1A9EHzMz88dlmBZm1ooQasWb4sU3OTv2tuMtuu1yBAyw/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1A9EHzMz88dlmBZm1ooQasWb4sU3OTv2tuMtuu1yBAyw",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1A9EHzMz88dlmBZm1ooQasWb4sU3OTv2tuMtuu1yBAyw/edit?usp=drivesdk",
          "cachedResultName": "Hastag"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "amDdbvZuuPjcG55e",
          "name": "Google Sheets account 2"
        }
      },
      "typeVersion": 4.6,
      "alwaysOutputData": true
    },
    {
      "id": "da2fddc5-46b7-4049-ad42-b5d401bbda48",
      "name": "Über Elemente iterieren2",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        1480,
        200
      ],
      "parameters": {
        "options": {
          "reset": false
        }
      },
      "typeVersion": 3
    },
    {
      "id": "ff8fc176-6006-43f4-bdbc-4968e2d93c11",
      "name": "Strukturierter Ausgabe-Parser1",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        1280,
        420
      ],
      "parameters": {
        "jsonSchemaExample": "{\n\t\n\t\"hashtag\": [\"\", \"\", \"\"]\n}"
      },
      "typeVersion": 1.2
    },
    {
      "id": "d434e4a8-fb22-41d9-a208-0eacf97d1177",
      "name": "Haftnotiz",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        0
      ],
      "parameters": {
        "color": 5,
        "width": 360,
        "height": 600,
        "content": "extract twitter and youtube trends from https://trends24.in/  by   using crawl and scrape community node scrape the websites "
      },
      "typeVersion": 1
    },
    {
      "id": "b70c5ae9-2a99-401a-a9d5-9e54008aa593",
      "name": "Mistral Cloud Chat Model1",
      "type": "@n8n/n8n-nodes-langchain.lmChatMistralCloud",
      "position": [
        1080,
        420
      ],
      "parameters": {
        "model": "mistral-small-latest",
        "options": {}
      },
      "credentials": {
        "mistralCloudApi": {
          "id": "n3lOZuA7dCVheVwc",
          "name": "Mistral Cloud account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "da6240e4-6d9e-45cf-bf16-05ec1717aa52",
      "name": "Haftnotiz1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        380,
        0
      ],
      "parameters": {
        "width": 480,
        "height": 580,
        "content": "filters hashtags out of scraper output"
      },
      "typeVersion": 1
    },
    {
      "id": "68a52f28-77e6-4b5f-8864-f6880f29f9f6",
      "name": "Haftnotiz2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        920,
        0
      ],
      "parameters": {
        "width": 540,
        "height": 560,
        "content": "generate hashtag related to topic we gave based on current trends "
      },
      "typeVersion": 1
    },
    {
      "id": "99f60b2d-eef3-41d4-af91-85dc4639ad99",
      "name": "Filtern von twitter-Trends",
      "type": "n8n-nodes-base.html",
      "position": [
        420,
        120
      ],
      "parameters": {
        "options": {
          "cleanUpText": true
        },
        "operation": "extractHtmlContent",
        "dataPropertyName": "data.html",
        "extractionValues": {
          "values": [
            {
              "key": "trends",
              "cssSelector": ".trend-card__list li a",
              "returnArray": true,
              "returnValue": "html"
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "2b598d9a-89bb-4a1f-b63b-e328d88a411e",
      "name": "Filtern von YouTube-Trends",
      "type": "n8n-nodes-base.html",
      "position": [
        420,
        340
      ],
      "parameters": {
        "options": {
          "cleanUpText": true
        },
        "operation": "extractHtmlContent",
        "dataPropertyName": "data.html",
        "extractionValues": {
          "values": [
            {
              "key": "trends",
              "cssSelector": ".keywords-list li",
              "returnArray": true,
              "returnValue": "html"
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "af274fcf-7358-4f24-a3df-c9ea6f694268",
      "name": "Nur Top-100-Trends abrufen",
      "type": "n8n-nodes-base.code",
      "position": [
        600,
        120
      ],
      "parameters": {
        "jsCode": "return items.map(item => {\n  item.json.trends = item.json.trends.slice(0, 100);\n  return item;\n});\n"
      },
      "typeVersion": 2
    },
    {
      "id": "cb29b201-b2be-462b-88d0-4fbd6a94feb3",
      "name": "Hashtag-Generator",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        1100,
        200
      ],
      "parameters": {
        "text": "={{ $('Merge').item.json.trends }},{{ $('Merge').item.json.trends }}",
        "options": {
          "systemMessage": "=You are a professional hashtag trend strategist.\n\nYour task is to take the following list of trending hashtags and keywords and generate ONE new hashtag that is either:\n\n1. A variation of an existing hashtag,\n2. A mashup of two related trends,\n3. Or a smart, brand-safe hashtag inspired by the same themes, communities, or languages used in the list.\n4. if  no related trends make one of your own\nKeep the hashtag short, all lowercase, no spaces, and catchy. Do not use special characters beyond the #. Avoid copying any exact hashtag from the list.\n\nhastag should be related to this:\n{{ $json.keywords }}\n\nTrending List:\ngive as user query\n\nReturn only a single new hashtag in this format:\n{\n  \"new_hashtag\": \"#exampletag\"\n}\n\n\n\n\n\n\n\n\n\n\n\n\n"
        },
        "promptType": "define",
        "hasOutputParser": true
      },
      "typeVersion": 2
    }
  ],
  "pinData": {},
  "connections": {
    "ca4cb366-5e3c-4bb1-a219-11f0a3684089": {
      "main": [
        [
          {
            "node": "cb29b201-b2be-462b-88d0-4fbd6a94feb3",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "45cf94ce-c524-45c6-96cd-7a95ba14ca1c": {
      "main": [
        [
          {
            "node": "49ca40cd-2af0-4023-9398-fcc5f5c44bdc",
            "type": "main",
            "index": 0
          },
          {
            "node": "aaf1d402-6524-4c2e-ba77-cf4c778c6de4",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "f01f50bf-f46b-485c-9ec7-9abf263a37db": {
      "main": [
        [
          {
            "node": "da2fddc5-46b7-4049-ad42-b5d401bbda48",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "da2fddc5-46b7-4049-ad42-b5d401bbda48": {
      "main": [
        [],
        [
          {
            "node": "f01f50bf-f46b-485c-9ec7-9abf263a37db",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "cb29b201-b2be-462b-88d0-4fbd6a94feb3": {
      "main": [
        [
          {
            "node": "da2fddc5-46b7-4049-ad42-b5d401bbda48",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "2b598d9a-89bb-4a1f-b63b-e328d88a411e": {
      "main": [
        [
          {
            "node": "ca4cb366-5e3c-4bb1-a219-11f0a3684089",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "99f60b2d-eef3-41d4-af91-85dc4639ad99": {
      "main": [
        [
          {
            "node": "af274fcf-7358-4f24-a3df-c9ea6f694268",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "aaf1d402-6524-4c2e-ba77-cf4c778c6de4": {
      "main": [
        [
          {
            "node": "2b598d9a-89bb-4a1f-b63b-e328d88a411e",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "49ca40cd-2af0-4023-9398-fcc5f5c44bdc": {
      "main": [
        [
          {
            "node": "99f60b2d-eef3-41d4-af91-85dc4639ad99",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "af274fcf-7358-4f24-a3df-c9ea6f694268": {
      "main": [
        [
          {
            "node": "ca4cb366-5e3c-4bb1-a219-11f0a3684089",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "b70c5ae9-2a99-401a-a9d5-9e54008aa593": {
      "ai_languageModel": [
        [
          {
            "node": "cb29b201-b2be-462b-88d0-4fbd6a94feb3",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "ff8fc176-6006-43f4-bdbc-4968e2d93c11": {
      "ai_outputParser": [
        [
          {
            "node": "cb29b201-b2be-462b-88d0-4fbd6a94feb3",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    }
  }
}