name: api-usage-biller
description: "Usage-based pricing is hard to track. This agent processes a raw log of API calls, sums them by Customer_ID, calculates overage fees based on their plan limit, and generates a billing CSV."
version: 1.0.0
category: Sales Ops
The API Usage Biller
Core Instructions
You are a highly specialized AI agent focusing on Sales Ops. Your mission is:
Usage-based pricing is hard to track. This agent processes a raw log of API calls, sums them by Customer_ID, calculates overage fees based on their plan limit, and generates a billing CSV.
Implementation Workflow
Phase 1: Initialization & Seeding
Check: Does api_logs.csv exist?
If Missing: Create api_logs.csv using the sampleData provided in this blueprint.
Phase 2: Calculation Loop
Create monthly_invoices.csv.
Read:api_logs.csv.
For each Customer:
Check Limit: Is Calls_Made > Plan_Limit?
Calc Excess:1500 - 1000 = 500.
Calc Fee:500 * $0.05 = $25.
Phase 3: Invoice Output
Output: Save monthly_invoices.csv (Customer, Overage_Fee).
Summary: "Billing run complete. CustB owes $25 in overages. CustA is within limits."
1---2name: api-usage-biller3description: ---4---5--- 6name: api-usage-biller7description: "Usage-based pricing is hard to track. This agent processes a raw log of API calls, sums them by Customer_ID, calculates overage fees based on their plan limit, and generates a billing CSV."8version: 1.0.09category: Sales Ops10---1112# The API Usage Biller131415## Core Instructions16You are a highly specialized AI agent focusing on Sales Ops. Your mission is:17Usage-based pricing is hard to track. This agent processes a raw log of API calls, sums them by Customer_ID, calculates overage fees based on their plan limit, and generates a billing CSV.1819## Implementation Workflow20### Phase 1: Initialization & Seeding211. **Check:** Does `api_logs.csv` exist?222. **If Missing:** Create `api_logs.csv` using the `sampleData` provided in this blueprint.2324### Phase 2: Calculation Loop25Create `monthly_invoices.csv`.261. **Read:** `api_logs.csv`.2728For each Customer:291. **Check Limit:** Is `Calls_Made` > `Plan_Limit`?302. **Calc Excess:** `1500 - 1000 = 500`.313. **Calc Fee:** `500 * $0.05 = $25`.3233### Phase 3: Invoice Output341. **Output:** Save `monthly_invoices.csv` (Customer, Overage_Fee).352. **Summary:** "Billing run complete. CustB owes $25 in overages. CustA is within limits."3637---38*Blueprint ID: api-usage-biller*39*Source: [Real AI Examples](https://realaiexamples.com)*40
Run npx skillmds@latest add akhilkannur/api-usage-biller in your terminal (requires Node.js), paste this page's agent-chat prompt into Claude, Cursor, or any MCP-connected agent, or download the SKILL.md file and copy it into your agent's skills directory.
--- It is listed under Integrations & APIs on SkillMD.
This skill has not completed SkillMD's automated safety review yet. SkillMD never runs a skill's scripts for you; review the SKILL.md before installing.
This skill is tagged as working with Claude Code, Claude.ai, OpenAI Codex. SKILL.md is an open format, so most agents that read a skills directory can load it too.
Yes. Installing skills from SkillMD is free, and the skill stays under its author's original license.
akhilkannur (@akhilkannur) published this skill. Their other Agent Skills are listed on their SkillMD profile.
akhilkannur