Export Zammad Users, Roles, Groups, and Organizations to Excel
Workflow Description
A manual automation that retrieves users, roles, groups, and organizations from Zammad via API calls and converts them into a formatted Excel file, streamlining data management and report generation for organizational oversight.
How it works
- 1.Trigger the workflow manually through a button click
- 2.Call Zammad API to fetch users, roles, groups, and organizations data
- 3.Process and structure the retrieved data
- 4.Convert the formatted data into an Excel file
- 5.Generate and make the file available for download
Use cases
- Export complete user lists with assigned roles and permissions monthly
- Create backup snapshots of organizational structure and team hierarchies
- Generate administrative reports on staffing and access control configuration
Requirements
- Active Zammad account with API access credentials
- n8n instance properly configured with Zammad connection
Service Value
Ready-made workflow template for automation delivery and service execution.
Apps Used
Details
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (18)
When clicking ‘Test workflow’
Manual Trigger
Zammad Univeral User Object
Set
Zammad Univeral Organization Object
Set
Zammad Univeral Role Object
Set
Get all Organizations
Zammad
Get all Roles
HTTP Request
Convert to Excel Organizations
Convert To File
Convert to Excel Roles
Convert To File
Convert to Excel Users
Convert To File
Get all Users
Zammad
Zammad Univeral Group Object
Set
Get all Groups
HTTP Request
If
If
Basic Variables
Set
Convert to Excel Groups
Convert To File
Filter Groups if needed
If
Filter Roles if needed
If
Filter Organizations if needed
If