Personal - Solicitud de TRM

Avanzado

Este es unFinance, AIflujo de automatización del dominio deautomatización que contiene 31 nodos.Utiliza principalmente nodos como If, Set, Code, Sort, Limit, combinando tecnología de inteligencia artificial para lograr automatización inteligente. Obtener la tasa de cambio del colombiano contra el dólar a través de un bot de Telegram y reconocimiento de fechas de IA

Requisitos previos
  • Bot Token de Telegram
  • Pueden requerirse credenciales de autenticación para la API de destino
  • Clave de API de OpenAI
Vista previa del flujo de trabajo
Visualización de las conexiones entre nodos, con soporte para zoom y panorámica
Exportar flujo de trabajo
Copie la siguiente configuración JSON en n8n para importar y usar este flujo de trabajo
{
  "id": "MVcw4IwqLxTDzdt5",
  "meta": {
    "instanceId": "51270372ea87f40bc06437a6d111ae29e684e524a2e6c52d7a6f84dde18d4a17",
    "templateCredsSetupCompleted": true
  },
  "name": "Personal - Solicitar TRM",
  "tags": [],
  "nodes": [
    {
      "id": "f1d44561-9c6a-4e5d-835b-630e858a3181",
      "name": "OpenAI Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        1140,
        -620
      ],
      "parameters": {
        "model": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-4.1-nano",
          "cachedResultName": "gpt-4.1-nano"
        },
        "options": {
          "maxRetries": 2,
          "temperature": 0
        }
      },
      "credentials": {
        "openAiApi": {
          "id": "BfhecJBx32L0a2gT",
          "name": "OpenAi account"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "2b3a4c40-77b2-48d3-a2af-8fc084d24183",
      "name": "Cuando se recibe un mensaje Telegram",
      "type": "n8n-nodes-base.telegramTrigger",
      "position": [
        -400,
        -840
      ],
      "webhookId": "76fd085e-cba0-40ab-9937-3efb9057d4de",
      "parameters": {
        "updates": [
          "message"
        ],
        "additionalFields": {}
      },
      "credentials": {
        "telegramApi": {
          "id": "xxxxxxx",
          "name": "name_bot"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "d8686b18-59d7-461d-a24a-d8f44703db2c",
      "name": "Fecha y hora local actual",
      "type": "n8n-nodes-base.code",
      "position": [
        920,
        -840
      ],
      "parameters": {
        "jsCode": "const now = new Date();\n\n// Ajustar a hora local de Colombia (UTC-5)\nconst utc = now.getTime() + now.getTimezoneOffset() * 60000;\nconst colombiaTime = new Date(utc - 5 * 3600000);\n\n// Formato YYYY-MM-DD\nconst fecha = colombiaTime.toISOString().split('T')[0];\n\n// Formato YYYY-MM-DD HH:mm:ss\nconst fechaHora = colombiaTime.toISOString().replace('T', ' ').substring(0, 19);\n\nreturn [\n  {\n    json: {\n      fecha_actual: fecha,\n      fecha_hora_actual: fechaHora,\n    }\n  }\n];"
      },
      "typeVersion": 2
    },
    {
      "id": "022626cd-5a65-4225-9307-817a024799c2",
      "name": "Validar si la fecha es pasada",
      "type": "n8n-nodes-base.if",
      "position": [
        1700,
        -840
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "b245d771-5b2e-4384-8357-0357e5a1ce2e",
              "operator": {
                "type": "dateTime",
                "operation": "after"
              },
              "leftValue": "={{ $json.output.date }}",
              "rightValue": "={{ $('Local Current Date and Time').item.json.fecha_actual }}"
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "f40edcdb-ff34-491e-b460-f09353aba40f",
      "name": "Notificar fecha pasada",
      "type": "n8n-nodes-base.telegram",
      "position": [
        1920,
        -940
      ],
      "webhookId": "4761d2c3-62ee-413d-b114-67ef7a49f4eb",
      "parameters": {
        "text": "=Fecha posterior a fecha actual",
        "chatId": "={{ $('Once a Telegram Message is received').item.json.message.from.id }}",
        "additionalFields": {
          "appendAttribution": false
        }
      },
      "credentials": {
        "telegramApi": {
          "id": "xxxxxx",
          "name": "name_bot"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "9d8c17b5-ce7f-40c0-8e35-64b9b42927f5",
      "name": "Obtener TRM",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1920,
        -740
      ],
      "parameters": {
        "url": "=https://www.datos.gov.co/resource/32sa-8pi3.json?vigenciadesde={{ $json.output.date }}",
        "options": {}
      },
      "typeVersion": 4.2,
      "alwaysOutputData": true
    },
    {
      "id": "cd58e419-7d3a-4314-afa3-9fde3c7e998b",
      "name": "Verificar si existe Valor",
      "type": "n8n-nodes-base.if",
      "position": [
        2140,
        -740
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "9f3ed730-0414-4f19-9941-2e6663ae221c",
              "operator": {
                "type": "string",
                "operation": "exists",
                "singleValue": true
              },
              "leftValue": "={{ $json.valor }}",
              "rightValue": ""
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "1813eccf-36ae-4201-bbbd-3bc6ebf63e3d",
      "name": "Enviar mensaje al usuario",
      "type": "n8n-nodes-base.telegram",
      "position": [
        2360,
        -840
      ],
      "webhookId": "4761d2c3-62ee-413d-b114-67ef7a49f4eb",
      "parameters": {
        "text": "={{ $json.valor }}\nTRM del {{ $('Extractor Agent').item.json.output.date }}",
        "chatId": "={{ $('Once a Telegram Message is received').item.json.message.from.id }}",
        "additionalFields": {
          "appendAttribution": false
        }
      },
      "credentials": {
        "telegramApi": {
          "id": "xxxxxx",
          "name": "name_bot"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "93bb62fb-6e42-4498-a758-4d99ea54a852",
      "name": "Generar un array con 10 números",
      "type": "n8n-nodes-base.code",
      "position": [
        2360,
        -640
      ],
      "parameters": {
        "jsCode": "// Generar array del 1 al 10\nconst counter = Array.from({ length: 10 }, (_, i) => i + 1);\n\n// Devolver el resultado en el formato adecuado\nreturn [\n  {\n    json: {\n      counter\n    }\n  }\n];"
      },
      "typeVersion": 2
    },
    {
      "id": "c85942c6-1627-49d4-8f62-ffda4f08c6f1",
      "name": "Dividir elementos para el bucle",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        2580,
        -640
      ],
      "parameters": {
        "options": {},
        "fieldToSplitOut": "counter"
      },
      "typeVersion": 1
    },
    {
      "id": "9c57b15e-958e-4b1a-ac30-701e7b874319",
      "name": "Obtener las últimas 10 respuestas",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        2800,
        -640
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 3
    },
    {
      "id": "59168aad-9ec1-4dc9-9c46-85c1cf4f40a6",
      "name": "Obtener TRM para fecha pasada",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        3240,
        -490
      ],
      "parameters": {
        "url": "=https://www.datos.gov.co/resource/32sa-8pi3.json?vigenciadesde={{ $json.adjustedDate }}",
        "options": {}
      },
      "typeVersion": 4.2,
      "alwaysOutputData": true
    },
    {
      "id": "9a802ea6-8591-4229-840e-b2789e1ef4b5",
      "name": "Nota adhesiva",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        3420,
        -500
      ],
      "parameters": {
        "color": 4,
        "width": 400,
        "height": 180,
        "content": "## Reason for Loop\nSome TRM are valid for several days, like during weekends or holidays, so 10 days are validated to grab the last available TRM"
      },
      "typeVersion": 1
    },
    {
      "id": "ca8cae67-d0e1-4bb5-94b6-80c3d00f0b5c",
      "name": "Convertir fecha",
      "type": "n8n-nodes-base.code",
      "position": [
        3020,
        -640
      ],
      "parameters": {
        "jsCode": "const items = $input.all();\nlet counter = $input.first().json.counter;\n\nreturn items.map(item => {\n  const originalDate = new Date($('Validate if Date is in the past').item.json.output.date);\n  originalDate.setDate(originalDate.getDate() - counter);\n  const adjustedDate = originalDate.toISOString().split('T')[0];\n\n  const result = {\n    ...item.json,\n    adjustedDate,\n    loopCounter: counter\n  };\n\n  counter++;\n  return { json: result };\n});"
      },
      "typeVersion": 2
    },
    {
      "id": "370fd786-7611-4148-be16-df28ef18c637",
      "name": "Obtener filas no vacías",
      "type": "n8n-nodes-base.filter",
      "position": [
        3020,
        -840
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "2de92428-e76f-4a46-a67a-e28b3fefc845",
              "operator": {
                "type": "string",
                "operation": "exists",
                "singleValue": true
              },
              "leftValue": "={{ $json.valor }}",
              "rightValue": ""
            }
          ]
        }
      },
      "typeVersion": 2.2,
      "alwaysOutputData": true
    },
    {
      "id": "f468d509-68c5-4d78-b22d-86950d1a9792",
      "name": "Ordenar datos más recientes",
      "type": "n8n-nodes-base.sort",
      "position": [
        3460,
        -1040
      ],
      "parameters": {
        "options": {},
        "sortFieldsUi": {
          "sortField": [
            {
              "order": "descending",
              "fieldName": "vigenciadesde"
            }
          ]
        }
      },
      "typeVersion": 1
    },
    {
      "id": "7696b138-dff9-4b08-848f-81d70422779a",
      "name": "Obtener el último dato",
      "type": "n8n-nodes-base.limit",
      "position": [
        3680,
        -1040
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "5fdafe49-ecec-45ac-8e58-f71951bdbacd",
      "name": "Enviar TRM actual",
      "type": "n8n-nodes-base.telegram",
      "position": [
        3900,
        -1040
      ],
      "webhookId": "4761d2c3-62ee-413d-b114-67ef7a49f4eb",
      "parameters": {
        "text": "={{ $json.valor }}\nTRM del {{ $('Extractor Agent').item.json.output.date }}",
        "chatId": "={{ $('Once a Telegram Message is received').item.json.message.from.id }}",
        "additionalFields": {
          "appendAttribution": false
        }
      },
      "credentials": {
        "telegramApi": {
          "id": "xxxxxxxx",
          "name": "name_bot"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "cb29d564-95cd-4a66-b4a6-9f6ee5204452",
      "name": "Si",
      "type": "n8n-nodes-base.if",
      "position": [
        3240,
        -840
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "d8eff85a-bedc-4363-a46b-5ec32953113f",
              "operator": {
                "type": "string",
                "operation": "exists",
                "singleValue": true
              },
              "leftValue": "={{ $json.valor }}",
              "rightValue": ""
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "dee431c6-80ee-4f37-a291-61b5ee74557e",
      "name": "Enviar sin datos",
      "type": "n8n-nodes-base.telegram",
      "position": [
        3460,
        -840
      ],
      "webhookId": "4761d2c3-62ee-413d-b114-67ef7a49f4eb",
      "parameters": {
        "text": "=No existe información para la fecha proporcionada: {{ $('Extractor Agent').item.json.output.date }}",
        "chatId": "={{ $('Once a Telegram Message is received').item.json.message.from.id }}",
        "additionalFields": {
          "appendAttribution": false
        }
      },
      "credentials": {
        "telegramApi": {
          "id": "xxxxxxx",
          "name": "name_bot"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "d3bef604-c465-48da-8f0b-50a47896968a",
      "name": "Calculadora",
      "type": "@n8n/n8n-nodes-langchain.toolCalculator",
      "position": [
        1260,
        -620
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "08e70a77-6801-4beb-b81f-766404cb992a",
      "name": "Pensar",
      "type": "@n8n/n8n-nodes-langchain.toolThink",
      "position": [
        1380,
        -620
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "ffd80923-e0e2-4198-8ce5-66bff53993fe",
      "name": "Extractor Agent",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        1232,
        -840
      ],
      "parameters": {
        "text": "={{ $('Edit Fields').item.json.text }}",
        "options": {
          "systemMessage": "=Eres un algoritmo experto en extracción de información.\nFecha actual: {{ $json.fecha_actual }}\nTu tarea es identificar y extraer fechas mencionadas en un texto escrito en español, incluso si están redactadas de forma natural o ambigua.\nSigue estas reglas:\n\t•\tSi el texto menciona una fecha explícita o relativa (por ejemplo: “20 de mayo”, “el 17”, “ayer”, “antier”, “hoy”), extrae la fecha en formato AAAA-MM-DD.\n\t•\tSi una fecha no incluye el año, asume el año actual.\n\t•\tSi no incluye ni mes ni año, asume el mes y año actuales.\n\t•\tSi el texto no contiene una fecha clara pero es ambiguo (como “Hola”, “ok”, “listo”, “gracias”), devuelve la fecha actual.\n\t•\tNo generes ningún texto adicional, solo la fecha en formato AAAA-MM-DD."
        },
        "promptType": "define",
        "hasOutputParser": true
      },
      "typeVersion": 1.9
    },
    {
      "id": "8b49d5c6-ce05-4ca9-a231-0bd4686040bf",
      "name": "Solo texto",
      "type": "n8n-nodes-base.set",
      "position": [
        480,
        -740
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "311e21c9-7edc-446d-9857-c9e60a429678",
              "name": "text",
              "type": "string",
              "value": "={{ $json.message.text }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "e586891d-2af9-4a04-bb40-3b3f3f216bf4",
      "name": "Audio Texto",
      "type": "n8n-nodes-base.set",
      "position": [
        480,
        -940
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "49569683-a732-47a9-8fbf-6e6303c03ad1",
              "name": "text",
              "type": "string",
              "value": "={{ $json.text }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "ff0b076d-9c39-4e98-a71c-a2f3f6df3231",
      "name": "Editar Campos",
      "type": "n8n-nodes-base.set",
      "position": [
        700,
        -840
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "72ede214-3023-459d-8a27-14be602440bf",
              "name": "text",
              "type": "string",
              "value": "={{ $json.text }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "70c427d1-8f32-49a0-ac32-6cf4a57d92e1",
      "name": "Structured Output Parser",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        1500,
        -620
      ],
      "parameters": {
        "jsonSchemaExample": "{\n\t\"date\": \"2025-04-01\"\n}"
      },
      "typeVersion": 1.2
    },
    {
      "id": "9cde8b3a-6e49-4843-a11d-e78d46204c4c",
      "name": "Validar Texto o Audio",
      "type": "n8n-nodes-base.switch",
      "position": [
        -180,
        -840
      ],
      "parameters": {
        "rules": {
          "values": [
            {
              "outputKey": "voice",
              "conditions": {
                "options": {
                  "version": 2,
                  "leftValue": "",
                  "caseSensitive": true,
                  "typeValidation": "strict"
                },
                "combinator": "and",
                "conditions": [
                  {
                    "id": "eaaa57f6-51e2-41c9-8a56-a78547c0a8c5",
                    "operator": {
                      "type": "object",
                      "operation": "exists",
                      "singleValue": true
                    },
                    "leftValue": "={{ $json.message.voice }}",
                    "rightValue": ""
                  }
                ]
              },
              "renameOutput": true
            },
            {
              "outputKey": "text",
              "conditions": {
                "options": {
                  "version": 2,
                  "leftValue": "",
                  "caseSensitive": true,
                  "typeValidation": "strict"
                },
                "combinator": "and",
                "conditions": [
                  {
                    "id": "1fda3a77-2a23-43b2-aaae-2ed3f0eed1f6",
                    "operator": {
                      "type": "string",
                      "operation": "exists",
                      "singleValue": true
                    },
                    "leftValue": "={{ $json.message.text }}",
                    "rightValue": ""
                  }
                ]
              },
              "renameOutput": true
            }
          ]
        },
        "options": {
          "fallbackOutput": "none"
        }
      },
      "typeVersion": 3.2
    },
    {
      "id": "75fc07c0-455c-490a-8ac9-422ddfee9b48",
      "name": "Descargar Audio",
      "type": "n8n-nodes-base.telegram",
      "position": [
        40,
        -940
      ],
      "webhookId": "d8240579-0461-483d-8ed0-93ddce22a1cd",
      "parameters": {
        "fileId": "={{ $json.message.voice.file_id }}",
        "resource": "file"
      },
      "credentials": {
        "telegramApi": {
          "id": "xxxxxxx",
          "name": "name_bot"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "47379a28-148b-4a36-8f06-4c994613d83c",
      "name": "Transcribir Audio",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        260,
        -940
      ],
      "parameters": {
        "options": {
          "language": "es",
          "temperature": 0
        },
        "resource": "audio",
        "operation": "transcribe",
        "binaryPropertyName": "=data"
      },
      "credentials": {
        "openAiApi": {
          "id": "BfhecJBx32L0a2gT",
          "name": "OpenAi account"
        }
      },
      "typeVersion": 1.8
    },
    {
      "id": "1e3e8207-fc34-4c83-8fb4-8aa7a4639c4b",
      "name": "Nota adhesiva1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -900,
        -1700
      ],
      "parameters": {
        "color": 3,
        "width": 840,
        "height": 780,
        "content": "# 📌 Workflow: Request TRM (Representative Market Rate)\n\n## 🎯 Objective\n\nRetrieve the TRM (Colombian Peso to US Dollar exchange rate) for a specific date provided by the user via Telegram.\n\n## 🔄 Summary Flow\n\n1. 📨 **Telegram Message**  \n   The user sends a text or audio to a Telegram Bot.\n\n2. 🧠 **Date Extraction**  \n   AI (OpenAI) is used to identify the date in `YYYY-MM-DD` format.\n\n3. 📅 **Validation**  \n   If the date is in the future, the user is notified that it is not valid.\n\n4. 📡 **TRM Query**  \n   The bot queries the open data API from the Colombian government.\n\n5. 📥 **Result**  \n   - ✅ If TRM data exists for that date → The bot replies to the user.  \n   - ❌ If not → It searches up to 10 previous days for available data.\n\n6. 📤 **Final Response**  \n   The most recent available value is sent, or a message indicating no information is available.\n\n## 🔗 Data Source\n**datos.gov.co** – [TRM](https://www.datos.gov.co/)"
      },
      "typeVersion": 1
    }
  ],
  "active": true,
  "pinData": {
    "Once a Telegram Message is received": [
      {
        "json": {
          "message": {
            "chat": {
              "id": 6162094450,
              "type": "private",
              "first_name": "Juan"
            },
            "date": 1747764561,
            "from": {
              "id": 6162094450,
              "is_bot": false,
              "first_name": "Juan",
              "language_code": "en"
            },
            "text": "enviame un audio",
            "message_id": 61
          },
          "update_id": 612273063
        }
      }
    ]
  },
  "settings": {
    "callerPolicy": "workflowsFromSameOwner",
    "executionOrder": "v1",
    "executionTimeout": 60
  },
  "versionId": "1141769b-3bb4-4f42-8bcf-d8c64ae27cd6",
  "connections": {
    "cb29d564-95cd-4a66-b4a6-9f6ee5204452": {
      "main": [
        [
          {
            "node": "f468d509-68c5-4d78-b22d-86950d1a9792",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "dee431c6-80ee-4f37-a291-61b5ee74557e",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "08e70a77-6801-4beb-b81f-766404cb992a": {
      "ai_tool": [
        [
          {
            "node": "ffd80923-e0e2-4198-8ce5-66bff53993fe",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "9d8c17b5-ce7f-40c0-8e35-64b9b42927f5": {
      "main": [
        [
          {
            "node": "cd58e419-7d3a-4314-afa3-9fde3c7e998b",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "8b49d5c6-ce05-4ca9-a231-0bd4686040bf": {
      "main": [
        [
          {
            "node": "ff0b076d-9c39-4e98-a71c-a2f3f6df3231",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "e586891d-2af9-4a04-bb40-3b3f3f216bf4": {
      "main": [
        [
          {
            "node": "ff0b076d-9c39-4e98-a71c-a2f3f6df3231",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "d3bef604-c465-48da-8f0b-50a47896968a": {
      "ai_tool": [
        [
          {
            "node": "ffd80923-e0e2-4198-8ce5-66bff53993fe",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "ff0b076d-9c39-4e98-a71c-a2f3f6df3231": {
      "main": [
        [
          {
            "node": "d8686b18-59d7-461d-a24a-d8f44703db2c",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "ca8cae67-d0e1-4bb5-94b6-80c3d00f0b5c": {
      "main": [
        [
          {
            "node": "59168aad-9ec1-4dc9-9c46-85c1cf4f40a6",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "75fc07c0-455c-490a-8ac9-422ddfee9b48": {
      "main": [
        [
          {
            "node": "47379a28-148b-4a36-8f06-4c994613d83c",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "ffd80923-e0e2-4198-8ce5-66bff53993fe": {
      "main": [
        [
          {
            "node": "022626cd-5a65-4225-9307-817a024799c2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "47379a28-148b-4a36-8f06-4c994613d83c": {
      "main": [
        [
          {
            "node": "e586891d-2af9-4a04-bb40-3b3f3f216bf4",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "7696b138-dff9-4b08-848f-81d70422779a": {
      "main": [
        [
          {
            "node": "5fdafe49-ecec-45ac-8e58-f71951bdbacd",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "f1d44561-9c6a-4e5d-835b-630e858a3181": {
      "ai_languageModel": [
        [
          {
            "node": "ffd80923-e0e2-4198-8ce5-66bff53993fe",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "370fd786-7611-4148-be16-df28ef18c637": {
      "main": [
        [
          {
            "node": "cb29d564-95cd-4a66-b4a6-9f6ee5204452",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "cd58e419-7d3a-4314-afa3-9fde3c7e998b": {
      "main": [
        [
          {
            "node": "1813eccf-36ae-4201-bbbd-3bc6ebf63e3d",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "93bb62fb-6e42-4498-a758-4d99ea54a852",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "59168aad-9ec1-4dc9-9c46-85c1cf4f40a6": {
      "main": [
        [
          {
            "node": "9c57b15e-958e-4b1a-ac30-701e7b874319",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "f468d509-68c5-4d78-b22d-86950d1a9792": {
      "main": [
        [
          {
            "node": "7696b138-dff9-4b08-848f-81d70422779a",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "9cde8b3a-6e49-4843-a11d-e78d46204c4c": {
      "main": [
        [
          {
            "node": "75fc07c0-455c-490a-8ac9-422ddfee9b48",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "8b49d5c6-ce05-4ca9-a231-0bd4686040bf",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "c85942c6-1627-49d4-8f62-ffda4f08c6f1": {
      "main": [
        [
          {
            "node": "9c57b15e-958e-4b1a-ac30-701e7b874319",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "70c427d1-8f32-49a0-ac32-6cf4a57d92e1": {
      "ai_outputParser": [
        [
          {
            "node": "ffd80923-e0e2-4198-8ce5-66bff53993fe",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "9c57b15e-958e-4b1a-ac30-701e7b874319": {
      "main": [
        [
          {
            "node": "370fd786-7611-4148-be16-df28ef18c637",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "ca8cae67-d0e1-4bb5-94b6-80c3d00f0b5c",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "d8686b18-59d7-461d-a24a-d8f44703db2c": {
      "main": [
        [
          {
            "node": "ffd80923-e0e2-4198-8ce5-66bff53993fe",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "022626cd-5a65-4225-9307-817a024799c2": {
      "main": [
        [
          {
            "node": "f40edcdb-ff34-491e-b460-f09353aba40f",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "9d8c17b5-ce7f-40c0-8e35-64b9b42927f5",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "93bb62fb-6e42-4498-a758-4d99ea54a852": {
      "main": [
        [
          {
            "node": "c85942c6-1627-49d4-8f62-ffda4f08c6f1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "2b3a4c40-77b2-48d3-a2af-8fc084d24183": {
      "main": [
        [
          {
            "node": "9cde8b3a-6e49-4843-a11d-e78d46204c4c",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
Preguntas frecuentes

¿Cómo usar este flujo de trabajo?

Copie el código de configuración JSON de arriba, cree un nuevo flujo de trabajo en su instancia de n8n y seleccione "Importar desde JSON", pegue la configuración y luego modifique la configuración de credenciales según sea necesario.

¿En qué escenarios es adecuado este flujo de trabajo?

Avanzado - Finanzas, Inteligencia Artificial

¿Es de pago?

Este flujo de trabajo es completamente gratuito, puede importarlo y usarlo directamente. Sin embargo, tenga en cuenta que los servicios de terceros utilizados en el flujo de trabajo (como la API de OpenAI) pueden requerir un pago por su cuenta.

Información del flujo de trabajo
Nivel de dificultad
Avanzado
Número de nodos31
Categoría2
Tipos de nodos19
Descripción de la dificultad

Adecuado para usuarios avanzados, flujos de trabajo complejos con 16+ nodos

Autor
Juan Sanchez

Juan Sanchez

@juansave

Experienced cloud solutions professional with a strong focus on Microsoft technologies, including Microsoft 365, Azure, Entra, and the Power Platform. Skilled in designing and implementing automation using Power Automate and PowerShell. Proven track record in sales, marketing, and delivering managed services for cloud environments. Passionate about digital transformation, AI integration, and streamlining business processes through low-code platforms.

Enlaces externos
Ver en n8n.io

Compartir este flujo de trabajo

Categorías

Categorías: 34