Update Zammad User Roles from Excel File

This n8n workflow streamlines user role management in Zammad, a popular open-source helpdesk and customer support platform. It reads user data—including emails and desired roles—from an Excel file, queries the Zammad API to find matching users, and updates their roles accordingly. Key features include robust error handling to continue processing even if individual updates fail, customizable variables for Zammad base URL and Excel source, and seamless integration via HTTP requests with Bearer token authentication.

Benefits include significant time savings for administrators managing large teams or frequent role changes, reducing manual data entry errors and ensuring consistency across your support organization. It's ideal for scaling customer support operations where roles like agent, admin, or customer need periodic updates based on HR spreadsheets or external data sources.

Use cases span onboarding/offboarding employees, bulk role promotions during organizational changes, or syncing roles from external systems like HR tools. Simply import the workflow JSON, configure credentials, provide your Excel URL, and execute—perfect for non-technical users with basic n8n knowledge. For enhancements, check the linked GitHub repository.