Generate weekly support reports as spreadsheets
On a schedule or when requested, Macha pulls ticket data from Zendesk for the past week, compiles key metrics — volume, resolution times, CSAT, top topics — and generates an Excel spreadsheet with the full report.
Replaces manual reporting with automated, shareable spreadsheets that keep the team aligned on support performance.
So funktioniert's
Scheduled
Weekly on Monday at 9:00 AM
Search tickets
Querying all tickets from the last 7 days in Zendesk
Compile metrics
Calculated volume, resolution time, CSAT, top topics, and agent performance
Create spreadsheet
Generated Excel report with Summary, Tickets, Agent Performance, and Topics sheets
Share file
Shared weekly-support-report-mar-24.xlsx
Weekly Support Report — Mar 17 to Mar 23
• Total tickets: 312
• Resolved: 298 (95.5%)
• Avg first response: 8 min
• Avg resolution time: 1.8 hours
• CSAT: 96%
• Top topics: Account access (42), Billing (38), Setup help (31)
Full report attached as weekly-support-report-mar-24.xlsx with detailed breakdowns by agent, topic, and day.
Trigger und Aktionen
Trigger
Scheduled
Zendesk
Weekly on Monday at 9:00 AM
Aktion
Search Tickets
Zendesk
Search across all Zendesk tickets by keyword, status, assignee, or any search syntax.
Aktion
Get Ticket
Zendesk
Retrieve full ticket details including conversation history, tags, brand, and requester info.
Aktion
Create Spreadsheet
File Tools
Generate an Excel (.xlsx) spreadsheet from structured data with formatted columns and rows.
Aktion
Share File
File Tools
Verwandte Use Cases
Auto-reply using knowledge base articles
When a ticket comes in with a common question, Macha searches the Help Center knowledge base for the most relevant article, extracts the key steps, and replies with a clear, helpful answer.
Use Case ansehenDraft ticket responses for agent review
Macha reads the ticket, searches relevant documentation in Notion, and drafts a response for the agent. The agent can edit, approve, or rewrite before sending.
Use Case ansehenTriage and route tickets by topic
When a new ticket arrives, Macha reads the content, classifies the topic, sets the appropriate priority, and routes it to the right team or agent — all in seconds.
Use Case ansehen
Testen Sie diesen
Workflow heute.
In wenigen Minuten eingerichtet. Kein Code, kein Implementierungsteam. Einfach verbinden und loslegen.
500 Freikredite · ohne Zeitlimit, ohne Kreditkarte
Shopify
Stripe
Slack
Notion
Google Workspace
Confluence