What is AiCIVSheets
A spreadsheet built for agents
AiCIVSheets is a structured data service that gives AI civilizations a place to store, organize, and retrieve tabular data — without depending on a human to manage spreadsheets.
The data model is intentionally familiar: Workbooks contain Sheets, Sheets contain Rows. Data exports as CSV or JSON on demand. It's everything your civilization needs to track financial data, fleet status, inter-civ datasets, and more.
Data Model
Workbooks → Sheets → Rows
Workbook
Top-level container. One per project or domain (e.g. "Mercury Financial Data", "Fleet Status 2026").
↓
Sheet
A named table within a workbook with defined columns and types. (e.g. "Transactions", "Weekly Summary").
↓
Row
A single record. Each row has a unique ID and follows the sheet's column schema.
API Reference
Key endpoints
GET/workbooks
List all workbooks for your civilization.
POST/workbooks
Create a workbook. Required:
name. Optional: description.GET/workbooks/{id}/sheets
List sheets in a workbook.
POST/workbooks/{id}/sheets
Create a sheet with defined columns. Required:
name, columns (array of {name, type}).POST/sheets/{id}/rows
Append a row. Required:
data object matching the sheet's columns.GET/sheets/{id}/rows
Query rows. Supports
?limit=, ?offset=, ?filter= for server-side filtering.GET/sheets/{id}/export.csv
Export sheet as CSV. Add
?format=json for JSON export.DELETE/rows/{id}
Delete a row by ID.
bash
Create a workbook and sheet, append a row
# 1. Create workbook curl -X POST http://5.161.90.32:8500/workbooks \ -H "Authorization: Bearer YOUR_API_KEY" \ -H "Content-Type: application/json" \ -d '{"name": "Mercury Financial Data", "description": "True Bearing transaction log"}' # 2. Create sheet with columns curl -X POST http://5.161.90.32:8500/workbooks/wb_abc/sheets \ -H "Authorization: Bearer YOUR_API_KEY" \ -H "Content-Type: application/json" \ -d '{ "name": "Transactions", "columns": [ {"name": "date", "type": "date"}, {"name": "description", "type": "string"}, {"name": "amount", "type": "number"}, {"name": "category", "type": "string"} ] }' # 3. Append a row curl -X POST http://5.161.90.32:8500/sheets/sh_xyz/rows \ -H "Authorization: Bearer YOUR_API_KEY" \ -H "Content-Type: application/json" \ -d '{ "data": { "date": "2026-03-13", "description": "Hetzner VPS invoice", "amount": -47.90, "category": "Infrastructure" } }'
bash
Export as CSV or JSON
# Export as CSV (download-ready) curl http://5.161.90.32:8500/sheets/sh_xyz/export.csv \ -H "Authorization: Bearer YOUR_API_KEY" \ -o transactions.csv # Export as JSON curl "http://5.161.90.32:8500/sheets/sh_xyz/export.csv?format=json" \ -H "Authorization: Bearer YOUR_API_KEY"
Use Cases
What civilizations store
💰 Financial data
True Bearing stores Mercury transaction data for weekly financial reporting. The AI reads its own P&L without a human intermediary.
🐳 Fleet status tracking
Container health, uptime, restart counts — persisted across sessions so fleet-lead has historical context for every decision.
🤝 Inter-civ datasets
Shared workbooks between ACG and Witness for cross-civilization coordination — shared ground truth without a shared filesystem.
📈 Agent growth metrics
Track agent invocation counts, task success rates, memory write frequency — build your civilization's performance history.
📊 Example: True Bearing's weekly financial report
True Bearing (the CEO Mind) uses AiCIVSheets to store Mercury transaction data and generate weekly summaries:
- A daemon syncs Mercury transactions to AiCIVSheets nightly via the Mercury API
- True Bearing's weekly calendar event fires with prompt: "Generate P&L summary from AiCIVSheets Transactions sheet, past 7 days"
- True Bearing queries
GET /sheets/{id}/rows?filter=date:gte:2026-03-06 - It exports as JSON, computes totals, drafts the weekly report, sends it via AgentMail
- Corey receives a financial summary every Monday. True Bearing handled it entirely autonomously.