The Scenario
You are a sales coach. You have a strong suspicion that several of your 12 reps are dominating discovery calls — talking for long stretches while the prospect barely gets a word in. Gong tracks this precisely: talk ratio, longest monologue, and patience score per rep per call.
You want to identify the specific reps who need coaching before the next team training session, so the session can be targeted. A generic "talk less, listen more" slide helps nobody. Names and numbers do.
The slow version:
- Log into Gong analytics, filter to interaction stats, filter to rep 1
- Write down the talk ratio, monologue, and patience score
- Go back, filter to rep 2, repeat
- Build the comparison table in Excel from twelve separate Gong filter states
- By rep 8 you are not sure whether your date filter is still set to Q1 or reset to all time.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that reads Gong's interaction stats API directly, so you do not have to navigate the analytics interface once per rep.
Open the SheetXAI sidebar and type:
Pull Gong interaction stats for the last 90 days and highlight reps in this workbook whose talk ratio exceeds 65% in red. Include each rep's name, average talk ratio, average longest monologue, and average patience score.
SheetXAI pulls the interaction stats for all 12 reps, writes the table, and applies the red highlight to every rep over the 65% threshold.
What You Get
A comparison table with one row per rep:
- Column A — rep name
- Column B — average talk ratio
- Column C — average longest monologue in minutes
- Column D — average patience score
- Rows above 65% talk ratio highlighted in red
The highlighted rows are your coaching targets. Longest monologue tells you whether it is a chronic "runs long on one topic" problem or just general heavy talking. Patience score tells you whether the rep is interrupting or just talking a lot.
What If the Data Is Not Quite Ready
When you want to flag reps above the threshold and add a text label
Color alone is easy to miss in a printed handout. You want a text flag too.
Fetch Gong interaction stats for Q1 for all reps. Write name, average talk ratio, longest monologue, and patience score into columns A through D. In column E, write "Over-talking" for reps above 65% talk ratio and leave blank otherwise. Highlight those rows red.
When you want to compare Q1 to Q4 to see if a previous training helped
If you ran a discovery workshop in December, you want to know whether the numbers moved.
Fetch Gong interaction stats for Q1 and for Q4 of last year. Write Q1 stats in columns A through D and Q4 stats in columns F through I. In column J, calculate the change in talk ratio and highlight reps who improved by more than 5 points in green.
When you want to scope to discovery calls only
Talk ratio on a demo call is less meaningful than on a discovery call. You only care about discovery.
Fetch Gong interaction stats for Q1, filtered to calls tagged as "Discovery." Write name, average talk ratio, longest monologue, and patience score into columns A through D. Flag reps above 65% in column E and highlight those rows red.
When you want the full coaching package — pull, flag, sort, and a written agenda — in one go
Blank workbook, training session in two days.
Fetch Gong interaction stats for Q1 for all reps, filtered to discovery calls. Write name, average talk ratio, longest monologue, and patience score into columns A through D. In column E, flag reps above 65% as "Over-talking." Sort by talk ratio descending. Write a three-sentence coaching agenda in cell A14 naming the top three reps who need the most work and what their actual talk ratio numbers are.
The pattern: the pull, the flags, the sort, and the coaching brief are one ask.
Try It
Get the 7-day free trial of SheetXAI and open a blank workbook tab, then ask it to pull your team's Gong interaction stats for any date range. The Gong integration is included in every SheetXAI plan. For related workflows, see how to build a rep activity leaderboard in Excel from Gong data or the Gong in Excel overview.