Track OpenAI Token Usage and AI Agent Metrics with Google Sheets Dashboard
Last edited 58 days ago
What it does
Captures token usage and cost from your AI Agent/LLM. Logs model, tokens, cost, tool use, and conversation I/O to Google Sheets for simple observability and billing.
Perfect for
Developers adding usage monitoring to AI agents.
Teams needing cost transparency in prototypes.
How it works
- Chat Trigger collects user input for the AI Agent.
- A Set node injects metadata like workflow, execution, and client IDs.
- LangChain Code node returns a configured Chat model with a callback that reads usage metadata.
- The callback computes input, output, and total costs based on per‑million token prices you define.
- It appends token metrics to a Google Sheet via the Google Sheets Tool.
- The Agent records intermediate tool calls.
- An If node checks whether a tool was used.
- When tools are used, the workflow logs input, output, tool name, and metadata to an Observability sheet.
How to use
SELF-HOSTED N8N ONLY - the Langchain Code node is only available in the self-hosted version of n8n. It is not available in n8n cloud.
Requirements
Self-hosted version of n8n
If you have any questions in running the workflow, see the attached video: https://youtu.be/JSulRS128MA
You may also like
New to n8n?
Need help building new n8n workflows? Process automation for you or your company will save you time and money, and it's completely free!
