Track AI Agent token usage and estimate costs in Google Sheets

Go to Workflow
1,818 views
Built by Solomon Solomon
Created on June 05, 2026

Description


This n8n template demonstrates how to obtain token usage from AI Agents and places the data into a spreadsheet that calculates the estimated cost of the execution.

Obtaining the token usage from AI Agents is tricky, because it doesn't provide all the data from tool calls. This workflow taps into the workflow execution metadata to extract token usage information.

Works well with OpenAI, Google and Anthropic. Other LLM providers might need small tweaks.

How it works
The AI Agent executes and then calls a subworkflow to calculate the token usage.
The data is stored in Google Sheets
The spreadsheet has formulas to calculate the estimated cost of the execution.

How to use
The AI Agent is used as an example. Feel free to replace this with other agents you have.
Call the subworkflow AFTER all the other branches have finished executing.

Requirements
LLM account (OpenAI, Gemini...) for API usage.
Google Drive and Sheets credentials
n8n API key of your instance

Nodes Used (6)

AI Agent
@n8n/n8n-nodes-langchain.agent
Anthropic Chat Model
@n8n/n8n-nodes-langchain.lmChatAnthropic
Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini
Google Sheets
n8n-nodes-base.googleSheets
OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi
Think Tool
@n8n/n8n-nodes-langchain.toolThink