The Scenario
You are a sales ops analyst. Your head of sales wants to see a chart on Monday morning showing how outreach volume changed week over week for the 10-person SDR team throughout Q1 — not just a snapshot, a full 13-week trend.
Gong tracks daily call and email activity per rep. The data is there. The problem is extracting it in a shape that can roll up into weekly totals and land in a clean sheet ready for a chart.
The slow version:
- Navigate to Gong's activity report, filter by team, filter by Q1
- Try to export — discover the export doesn't include day-by-day breakdown, just totals
- Pull the Gong API yourself (or convince an engineer to), parse the JSON
- Write a script to aggregate by ISO week
- Paste the output into Sheets, format it, build the chart
- It is Sunday night and you still haven't built the chart.
The fast version is one prompt on Friday afternoon.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that reads Gong's daily stats API, so you do not have to touch a script or an API call yourself.
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 sheet, and builds the Weekly Trend tab with 13 rows — one per week — showing total calls and emails across the team.
What You Get
Two tabs:
Main tab — raw daily data:
- One row per rep per day: date, name, calls made, emails sent
Weekly Trend tab — aggregated view:
- One row per ISO week (13 rows for Q1)
- Total calls across the team per week
- Total emails across the team per week
The trend is in the shape of the numbers, not in any single week. If calls dropped 30% in week 6, that is visible immediately. You did not need to write a formula to see it.
What If the Data Is Not Quite Ready
Daily stat pulls across a full quarter for 10 reps produce a lot of rows. The shape of the data varies too.
When some reps joined mid-quarter and skew the early weeks
A rep who started in week 5 looks like low volume in weeks 1 through 4 because they were not there. That can make the team trend look worse than it was.
Fetch daily Gong stats for all users from January 1 to March 31. Write one row per user per day. Then 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 the adjusted weekly totals to the "Weekly Trend" tab.
When you want per-rep weekly trends, not just team totals
The head of sales wants to know whether the dip in week 8 was team-wide or just two reps.
Fetch Gong daily stats for Q1. After writing the raw rows, build a second summary tab called "Rep Weekly" 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 to filter to calls only and ignore email
Some SDR teams count email separately and only care about call volume for the Gong trend.
Fetch Gong daily stats for all SDR users from January 1 to March 31. Write one row per user per day with only date, name, and calls made. Aggregate by ISO week with total team calls per week and write to the "Weekly Trend" tab. Ignore email counts entirely.
When you want the full setup — raw data, weekly rollup, chart-ready output, and a trend summary — in one go
Blank sheet, Monday deadline, head of sales wants it before standup.
Fetch day-by-day Gong activity stats for all users from January 1 to March 31. Write one row per user per day with date, name, calls made, and emails sent. Aggregate by ISO week and write total team calls and emails per week to a "Weekly Trend" tab. In the "Weekly Trend" tab, highlight the highest-volume week in green and the lowest in red. Write a two-sentence summary in cell A1 of "Weekly Trend" naming the peak week and the lowest week and the percentage difference between them.
The pattern: the raw pull, the aggregation, the formatting, and the summary are all one ask. You walk in Monday with a finished artifact.
Try It
Get the 7-day free trial of SheetXAI and open a blank sheet, then ask it to pull your team's Gong daily activity 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 from Gong data or the Gong in Google Sheets overview.