Automated OpenAI Usage & Cost Tracking to Google Sheets

This workflow automates the process of monitoring OpenAI API usage and costs, and logs the results into Google Sheets for easy tracking and analysis. It begins with a scheduled trigger that activates daily, then makes HTTP requests to retrieve API token usage and cost details from the OpenAI admin API. The data is de-duplicated, structured, and combined with project information, then split into usage and cost data. These are further formatted and appended into designated Google Sheets tabs. The workflow also includes optional steps like retrieving detailed project and API key info, making it highly adaptable for ongoing monitoring. It’s ideal for organizations that need regular, automated insights into their OpenAI API consumption and expenses, ensuring better cost control and resource management.