📊 Tracker de tokens AI para WhatsApp y Telegram - Almacenamiento del uso de AI en Google Sheets

Avanzado

Este es unFinance, AI, IT Opsflujo de automatización del dominio deautomatización que contiene 37 nodos.Utiliza principalmente nodos como If, Set, Code, Filter, Switch, combinando tecnología de inteligencia artificial para lograr automatización inteligente. 📊 Tracker de tokens AI para WhatsApp y Telegram - Guarda el uso de AI en Google Sheets

Requisitos previos
  • Punto final de HTTP Webhook (n8n generará automáticamente)
  • Bot Token de Telegram
  • Cuenta de Google y credenciales de API de Gmail
  • Pueden requerirse credenciales de autenticación para la API de destino
  • Clave de API de Airtable
  • Credenciales de API de Google Sheets
  • 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": "aeYhwC8OyRGijiTb",
  "meta": {
    "instanceId": "b79da95dcb1b69eebc3470f6fd833d7e53e389c229c716386bdb8e7c291ad2b9"
  },
  "name": "📊 AI Token Tracker for WhatsApp & Telegram – Save AI Usage to Google Sheets",
  "tags": [
    {
      "id": "mhx5MJAkz32rJgeQ",
      "name": "iloveflows.com",
      "createdAt": "2025-05-09T14:28:31.509Z",
      "updatedAt": "2025-05-09T14:28:31.509Z"
    }
  ],
  "nodes": [
    {
      "id": "bbfc6da2-6c99-4907-b46f-a32df9308aef",
      "name": "Enviar Correo",
      "type": "n8n-nodes-base.gmailTool",
      "disabled": true,
      "position": [
        660,
        280
      ],
      "webhookId": "18eaba1a-1821-4b08-b623-7496a908f4d3",
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "3e402e46-f5f9-432f-bee1-9b7c5f98c2b4",
      "name": "Obtener Contactos",
      "type": "n8n-nodes-base.airtableTool",
      "disabled": true,
      "position": [
        760,
        280
      ],
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "36d8be2b-76a9-4ee1-b42e-185d867552e8",
      "name": "Registro",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1160,
        0
      ],
      "parameters": {},
      "typeVersion": 4.5
    },
    {
      "id": "54800e58-3348-4ea7-b1f2-f3b330441add",
      "name": "Crear Evento",
      "type": "n8n-nodes-base.googleCalendarTool",
      "disabled": true,
      "position": [
        860,
        280
      ],
      "parameters": {},
      "typeVersion": 1.3
    },
    {
      "id": "ce41257e-356f-4b7a-b92e-90a766a29ce5",
      "name": "Limpiar",
      "type": "n8n-nodes-base.code",
      "position": [
        1020,
        0
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "a91da594-54cc-4bba-83ae-db4a3d5a6aa6",
      "name": "Errores",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1160,
        280
      ],
      "parameters": {},
      "typeVersion": 4.5
    },
    {
      "id": "431a8770-0a6b-4d63-ad40-2be04216ebdc",
      "name": "Respuesta de Error",
      "type": "n8n-nodes-base.telegram",
      "position": [
        1720,
        280
      ],
      "webhookId": "4129bcc4-aa42-4404-8cf4-9731422f7e86",
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "b649cc8a-4814-4730-a18a-ed3a40c79701",
      "name": "Respuesta",
      "type": "n8n-nodes-base.telegram",
      "position": [
        1720,
        0
      ],
      "webhookId": "e71223d1-8880-4a0f-98b1-d7b002378954",
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "e86b5d5d-05a2-46f9-82a7-1fca39ec88ce",
      "name": "Nota Adhesiva",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -680,
        -120
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "4277b9b8-2be1-4e7a-a89e-e446287007df",
      "name": "Nota Adhesiva1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        460,
        -120
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "540d74a0-e4e8-426d-b39f-5553ffd8d203",
      "name": "Nota Adhesiva2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        460,
        180
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "f8fdc426-f97e-4d51-affe-7443b368d3a5",
      "name": "Nota Adhesiva3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        640,
        180
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "1bb5794e-82ff-4d59-a640-db42fd043604",
      "name": "Nota Adhesiva4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        980,
        -120
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "13b54670-f5c8-4ffd-b746-0f3a8e5301d2",
      "name": "Nota Adhesiva5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        980,
        180
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "46aa0a5e-719f-4e15-9723-60a02bdc82c8",
      "name": "Limpiar",
      "type": "n8n-nodes-base.code",
      "position": [
        1020,
        280
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "e48dbb12-ddd1-4891-84b2-5afbfe5eab28",
      "name": "Nota Adhesiva6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1320,
        -120
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "e7435546-bbc0-4d9c-9e11-23f882cb0077",
      "name": "Agente de IA",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "onError": "continueErrorOutput",
      "position": [
        580,
        -20
      ],
      "parameters": {},
      "typeVersion": 1.9
    },
    {
      "id": "07cf1d5a-7f4f-4827-bf33-fa4deca0fb8b",
      "name": "Nota Adhesiva8",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1220,
        -120
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "eafbda63-9d18-4c5b-8528-ec6f99b6d513",
      "name": "Evolution API",
      "type": "n8n-nodes-base.webhook",
      "position": [
        -620,
        80
      ],
      "webhookId": "08b83c00-ab4b-4753-8415-93168690ce57",
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "631e3652-49d3-4a53-8f8f-44baab5fc4fb",
      "name": "Obtener Medios",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -20,
        -20
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "85ae2fa7-17af-408f-9c98-03ca6e8c8e57",
      "name": "Nota Adhesiva19",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -300,
        -120
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "4a23d554-a01f-4eed-9325-01a9d8464279",
      "name": "Nota Adhesiva20",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -60,
        -120
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "3195e145-a460-40b0-92e4-aba90f60ee42",
      "name": "Separación de Audio o Texto",
      "type": "n8n-nodes-base.if",
      "position": [
        -240,
        0
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "73ec0645-70f4-40d2-abe2-14a64dc1bcff",
      "name": "Convertir a Archivo",
      "type": "n8n-nodes-base.convertToFile",
      "position": [
        120,
        -20
      ],
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "8f4c5346-4a0f-4f48-b2a7-00863d7305db",
      "name": "Transcripción de Audio",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        260,
        -20
      ],
      "parameters": {},
      "typeVersion": 1.6
    },
    {
      "id": "b338cf7b-1a87-4a66-8b20-e20357dc81fd",
      "name": "Telegram",
      "type": "n8n-nodes-base.telegramTrigger",
      "position": [
        -620,
        260
      ],
      "webhookId": "dcfa2f69-f5d4-4f3d-926f-d14f6e3e59f3",
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "30d66342-6afb-4bc6-801e-b04359204feb",
      "name": "Nota Adhesiva21",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -60,
        180
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "72bd6f8f-ebad-4f38-8028-520fb76d6f6c",
      "name": "Filtro",
      "type": "n8n-nodes-base.filter",
      "position": [
        260,
        280
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "733a7a45-b428-4bc9-806b-16a08749e8eb",
      "name": "Mapeo de Texto",
      "type": "n8n-nodes-base.set",
      "position": [
        -20,
        280
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "96e1ec07-f9d5-4d7f-93ba-fb20b94fec6e",
      "name": "Modelo de Chat",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenRouter",
      "position": [
        500,
        300
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "c0b0c08a-01f5-4c18-a4f4-c930e3bfc6ed",
      "name": "Fuente de Entrada",
      "type": "n8n-nodes-base.switch",
      "position": [
        1340,
        -20
      ],
      "parameters": {},
      "typeVersion": 3.2
    },
    {
      "id": "96279412-1dad-4af2-a327-280f9cd8e866",
      "name": "Mapa",
      "type": "n8n-nodes-base.set",
      "position": [
        -480,
        80
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "614e597e-e7a5-4296-be51-d3b9649d00f8",
      "name": "Mapa1",
      "type": "n8n-nodes-base.set",
      "position": [
        -480,
        260
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "be1d7967-70bd-403b-8d1f-7b3949ae7deb",
      "name": "WhatsApp",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1560,
        -80
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "c6cb3ba8-0655-405d-b440-563f2c7f2de6",
      "name": "WhatsApp Error",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1560,
        200
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "a375dd86-192c-4bc8-b62f-d92a17c6d0c2",
      "name": "Nota Adhesiva7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1320,
        180
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "bd7b5899-0060-4cf9-a776-486c94186124",
      "name": "Fuente de Entrada1",
      "type": "n8n-nodes-base.switch",
      "position": [
        1340,
        260
      ],
      "parameters": {},
      "typeVersion": 3.2
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "d3370083-c273-4631-83e3-9df174874430",
  "connections": {
    "36d8be2b-76a9-4ee1-b42e-185d867552e8": {
      "main": [
        [
          {
            "node": "c0b0c08a-01f5-4c18-a4f4-c930e3bfc6ed",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "96279412-1dad-4af2-a327-280f9cd8e866": {
      "main": [
        [
          {
            "node": "3195e145-a460-40b0-92e4-aba90f60ee42",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "614e597e-e7a5-4296-be51-d3b9649d00f8": {
      "main": [
        [
          {
            "node": "733a7a45-b428-4bc9-806b-16a08749e8eb",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "a91da594-54cc-4bba-83ae-db4a3d5a6aa6": {
      "main": [
        [
          {
            "node": "bd7b5899-0060-4cf9-a776-486c94186124",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "72bd6f8f-ebad-4f38-8028-520fb76d6f6c": {
      "main": [
        [
          {
            "node": "e7435546-bbc0-4d9c-9e11-23f882cb0077",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "e7435546-bbc0-4d9c-9e11-23f882cb0077": {
      "main": [
        [
          {
            "node": "46aa0a5e-719f-4e15-9723-60a02bdc82c8",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "46aa0a5e-719f-4e15-9723-60a02bdc82c8",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "46aa0a5e-719f-4e15-9723-60a02bdc82c8": {
      "main": [
        [
          {
            "node": "a91da594-54cc-4bba-83ae-db4a3d5a6aa6",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "b338cf7b-1a87-4a66-8b20-e20357dc81fd": {
      "main": [
        [
          {
            "node": "614e597e-e7a5-4296-be51-d3b9649d00f8",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "631e3652-49d3-4a53-8f8f-44baab5fc4fb": {
      "main": [
        [
          {
            "node": "73ec0645-70f4-40d2-abe2-14a64dc1bcff",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "96e1ec07-f9d5-4d7f-93ba-fb20b94fec6e": {
      "ai_languageModel": [
        [
          {
            "node": "e7435546-bbc0-4d9c-9e11-23f882cb0077",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "bbfc6da2-6c99-4907-b46f-a32df9308aef": {
      "ai_tool": [
        [
          {
            "node": "e7435546-bbc0-4d9c-9e11-23f882cb0077",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "54800e58-3348-4ea7-b1f2-f3b330441add": {
      "ai_tool": [
        [
          {
            "node": "e7435546-bbc0-4d9c-9e11-23f882cb0077",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "3e402e46-f5f9-432f-bee1-9b7c5f98c2b4": {
      "ai_tool": [
        [
          {
            "node": "e7435546-bbc0-4d9c-9e11-23f882cb0077",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "c0b0c08a-01f5-4c18-a4f4-c930e3bfc6ed": {
      "main": [
        [
          {
            "node": "be1d7967-70bd-403b-8d1f-7b3949ae7deb",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "b649cc8a-4814-4730-a18a-ed3a40c79701",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "733a7a45-b428-4bc9-806b-16a08749e8eb": {
      "main": [
        [
          {
            "node": "72bd6f8f-ebad-4f38-8028-520fb76d6f6c",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "eafbda63-9d18-4c5b-8528-ec6f99b6d513": {
      "main": [
        [
          {
            "node": "96279412-1dad-4af2-a327-280f9cd8e866",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "bd7b5899-0060-4cf9-a776-486c94186124": {
      "main": [
        [
          {
            "node": "c6cb3ba8-0655-405d-b440-563f2c7f2de6",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "431a8770-0a6b-4d63-ad40-2be04216ebdc",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "73ec0645-70f4-40d2-abe2-14a64dc1bcff": {
      "main": [
        [
          {
            "node": "8f4c5346-4a0f-4f48-b2a7-00863d7305db",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "8f4c5346-4a0f-4f48-b2a7-00863d7305db": {
      "main": [
        [
          {
            "node": "733a7a45-b428-4bc9-806b-16a08749e8eb",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "3195e145-a460-40b0-92e4-aba90f60ee42": {
      "main": [
        [
          {
            "node": "631e3652-49d3-4a53-8f8f-44baab5fc4fb",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "733a7a45-b428-4bc9-806b-16a08749e8eb",
            "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, Operaciones de TI

¿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 nodos37
Categoría3
Tipos de nodos18
Descripción de la dificultad

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

Autor
Amanda Benks

Amanda Benks

@amanda

Hi loves! I've been making workflows for n8n for two years, and I hope you like my flows <3

Enlaces externos
Ver en n8n.io

Compartir este flujo de trabajo

Categorías

Categorías: 34