Sirhexalot This workflow corresponds to n8n.io template #2598 — we link there as the canonical source.
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": "xzKlhjcc6QEzA98Z",
"meta": {
"templateId": "2041",
"templateCredsSetupCompleted": true
},
"name": "Update Roles by Excel",
"tags": [],
"nodes": [
{
"id": "580d8a47-32cc-4976-a464-793523ae3d1e",
"name": "When clicking \"Execute Workflow\"",
"type": "n8n-nodes-base.manualTrigger",
"position": [
80,
140
],
"parameters": {},
"typeVersion": 1
},
{
"id": "f37ea772-a953-4b5b-8e54-c76e42938544",
"name": "Extract from File",
"type": "n8n-nodes-base.extractFromFile",
"position": [
760,
140
],
"parameters": {
"options": {},
"operation": "xlsx"
},
"typeVersion": 1
},
{
"id": "60ab7913-d421-41cd-af04-ccec2ed6838e",
"name": "Merge",
"type": "n8n-nodes-base.merge",
"position": [
1700,
120
],
"parameters": {
"mode": "combine",
"options": {},
"fieldsToMatchString": "email"
},
"typeVersion": 3
},
{
"id": "ad6719b4-95dc-419e-94cb-97039014be62",
"name": "Basic Variables",
"type": "n8n-nodes-base.set",
"position": [
320,
140
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "68b32087-5e23-4590-8042-0061234ce479",
"name": "zammad_base_url",
"type": "string",
"value": "https://zammad.sirhexalot.de/"
},
{
"id": "240f4dc5-a070-4623-96e7-1e0750dbeba5",
"name": "excel_source_url",
"type": "string",
"value": "http://zammad.sirhexalot.de/Users.txt"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "8f18e493-5dbe-4447-a422-450c610e9585",
"name": "Zammad Univeral User Object",
"type": "n8n-nodes-base.set",
"position": [
1020,
140
],
"parameters": {
"values": {
"string": [
{
"name": "email",
"value": "={{ $json.email }}"
},
{
"name": "role_ids",
"value": "={{ $json.role_ids }}\n"
}
]
},
"options": {},
"keepOnlySet": true
},
"typeVersion": 1
},
{
"id": "5bc0a423-91bc-4b52-af05-2869223bbbff",
"name": "Download Excel",
"type": "n8n-nodes-base.httpRequest",
"position": [
540,
140
],
"parameters": {
"url": "={{ $json.excel_source_url }}",
"options": {
"response": {
"response": {
"responseFormat": "file"
}
}
}
},
"typeVersion": 4.1
},
{
"id": "b5962a7b-27d3-45f1-adc4-1abff5d1c990",
"name": "Find Zammad User by email",
"type": "n8n-nodes-base.httpRequest",
"position": [
1360,
-60
],
"parameters": {
"url": "={{ $('Basic Variables').item.json.zammad_base_url }}api/v1/users/search?query=email:{{ $json.email }}",
"options": {},
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth"
},
"credentials": {
"httpHeaderAuth": {
"name": "<your credential>"
}
},
"executeOnce": false,
"typeVersion": 4.2,
"alwaysOutputData": false
},
{
"id": "0b8f5007-d28d-4406-a7ec-aa69d2b865d5",
"name": "Update User Roles",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueErrorOutput",
"position": [
2020,
120
],
"parameters": {
"url": "={{ $('Basic Variables').item.json.zammad_base_url }}/api/v1/users/{{ $json.id }}",
"method": "PUT",
"options": {},
"jsonBody": "={\n \"role_ids\": [\n {{ $json.role_ids }}\n ]\n} ",
"sendBody": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth"
},
"credentials": {
"httpHeaderAuth": {
"name": "<your credential>"
}
},
"typeVersion": 4.2
},
{
"id": "7724e271-0beb-4fc3-a9dd-4e55bcf033a1",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
60,
-500
],
"parameters": {
"width": 577.5890410958907,
"height": 253.58904109589045,
"content": "## Authentication for Zammad\n\nCreate in the Node Find Zammad User by email a Header Auth Authentication\n\nUse:\n\nName: Authorization\nValue: Bearer YOUR_TOKEN_HERE put here your zammad api token - \n"
},
"typeVersion": 1
}
],
"active": false,
"settings": {
"executionOrder": "v1"
},
"versionId": "2e34f31f-cb00-43e1-8709-6405ea8521ac",
"connections": {
"Merge": {
"main": [
[
{
"node": "Update User Roles",
"type": "main",
"index": 0
}
]
]
},
"Download Excel": {
"main": [
[
{
"node": "Extract from File",
"type": "main",
"index": 0
}
]
]
},
"Basic Variables": {
"main": [
[
{
"node": "Download Excel",
"type": "main",
"index": 0
}
]
]
},
"Extract from File": {
"main": [
[
{
"node": "Zammad Univeral User Object",
"type": "main",
"index": 0
}
]
]
},
"Find Zammad User by email": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 0
}
]
]
},
"Zammad Univeral User Object": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 1
},
{
"node": "Find Zammad User by email",
"type": "main",
"index": 0
}
]
]
},
"When clicking \"Execute Workflow\"": {
"main": [
[
{
"node": "Basic Variables",
"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.
httpHeaderAuth
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
This n8n workflow allows you to update user roles in Zammad based on data from an Excel file. The workflow automates role assignments, ensuring efficient and consistent updates. Excel Integration: Import user data from an Excel file containing emails and role assignments.…
Source: https://n8n.io/workflows/2598/ — 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.
This workflow allows you to import any workflow from a file or another n8n instance and map the credentials easily. A multi-form setup guides you through the entire process At the beginning you have t
[n8n] Advanced URL Parsing and Shortening Workflow - Switchy.io Integration. Uses splitInBatches, stickyNote, httpRequest, html. Event-driven trigger; 56 nodes.
[](https://youtu.be/c7yCZhmMjtI)
This automation organizes your n8n workflows files into categorizes (Active, Template, Done, Archived) and uploads them directly to a categorized Google Drive folders. It is designed to help users man
Create Animated Stories using GPT-4o-mini, Midjourney, Kling and Creatomate API. Uses httpRequest. Event-driven trigger; 51 nodes.