AI Report Builder

Upload data (CSV/Excel) → AI analyzes → generates professional reports (charts + narrative + formatting).

---

Quick Start

python3 scripts/generator.py --input data.csv --output report.xlsx --template monthly_operation
python3 scripts/generator.py --input sales.xlsx --output monthly.xlsx --template sales

---

Tiered Features

| Feature | FREE | PRO | |----------------------|:-----------------:|:-----------------:| | Total uses | 5 (lifetime) | Unlimited | | Chart types | Line only | Line only | | AI narrative analysis | — | Yes | | Multi-sheet Excel | — | Yes | | PDF export | — | — | | Price | Free | $0.01/report |

---

Core Features

• Multi-format support: CSV, Excel (.xlsx/.xls)
• AI-powered analysis: OpenAI-compatible API
• Chart generation: Line, bar, pie, scatter, histogram
• Multi-sheet Excel reports: Professional formatting
• Template system: Monthly, financial, sales, data comparison, custom

---

Usage

python3 scripts/generator.py \
  --input data.csv \
  --output report.xlsx \
  --template monthly_operation \
  --ai-provider openai \
  --ai-model gpt-4o-mini \
  --no-ai

Arguments:

• --input/-i: Data file path (CSV/Excel) — required
• --output/-o: Output report path (default: report.xlsx)
• --template/-t: Template type (monthly_operation/financial/sales/data_comparison/custom)
• --ai-provider: AI provider (openai/deepseek)
• --ai-model: AI model name
• --no-ai: Skip AI analysis (charts only)
• --sheet: Excel sheet name

---

Supported Templates

| Template | Description | |----------|-------------| | monthly_operation | Monthly operational report | | financial | Financial analysis report | | sales | Sales performance report | | data_comparison | Period-over-period comparison | | custom | Custom format |

---

Directory Structure

ai-report-builder/
├── SKILL.md
├── requirements.txt
├── scripts/
│   ├── generator.py      # CLI entry point
│   └── __init__.py
└── core/
    ├── parser.py         # Data parsing (pandas)
    ├── charts.py         # Chart generation (matplotlib)
    ├── ai_analyzer.py    # AI analysis (OpenAI-compatible)
    ├── report_builder.py # Excel multi-sheet builder
    ├── quota.py          # Quota management
    └── templates.py      # Template system

---

Billing

• Pay-per-call: $0.0100 USDT per execution via SkillPay.me
• Balance insufficient: Payment URL returned — user tops up at https://skillpay.me/ai-report-builder
• External data flow: FEISHU_USER_ID transmitted to skillpay.me/api/v1/billing for billing identification only; not stored or shared with any third party
• Billing model: Each report generation = 1 call = $0.0100 USDT
• Privacy: FEISHU_USER_ID is used solely to identify the billing account; no personal data is retained or shared beyond the payment processor

---

Required Environment Variables

| Variable | Description | |----------|-------------| | SKILL_BILLING_API_KEY | SkillPay Builder API Key | | SKILL_BILLING_SKILL_ID | SkillPay Skill ID (ai-report-builder) | | FEISHU_USER_ID | User open_id for billing (passed by Feishu runtime) |

---

License

MIT