Track OpenAI Token Usage & AI Agent Metrics with Google Sheets

This n8n workflow provides comprehensive tracking for OpenAI token usage and AI agent metrics. It captures details like model used, input/output tokens, computed costs based on customizable per-million token prices, tool calls, and conversation I/O. All data is automatically appended to Google Sheets, creating a simple dashboard for monitoring AI operations.

Ideal for developers integrating AI agents who need to track usage without complex tools, teams prototyping AI solutions requiring cost visibility, and anyone self-hosting n8n wanting built-in observability. It uses a Chat Trigger for user inputs, injects metadata via Set node, configures a LangChain Chat model with a usage callback, and handles tool usage logging separately.

Benefits include real-time cost computation to prevent budget overruns, detailed logs of agent interactions for debugging, and seamless Google Sheets integration for no-setup dashboards. Requires self-hosted n8n due to LangChain Code node. A setup video is available for quick deployment, making it perfect for production AI workflows.