Exportar objetos de Zammad (usuarios, roles, grupos y organizaciones) a Excel
Avanzado
Este es unSupportflujo de automatización del dominio deautomatización que contiene 18 nodos.Utiliza principalmente nodos como If, Set, Zammad, HttpRequest, ConvertToFile. Exportar objetos de Zammad (usuarios, roles, grupos, organizaciones) a Excel
Requisitos previos
- •Pueden requerirse credenciales de autenticación para la API de destino
Nodos utilizados (18)
Categoría
Vista previa del flujo de trabajo
Visualización de las conexiones entre nodos, con soporte para zoom y panorámica
Exportar flujo de trabajo
Copie la siguiente configuración JSON en n8n para importar y usar este flujo de trabajo
{
"id": "IXumIzS9WtPAhKFX",
"meta": {
"instanceId": "494d0146a0f47676ad70a44a32086b466621f62da855e3eaf0ee51dee1f76753",
"templateCredsSetupCompleted": true
},
"name": "Export Zammad Objects Users, Roles, Groups and Organizations to Excel",
"tags": [],
"nodes": [
{
"id": "59b12a25-d90f-47f0-a043-a51f71f5761e",
"name": "Al hacer clic en 'Probar flujo de trabajo'",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-120,
-80
],
"parameters": {},
"typeVersion": 1
},
{
"id": "259acda6-75be-4011-b021-56321ab10478",
"name": "Objeto de Usuario Universal de Zammad",
"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": "Objeto de Organización Universal de Zammad",
"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": "Objeto de Rol Universal de Zammad",
"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": "Obtener todas las organizaciones",
"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
},
{
"id": "b4a9c2ca-b110-46ba-b5b9-2e8d8e357dfb",
"name": "Obtener todos los 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": "Convertir a Excel (Organizaciones)",
"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": "Convertir a 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": "Convertir a Excel (Usuarios)",
"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": "Obtener todos los usuarios",
"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
},
{
"id": "ae687777-c1cb-4a23-ae1e-aa34febc27d6",
"name": "Objeto de Grupo Universal de Zammad",
"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": "Obtener todos los grupos",
"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": "Si",
"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": "Variables básicas",
"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": "Convertir a Excel (Grupos)",
"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": "Filtrar grupos si es necesario",
"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": "Filtrar roles si es necesario",
"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": "Filtrar organizaciones si es necesario",
"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,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "8282fc5a-1ed4-4730-8e08-3d9f279dc3b5",
"connections": {
"e30bd0ad-9772-4af7-9012-99199fee65b2": {
"main": [
[
{
"node": "f1160af5-fcee-421d-9ede-b6f56ac0ce8d",
"type": "main",
"index": 0
}
]
]
},
"b4a9c2ca-b110-46ba-b5b9-2e8d8e357dfb": {
"main": [
[
{
"node": "c40b275c-1d33-4604-8073-3651641c94ed",
"type": "main",
"index": 0
}
]
]
},
"192c5342-5140-48f9-acb0-d14a41064fa3": {
"main": [
[
{
"node": "259acda6-75be-4011-b021-56321ab10478",
"type": "main",
"index": 0
}
]
]
},
"0d38e0b3-1a59-4a8f-9a04-8526aba91fd5": {
"main": [
[
{
"node": "ae687777-c1cb-4a23-ae1e-aa34febc27d6",
"type": "main",
"index": 0
}
]
]
},
"2a83536e-e250-425a-aac7-f26ede0caf54": {
"main": [
[
{
"node": "b4a9c2ca-b110-46ba-b5b9-2e8d8e357dfb",
"type": "main",
"index": 0
},
{
"node": "0d38e0b3-1a59-4a8f-9a04-8526aba91fd5",
"type": "main",
"index": 0
}
]
]
},
"29a257db-955d-4ff3-a7bb-f9a888f96e78": {
"main": [
[
{
"node": "57c68cc2-f5d6-4425-9dc2-b2d6b21f0026",
"type": "main",
"index": 0
}
]
]
},
"c7c7b6b4-7faa-48b4-b7d8-6782dd1e4187": {
"main": [
[
{
"node": "1a05b494-919c-4e53-8772-8c504e667f1c",
"type": "main",
"index": 0
}
]
]
},
"bd191e0d-927d-44ca-afe6-fa6c7f3d59a2": {
"main": [
[
{
"node": "db6a3024-9778-4d1e-8b25-34f2ee3ec26f",
"type": "main",
"index": 0
}
]
]
},
"c40b275c-1d33-4604-8073-3651641c94ed": {
"main": [
[
{
"node": "c7c7b6b4-7faa-48b4-b7d8-6782dd1e4187",
"type": "main",
"index": 0
}
]
]
},
"259acda6-75be-4011-b021-56321ab10478": {
"main": [
[
{
"node": "e30bd0ad-9772-4af7-9012-99199fee65b2",
"type": "main",
"index": 0
}
]
]
},
"ae687777-c1cb-4a23-ae1e-aa34febc27d6": {
"main": [
[
{
"node": "bd191e0d-927d-44ca-afe6-fa6c7f3d59a2",
"type": "main",
"index": 0
}
]
]
},
"a255bc7b-5d35-4671-852e-53f2b0980c26": {
"main": [
[
{
"node": "9f5049cc-37ca-4069-86a1-75dffa9c2c96",
"type": "main",
"index": 0
}
]
]
},
"59b12a25-d90f-47f0-a043-a51f71f5761e": {
"main": [
[
{
"node": "192c5342-5140-48f9-acb0-d14a41064fa3",
"type": "main",
"index": 0
},
{
"node": "2a83536e-e250-425a-aac7-f26ede0caf54",
"type": "main",
"index": 0
},
{
"node": "29a257db-955d-4ff3-a7bb-f9a888f96e78",
"type": "main",
"index": 0
}
]
]
},
"57c68cc2-f5d6-4425-9dc2-b2d6b21f0026": {
"main": [
[
{
"node": "a255bc7b-5d35-4671-852e-53f2b0980c26",
"type": "main",
"index": 0
}
]
]
}
}
}Preguntas frecuentes
¿Cómo usar este flujo de trabajo?
Copie el código de configuración JSON de arriba, cree un nuevo flujo de trabajo en su instancia de n8n y seleccione "Importar desde JSON", pegue la configuración y luego modifique la configuración de credenciales según sea necesario.
¿En qué escenarios es adecuado este flujo de trabajo?
Avanzado - Soporte
¿Es de pago?
Este flujo de trabajo es completamente gratuito, puede importarlo y usarlo directamente. Sin embargo, tenga en cuenta que los servicios de terceros utilizados en el flujo de trabajo (como la API de OpenAI) pueden requerir un pago por su cuenta.
Flujos de trabajo relacionados recomendados
Zammad - Asignar organizaciones a usuarios existentes mediante asignación basada en dominio
Asignar usuarios de Zammad a organizaciones por dominio de correo electrónico
If
Set
Merge
+
If
Set
Merge
8 NodosSirhexalot
Soporte
Sincronizar contactos de Entra con usuarios de Zammad
Entra联系人aZammad用户sincronización
If
Set
Merge
+
If
Set
Merge
14 NodosSirhexalot
🌍 Traductor de IA para WhatsApp – Traducción automática de voz y texto
🌍 Traductor e intérprete de IA de WhatsApp – Traducción de voz y texto
If
Set
Code
+
If
Set
Code
69 NodosBruno Dias
Ventas
✅ Fábrica de Reels virales
Usar Veo, Shotstack y Postiz para automatizar la creación y publicación de videos ASMR de frutas de vidrio
If
Jwt
Set
+
If
Jwt
Set
37 NodosAyoub Boutouil
Creación de contenido
Episodio 8: Influencer de Instagram
Automatizar el contenido de influencers de Instagram con GPT-4.1, Supabase y aprobación manual
If
Set
Gmail
+
If
Set
Gmail
55 NodosNICKYAI
Diseño
Envío automático de solicitudes de contacto y mensajes de rompimiento de hielo en LinkedIn usando Unipile y Google Sheets
Envío automático de solicitudes de conexión de LinkedIn y mensajes de rompimiento de hielo con Unipile y Google Sheets
If
Set
Code
+
If
Set
Code
44 NodosPollupAI
Otros
Información del flujo de trabajo
Nivel de dificultad
Avanzado
Número de nodos18
Categoría1
Tipos de nodos6
Descripción de la dificultad
Autor
Sirhexalot
@sirhexalotOpen source enthusiast and Zammad user with a passion for sharing knowledge and building simple, effective automation solutions with n8n.
Enlaces externos
Ver en n8n.io →
Compartir este flujo de trabajo