The Scenario
Every Monday morning at 8:55 AM, the support director pastes a screenshot of ticket counts into the team standup doc. The screenshot comes from him manually opening each of 12 Zendesk views and writing down the number. It takes him 20 minutes. He's been doing it every week for 11 months.
His view IDs are already in column A of a sheet. Someone finally connected this behavior to the amount of manual effort it represents.
The bad version:
- Log into Zendesk.
- Navigate to view 1, note the count.
- Navigate to view 2, note the count.
- Continue through all 12 views.
- Type the numbers into the sheet.
- Post the sheet to the standup doc.
This is not a Zendesk problem. Zendesk shows you the counts. The problem is that there's no way to pull those 12 counts into a spreadsheet without doing it manually — unless you have something that reads the sheet and calls the API.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It reads the view IDs from your column and uses the Zendesk integration to fetch the current ticket count for each view.
Open the SheetXAI sidebar in the standup sheet and paste:
For each Zendesk view ID in column A, fetch the current ticket count and write it into column B along with the view name in column C
What You Get
- Column A: View IDs (already there).
- Column B: Current ticket count for each view, pulled live.
- Column C: View name, pulled from Zendesk so the director doesn't have to maintain a separate name list.
The standup sheet is ready in seconds. The 20-minute Monday routine is now a 30-second one.
What If the Data Is Not Quite Ready
Some view IDs may have been deleted or deactivated
For each Zendesk view ID in column A, fetch the current ticket count and write it to column B and view name to column C. If a view ID is not found or is inactive, write 'view not found' in column B
Missing or inactive views are flagged rather than producing blank cells that look like zero counts.
You want a timestamp on the snapshot
For each Zendesk view ID in column A, fetch the current ticket count and write to column B, view name to column C. Write the current date and time to cell E1 as the snapshot timestamp
One cell records when the pull happened — useful for tracking if counts are compared week-over-week.
You want to calculate the change from last week
For each Zendesk view ID in column A, fetch the current ticket count and write to column C. Column B already has last week's count. Write the difference (column C minus column B) to column D and label positive differences as 'up' and negative as 'down' in column E
Week-over-week delta calculation in the same pass as the fresh pull.
Full automated standup dashboard
For each view ID in column A, fetch the current ticket count and write to column B, view name to column C. Calculate the 4-week rolling average using columns F through I (prior week counts) and write it to column D. Flag any view where the current count is more than 20% above the rolling average with 'spike' in column E
Live counts, rolling averages, and spike detection — one prompt turns a 20-minute Monday chore into a self-updating dashboard.
Try It
Get the 7-day free trial of SheetXAI and open your standup sheet with view IDs in column A, then run the count pull. Related: search and export tickets to dig into what's driving volume in any view, or return to the Zendesk integration guide.