Skip to content

Repository files navigation

⚡ SheetBrain AI — Autonomous Multi-Agent Spreadsheet Workspace

Transform Natural Language into Living, Formula-Driven Spreadsheets & Visual Dashboards in Seconds.

👤 Lead Developer & Architect: DIPPU SINHA (@dippus)
🚀 Live Deployment: https://main.ddro9iqx1ajmw.amplifyapp.com
🎬 2-Minute Demo Video: https://youtu.be/Hxn7xwU3NO4

Author: DIPPU SINHA Demo Video GitHub Repository AWS Bedrock Amazon S3 AWS CloudWatch Live Demo Public Telemetry Univer Office SDK Next.js 14 License: MIT


💡 What is SheetBrain AI? (Executive Overview & Problem Statement)

Most AI tools (like ChatGPT or Claude) only output dead text or static markdown tables in a chat box. You cannot click cells, edit numbers, calculate dynamic formulas, or generate interactive charts.

SheetBrain AI changes this completely. It is an autonomous spreadsheet intelligence platform that takes a plain English prompt (e.g. "Build a 12-month startup runway forecast with hiring costs and burn rate chart") and instantly compiles an interactive, Excel-grade living spreadsheet with real reactive formulas (=SUM, =GROWTH, =IF) and dynamic charts.


🔥 Key Features (Core Highlights)

1. 🗣️ Natural Language to Living Spreadsheet

  • Describe your financial model, sales tracker, or budget in plain words.
  • In under 3 seconds, SheetBrain generates a fully structured spreadsheet populated with industry-accurate benchmark data.

2. 🧮 Reactive Formula Engine (Not Hardcoded Numbers)

  • Formulas are real mathematical expressions: =SUM(C2:C10), =AVERAGE(D2:D10), =(B5-B4)/B4.
  • When you change any number in a cell, all related totals, formulas, and charts dynamically recalculate in real time.

3. 🖥️ Excel-Grade Univer Canvas

  • Built on Univer ("The Office Harness for AI Agents").
  • Full spreadsheet functionality: cell editing, formulas, sorting, formatting, keyboard navigation, and multi-sheet tabs.

4. 🔮 "What-If" Scenario Simulation (The Winning Edge)

  • Test business hypotheses instantly: "What if customer acquisition cost increases by 25%?"
  • SheetBrain dynamically stress-tests the spreadsheet, re-evaluates formulas, and highlights affected cells in color-coded Red/Green indicators.

5. 📊 Automatic Chart & Analytics Engine

  • Automatically selects and renders the most relevant visualization (Bar, Line, Waterfall, or Donut) bound directly to cell ranges.

6. 💾 1-Click Export to Microsoft Excel & Google Sheets

  • Export generated workbooks directly into native .xlsx or .csv files with formulas preserved.

🧠 How It Works (Autonomous Multi-Agent Pipeline)

SheetBrain uses a 5-stage collaborative neuro-symbolic architecture powered by Amazon Bedrock (Claude 3.5 Sonnet & Amazon Nova in Sydney ap-southeast-2) and a local deterministic engine:

  ┌────────────────────────────────────────────────────────────────────────┐
  │                 User Prompt: "BCA Semester 5 Student Gradebook"        │
  └───────────────────────────────────┬────────────────────────────────────┘
                                      │
                                      ▼
  ┌────────────────────────────────────────────────────────────────────────┐
  │ 🏛️ AGENT 1: Schema Architect                                           │
  │ Models domain taxonomy, column metadata, datatypes, & benchmark rows   │
  └───────────────────────────────────┬────────────────────────────────────┘
                                      │
                                      ▼
  ┌────────────────────────────────────────────────────────────────────────┐
  │ 🧮 AGENT 2: Formula Compiler                                           │
  │ Synthesizes reactive Excel formulas (=SUM, =IF, =ROUND) & anti-circular│
  └───────────────────────────────────┬────────────────────────────────────┘
                                      │
                                      ▼
  ┌────────────────────────────────────────────────────────────────────────┐
  │ 📊 AGENT 3: Visual Analytics Engine                                    │
  │ Auto-selects & binds dynamic charts (Bar / Line / Area) to coordinates │
  └───────────────────────────────────┬────────────────────────────────────┘
                                      │
                                      ▼
  ┌────────────────────────────────────────────────────────────────────────┐
  │ ⚡ AGENT 4: Deterministic Math Engine (HyperFormula v3)                 │
  │ Zero-hallucination DAG recalculation & mathematical dependency resolve │
  └───────────────────────────────────┬────────────────────────────────────┘
                                      │
                                      ▼
  ┌────────────────────────────────────────────────────────────────────────┐
  │ 🛠️ AGENT 5: Self-Correction Loop                                       │
  │ Audits recalculated matrix, auto-repairs defects & verifies convergence│
  └───────────────────────────────────┬────────────────────────────────────┘
                                      │
                                      ▼
  ┌────────────────────────────────────────────────────────────────────────┐
  │ 🖥️ UNIVER SPREADSHEET CANVAS (Browser Client)                           │
  │ Living, editable, reactive spreadsheet ready to use & export to Excel  │
  └────────────────────────────────────────────────────────────────────────┘

🛠️ Technology Stack

Layer Technology Purpose
Frontend Framework Next.js 14+ (App Router) + TypeScript High-performance React framework with strict typing
Spreadsheet Engine Univer Office SDK (@univerjs/core, @univerjs/sheets) Canvas-based Excel-grade spreadsheet runtime
Styling & UI Tailwind CSS + Lucide Icons Dark OLED Luxury fintech aesthetic, sleek glassmorphism
Charts Recharts + Univer Charts Responsive, dynamic business visualizations
Generative AI Amazon Bedrock (Claude 3.5 Sonnet / Amazon Nova, ap-southeast-2) Semantic reasoning, ontology mapping & multi-agent intent
Formula Engine HyperFormula v3.4.0 (Handsontable DAG Engine) Instant (<50ms) reactive dependency graph, IF(), VLOOKUP(), aggregations
Durable Storage Amazon S3 (ap-southeast-2 Multi-AZ) Continuous background persistence for multi-sheet workbooks
Observability Amazon CloudWatch EMF (Embedded Metric Format) Production structured metric emissions & latency tracking
Hosting & CI/CD AWS Amplify Hosting (ap-southeast-2) Serverless hosting with CloudFront edge distribution

👥 Who Is This For? (Target Users)

  • 🚀 Startup Founders: Build 12-month runway models, hiring plans, and cash burn projections in 3 seconds.
  • 📈 Sales & Growth Teams: Track CAC & LTV cohorts, marketing ROAS, and commission calculators.
  • 💼 Financial Analysts: Generate P&L forecasts, DCF valuation models, and sensitivity tables.
  • 📋 Product Managers & Educators: Create sprint velocity boards, student gradebooks, and inventory matrices.

🚀 Quick Start & Local Setup

# 1. Clone the repository
git clone https://github.com/dippus/sheetbrain-ai.git
cd sheetbrain-ai

# 2. Install dependencies
npm install

# 3. Start local development server
npm run dev

Open http://localhost:3000 in your browser to start using SheetBrain AI.


📂 Project Documentation Quick Links

For complete technical and architectural specifications, see:


👨‍💻 Author & Developer Profile

  • Developer & Project Lead: DIPPU SINHA
  • Role: Lead Systems Architect & Full-Stack AI Engineer
  • Bio: AI Systems & Full-Stack Engineer | Architecting autonomous multi-agent spreadsheet intelligence platforms with AWS Bedrock, Next.js & TypeScript.
  • GitHub Profile: @dippus
  • Project Repository: https://github.com/dippus/sheetbrain-ai
  • AWS Builder Center Profile: DIPPU SINHA
  • Hackathon Submission: AWS "Zero to Shipped" Hackathon — Workplace Efficiency Track (Community Lane)
  • Live Deployment: https://main.ddro9iqx1ajmw.amplifyapp.com

📄 License

This project is open-source and licensed under the MIT License.

About

Autonomous Multi-Agent AI Spreadsheet & Financial Modeling Studio powered by Univer Office SDK & Amazon Bedrock.

Topics

Resources

Stars

0 stars

Watchers

1 watching

Forks

Releases

Packages

Contributors

Languages