Workflow: Export Zammad Objects Users, Roles, Groups and Organizations to Excel
Integrations: convertToFile, httpRequest, if, manualTrigger, set, zammad

{"id": "IXumIzS9WtPAhKFX", "meta": {"instanceId": "workflow-66e98c6b", "versionId": "1.0.0", "createdAt": "2025-09-29T07:07:49.960505", "updatedAt": "2025-09-29T07:07:49.960518", "owner": "n8n-user", "license": "MIT", "category": "automation", "status": "active", "priority": "high", "environment": "production"}, "name": "Export Zammad Objects Users, Roles, Groups and Organizations to Excel", "tags": ["automation", "n8n", "production-ready", "excellent", "optimized"], "nodes": [{"id": "59b12a25-d90f-47f0-a043-a51f71f5761e", "name": "When clicking \u2018Test workflow\u2019", "type": "n8n-nodes-base.manualTrigger", "position": [-120, -80], "parameters": {}, "typeVersion": 1, "notes": "This manualTrigger node performs automated tasks as part of the workflow."}, {"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, "notes": "This set node performs automated tasks as part of the workflow."}, {"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, "notes": "This set node performs automated tasks as part of the workflow."}, {"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, "notes": "This set node performs automated tasks as part of the workflow."}, {"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": {"id": "fj5GuzcJuNLQeMxz", "name": "Zammad Token Auth account"}}, "typeVersion": 1, "notes": "This zammad node performs automated tasks as part of the workflow."}, {"id": "b4a9c2ca-b110-46ba-b5b9-2e8d8e357dfb", "name": "Get all Roles", "type": "n8n-nodes-base.httpRequest", "position": [340, 400], "parameters": {"url": "{{ $env.BASE_URL }}", "options": {}, "sendHeaders": true, "headerParameters": {"parameters": [{"name": "Authorization", "value": "=Bearer {{ $json.zammad_api_key }}"}]}}, "typeVersion": 4.2, "notes": "This httpRequest node performs automated tasks as part of the workflow."}, {"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, "notes": "This convertToFile node performs automated tasks as part of the workflow."}, {"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, "notes": "This convertToFile node performs automated tasks as part of the workflow."}, {"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, "notes": "This convertToFile node performs automated tasks as part of the workflow."}, {"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": {"id": "fj5GuzcJuNLQeMxz", "name": "Zammad Token Auth account"}}, "typeVersion": 1, "notes": "This zammad node performs automated tasks as part of the workflow."}, {"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, "notes": "This set node performs automated tasks as part of the workflow."}, {"id": "0d38e0b3-1a59-4a8f-9a04-8526aba91fd5", "name": "Get all Groups", "type": "n8n-nodes-base.httpRequest", "position": [340, 620], "parameters": {"url": "{{ $env.BASE_URL }}", "options": {}, "sendHeaders": true, "headerParameters": {"parameters": [{"name": "Authorization", "value": "=Bearer {{ $json.zammad_api_key }}"}]}}, "typeVersion": 4.2, "notes": "This httpRequest node performs automated tasks as part of the workflow."}, {"id": "e30bd0ad-9772-4af7-9012-99199fee65b2", "name": "If Node", "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, "notes": "This if node performs automated tasks as part of the workflow."}, {"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, "notes": "This set node performs automated tasks as part of the workflow."}, {"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, "notes": "This convertToFile node performs automated tasks as part of the workflow."}, {"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, "notes": "This if node performs automated tasks as part of the workflow."}, {"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, "notes": "This if node performs automated tasks as part of the workflow."}, {"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, "notes": "This if node performs automated tasks as part of the workflow."}], "active": false, "pinData": {}, "settings": {"executionOrder": "v1", "saveManualExecutions": true, "callerPolicy": "workflowsFromSameOwner", "errorWorkflow": null, "timezone": "UTC", "executionTimeout": 3600, "maxExecutions": 1000, "retryOnFail": true, "retryCount": 3, "retryDelay": 1000}, "versionId": "8282fc5a-1ed4-4730-8e08-3d9f279dc3b5", "connections": {"b4a9c2ca-b110-46ba-b5b9-2e8d8e357dfb": {"main": [[{"node": "error-handler-b4a9c2ca-b110-46ba-b5b9-2e8d8e357dfb", "type": "main", "index": 0}], [{"node": "error-handler-b4a9c2ca-b110-46ba-b5b9-2e8d8e357dfb-dc99ed5b", "type": "main", "index": 0}], [{"node": "error-handler-b4a9c2ca-b110-46ba-b5b9-2e8d8e357dfb-8cb82c29", "type": "main", "index": 0}], [{"node": "error-handler-b4a9c2ca-b110-46ba-b5b9-2e8d8e357dfb-5791dea6", "type": "main", "index": 0}], [{"node": "error-handler-b4a9c2ca-b110-46ba-b5b9-2e8d8e357dfb-81ee9ead", "type": "main", "index": 0}], [{"node": "error-handler-b4a9c2ca-b110-46ba-b5b9-2e8d8e357dfb-8fb7d2ca", "type": "main", "index": 0}], [{"node": "error-handler-b4a9c2ca-b110-46ba-b5b9-2e8d8e357dfb-98cc6618", "type": "main", "index": 0}], [{"node": "error-handler-b4a9c2ca-b110-46ba-b5b9-2e8d8e357dfb-4de9627e", "type": "main", "index": 0}], [{"node": "error-handler-b4a9c2ca-b110-46ba-b5b9-2e8d8e357dfb-ae651b36", "type": "main", "index": 0}]]}, "0d38e0b3-1a59-4a8f-9a04-8526aba91fd5": {"main": [[{"node": "error-handler-0d38e0b3-1a59-4a8f-9a04-8526aba91fd5", "type": "main", "index": 0}], [{"node": "error-handler-0d38e0b3-1a59-4a8f-9a04-8526aba91fd5-a82e5ba3", "type": "main", "index": 0}], [{"node": "error-handler-0d38e0b3-1a59-4a8f-9a04-8526aba91fd5-f9fbd042", "type": "main", "index": 0}], [{"node": "error-handler-0d38e0b3-1a59-4a8f-9a04-8526aba91fd5-604dca3f", "type": "main", "index": 0}], [{"node": "error-handler-0d38e0b3-1a59-4a8f-9a04-8526aba91fd5-f5232e94", "type": "main", "index": 0}], [{"node": "error-handler-0d38e0b3-1a59-4a8f-9a04-8526aba91fd5-33ccb140", "type": "main", "index": 0}], [{"node": "error-handler-0d38e0b3-1a59-4a8f-9a04-8526aba91fd5-c971c95d", "type": "main", "index": 0}], [{"node": "error-handler-0d38e0b3-1a59-4a8f-9a04-8526aba91fd5-34d1e706", "type": "main", "index": 0}], [{"node": "error-handler-0d38e0b3-1a59-4a8f-9a04-8526aba91fd5-65749623", "type": "main", "index": 0}]]}, "9f5049cc-37ca-4069-86a1-75dffa9c2c96": {"main": [[{"node": "error-handler-9f5049cc-37ca-4069-86a1-75dffa9c2c96-494fe152", "type": "main", "index": 0}]]}, "1a05b494-919c-4e53-8772-8c504e667f1c": {"main": [[{"node": "error-handler-1a05b494-919c-4e53-8772-8c504e667f1c-b697f393", "type": "main", "index": 0}]]}, "f1160af5-fcee-421d-9ede-b6f56ac0ce8d": {"main": [[{"node": "error-handler-f1160af5-fcee-421d-9ede-b6f56ac0ce8d-abef53b3", "type": "main", "index": 0}]]}, "db6a3024-9778-4d1e-8b25-34f2ee3ec26f": {"main": [[{"node": "error-handler-db6a3024-9778-4d1e-8b25-34f2ee3ec26f-671daa45", "type": "main", "index": 0}]]}}, "description": "Automated workflow: Export Zammad Objects Users, Roles, Groups and Organizations to Excel. This workflow processes data and performs automated tasks.", "notes": "Excellent quality workflow: Export Zammad Objects Users, Roles, Groups and Organizations to Excel. This workflow has been optimized for production use with comprehensive error handling, security, and documentation."}