Générer des hashtags pour les médias sociaux en se basant sur les tendances Twitter et YouTube avec Mistral AI

• •Informations d'identification Google Sheets API

{
  "meta": {
    "instanceId": "d2787088d49a05164783f5a9fa37e1730a27b190e51881d2128ba2bcd8c2656e"
  },
  "nodes": [
    {
      "id": "ca4cb366-5e3c-4bb1-a219-11f0a3684089",
      "name": "Fusion",
      "type": "n8n-nodes-base.merge",
      "position": [
        760,
        200
      ],
      "parameters": {},
      "typeVersion": 3.1
    },
    {
      "id": "45cf94ce-c524-45c6-96cd-7a95ba14ca1c",
      "name": "déclencheur quotidien",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -380,
        220
      ],
      "parameters": {
        "rule": {
          "interval": [
            {}
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "49ca40cd-2af0-4023-9398-fcc5f5c44bdc",
      "name": "extraire les tendances twitter",
      "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": "extraire les tendances YouTube",
      "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": "Boucle sur les éléments2",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        1480,
        200
      ],
      "parameters": {
        "options": {
          "reset": false
        }
      },
      "typeVersion": 3
    },
    {
      "id": "ff8fc176-6006-43f4-bdbc-4968e2d93c11",
      "name": "Analyseur de sortie structurée1",
      "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": "Note adhésive",
      "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": "Note adhésive1",
      "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": "Note adhésive2",
      "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": "filtrer les tendances twitter",
      "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": "filtrer les tendances YouTube",
      "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": "obtenir seulement les 100 premières tendances",
      "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": "générateur de hashtags",
      "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
          }
        ]
      ]
    }
  }
}