Start free
Read & reportRead-only source

See your OpenAI numbers in Data Studio.

Review OpenAI daily API costs, completion token counts and projects in a read-only data source.

  • Traffic, sources and conversions in a sheet or dashboard, refreshed for you
  • A weekly traffic report nobody has to rebuild
  • Ask ChatGPT or Claude what changed, using live OpenAI numbers
OpenAIData StudioData Studio

Start free Connect OpenAI

Updated November 2026

OpenAI reportSample data
DateLine itemCurrency
2026-11-13gpt-4oUSD
Oct 28640640
Oct 29210210
Refreshes on your schedule in Data Studio

Who uses Datapipe with OpenAI

Marketers

See which channels and pages bring visitors who convert.

Founders

Get a weekly traffic summary without opening another dashboard.

Agencies

Send each client the same clean traffic report every month.

What you can do with OpenAI

Read and report

Read organization costs, token usage and projects using your OpenAI Admin key.

  • Organization costs
  • Token usage
  • Projects

Explore metrics and dimensions

Read-only source

Datapipe reads OpenAI data for reports. It never changes anything in OpenAI.

Full read details

Projects and keys are never modified.

Examples for your team

Read & report

Monitor OpenAI API spend and token consumption

Combine daily costs by line item and token usage by model in one report.

  1. Scheduled refresh
  2. Latest OpenAI data
  3. Updated report

Before you connect

What you need

An API key or token from your OpenAI account.

Read-only

Read access only. Datapipe never changes anything in OpenAI.

Limits and exclusions

Read-only. Projects and keys are never modified.

Full details and limits

Organization API spend, completion token usage, and projects from OpenAI.

Read-only reporting access using your OpenAI Admin API key. Projects and keys are never modified.

Read-only. No model is called, token usage covers completions, and days are in UTC.

Reports you can build

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

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.

Hover or tap a field to see what it means. Custom fields from your own account appear after you connect.

Send OpenAI data anywhere

Ask AI about your data

Claude or ChatGPT can read the same numbers. You ask in a normal sentence, and the answer stays with your report.

Summarize OpenAI organization costs and completion token counts by model.

OpenAI spend totaled $1,248.40 this week, led by gpt-4o with 42.6M input and 8.9M output tokens.

Better than exporting by hand

Start from a goal

How it works

  1. Create a project and choose OpenAI in Data sources.

  2. Pick where it goes. This one sends the numbers to Data Studio.

  3. Pick where it goes. Choose costs, token usage or projects and a destination.

Sample report

OpenAI reportSample data
DateLine itemCurrencySpendDateModelInput tokensCached input tokens
2026-11-13gpt-4oUSD$184.202026-11-131,2401,2401,240
Oct 28640640$125.50Oct 28640640640
Oct 29210210$42.00Oct 29210210210

Sample numbers, so you can see the shape. Your report uses your accounts.

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

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.

No. Name a project, add a data source, then choose a report and destination.

OAuth means you sign in with the service and grant access, without pasting an API key. Datapipe works with multiple partners to provide that sign-in. Some partners already provide it. Some integrations are API-only at present, so you paste a key or token. OAuth is coming soon for some. Some partners do not provide OAuth at all. The setup steps on each integration page say how that source connects. Signing in is only how the connection is made. It is not permission to change records. Where a source supports changes, those writes stay off until the workspace owner turns specific actions on and approves each one. We do not promise OAuth on every source, and we do not share dates.

This integration is read-only in Datapipe. You can report on OpenAI, send the reports to your destinations and ask an AI assistant about them. Datapipe never changes anything in OpenAI. Read-only reporting access using your OpenAI Admin API key. Projects and keys are never modified.

This page lists 11 report fields across 3 datasets. You pick the columns when you build the report.

Organization API spend, completion token usage, and projects from OpenAI. Account permissions and the records available from the provider determine which rows can be read.

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.

Yes. The same numbers can go to a sheet, a chart, a warehouse, or an assistant.

Try OpenAI with sample data first

Build the report first, then add OpenAI when you are ready.

Start free Add data source