Skip to content
NEWMarketplace and the trig8n Agent: sell what you build, and get plans and changes that are tested before you see them. See what is new

Library / Reports, Analytics & Dashboards

Reports, Analytics & Dashboards

Track OpenAI API Usage and Costs in Google Sheets

On a schedule, this pulls token usage and costs from the OpenAI Admin API per project and key and logs them to Google Sheets.

Import it free Sign in to open it

The steps

  1. Schedule Trigger
  2. OpenAI Admin - get token usage
  3. OpenAI Admin - Get cost
  4. Remove Duplicates
  5. Set api_key and project ids
  6. Set api_key id and name
  7. Add api_key name to token usage
  8. Get project_ids
  9. Merge token, usage, projects
  10. Merge token and usage
  11. Structure usage, cost, projects
  12. Split Out api_key and project
  13. Split Out Usage
  14. Split Out Cost

26 steps in total.

Similar automations

Monitoring, Ops & IncidentsTrack AI Agent Token Usage and Costs in Sheets13 stepsWeb Scraping & ResearchTrack Daily PG&E Energy Costs and Email Them14 stepsWeb Scraping & ResearchTrack Daily PG&E Energy Costs with Airtop15 stepsMonitoring, Ops & IncidentsTrack AI Token Usage for WhatsApp and Telegram Agents25 steps