The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"id": "IXumIzS9WtPAhKFX",
"meta": {
"templateCredsSetupCompleted": true
},
"name": "Export Zammad Objects Users, Roles, Groups and Organizations to Excel",
"tags": [],
"nodes": [
{
"id": "59b12a25-d90f-47f0-a043-a51f71f5761e",
"name": "When clicking \u2018Test workflow\u2019",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-120,
-80
],
"parameters": {},
"typeVersion": 1
},
{
"id": "259acda6-75be-4011-b021-56321ab10478",
"name": "Zammad Univeral User Object",
"type": "n8n-nodes-base.set",
"position": [
600,
-80
],
"parameters": {
"values": {
"number": [
{
"name": "user_id",
"value": "={{ $json.id }}"
},
{
"name": "organization_id",
"value": "={{ $json.organization_id }}"
}
],
"string": [
{
"name": "email",
"value": "={{ $json.email }}"
},
{
"name": "firstname",
"value": "={{ $json.firstname }}"
},
{
"name": "lastname",
"value": "={{ $json.lastname }}"
},
{
"name": "role_ids",
"value": "={{ $json.role_ids.join() }}\n"
},
{
"name": "groups",
"value": "={{ $json.group_ids }}"
}
]
},
"options": {},
"keepOnlySet": true
},
"typeVersion": 1
},
{
"id": "57c68cc2-f5d6-4425-9dc2-b2d6b21f0026",
"name": "Zammad Univeral Organization Object",
"type": "n8n-nodes-base.set",
"position": [
600,
160
],
"parameters": {
"values": {
"number": [
{
"name": "organization_id",
"value": "={{ $json.id }}"
},
{
"name": "name",
"value": "={{ $json.name }}"
}
]
},
"options": {},
"keepOnlySet": true
},
"typeVersion": 1
},
{
"id": "c40b275c-1d33-4604-8073-3651641c94ed",
"name": "Zammad Univeral Role Object",
"type": "n8n-nodes-base.set",
"position": [
600,
400
],
"parameters": {
"values": {
"number": [
{
"name": "role_id",
"value": "={{ $json.id }}"
},
{
"name": "name",
"value": "={{ $json.name }}"
}
]
},
"options": {},
"keepOnlySet": true
},
"typeVersion": 1
},
{
"id": "29a257db-955d-4ff3-a7bb-f9a888f96e78",
"name": "Get all Organizations",
"type": "n8n-nodes-base.zammad",
"position": [
340,
160
],
"parameters": {
"resource": "organization",
"operation": "getAll",
"returnAll": true
},
"credentials": {
"zammadTokenAuthApi": {
"name": "<your credential>"
}
},
"typeVersion": 1
},
{
"id": "b4a9c2ca-b110-46ba-b5b9-2e8d8e357dfb",
"name": "Get all Roles",
"type": "n8n-nodes-base.httpRequest",
"position": [
340,
400
],
"parameters": {
"url": "={{ $json.zammad_base_url }}/api/v1/roles",
"options": {},
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "Authorization",
"value": "=Bearer {{ $json.zammad_api_key }}"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "9f5049cc-37ca-4069-86a1-75dffa9c2c96",
"name": "Convert to Excel Organizations",
"type": "n8n-nodes-base.convertToFile",
"position": [
1320,
140
],
"parameters": {
"options": {
"fileName": "Zammad_Organizations.xlsx"
},
"operation": "xlsx"
},
"typeVersion": 1.1
},
{
"id": "1a05b494-919c-4e53-8772-8c504e667f1c",
"name": "Convert to Excel Roles",
"type": "n8n-nodes-base.convertToFile",
"position": [
1340,
380
],
"parameters": {
"options": {
"fileName": "Zammad_Roles.xlsx"
},
"operation": "xlsx"
},
"typeVersion": 1.1
},
{
"id": "f1160af5-fcee-421d-9ede-b6f56ac0ce8d",
"name": "Convert to Excel Users",
"type": "n8n-nodes-base.convertToFile",
"position": [
1300,
-100
],
"parameters": {
"options": {
"fileName": "Zammad_Users.xslx"
},
"operation": "xlsx"
},
"typeVersion": 1.1
},
{
"id": "192c5342-5140-48f9-acb0-d14a41064fa3",
"name": "Get all Users",
"type": "n8n-nodes-base.zammad",
"position": [
340,
-80
],
"parameters": {
"filters": {},
"operation": "getAll",
"returnAll": true
},
"credentials": {
"zammadTokenAuthApi": {
"name": "<your credential>"
}
},
"typeVersion": 1
},
{
"id": "ae687777-c1cb-4a23-ae1e-aa34febc27d6",
"name": "Zammad Univeral Group Object",
"type": "n8n-nodes-base.set",
"position": [
620,
620
],
"parameters": {
"values": {
"number": [
{
"name": "group_id",
"value": "={{ $json.id }}"
},
{
"name": "name",
"value": "={{ $json.name }}"
}
]
},
"options": {},
"keepOnlySet": true
},
"typeVersion": 1
},
{
"id": "0d38e0b3-1a59-4a8f-9a04-8526aba91fd5",
"name": "Get all Groups",
"type": "n8n-nodes-base.httpRequest",
"position": [
340,
620
],
"parameters": {
"url": "={{ $json.zammad_base_url }}/api/v1/groups",
"options": {},
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "Authorization",
"value": "=Bearer {{ $json.zammad_api_key }}"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "e30bd0ad-9772-4af7-9012-99199fee65b2",
"name": "If",
"type": "n8n-nodes-base.if",
"position": [
900,
-80
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "0ca9d3a3-b726-4396-8cec-4a74c8e3949b",
"operator": {
"type": "object",
"operation": "exists",
"singleValue": true
},
"leftValue": "={{ $json }}",
"rightValue": 1781
}
]
}
},
"typeVersion": 2.2
},
{
"id": "2a83536e-e250-425a-aac7-f26ede0caf54",
"name": "Basic Variables",
"type": "n8n-nodes-base.set",
"position": [
60,
400
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "68b32087-5e23-4590-8042-0061234ce479",
"name": "zammad_base_url",
"type": "string",
"value": "-put-your-zammad-base-url-"
},
{
"id": "7db7572e-2524-4f2a-a1d6-b44330662c30",
"name": "zammad_api_key",
"type": "string",
"value": "-put-your-api-key-"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "db6a3024-9778-4d1e-8b25-34f2ee3ec26f",
"name": "Convert to Excel Groups",
"type": "n8n-nodes-base.convertToFile",
"position": [
1340,
600
],
"parameters": {
"options": {
"fileName": "Zammad_Groups.xlsx"
},
"operation": "xlsx"
},
"typeVersion": 1.1
},
{
"id": "bd191e0d-927d-44ca-afe6-fa6c7f3d59a2",
"name": "Filter Groups if needed",
"type": "n8n-nodes-base.if",
"position": [
900,
620
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "0ca9d3a3-b726-4396-8cec-4a74c8e3949b",
"operator": {
"type": "object",
"operation": "exists",
"singleValue": true
},
"leftValue": "={{ $json }}",
"rightValue": {}
}
]
}
},
"typeVersion": 2.2
},
{
"id": "c7c7b6b4-7faa-48b4-b7d8-6782dd1e4187",
"name": "Filter Roles if needed",
"type": "n8n-nodes-base.if",
"position": [
900,
400
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "0ca9d3a3-b726-4396-8cec-4a74c8e3949b",
"operator": {
"type": "object",
"operation": "exists",
"singleValue": true
},
"leftValue": "={{ $json }}",
"rightValue": 1781
}
]
}
},
"typeVersion": 2.2
},
{
"id": "a255bc7b-5d35-4671-852e-53f2b0980c26",
"name": "Filter Organizations if needed",
"type": "n8n-nodes-base.if",
"position": [
900,
160
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "0ca9d3a3-b726-4396-8cec-4a74c8e3949b",
"operator": {
"type": "object",
"operation": "exists",
"singleValue": true
},
"leftValue": "={{ $json }}",
"rightValue": 1781
}
]
}
},
"typeVersion": 2.2
}
],
"active": false,
"settings": {
"executionOrder": "v1"
},
"versionId": "8282fc5a-1ed4-4730-8e08-3d9f279dc3b5",
"connections": {
"If": {
"main": [
[
{
"node": "Convert to Excel Users",
"type": "main",
"index": 0
}
]
]
},
"Get all Roles": {
"main": [
[
{
"node": "Zammad Univeral Role Object",
"type": "main",
"index": 0
}
]
]
},
"Get all Users": {
"main": [
[
{
"node": "Zammad Univeral User Object",
"type": "main",
"index": 0
}
]
]
},
"Get all Groups": {
"main": [
[
{
"node": "Zammad Univeral Group Object",
"type": "main",
"index": 0
}
]
]
},
"Basic Variables": {
"main": [
[
{
"node": "Get all Roles",
"type": "main",
"index": 0
},
{
"node": "Get all Groups",
"type": "main",
"index": 0
}
]
]
},
"Get all Organizations": {
"main": [
[
{
"node": "Zammad Univeral Organization Object",
"type": "main",
"index": 0
}
]
]
},
"Filter Roles if needed": {
"main": [
[
{
"node": "Convert to Excel Roles",
"type": "main",
"index": 0
}
]
]
},
"Filter Groups if needed": {
"main": [
[
{
"node": "Convert to Excel Groups",
"type": "main",
"index": 0
}
]
]
},
"Zammad Univeral Role Object": {
"main": [
[
{
"node": "Filter Roles if needed",
"type": "main",
"index": 0
}
]
]
},
"Zammad Univeral User Object": {
"main": [
[
{
"node": "If",
"type": "main",
"index": 0
}
]
]
},
"Zammad Univeral Group Object": {
"main": [
[
{
"node": "Filter Groups if needed",
"type": "main",
"index": 0
}
]
]
},
"Filter Organizations if needed": {
"main": [
[
{
"node": "Convert to Excel Organizations",
"type": "main",
"index": 0
}
]
]
},
"When clicking \u2018Test workflow\u2019": {
"main": [
[
{
"node": "Get all Users",
"type": "main",
"index": 0
},
{
"node": "Basic Variables",
"type": "main",
"index": 0
},
{
"node": "Get all Organizations",
"type": "main",
"index": 0
}
]
]
},
"Zammad Univeral Organization Object": {
"main": [
[
{
"node": "Filter Organizations if needed",
"type": "main",
"index": 0
}
]
]
}
}
}
Credentials you'll need
Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.
zammadTokenAuthApi
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
How this works
Easily extract and export your Zammad support system's user data, roles, groups, and organisations into a single Excel file for quick analysis or reporting, saving hours of manual data handling. This workflow suits Zammad administrators or support teams needing to review team structures or compliance without diving into the dashboard. The key step involves fetching all relevant objects via the Zammad integration and an HTTP request, then converting them into structured Excel sheets for seamless download.
Use this workflow when preparing periodic audits, migrating data to another tool, or sharing overviews with non-technical stakeholders, especially for datasets under a few thousand records to avoid timeouts. Avoid it for real-time monitoring or very large instances where direct database queries might be more efficient. Common variations include filtering by specific dates or adding custom columns before export, or integrating with Google Sheets instead of Excel for collaborative editing.
About this workflow
Export Zammad Objects Users, Roles, Groups and Organizations to Excel. Uses manualTrigger, zammad, httpRequest, convertToFile. Event-driven trigger; 18 nodes.
Source: https://github.com/Zie619/n8n-workflows — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
Update all Zammad Roles to default values. Uses manualTrigger, zammad, httpRequest, convertToFile. Event-driven trigger; 10 nodes.
Create Animated Stories using GPT-4o-mini, Midjourney, Kling and Creatomate API. Uses httpRequest, stickyNote, manualTrigger. Event-driven trigger; 51 nodes.
Generate Leads with Google Maps - AlexK1919. Uses manualTrigger, scheduleTrigger, executeWorkflowTrigger, stopAndError. Event-driven trigger; 42 nodes.
Limit Code. Uses microsoftOutlookTrigger, httpRequest, limit, noOp. Event-driven trigger; 41 nodes.
AutoQoutesV2_template. Uses manualTrigger, httpRequest, stickyNote, googleSheets. Event-driven trigger; 28 nodes.