Export objects of users, roles, groups, and organizations to Excel
Workflow Description
An automation template that extracts users, roles, groups, and organizations data from Zammad and converts it into an Excel file, enabling efficient data management and comprehensive reporting for administrative operations.
How it works
- 1.Trigger the workflow manually when export is needed
- 2.Fetch users, roles, groups, and organizations data from Zammad API
- 3.Process and structure the retrieved data for export
- 4.Convert the processed data into Excel file format
- 5.Deliver the Excel file to the user or designated storage location
Use cases
- Generate comprehensive organizational structure reports with user roles and permissions
- Support periodic audits and reviews of user access and organizational hierarchy
- Enable data migration and backup operations across systems
- Create pivot tables and analytical views using exported data in spreadsheet applications
Requirements
- Valid Zammad API credentials and authentication token configured
- Active n8n account with manual trigger execution enabled
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