🎫 Update Zammad roles by Excel

⚡ 565 views · 🎫 Ticket Management & Triage

💡 Pro Tip — If you need GitHub data beyond what the REST API gives you, ScraperNode has a repository scraper that extracts metadata at scale without token rate limits.

Description

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

1. Import the Workflow: Upload the provided .json file into your n8n instance.
2. Set Variables:
   • zammad_base_url: Your Zammad instance URL.
   • excel_source_url: URL of the Excel file containing user data.
3. 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>

4. 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.

🔗 Nodes Used

HTTP Request, Extract from File

📥 Import

Download workflow.json and import into n8n: Workflow menu → Import from File

📖 Importing guide · 🔑 Credential setup