CoolFace
Apppublic

ScaleupXQ/big-screen-2

sourceHugging Facemitupdated 8mo agoView on Hugging Face
0likes
App README

SDR Status Tracker

Interactive dashboard for tracking SDR (Sales Development Representative) activity and performance. Built for ScaleupXQ. Data is fetched from Google Sheets via a FastAPI backend and displayed as leaderboards, weekly tables, and color-coded progress bars.

Features

  • —Live Google Sheets Integration: Fetches data per month from configurable Google Sheets
  • —Multi-month Support: Month selector dropdown, each month linked to its own sheet/tab
  • —Progress Visualization: Color-coded progress bars for all activity targets (Calls, Emails, LinkedIn, Prospects, Discovery, SQL)
  • —Leaderboard with Capping: SDR rankings using a scoring system where 100% requires ALL individual targets to be met
  • —Real-time Refresh: Server-Sent Events (SSE) push updates to connected browsers
  • —Cache with Webhook Invalidation: In-memory cache (1-hour TTL), clearable via POST /api/invalidate-cache
  • —Dynamic Column Layout: Column positions auto-detected from sheet headers via detect_columns.py

Configuration

Set these environment variables (in HuggingFace Space secrets for production):

VariableRequiredDescription
GOOGLE_CREDENTIALSYesService account JSON key (as string)
GOOGLE_SHEET_IDNoDefault spreadsheet ID (fallback)
GOOGLE_SHEET_GIDNoDefault tab/sheet GID (fallback)
WEBHOOK_SECRETNoSecret for cache invalidation webhook

Month definitions (sheet IDs, tab names, start weeks) are configured in months_config.json. Column layout is in column_config.json.

Usage

  1. 1.Select a month from the dropdown to load that month's data
  2. 2.Click "Refresh Data" to invalidate cache and fetch the latest from Google Sheets
  3. 3.Data caches for 1 hour to reduce API calls; cache is also invalidated via webhook

Technical Details

See DEVELOPMENT.md for architecture, key functions, configuration files, customization, and troubleshooting.