Track OpenAI Costs: Usage & Keys in Google Sheets

# Automated tracking of OpenAI token usage and costs in Google Sheets

This automation workflow enables regular, hands-free collection, structuring, and logging of OpenAI token usage and cost data from API keys and projects. Ideal for budget control, financial reporting, and operational oversight in teams using OpenAI at scale.

## Who it´s for
- OpenAI administrators monitoring team-wide token usage
- Financial analysts managing AI API spending
- Technical leads overseeing multiple OpenAI projects
- Companies with numerous API keys requiring centralized tracking

## What the automation does
- Triggered on a schedule via cron
- Fetches usage and cost data from OpenAI Admin API
- Retrieves details per API key and project
- Merges, deduplicates, and enriches data with names
- Structures records for clear reporting
- Appends final usage and cost entries to separate sheets in Google Sheets

## What´s included
- Ready-to-use n8n workflow
- Cron-based trigger logic
- Integrations with OpenAI Admin API and Google Sheets API
- Basic text instructions for setup and adaptation

## Requirements for setup
- n8n account (cloud or self-hosted)
- OpenAI account with admin access and active API keys
- Google account with access to Google Sheets
- Valid API credentials and permissions to read usage data

## Benefits and outcomes
- Full visibility into OpenAI spending
- Eliminates manual data collection efforts
- Enables detection of anomalies or token leaks
- Supports data-driven budget optimization
- Enables scheduled, human-free reporting
- Centralized, structured data storage in Google Sheets

## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via chat