Library / Customer Support & Helpdesk
Customer Support & Helpdesk
Update Zammad User Roles from an Excel File
When you run it, it downloads an Excel file, reads each row, finds the matching Zammad user by email and updates their roles.
What it does
# Update Roles by Excel ## Overview Automated workflow: Update Roles by Excel. This workflow integrates 7 different services: stickyNote, httpRequest, merge, set, stopAndError. It contains 16 nodes and follows best practices for error handling and security. ## Workflow Details - Total Nodes: 16 - Node Types: 7 - Error Handling: ✅ Implemented - Security: ✅ Hardened (no sensitive data) - Documentation: ✅ Complete ## Node Breakdown - When clicking "Execute Workflow": manualTrigger - Extract from File: extractFromFile - Merge: merge - Basic Variables: set - Zammad Univeral User Object: set - Download Excel: httpRequest - Find Zammad User by email: httpRequest - Update User Roles: httpRequest - Sticky Note: stickyNote - Error Handler: stopAndError - ... and 6 more nodes ## Usage Instructions 1. Configure Credentials: Set up all required API keys and credentials 2. Update Variables: Replace any placeholder values with actual data 3. Test Workflow: Run in test mode to verify functionality 4. Deploy: Activate the workflow for production use ## Security Notes - All sensitive data has been removed or replaced with placeholders - Error handling is implemented for reliability - Follow security best practices when configuring credentials ## Troubleshooting - Check error logs if workflow fails - Verify all credentials are properly configured - Ensure all required services are accessible
The steps
- When clicking "Execute Workflow"
- Extract from File
- Merge
- Basic Variables
- Zammad Univeral User Object
- Download Excel
- Find Zammad User by email
- Update User Roles
- Error Handler
- Stopanderror 1
- Stopanderror 2
- Error Handler for f37ea772
- Error Handler for 5bc0a423
- Error Handler for b5962a7b
37 steps in total.
Similar automations
Customer Support & HelpdeskExport Zammad Users, Roles, Groups and Organizations to Excel41 stepsCustomer Support & HelpdeskReset All Zammad Roles to Default Values30 stepsCustomer Support & HelpdeskUpdate Zammad User Roles from an Excel File8 stepsCustomer Support & HelpdeskReset All Zammad Roles to Default Values10 steps