The Scenario
You are a sales coach. You have a hypothesis: some of your 12 reps are dominating discovery calls, talking for stretches so long the prospect barely gets a word in. Gong tracks this — talk ratio, longest monologue, patience score, all per rep, all per call.
You want to identify the worst offenders before the next team training so you can make the session specific instead of generic. "Talk less, listen more" is not feedback. A list of names with numbers is.
The slow version:
- Log into Gong's analytics section, navigate to interaction stats
- Filter by rep, by time period — one rep at a time
- Write down each rep's talk ratio
- Go back, filter to the next rep, repeat
- Build the comparison table in Sheets from twelve separate Gong filter states
- By rep 7 you are not sure if you filtered to Q1 or Q1 plus January of last year because the date filter reset.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that reads Gong's interaction stats API directly, so you do not have to navigate the Gong analytics interface once per rep.
Open the SheetXAI sidebar and type:
Fetch interaction statistics from Gong for all users for Q1 and write each user's name, average talk ratio, average longest monologue, and average patience score into columns A through D.
SheetXAI pulls the interaction stats for all 12 reps across Q1 and writes the table. One row per rep, four columns, ready for the coaching session.
What You Get
A comparison table with one row per rep:
- Column A — rep name
- Column B — average talk ratio (percentage of call time the rep was speaking)
- Column C — average longest monologue in minutes
- Column D — average patience score
Talk ratio above 65% on a discovery call is a problem. You can see at a glance which reps are over that line. Longest monologue tells you whether it is chronic (rep talks for 8 minutes at a stretch) or just a pattern of heavy total talking. Patience score tells you whether the rep is waiting for the prospect to finish before jumping in.
What If the Data Is Not Quite Ready
Interaction stats across a team always need some scoping and annotation to be useful.
When you want to flag reps above the talk ratio threshold immediately
Rather than scanning the table yourself, you want the flags built in.
Fetch Gong interaction stats for all reps for Q1. Write name, average talk ratio, average longest monologue, and average patience score into columns A through D. In column E, write "Over-talking" for any rep whose average talk ratio exceeds 65% and leave it blank otherwise. Highlight those rows in red.
When you want to compare Q1 to Q4 of last year to see if coaching is working
If you ran a discovery skills training in December, you want to know if it moved the numbers.
Fetch Gong interaction stats for Q1 and for Q4 of the prior year. Write Q1 stats for each rep 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, not all call types
Talk ratio on a demo call is different from talk ratio on a discovery call. You only care about the discovery calls.
Fetch Gong interaction stats for Q1 for all reps, filtered to calls tagged as "Discovery" in Gong. Write name, average talk ratio, longest monologue, and patience score into columns A through D. Flag reps above 65% talk ratio in column E.
When you want the full picture — pull, flag, compare to a threshold, sort, and write a coaching agenda in one go
Blank sheet, training session in two days.
Fetch Gong interaction stats for all reps for Q1, filtered to discovery calls only. Write name, average talk ratio, longest monologue, and patience score into columns A through D. In column E, flag reps above 65% talk ratio as "Over-talking." Sort rows by talk ratio descending. Write a three-sentence coaching agenda in cell A14 naming the top three reps who need the most work on talk ratio and what their numbers actually are.
The pattern: the pull, the flags, the sort, and the coaching brief are one ask. You walk into the training session knowing exactly which reps to address and what to say.
Try It
Get the 7-day free trial of SheetXAI and open a blank sheet, 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 pull rep activity stats and build a weekly leaderboard from Gong or the Gong in Google Sheets overview.