Zammad Data Export to Structured Excel Files - n8n Workflow

Zammad System Administrators needing regular data backups or migrations.
Data Analysts required to audit or report on Zammad user, role, and group assignments.
n8n users looking for practical n8n templates that showcase complex data manipulation and multi-path processing.
Developers needing to extract configuration data using an automated n8n node combination.

Managing Zammad data, especially for auditing or bulk reporting, often requires exporting key objects like users and roles. This comprehensive n8n workflow solves the tedious manual export problem by providing a single, automated execution path. It concurrently extracts four primary data types—Users, Organizations, Roles, and Groups—using both dedicated Zammad n8n node connections and flexible HTTP Requests.

The core value of this n8n template lies in its parallelism and data standardization. After retrieving the raw data, dedicated 'Set' n8n node operations clean and standardize the output for each object type (e.g., mapping group IDs and combining role IDs for users). Finally, the clean data streams are converted directly into separate, ready-to-use XLSX files, demonstrating an efficient use of the file conversion n8n node.

This n8n workflow begins with the Manual Trigger n8n trigger, allowing for on-demand execution.

1. Variable Setup: The process first uses a 'Set' n8n node ('Basic Variables') to define the zammadbaseurl and zammadapikey. These variables are critical for subsequent HTTP Request nodes.


2. Parallel Data Extraction: The n8n workflow splits into four parallel branches to retrieve data:

1. Data Structuring: Four dedicated 'Set' n8n node operations (e.g., 'Zammad Univeral User Object') normalize the retrieved JSON data. For instance, the User Set node consolidates role IDs and group IDs into clean string fields, making the data spreadsheet-friendly.


2. Flow Control: Placeholder 'If' n8n node gates are used to ensure data exists before proceeding. These nodes are included in this n8n template for easy customization, allowing users to implement specific filtering criteria (e.g., only exporting active users).


3. File Conversion: Finally, four 'Convert to File' n8n node operations convert each structured data stream into its corresponding XLSX file (ZammadUsers.xslx, ZammadOrganizations.xlsx, etc.), completing the full automation using this efficient n8n workflow structure.

To deploy this n8n workflow, follow these steps:

1. Import: Copy the provided JSON code and import it directly into your n8n instance using the 'New' menu and selecting 'Import from JSON'.


2. Zammad Credentials: This n8n workflow utilizes two methods for Zammad connection:

1. Testing: Execute the n8n workflow using the 'Test workflow' button. The resulting XLSX files will be available in the output of the final 'Convert to Excel' n8n node steps.

Manual Trigger (n8n trigger): Initiates the entire data export process manually.
Basic Variables (Set n8n node): Essential setup for HTTP requests. It securely injects the Zammad base URL and API key as flow variables (zammadbaseurl, zammadapikey) to be used by subsequent HTTP Request n8n node steps.
Get all Users / Get all Organizations (Zammad n8n node): Uses the dedicated Zammad credential to retrieve all items for the selected resource with the getAll operation.
Get all Roles / Get all Groups (HTTP Request n8n node): Fetches role and group data using a dynamic URL and bearer token authentication, pulling values from the Basic Variables n8n node setup.
Zammad Univeral User Object (Set n8n node): Transforms raw user data. Key configuration includes mapping roleids and groupids arrays into comma-separated strings using JSON expression ={{ $json.roleids.join() }}.
Filter X if needed (If n8n node): Used as a standard flow control gate. Currently configured to check if the input object exists, acting as a passthrough, but ready for custom filtering logic.

• Convert to Excel X (Convert to File n8n node): The final action of this n8n workflow. It takes the standardized JSON array and outputs it as an XLSX file, assigning unique filenames like ZammadUsers.xslx and Zammad_Roles.xlsx.