AutomationFlowsData & Sheets › Token Estim8r UI – Visualize Token Usage Analytics Dashboard in N8n

Token Estim8r UI – Visualize Token Usage Analytics Dashboard in N8n

Original n8n title: 📊 Token Estim8r UI – Visualize Token Usage Analytics Dashboard in N8n

ByRealSimple Solutions @joeperes on n8n.io

Artwork Generated with ✨ ideoGener8r n8n workflow template

Webhook trigger★★★★★ complexity30 nodesGoogle SheetsHTTP Request
Data & Sheets Trigger: Webhook Nodes: 30 Complexity: ★★★★★ Added:

This workflow corresponds to n8n.io template #3529 — we link there as the canonical source.

This workflow follows the Google Sheets → HTTP Request recipe pattern — see all workflows that pair these two integrations.

The workflow JSON

Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →

Download .json
{
  "id": "0mKBxHjQ8S3Jr2GZ",
  "meta": {
    "templateCredsSetupCompleted": false
  },
  "name": "Token Estim8r EMPTY CODE",
  "tags": [
    {
      "id": "n7iHVPoDy5TG4oVr",
      "name": "utility",
      "createdAt": "2025-01-14T14:58:44.872Z",
      "updatedAt": "2025-01-14T14:58:44.872Z"
    },
    {
      "id": "pRdXyfp6n3bBMCdp",
      "name": "AI Token Usage",
      "createdAt": "2025-04-12T22:20:57.332Z",
      "updatedAt": "2025-04-12T22:20:57.332Z"
    }
  ],
  "nodes": [
    {
      "id": "43df953e-428d-4b42-b449-39d9763b8f13",
      "name": "Get AI Usage Data",
      "type": "n8n-nodes-base.code",
      "position": [
        -180,
        280
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "533ca2a3-6e48-4bc6-8a0c-779b4618f5b2",
      "name": "Set Ai_Run_Data",
      "type": "n8n-nodes-base.set",
      "position": [
        100,
        280
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "979f6a66-cfff-4df9-b0bd-3b7ace68149c",
      "name": "Get Models Price and Add Summary",
      "type": "n8n-nodes-base.code",
      "position": [
        740,
        280
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "72051d50-5715-478e-b6f6-f7678138fd9b",
      "name": "Google Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1040,
        280
      ],
      "parameters": {},
      "typeVersion": 4.5
    },
    {
      "id": "c582210d-671d-4be2-b26b-26a38c997671",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1860,
        140
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "6ee8b96f-67f7-4424-b6bb-baad3cc7004e",
      "name": "Sticky Note6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -940,
        1240
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "1b60cb57-3b44-4c07-9390-61f19204228d",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1860,
        -260
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "984da037-a7dd-452f-8326-f760f6d7016a",
      "name": "HTML",
      "type": "n8n-nodes-base.html",
      "position": [
        -460,
        500
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "3afc7727-6221-4b14-bc78-5bd8318b99c3",
      "name": "Respond to Webhook",
      "type": "n8n-nodes-base.respondToWebhook",
      "position": [
        100,
        500
      ],
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "2c0c8c1c-47ca-44dc-af32-a4a569ff5361",
      "name": "Google Sheets1",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -740,
        980
      ],
      "parameters": {},
      "typeVersion": 4.5
    },
    {
      "id": "b5c7912a-d7e9-4db6-af46-21e2c0fb399b",
      "name": "Respond to Webhook1",
      "type": "n8n-nodes-base.respondToWebhook",
      "position": [
        120,
        980
      ],
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "98e0ea0a-2f35-43ac-b4b1-ca4d99e6ede5",
      "name": "Wait",
      "type": "n8n-nodes-base.wait",
      "position": [
        -740,
        280
      ],
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "696dc1fd-303c-4f5c-8c48-cb5ebf445574",
      "name": "n8n - Get Execution",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -460,
        280
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "6e564cd6-0ac5-48f6-a654-9957d92e6a37",
      "name": "Send Token Estim8r Data",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -920,
        -120
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "3b3d0967-7604-4b80-87a4-16d3347e8eeb",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1160,
        -260
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "e3e80a96-bdf2-4272-82f1-b60b6b1254f6",
      "name": "Convert to File",
      "type": "n8n-nodes-base.convertToFile",
      "position": [
        -200,
        740
      ],
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "b1276cd4-f138-4a6e-b992-fd9371e28f4f",
      "name": "Respond to Webhook2",
      "type": "n8n-nodes-base.respondToWebhook",
      "position": [
        120,
        740
      ],
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "4d647c17-02f1-4bb8-9462-06f2f1152008",
      "name": "SetImageStrings",
      "type": "n8n-nodes-base.set",
      "position": [
        -740,
        740
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "f74c229e-59e7-47c8-bd47-3443797270a5",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1080,
        700
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "454dff82-dd9c-42ec-9956-c0e1da0c25a7",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1080,
        480
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "ba26f9ec-c75b-445f-a79d-8bddab260e30",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1080,
        240
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "7a8b4329-78ac-4dbc-ba0f-2a42e413b400",
      "name": "Sticky Note7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1080,
        940
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "19be06ed-3b81-41cd-959f-7efece3b3f46",
      "name": "SetPayload",
      "type": "n8n-nodes-base.set",
      "position": [
        -480,
        980
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "515af5eb-8a3e-4abf-b20a-6d3c3e2e7e4c",
      "name": "Aggregate Payload",
      "type": "n8n-nodes-base.aggregate",
      "position": [
        -200,
        980
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "97202826-e46a-4630-89b0-bf61a1eeff0e",
      "name": "Webhook Add Data",
      "type": "n8n-nodes-base.webhook",
      "position": [
        -1020,
        280
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "fef17245-9368-4b43-8aa1-fa9309280a24",
      "name": "Webhook UI",
      "type": "n8n-nodes-base.webhook",
      "position": [
        -1020,
        500
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "8b68662c-d6ec-4b7d-82bf-5287ff75f353",
      "name": "Webhook GetImage",
      "type": "n8n-nodes-base.webhook",
      "position": [
        -1020,
        740
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "8bed380b-c14c-461b-86bc-149f47e39c06",
      "name": "GetPayload",
      "type": "n8n-nodes-base.webhook",
      "position": [
        -1020,
        980
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "3ab90593-27b6-4786-94bb-b64bd2cf87ce",
      "name": "Get AI Pricing - Live",
      "type": "n8n-nodes-base.httpRequest",
      "onError": "continueRegularOutput",
      "position": [
        440,
        100
      ],
      "parameters": {},
      "retryOnFail": true,
      "typeVersion": 4.2
    },
    {
      "id": "82e360a2-8a83-4ea2-aa38-74535ab6bd37",
      "name": "Get AI Pricing - 2024-04",
      "type": "n8n-nodes-base.set",
      "position": [
        440,
        280
      ],
      "parameters": {},
      "typeVersion": 3.4
    }
  ],
  "active": true,
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "912897a7-6710-412c-8409-6ff66315ac7a",
  "connections": {
    "HTML": {
      "main": [
        [
          {
            "node": "Respond to Webhook",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Wait": {
      "main": [
        [
          {
            "node": "n8n - Get Execution",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "GetPayload": {
      "main": [
        [
          {
            "node": "Google Sheets1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "SetPayload": {
      "main": [
        [
          {
            "node": "Aggregate Payload",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Webhook UI": {
      "main": [
        [
          {
            "node": "HTML",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets1": {
      "main": [
        [
          {
            "node": "SetPayload",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Convert to File": {
      "main": [
        [
          {
            "node": "Respond to Webhook2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set Ai_Run_Data": {
      "main": [
        [
          {
            "node": "Get AI Pricing - 2024-04",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "SetImageStrings": {
      "main": [
        [
          {
            "node": "Convert to File",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Webhook Add Data": {
      "main": [
        [
          {
            "node": "Wait",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Webhook GetImage": {
      "main": [
        [
          {
            "node": "SetImageStrings",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Aggregate Payload": {
      "main": [
        [
          {
            "node": "Respond to Webhook1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get AI Usage Data": {
      "main": [
        [
          {
            "node": "Set Ai_Run_Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "n8n - Get Execution": {
      "main": [
        [
          {
            "node": "Get AI Usage Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get AI Pricing - 2024-04": {
      "main": [
        [
          {
            "node": "Get Models Price and Add Summary",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Models Price and Add Summary": {
      "main": [
        [
          {
            "node": "Google Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
Pro

For the full experience including quality scoring and batch install features for each workflow upgrade to Pro

About this workflow

Artwork Generated with ✨ ideoGener8r n8n workflow template

Source: https://n8n.io/workflows/3529/ — original creator credit. Request a take-down →

More Data & Sheets workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.

Data & Sheets

[SANTOBET] FLUXO TODO - BACKUP. Uses googleSheets, httpRequest, googleSheetsTrigger. Webhook trigger; 57 nodes.

Google Sheets, HTTP Request, Google Sheets Trigger
Data & Sheets

FLUXO DISPARO DATA E HORA. Uses itemLists, googleSheets, httpRequest. Webhook trigger; 48 nodes.

Item Lists, Google Sheets, HTTP Request
Data & Sheets

This workflow allows you to accept online payments via YooKassa and log both orders and transactions in Google Sheets — all without writing a single line of code. It supports full payment flow: produc

Google Sheets, HTTP Request
Data & Sheets

Transform your n8n instance management with this advanced automation system featuring artificial intelligence-driven workflow selection. This template provides comprehensive maintenance operations wit

n8n, HTTP Request, Google Sheets +1
Data & Sheets

Nexus_v6(ล่าสุดจริงๆ)ล่าสุดไกไก. Uses googleSheets, httpRequest. Webhook trigger; 41 nodes.

Google Sheets, HTTP Request