The Scenario
The regulatory auditor's email arrived on Tuesday morning. They need complete conversation histories for 30 specific support tickets — every comment, every internal note, every timestamp — submitted as a structured document by end of week. The ticket IDs are already in column A of a compliance sheet.
The bad version:
- Open Zendesk, search for ticket 1, scroll through the conversation thread, manually copy each comment with its author and timestamp into the sheet.
- Realize internal notes look different from public replies in the Zendesk UI, and you're not sure you captured both correctly.
- Get to ticket 11 and calculate that you have nineteen more tickets and two remaining days, and start questioning every career decision that led here.
A compliance audit on support conversations is already stressful. Doing it comment-by-comment through the Zendesk UI — for 30 tickets, some of which have 40-comment threads — transforms a documentation task into something genuinely grueling.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It reads the ticket IDs and uses the Zendesk integration to fetch every comment from every ticket, writing the full history to your sheet automatically.
Open the SheetXAI sidebar in your compliance sheet and paste:
For each ticket ID in column A, fetch all comments from Zendesk and write them into this sheet with ticket ID, comment author, timestamp, public/internal flag, and comment text
What You Get
- One row per comment across all 30 tickets — not one row per ticket.
- Ticket ID in column A, author name in column B, timestamp in column C (readable format), visibility flag in column D (public or internal), comment body in column E.
- Internal notes and public replies both appear and are labeled correctly.
A ticket with 40 comments produces 40 rows. The full audit trail is there without any manual copying.
What If the Data Is Not Quite Ready
You need comments sorted chronologically across all tickets
For each ticket ID in column A, fetch all Zendesk comments and write them to this sheet with ticket ID, author, timestamp, visibility, and body — sort all rows by timestamp ascending
The cross-ticket sort runs before the data lands.
You only need comments from the past 90 days
For each ticket ID in column A, fetch all Zendesk comments created after 2026-02-14 and write ticket ID, author, timestamp, visibility, and comment text to this sheet
The date filter scopes the pull without a post-processing step.
You need to flag comments from a specific agent
For each ticket ID in column A, fetch all Zendesk comments and write ticket ID, author, timestamp, visibility, and body to this sheet. Add a column F with 'flagged' if the author email matches 'agent@example.com', otherwise leave blank
The conditional tagging happens inline.
Full audit export with summary
For each ticket ID in column A, fetch all Zendesk comments and write ticket ID, author, timestamp, visibility, and body to the 'Comments' tab. Then write a summary to the 'Summary' tab showing each ticket ID, total comment count, first comment date, and last comment date
Raw comment data in one tab, auditor-ready summary in the other — one prompt covers both.
The pattern: describe the full output shape across multiple tabs and SheetXAI handles the joins and aggregation.
Try It
Get the 7-day free trial of SheetXAI and open your compliance sheet with ticket IDs in column A, then run the comment export. Related: export the full audit trail, or return to the Zendesk integration guide.