Agentic KPI Dashboard
Real-time KPI monitoring dashboard with Airtable sync, n8n webhook ingestion, AI-powered chatbot insights, and live WebSocket updates.
!The Problem
Teams track KPIs across scattered spreadsheets and BI tools with no real-time visibility, no automated alerting, and no way to quickly ask questions about their data without digging through charts.
✓The Solution
A self-hosted Node.js dashboard that pulls KPI data from Airtable, accepts n8n webhook updates for real-time sync, displays metrics with interactive charts and health scoring, and includes an AI chatbot that can analyze all data and surface insights on demand.
How It Works
Express server initializes SQLite database with seed data
Cron job syncs KPI records from Airtable API
n8n sends webhook POSTs to /api/webhook/kpi for live updates
KPI engine enriches data with trend, progress, and health scores
WebSocket server broadcasts changes to all connected clients
Chart.js renders category distribution, status, and trend charts
AI chatbot loads all KPI context and streams responses via OpenRouter
Frontend auto-refreshes cards, charts, and table on WebSocket events
Key Features
Real-time KPI cards with sparkline trends and progress bars
Airtable bidirectional sync on configurable cron schedule
n8n webhook endpoints for live data ingestion
AI chatbot with full KPI context for instant insights
WebSocket live updates — no page refresh needed
Health scoring engine with category breakdowns
Interactive Chart.js visualizations (bar, doughnut, trend)
Dark and light theme with responsive design
Filterable data table with sort and search
Bulk update and snapshot webhook APIs
Tech Stack
Want to see more?
Check out the source code on GitHub or browse other projects in my portfolio.