The Scenario
You are a VP of Sales. It is Friday at 4 PM and you want to know — before you close your laptop — how your 15 reps actually performed this week by the numbers Gong tracks, not the numbers they self-report.
Call volume, talk ratio, customer engagement score. Three columns. Fifteen reps. Ranked.
The manual version:
- Log into Gong
- Navigate to the team activity report
- Figure out which filters get you last 7 days
- Export to CSV if the export works, or screenshot if it does not
- Open Excel, paste, delete the columns you do not care about, format the dates
- Sort by engagement score descending
- Copy the whole thing into the sheet your ops team uses
- It is now 5:15 and the sheet still has Gong's export headers in it.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that reads Gong directly, so you do not have to touch the Gong export interface.
Open the SheetXAI sidebar and type:
Fetch aggregate activity statistics for all Gong users for the past 7 days and write each user's name, number of calls, total talk time in minutes, and average interactivity score into columns A through D. Then rank users by interactivity score from highest to lowest in column E.
SheetXAI pulls the stats from Gong's activity API, writes every rep as a row, and sorts the ranking in column E. Fifteen reps, four metrics, one column of ranks — all in under two minutes.
What You Get
A clean leaderboard with one row per rep:
- Column A — rep name
- Column B — total calls in the past 7 days
- Column C — total talk time in minutes
- Column D — average interactivity score
- Column E — rank by interactivity score (1 = top performer)
The interactivity score is the one that matters. Call volume is easy to game. Interactivity — how much the customer is talking relative to the rep — is harder to fake.
Want to add formatting? Tell SheetXAI to highlight the top 3 rows green and the bottom 3 red. It will.
What If the Data Is Not Quite Ready
Leaderboards get more complicated once you have tenure differences, part-time reps, or reps who were on leave.
When some reps have zero calls because they were out
You do not want a rep who was at a conference all week sitting at the bottom of the leaderboard unfairly.
Fetch Gong activity stats for all reps for the past 7 days. Write name, calls, talk time, and interactivity score into columns A through D. In column F, write "OUT" for any rep with zero calls and exclude them from the ranking in column E.
When you want to compare this week to last week
A single week's leaderboard is fine. But the question leadership actually asks is: who improved?
Fetch Gong activity stats for this week (last 7 days) and the week before. Write this week's stats in columns A through D and last week's stats in columns F through I. In column J, calculate the interactivity score change per rep and sort by change descending in column K.
When you want to split the leaderboard by team or segment
Your 15 reps are split between SMB and Enterprise. The VP of SMB and the VP of Enterprise each want to see their team.
Fetch Gong stats for the past 7 days. Write name, team (SMB or Enterprise from the Gong user record), calls, talk time, and interactivity score into columns A through E. Then rank reps separately within each team in column F.
When you want the full picture with formatting, ranking, and a summary
No partially built sheet — just a question and a blank tab.
Fetch aggregate Gong activity stats for all reps for the past 7 days. Write name, calls, talk time in minutes, and interactivity score into columns A through D. Rank by interactivity score in column E. Highlight the top 3 rows green and the bottom 3 rows red. Write a one-sentence summary in cell A18 naming the top performer and the rep with the biggest gap to close.
The pattern: the data pull and the formatting are the same ask. You get the finished artifact, not the raw ingredients.
Try It
Get the 7-day free trial of SheetXAI and open a blank sheet, then ask it to pull your team's Gong stats for any time window. The Gong integration is included in every SheetXAI plan. For related workflows, see how to pull Gong interaction stats and flag reps who are over-talking or the Gong in Google Sheets overview.