Weekly sales call coaching board with rubric scorecards

Build me a weekly sales call coaching board that my sales manager opens every Friday to review reps against a fixed rubric, instead of keeping scattered notes in a spreadsheet. The whole review loop has to happen inside the app: find this week's calls, transcribe them, score them, write coaching notes, and export the week's scorecard. A manager should be able to get through three to five calls per rep in one sitting without leaving the board.

The landing view is This Week's Calls. Use Google Drive List Files to pull recordings from a configured folder, and Google Drive Get File Metadata to read each file's recorded date, name, and duration where available. Group the list by rep. Recordings are matched to reps by convention: either the file sits in a per rep subfolder, or the rep name is embedded in the filename. Make that matching rule configurable in a settings area, and show an Unmatched group for recordings the rule could not assign so nothing silently disappears. Default the view to the current week with the ability to page back to earlier weeks. Each row shows the rep, the call name, the recorded date, and its review status: not transcribed, transcribed, or reviewed.

Each row has a Transcribe button. The handler downloads the audio with Google Drive Download File Content and posts the raw bytes to Deepgram Transcribe Pre-recorded Audio with diarization and smart formatting enabled, so the transcript comes back speaker separated and readable. Three Deepgram details to get right: the auth header is Authorization: Token <key>, not Bearer. The /v1/listen endpoint accepts either a JSON body with a publicly reachable URL or raw audio bytes with an audio/* content type, and because Drive files are not public the handler must download the bytes and post them directly. All transcription options, including diarize, smart_format and punctuate, are query string parameters and never body fields. Transcription of a long call takes a while, so run it in the background, show progress on the row, and persist the finished transcript so it is never fetched twice.

Clicking a call opens the review page. The left side shows the speaker labeled transcript with timestamps. The right side shows computed conversation stats: rep talk ratio, longest uninterrupted monologue, and number of questions asked. Compute these from the diarized transcript by mapping the speaker labels to rep and prospect, and let the manager flip that assignment if the labels came back the other way around. Flag the talk ratio in a warning state when the rep is above roughly 55 percent of talk time. The widely cited benchmark is that top performers sit near 43 percent talking and 57 percent listening, so show that reference point next to the number rather than presenting a bare flag.

Below the stats sits the scorecard: a fixed rubric of five to eight skills rated 1 to 5 on a consistent scale. Start with discovery quality, objection handling, and next step agreed, and let an admin edit the skill list. For each skill the manager can attach one concrete observation, which is what makes the score defensible in a one to one. There is also a box for timestamped coaching notes, where clicking a timestamp in the transcript drops a linked marker into the note so every piece of feedback points at a real moment in the call.

Scores and notes persist in the app, and that data powers the second view, Rep Trends. One row per rep showing how each rubric skill has moved over the last several weeks, their rolling average talk ratio, and how many calls have been reviewed this week against a target of three to five. Make coverage impossible to miss, because the recurring failure in call coaching is that managers only ever get to a handful of calls. Reps with zero reviews this week should be visually distinct and sorted to the top, not buried at the bottom of a table.

An Export scorecard button appends the week's rows to a shared Google Sheet. Before writing, read the existing sheet with Google Sheets Get Values and skip any row that is already there, so re-running the export never duplicates. Then write the new rows with Google Sheets Append Values: one row per reviewed call with the date, rep, call name, each skill score, the talk ratio, and a link back to the call in the app.

Keep the whole thing dense and scannable. A manager doing a Friday review session wants the week's full picture on one screen, then a fast path into each call and back out again. Show review status everywhere so it is always obvious what is left to do.