All templates

Automated OpenRouter Usage and Cost Report

Every Monday, WebRun opens OpenRouter, reviews the past week's usage and spend broken down by model, exports the totals into a running Google Sheets tracker, and emails your team a short summary so nobody is surprised by the bill.

Runs on WebRun · Strict Lockdown policy
Every Monday at 8:00 AM WebRunorchestrates each step
1 OpenRouter review weekly usage and spend
2 Google Sheets log the totals by model
3 Gmail email the team a summary
In short

How do I track my weekly OpenRouter usage and spend by model?

WebRun reviews your OpenRouter usage every Monday, breaking down the past week's spend and request volume by model. It logs the totals into a running Google Sheets tracker and emails your team a short summary that calls out any model with a sharp cost increase, so nobody is surprised by the bill.

  • Cost spikes get flagged the same week they happen
  • Every week's spend by model is tracked in one running sheet
  • Your team gets a summary in their inbox instead of digging through a dashboard

Built for AI engineering teams · startups building on LLMs · product teams · finance and ops

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 openrouter.ai in a real browser with your saved login - no setup, no API keys.

  2. 1
    OpenRouter - review weekly usage and spend
    openrouter.ai
    WebRun in OpenRouter: review weekly usage and spend
    WebRun opens OpenRouter to review weekly usage and spend.
    • Open OpenRouter and check the usage dashboard for the past week
    • Note total spend and request volume broken down by model
    • Flag any model whose spend jumped sharply versus the week before

    Done when The week's usage and spend by model has been reviewed.

  3. 2
    Google Sheets - log the totals by model
    google.com
    WebRun in Google Sheets: log the totals by model
    WebRun opens Google Sheets to log the totals by model.
    • Open the usage tracker sheet
    • Add a new row with the week's totals by model
    • Keep a running month-to-date total at the top

    Done when The week's totals are logged in Google Sheets.

  4. 3
    Gmail - email the team a summary
    gmail.com
    WebRun in Gmail: email the team a summary
    WebRun opens Gmail to email the team a summary.
    • Email your team a short summary of the week's spend and top models
    • Call out any model with a sharp increase
    • Link to the full Google Sheets tracker for detail

    Done when Your team has this week's summary in their inbox.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
openrouter.ai
ScheduleRuns automatically on this cadence
Every Monday at 8:00 AM
DeliveryHow each run's result reaches you
Usage summary · Gmail
OutputWhat each run produces - A weekly summary of OpenRouter spend and usage by model, with a link to the full tracker.
Text
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 change my model settings or spending limits?

No. It only reads your usage and reports it. Changing models, rate limits, or budgets is always your call.

Who receives the email summary?

Only your own team's inbox, whatever address you set up. It is never sent outside your organization.

How does it flag a spend spike?

It compares each model's weekly spend against the previous week and calls out any jump, so a cost increase gets noticed the same week it happens.

Put this on autopilot.

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