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.
Features
- Excel Integration: Import user data from an Excel file containing emails and role assignments.
- Dynamic Updates: Match Zammad users by email and update their roles.
- Error Handling: Continue workflow execution even if some updates fail.
- Customizable Variables: Configure Zammad API URL, API key, and Excel file URL.
Usage
- Import the Workflow: Upload the provided
.jsonfile into your n8n instance. - Set Variables:
zammad_base_url: Your Zammad instance URL.excel_source_url: URL of the Excel file containing user data.
- Authentication for Zammad
- Create in the Node "Find Zammad User by email" and "Update User Roles" a Header Auth Authentication
- Name: Authorization
- Value: Bearer <put here your zammad api token>
- Run the Workflow: Execute the workflow to update user roles based on the Excel data.
Issues and Suggestions
For issues or suggestions, visit the GitHub Repository.