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.
Comment ça marche
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.
Triggers et actions
Trigger
Scheduled
Zendesk
Weekly on Monday at 9:00 AM
Action
Search Tickets
Zendesk
Search across all Zendesk tickets by keyword, status, assignee, or any search syntax.
Action
Get Ticket
Zendesk
Retrieve full ticket details including conversation history, tags, brand, and requester info.
Action
Create Spreadsheet
File Tools
Generate an Excel (.xlsx) spreadsheet from structured data with formatted columns and rows.
Action
Share File
File Tools
Cas d'usage liés
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.
Voir le cas d'usageDraft 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.
Voir le cas d'usageTriage 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.
Voir le cas d'usage
Essayez ce
workflow aujourd'hui.
Configuration en quelques minutes. Sans code, sans équipe d'intégration. Connectez et c'est parti.
500 crédits gratuits · sans limite de temps, sans carte de crédit
Shopify
Stripe
Slack
Notion
Google Workspace
Confluence