Update n8n Zammad Roles by Excel

Free

by Sirhexalotindividual

An n8n workflow that automates the process of updating user roles in Zammad using data provided in an Excel spreadsheet.

This n8n workflow provides an automated solution for bulk updating user roles in Zammad. By processing an Excel spreadsheet, users are identified and their roles are adjusted via the Zammad API. This is particularly useful for administrators who need to regularly synchronize permissions for a large number of users without performing manual updates in the web interface. The workflow only requires an n8n instance and a Zammad API token.

Features

  • Excel Integration

    Imports user data from an Excel file (.xlsx) containing emails and role assignments.

  • Dynamic User Mapping

    Automatically identifies Zammad users by their email address for precise updates.

  • API-based Automation

    Utilizes the Zammad REST API for secure and fast role updates.

  • Error Handling

    The workflow is designed to continue execution even if individual record updates fail.

Related packages