🔬 Track OpenAI Admin API usage and costs automatically with Google Sheets

⚡ 219 views · 🔬 Document Extraction & Analysis

Description

Overview

This workflow aims to help you and your team track your expenses with OpenAI It automatically collects your OpenAI organization’s API usage and cost data every few days and saves it to a ready-to-use Google Sheets template. It pulls detailed metrics for every project and API key, including token usage, model breakdowns, and costs per line item, making it easy for your team to analyze and track spend over time!

Who is it for

• Finance or ops teams tracking AI usage and spend
• Data/analytics teams needing detailed project-level breakdowns
• Technical leads or admins managing OpenAI organization usage and cost
• Anyone needing a simple audit trail or historical record of OpenAI API activity

How to get started

• Access to your organization’s OpenAI Admin API key -> Note: it’s a different API than the one you use to call the models.
• Add your credentials in all OpenAI Admin nodes as Predefined Credentials > OpenAI.
• Create your Google Sheets credentials
• Get the Google Sheets template (copy to your Drive)

How it works

1. Trigger: The workflow runs automatically on a schedule (every 3 days by default, but you can adjust).
2. Fetch Data: Calls OpenAI’s Admin API to get all token usage and cost details for the reporting window.
3. Enrich Data: Resolves project names and API key names for clarity in reports.
4. Write to Sheets: Appends new usage and cost data to your Google Sheet, with one row per project/key/period.

Google Sheets Template

• Use our template to track OpenAI’s cost and usage

Notes

• All data is appended, so your sheet keeps historical records. But ⚠️ if you run the workflow manually or change the schedule, you could end up with duplicated rows
• API key and project enrichment makes reports easier to read.
• You can adapt the workflow to save results anywhere: BigQuery, Airtable, DB, or even another spreadsheet.
• Easy to change schedule or reporting window to fit your team’s needs.

Extra

• Depending on your internal processes, you could also generate monthly files and automatically send the report to your finance team via email or Slack, for example. The possibilities are endless!
• Note that we intended to do the same with Anthropic and Gemini via API and n8n built-in methods. At this stage, it is not possible to do it, but it could probably be done using Browser Agents!

Service

If you need help implementing the template or modifying it, just reach out 💌

🔗 Nodes Used

Google Sheets, HTTP Request, Schedule Trigger

📥 Import

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

📖 Importing guide · 🔑 Credential setup