The Scenario
You are a sales ops analyst. The head of sales wants to present a week-over-week outreach trend for the 10-person SDR team across all of Q1 at the quarterly business review next Tuesday.
Gong tracks daily call and email activity per rep. The data is there. The gap is getting 13 weeks of daily stats out of Gong, rolled up by ISO week, and into an Excel workbook in a format the head of sales can show in a slide deck.
The slow version:
- Try to pull daily stats from Gong — the UI shows weekly summaries, not daily breakdowns
- Ask the Gong admin for an API export, wait two days
- Get a JSON dump, parse it in Python or ask an engineer
- Aggregate by ISO week in code, write to CSV, import to Excel
- Format the table, build a chart
- It is Monday evening and the QBR is Tuesday morning.
The fast version is one prompt on Friday.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that reads Gong's daily stats API, so you do not need an engineer or a script.
Open the SheetXAI sidebar and type:
Fetch day-by-day activity stats from Gong for all users from January 1 to March 31 and paste one row per user per day with columns: date, user name, calls made, emails sent. Then aggregate the data by ISO week number, calculate total team calls and emails per week, and paste the weekly summary into a new sheet called "Weekly Trend."
SheetXAI pulls the daily stats, writes every user-day row to the main tab, and builds the Weekly Trend tab — 13 rows, one per week, ready for the chart.
What You Get
Two tabs:
Main tab — raw daily data, one row per rep per day:
- Date, rep name, calls made, emails sent
Weekly Trend tab — aggregated view, one row per ISO week:
- Week number, total team calls, total team emails
The shape of the numbers tells the story. A 30% drop in calls in week 6 is visible in seconds. No formula required.
What If the Data Is Not Quite Ready
When reps who joined mid-quarter skew the early-week totals
A rep who started in week 5 has zero activity in weeks 1 through 4, making those weeks look worse than they were.
Fetch Gong daily stats for Q1 for all users. Write one row per user per day. Aggregate by ISO week, but only include each rep in the weekly total for weeks where they have at least one day of activity. Write adjusted totals to the "Weekly Trend" tab.
When you want per-rep weekly trends, not just team totals
The head of sales wants to know if the week-8 dip was a team problem or two specific reps dragging the number.
Fetch Gong daily stats for Q1. Write raw rows first. Then build a "Rep Weekly" tab with one row per rep per ISO week showing that rep's weekly call and email totals. Highlight weeks where a rep made fewer than 10 calls in orange.
When you want calls only and email is irrelevant
Some SDR teams track calls and emails separately and only care about call volume in the Gong trend.
Fetch Gong daily stats for Q1 for all SDR users. Write one row per user per day with date, name, and calls made only. Aggregate by ISO week with total team calls per week in the "Weekly Trend" tab. Ignore email counts.
When you want the full QBR-ready package — raw data, weekly rollup, chart-ready formatting, and a trend summary — in one go
Blank workbook, QBR tomorrow morning.
Fetch day-by-day Gong stats for all users from January 1 to March 31. Write one row per user per day with date, name, calls, and emails. Aggregate by ISO week and write totals to "Weekly Trend." In "Weekly Trend," highlight the highest-volume week green and the lowest red. Write a two-sentence summary in cell A15 naming the peak week and the lowest week with the percentage difference between them.
The pattern: the pull, the rollup, the formatting, and the narrative 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 daily stats for any date range. The Gong integration is included in every SheetXAI plan. For related workflows, see how to build a weekly rep leaderboard in Excel from Gong data or the Gong in Excel overview.