All templates

Automated OpenAI API Spend Tracking

Every morning, WebRun opens the OpenAI Platform usage dashboard, reads yesterday's API spend and the month-to-date total against your budget, logs the daily figure as a new row in Google Sheets, and updates a Notion status doc whenever spend is on pace to exceed the monthly budget before it resets.

Runs on WebRun · Strict Lockdown policy
Every day at 8:00 AM WebRunorchestrates each step
1 OpenAI Platform check API usage and spend
2 Google Sheets log daily spend
3 Notion update the budget status
In short

How do I track OpenAI API spend before it goes over budget?

Every morning, WebRun checks the OpenAI Platform usage dashboard for yesterday's API spend and the month-to-date total, logs the figure as a new row in Google Sheets, and updates a Notion status doc showing whether spend is on pace to stay within budget, so an overage gets caught with weeks to act, not on the invoice.

  • Budget overruns get caught with weeks to react, not on the invoice
  • Daily spend history builds up automatically in one sheet
  • The team always has a current answer to how spend is trending

Built for developer teams · AI product teams · startup founders · engineering managers

Step by step

What does WebRun do on every run?

The exact actions WebRun takes, in order - in plain language, so you can adjust anything.

  1. WebRun signs in and gets to work

    Opens platform.openai.com in a real browser with your saved login - no setup, no API keys.

  2. 1
    OpenAI Platform - check API usage and spend
    platform.openai.com
    WebRun in OpenAI Platform: check API usage and spend
    WebRun opens OpenAI Platform to check API usage and spend.
    • Open the OpenAI Platform usage dashboard
    • Read yesterday's spend and the month-to-date total
    • Compare month-to-date spend against your set monthly budget

    Done when Yesterday's spend and the month-to-date total are captured.

  3. 2
    Google Sheets - log daily spend
    google.com
    WebRun in Google Sheets: log daily spend
    WebRun opens Google Sheets to log daily spend.
    • Open the API spend tracker in Google Sheets
    • Add a new row with yesterday's spend and the running month-to-date total
    • Keep prior days in place so the spend trend is visible

    Done when Yesterday's spend is logged alongside the running history.

  4. 3
    Notion - update the budget status
    notion.so
    WebRun in Notion: update the budget status
    WebRun opens Notion to update the budget status.
    • Open the budget status doc in Notion
    • Update it to show whether spend is on, under, or over the pace needed to stay within budget
    • Add a note naming the projected month-end total

    Done when The Notion status doc reflects today's budget pace.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
platform.openai.com
ScheduleRuns automatically on this cadence
Every day at 8:00 AM
DeliveryHow each run's result reaches you
Spend status · Notion
OutputWhat each run produces - A daily spend row in Google Sheets and a Notion status doc showing whether OpenAI API spend is on pace to stay within budget.
Spreadsheet
Setup & safety

Secure by default

Connect once, stays signed in

WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.

Your credentials stay in your own private environment - WebRun never stores your passwords.
Strict Lockdown

Every action is checked against this policy before it runs.

Domains ALLOWLIST
Typed input ALLOW
Shell command BLOCK
File uploads BLOCK
Runs in a contained environment More on policies
Good to know

Questions, answered

Does it set spend limits or cap API keys for me?

No. WebRun only reads usage and reports it. Setting a hard spend limit or disabling a key stays your decision inside OpenAI Platform.

How does it know spend is on pace to go over?

It compares the month-to-date total against your set monthly budget and the days remaining in the cycle, and projects the month-end total from that pace.

Can I see spend trends over the past months?

Yes. Every day adds a row to the same Google Sheets tracker, so the daily and monthly spend trend is easy to review.

Put this on autopilot.

Turn it on in minutes - or have our team set it up for you.