The Scenario
You are a VP of Sales. You have 6 sales managers on your team. Coaching activity is supposed to be part of every manager's job — reviewing calls, running sessions, leaving feedback. But you have a suspicion that two of them are doing most of the work and the others are coasting.
Gong tracks every coaching action. Reviews, sessions, comments. The data is there. You want it in a Google Sheet, one row per manager, so you can have an informed conversation in your next 1:1s instead of going on instinct.
The slow version:
- Log into Gong, navigate to the coaching analytics section
- Filter by manager, filter by time period
- Write down the numbers for manager 1
- Go back, filter to manager 2, write down those numbers
- Repeat six times
- Open Sheets, build the table from your notes
- Your notes for manager 3 are missing because you got interrupted by a Slack message.
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 coaching API directly, so you do not have to navigate the Gong interface once per manager.
Open the SheetXAI sidebar and type:
Fetch coaching metrics from Gong for all managers and write their name, number of calls reviewed, total coaching sessions, and comments given into columns A through D.
SheetXAI pulls all six managers' coaching metrics and writes the table. One row per manager, four columns, ready for the 1:1.
What You Get
A clean comparison table with one row per manager:
- Column A — manager name
- Column B — number of calls reviewed in the period
- Column C — total coaching sessions run
- Column D — total comments left on calls
The table makes the conversation specific. "You reviewed 4 calls last month" is a different conversation than "your coaching volume feels low." You know the number. You can hold it.
What If the Data Is Not Quite Ready
Coaching metrics need context — time period, team size, and a ranking to make the comparison useful.
When you want to scope the pull to a specific month
Without a date filter, Gong may return all-time totals, which is not what you want for a monthly 1:1.
Fetch Gong coaching metrics for all managers for the calendar month of April. Write name, calls reviewed, sessions, and comments into columns A through D.
When you want to normalize by team size
A manager with 8 direct reports reviewing 10 calls is different from a manager with 3 direct reports reviewing 10 calls.
Fetch Gong coaching metrics for all managers for last month. Write name, calls reviewed, sessions, and comments into columns A through D. In column E, write each manager's headcount (from the Gong user records if available). In column F, calculate reviews per direct report and sort by that number descending.
When you want to rank managers and highlight outliers
The comparison is only useful if you can see who is at the top and bottom.
Fetch Gong coaching metrics for all managers for last month. Write name, calls reviewed, sessions, and comments into columns A through D. In column E, rank managers by total calls reviewed from highest to lowest. Highlight the top 2 rows green and the bottom 2 rows red.
When you want the full picture — pull, rank, normalize, and write a pre-read summary in one go
No pre-built sheet, just a blank tab and six 1:1s coming up.
Fetch Gong coaching metrics for all managers for the past 30 days. Write name, calls reviewed, sessions, and comments into columns A through D. In column E, rank by calls reviewed descending. Highlight the top 2 green and bottom 2 red. Write a three-sentence summary in cell A8 identifying the highest-volume coach, the lowest-volume coach, and the gap in reviews between them.
The pattern: the pull, the ranking, the formatting, and the narrative are one ask. You walk into the 1:1s knowing the numbers.
Try It
Get the 7-day free trial of SheetXAI and open a blank sheet, then ask it to pull your Gong coaching metrics for any date range. The Gong integration is included in every SheetXAI plan. For related workflows, see how to pull Gong scorecard results and spot skill gaps across your team or the Gong in Google Sheets overview.