Zammad Customer Support Analytics via Zulip

This workflow automates support ticket monitoring, replacing manual dashboard checks and report generation that take 2-4 hours daily for helpdesk teams. The Support Automation Trigger Webhook receives events, the Scheduled Report Trigger Cron runs daily at 8:30 AM weekdays, the Manual Report Trigger enables on-demand, the Support Security Validator If node verifies auth, the Support Data Sanitizer Set node prepares configs, the Ticket Data Fetcher Zammad node retrieves tickets, the Ticket Analytics Processor Function node calculates metrics like status/priority breakdowns, the Notification Channel Selector Switch node routes, the Zulip Notifier Zulip node alerts teams, the Support Analytics Logger Function node tracks KPIs, the Support Response Formatter Set node structures outputs, and the Support Success Response Respond to Webhook node confirms. Error paths (Support Security Error Response) handle auth fails. It helps support leads in small SaaS firms (10-30 staff) managing 200+ tickets monthly, providing real-time insights and alerts without constant logins, reducing resolution times and improving SLA compliance through proactive notifications.\n\nThis workflow saves 8-12 hours weekly on 200 tickets, enhancing efficiency by 80%. Use cases include helpdesk dashboards for tech support, SLA tracking for agencies. Suitable for small-mid teams. Requires Zammad (free self-host, $29/month cloud), Zulip (free), Airtable ($10/month Pro); n8n (free self-hosted or $20/month cloud). Scalable to 1,000 tickets/month with Pro tiers.\n\nInstall n8n via n8n.io or cloud.n8n.io. Get Zammad token at zammad.org (Admin > API > Generate). Configure Ticket Data Fetcher with token/URL. For Zulip, enable API at zulip.com (get token). Create Airtable base at airtable.com with 'Error Log' table. Set ZAMMAD_TOKEN env var. Import JSON; webhook POST 'customer-support-automation' with header auth. Update Scheduled Report Trigger for time zone.\n\nTest with Manual Report Trigger. Verify Zulip alert, Airtable log. Errors: Invalid token (401—regenerate), no tickets (empty). Activate webhook/Schedule. Monitor dashboard weekly. Optimize limits; refresh tokens quarterly.", "businessValue": "Saves 8-12 hours/week managing 200 support tickets", "setupTime": "25-35 minutes", "difficulty": "Intermediate", "requirements": ["Zammad (free self-host, $29/month cloud)", "Zulip API (free)", "Airtable API ($10/month Pro)", "n8n instance"], "useCase": "Automated ticket analytics and team notifications"