The Scenario
It's the first week of the new quarter and your VP of CX wants a CSAT breakdown by agent for Q1 — not the aggregate dashboard number, but the raw survey responses so she can see individual comment patterns and spot which agents are getting negative feedback on the same category of issue.
Zendesk's built-in CSAT report shows you the overall score. It doesn't let you export the individual responses with agent attribution and customer comments in a format that's easy to pivot.
The bad version:
- Navigate to the Zendesk Satisfaction tab.
- Try to export the ratings — discover the export includes fields you don't need and omits the assignee name.
- Download the CSV, open it in Sheets, realize the comment column is in a different position than you expected, spend 30 minutes reorganizing the table.
- Still have no clean way to filter by agent without a manual sort.
Customer satisfaction data is the clearest signal your support team generates. Spending an hour reformatting the export before you can read it wastes the signal.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It uses the Zendesk integration to pull all CSAT survey responses directly into the sheet with the exact columns you need.
Open the SheetXAI sidebar in your Q1 CSAT sheet and paste:
Export all Zendesk satisfaction ratings from the past 90 days into this sheet with columns for ticket ID, rating, comment, requester name, assignee name, and submission date
What You Get
- One row per survey response.
- Rating values (good / bad) in column C, readable without lookup.
- Assignee name included — not agent ID — so you can pivot by agent immediately.
- Customer comments in column D, untruncated.
- Submission date in a parseable format.
What If the Data Is Not Quite Ready
You only want negative ratings (bad)
Export all Zendesk satisfaction ratings from the past 90 days where the rating is 'bad' — include ticket ID, comment, requester name, assignee name, and submission date in this sheet
Negative-only filter in the ask. No post-export filtering needed.
You want to group by agent and count ratings
Export all Zendesk satisfaction ratings from the past 90 days to the 'Raw Ratings' tab with ticket ID, rating, comment, assignee name, and submission date. Then summarize to the 'By Agent' tab showing each assignee's good count, bad count, and CSAT percentage
One prompt writes the raw data to one tab and the summary to another.
You need a specific date range rather than the past 90 days
Export all Zendesk satisfaction ratings submitted between 2026-01-01 and 2026-03-31 into this sheet with ticket ID, rating, comment, requester name, assignee name, and submission date
Exact date range in the ask — no filter formulas needed after the fact.
Full Q1 CSAT package for VP review
Export all Zendesk satisfaction ratings from Q1 2026 to the 'Raw' tab with ticket ID, rating, comment, assignee name, and date. On the 'Summary' tab, write each agent's total responses, good count, bad count, and CSAT percentage. Flag any agent below 80% CSAT in column E of the Summary tab
Raw responses, agent summaries, and low-performer flags — one prompt, ready for the VP meeting.
Try It
Get the 7-day free trial of SheetXAI and open a blank sheet for your Q1 CSAT report, then run the satisfaction export. Related: export ticket metrics to layer in resolution time data, or return to the Zendesk integration guide.