Internal Operations Dashboard for 20-Person Team
Project overview
Built a real-time ops dashboard that replaced 4 separate tools for a 20-person team by integrating Slack, Google Sheets, and a custom task API into one unified interface.
The Problem
- Team was juggling 4 separate tools with no unified view
- Task updates in one tool weren't visible to others in real time
- Status reporting required manual copy-paste across platforms
- No single source of truth for team workload and task progress
- Slack notifications were noisy and lacked actionable context
What We Built
- Unified real-time dashboard pulling data from Slack, Sheets, and a task API
- Task assignment, status tracking, and priority view in one place
- Automated status syncing across integrated tools
- Role-based views for team leads and individual contributors
- Custom notification layer to surface only actionable updates
Features
Public / Audience
- View personal task list with priority and deadlines
- Update task status without switching tools
- See team-wide progress at a glance
- Receive filtered, relevant Slack alerts in-dashboard
Admin Panel
- Assign and reassign tasks across team members
- View team workload distribution and capacity
- Pull live data from Google Sheets into dashboard views
- Configure which Slack channels surface alerts
- Export weekly ops summaries as reports
Key Design Decisions
Single dashboard to avoid context-switching across tools
Read/write integration with Google Sheets as a lightweight database
Slack webhook integration for real-time event triggers
Custom task API to decouple task logic from UI
Role-based access so leads and contributors see different views
Tech Stack
Outcomes
Replaced 4 separate tools with one unified interface
Reduced time spent on manual status updates and reporting
Improved team-wide visibility into workload and progress
Slack noise reduced through filtered, contextual alerts
Team leads gained real-time capacity and bottleneck visibility
What made this work
For growing teams, the problem is rarely missing tools — it's too many disconnected ones. A focused integration layer can restore clarity without adding yet another platform.
Operations / SaaS · India · Web