CoolFace
Apppublic

ScaleupXQ/big-screen

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

SDR Status Tracker

Interactive dashboard for tracking sales development case progress with real-time data from Google Sheets.

Features

  • —Live Google Sheets Integration: Data syncs automatically from your spreadsheet
  • —Progress Visualization: Color-coded progress bars for SQL and Activity targets
  • —Leaderboards: Real-time rankings by SDR for weekly and monthly performance
  • —Theme Toggle: Light and dark mode support
  • —Sound Effects: Optional audio feedback for achievements

Configuration

Set these environment variables in your HuggingFace Space secrets:

VariableDescription
GOOGLE_CREDENTIALSService account JSON credentials
GOOGLE_SHEET_IDThe spreadsheet ID from the URL
GOOGLE_SHEET_GIDThe tab/sheet GID (optional)

Sheet Structure

Your Google Sheet should have these columns:

ColumnDescription
CaseClient/project name
GSSDR/team member name
W2SQL, W2SQLTarget, etc.Weekly SQL actuals and targets
W2Calls, W2CallsTarget, etc.Weekly call actuals and targets
MonthlySQL, MonthlySQLTargetMonthly SQL totals
MonthlyActivity, MonthlyActivityTargetMonthly activity totals

Usage

  1. 1.Click "Refresh Data" to fetch latest from Google Sheets
  2. 2.Data caches for 60 seconds to reduce API calls
  3. 3.Falls back to localStorage if API is unavailable