The Scenario
The audit firm sent a formal request on Monday: complete conversation records for 30 specific support tickets, including every public reply and internal note, with timestamps and author identification. The deadline is end of Thursday. The ticket IDs are already in column A of an Excel workbook set up for the audit documentation package.
You're the compliance coordinator. You've done this before — the last time, it took two days of clicking through ticket pages in Zendesk, copying comments into a Word document, and praying you didn't miss an internal note that looked like a public reply.
The bad version:
- Open Zendesk, search for ticket ID 1.
- Scroll through the conversation thread. Copy each comment, with author and timestamp, into the Excel workbook.
- Realize you're not sure whether the green-labeled notes in Zendesk are "public" or "internal" and spend five minutes verifying.
- Finish ticket 1. Open ticket 2.
30 tickets. Some of them have 40-comment threads. The audit firm is not going to accept a partially completed comment log.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook. It reads the ticket IDs and uses the Zendesk integration to fetch every comment from every ticket, writing the complete history to your workbook automatically.
Open the SheetXAI sidebar in your audit workbook and paste:
Pull all conversation comments for every ticket ID in column A from Zendesk and populate this Excel sheet with ticket ID, author name, comment body, and whether it is public or internal
What You Get
- One row per comment across all 30 tickets.
- Ticket ID, author name, comment body, and visibility flag (public/internal) in the four columns.
- Both public replies and internal notes are captured and labeled correctly.
A ticket with 40 comments produces 40 rows. No manual copying.
What If the Data Is Not Quite Ready
You need the timestamp for each comment
Pull all Zendesk comments for each ticket ID in column A and write ticket ID, author name, timestamp, visibility (public/internal), and comment body to this Excel sheet — sort by ticket ID then by timestamp ascending
Timestamp included and rows sorted chronologically.
You only need comments from agents, not customer replies
Pull all Zendesk comments for each ticket ID in column A — write ticket ID, author name, comment role (agent/customer), timestamp, and body. Filter to only agent-authored comments
Agent-only filter scoped in the ask.
You need to split the output into separate worksheets per ticket
Pull all Zendesk comments for each ticket ID in column A. Create a separate worksheet for each ticket named by the ticket ID, containing author name, timestamp, visibility, and comment body
One worksheet per ticket for the audit firm's preferred format.
Full audit package
Pull all Zendesk comments for each ticket ID in column A and write to the 'Comments' worksheet — ticket ID, author name, timestamp, visibility, and body. On the 'Summary' worksheet, write each ticket ID, total comment count, first comment date, and last comment date, sorted by ticket ID
Raw comment log plus auditor-ready summary — two worksheets, one prompt, delivered before the deadline.
Try It
Get the 7-day free trial of SheetXAI and open your audit workbook with ticket IDs in column A. Related: export the ticket audit trail for the field-change history alongside comments, or return to the Zendesk integration guide.