Start free

OpenAI connector · API cost reports

Read & reportRead-only source

See what your OpenAI usage costs, day by day.

Bring your OpenAI organization’s daily spend and token usage into your reports and AI assistants, with costs by line item and tokens by model.

  • Track daily OpenAI spend by line item
  • Compare input, cached and output tokens by model
  • Ask ChatGPT or Claude which models drive your bill
OpenAISheetsSheetsData StudioData StudioChatGPTChatGPTClaudeClaude

Start free Explore the data

Updated November 2026

OpenAI reportSample data
DateModelInput tokens
2026-11-10gpt-4.118,402,115
2026-11-10gpt-4.1-mini64,920,301
2026-11-11gpt-4.117,055,920
Refreshes on your schedule in Google Sheets

OpenAI reporting for one organization

One OpenAI organization is the data source. Costs and usage follow your report dates in UTC days; projects show the organization as it is now.

Organization costs

Read daily spend by line item, in the currency you are billed in.

Token usage

See daily input, cached input and output tokens and request counts by model for completions.

Projects

List every project with status and creation date, including archived ones.

Cost trends

Compare spend week by week to catch jumps early.

Report datasets and details

Reports you can build

3 reporting datasets, each with its own fields. Pick one in the app, then choose your columns.

  • Organization costs
  • Token usage
  • Projects
What each dataset reports
  • Organization costs

    Daily OpenAI organization spend in the report dates by line item, in the billed currency.

  • Token usage

    Daily OpenAI completion token usage and request counts by model in the report dates.

  • Projects

    OpenAI projects in your organization, including archived ones.

Metrics and dimensions

11 report fields across 3 datasets.

Search the available fields. Hover or tap a field to see what it means.

Send OpenAI data anywhere

Connect OpenAI usage to ChatGPT or Claude for cost questions

Use Datapipe’s MCP access as your OpenAI cost reporting tool. Ask about spend, tokens and models.

Example

Which OpenAI models used the most output tokens last month?

Add up last month’s output tokens by model, then sort from highest to lowest and compare with daily spend.

Start with OpenAI

What you need

An OpenAI Admin key from Settings, Organization, Admin keys. Admin keys are created by an organization owner; ordinary project keys can’t read costs or usage.

What to know

Read-only. Datapipe never calls a model, so it adds nothing to your bill. Token usage covers completions; other usage types aren’t included. One report reads up to 20,000 rows.

How it works

  1. Create your free account, then choose OpenAI in Data sources.

  2. Paste your OpenAI Admin key.

  3. Choose a report and destination: a sheet, Data Studio, ChatGPT or Claude.

Works well with OpenAI

Add both to the same project. Each keeps its own report, so you can check them side by side or ask ChatGPT or Claude a question that needs both.

Questions

Datapipe reads your organization’s daily costs by line item, daily completion token usage by model and your projects.

An Admin key, created by an organization owner under Settings, Organization, Admin keys. Project keys can’t read costs or usage.

No. It only reads cost and usage reports and never calls a model.

UTC, as OpenAI reports them.

Free to start. Paid plans add more data sources and refresh faster.

Free and Starter refresh once a day. Pro refreshes every hour. Agency refreshes every 15 minutes on the first 50 data sources.

One for each OpenAI account you add to a project. Adding the same account to another project counts again. Reports and destinations do not use extra data sources.

Keep AI spend in view.

Start free, add OpenAI and bring its costs into the tools you already use.

Start free See setup requirements