⚒️ 📊 AI token tracker for WhatsApp & Telegram – Save AI usage to Google Sheets

⚡ 651 views · ⚒️ Engineering

Description

💸 GPT-4o Token Tracker – Measure AI Usage and Cost via WhatsApp or Telegram

Hi! I’m Amanda — I create smart, useful AI automations for n8n and Make.
This workflow helps you monitor how many tokens are consumed per conversation with AI Agent Tokens, and logs that usage into Google Sheets — so you can track expenses and make smarter decisions about your AI usage.

You can connect it to Telegram or WhatsApp (via Evolution API), and it will automatically capture:

• Prompt and completion tokens
• Total tokens
• Time of interaction
• The user/channel
• (Optional) Cost estimate in USD

📊 What this workflow does

• Logs token usage from LangChain agents
• Calculates token totals for each request
• Appends the data to a structured Google Sheet
• Works with WhatsApp (Evolution API) or Telegram bots
• Ideal for tracking AI Agent Tokens usage over time and controlling costs

🧪 Free Spreadsheet Template

You can duplicate and use this template for logging token usage:
👉 Google Sheets Template

Includes columns like:

• Date
• Input
• Output
• Tokens (Prompt / Completion / Total)
• Tool name or use case
• Estimated cost

🛠️ Setup Instructions

1. Import the workflow to your n8n (Cloud or self-hosted)
2. Connect your Google Sheets account
3. Choose your trigger:
   • WhatsApp (Evolution API webhook)
   • Telegram (Bot webhook or message input)
4. Fill out:
   • AI Agent model used (e.g. gpt-4o)
   • Cost per 1K tokens (optional, for USD estimation)
5. Update spreadsheet ID and tab name in the Google Sheets node
6. (Optional) Connect as a sub-tool to an AI agent for automatic logging

🧰 Tech Used

• OpenRouter
• LangChain
• Google Sheets
• Telegram or WhatsApp webhook (Evolution API)
• Nodes: HTTP Request, Set, If, Google Sheets, Merge

✅ Who This Is For

• Developers or agencies that want to monitor AI Agent Tokens usage
• Freelancers managing AI bots for clients
• Teams that need billing visibility and cost control
• Anyone who wants transparency in AI token spending

✅ Requirements

• OpenAI GPT-4o access
• Google Sheets credential
• Telegram Bot Token (or Evolution API access for WhatsApp)
• n8n (Cloud or self-hosted)

🌐 Want this template?

❤️ Buy more workflows at: https://iloveflows.com
☁️ Try n8n Cloud: https://n8n.partnerlinks.io/amanda

🔗 Nodes Used

Google Sheets, HTTP Request, Webhook, Telegram, Telegram Trigger, Filter

📥 Import

Download workflow.json and import into n8n: Workflow menu → Import from File

📖 Importing guide · 🔑 Credential setup