Export Zammad Users, Roles, Groups & Orgs to Excel

This n8n workflow streamlines data extraction from Zammad, a popular open-source helpdesk and ticketing system. It fetches comprehensive details on users (including email, names, role_ids, group_ids, organization_id), roles, groups, and organizations using the Zammad API. The data is then structured and exported into individual Excel files, making it ideal for backups, audits, compliance reporting, or offline analysis.

Key benefits include time-saving automation of manual exports, reduced errors in data handling, and compatibility with tools like Excel for further processing or visualization. Users simply configure the Zammad base URL and API key in the Basic Variables node, trigger the workflow manually, and receive ready-to-use spreadsheets.

Use cases span customer support teams needing periodic reports, IT admins for user management overviews, or educational institutions using Zammad for learning analytics (e.g., tracking student support tickets by groups/roles). Enhancements can include scheduling via cron triggers or integrating with cloud storage for automated sharing. Report issues on the linked GitHub repo for community improvements.