Generar etiquetas para redes sociales basadas en tendencias de Twitter y YouTube con Mistral AI

• •Credenciales de API de Google Sheets

{
  "meta": {
    "instanceId": "d2787088d49a05164783f5a9fa37e1730a27b190e51881d2128ba2bcd8c2656e"
  },
  "nodes": [
    {
      "id": "ca4cb366-5e3c-4bb1-a219-11f0a3684089",
      "name": "Combinar",
      "type": "n8n-nodes-base.merge",
      "position": [
        760,
        200
      ],
      "parameters": {},
      "typeVersion": 3.1
    },
    {
      "id": "45cf94ce-c524-45c6-96cd-7a95ba14ca1c",
      "name": "activador diario",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -380,
        220
      ],
      "parameters": {
        "rule": {
          "interval": [
            {}
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "49ca40cd-2af0-4023-9398-fcc5f5c44bdc",
      "name": "extraer tendencias de 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": "extraer tendencias de 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": "Hojas de Google2",
      "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": "Bucle sobre elementos2",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        1480,
        200
      ],
      "parameters": {
        "options": {
          "reset": false
        }
      },
      "typeVersion": 3
    },
    {
      "id": "ff8fc176-6006-43f4-bdbc-4968e2d93c11",
      "name": "Analizador de salida estructurada1",
      "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": "Nota adhesiva",
      "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": "Nota adhesiva1",
      "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": "Nota adhesiva2",
      "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": "filtrar tendencias de 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": "filtrar tendencias de 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": "obtener solo las 100 tendencias principales",
      "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": "generador 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
          }
        ]
      ]
    },
    "Google Sheets2": {
      "main": [
        [
          {
            "node": "da2fddc5-46b7-4049-ad42-b5d401bbda48",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "da2fddc5-46b7-4049-ad42-b5d401bbda48": {
      "main": [
        [],
        [
          {
            "node": "Google Sheets2",
            "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
          }
        ]
      ]
    }
  }
}