Sirhexalot
Open source enthusiast and Zammad user with a passion for sharing knowledge and building simple, effective automation solutions with n8n.
Templates by Sirhexalot
Export Zammad objects (users, roles, groups, organizations) to Excel
This n8n workflow enables you to export data from Zammad, including Users, Roles, Groups, and Organizations, into individual Excel files. It simplifies data handling and reporting by creating structured outputs for further processing or sharing. Features Export Users with associated details such as email, firstname, lastname, roleids, and groupids. Export Roles and Organizations with their respective identifiers and names. Convert all data into separate Excel files for easy access and use. Usage Import this workflow into your n8n instance. Configure the required Zammad API credentials (zammadbaseurl and zammadapikey) in the Basic Variables node. Run the workflow to generate Excel files containing Zammad data. Issues and Suggestions If you encounter any issues or have suggestions for improvement, please report them on the GitHub repository. We appreciate your feedback to help enhance this workflow!
By SirhexalotSync Entra user to Zammad user
This workflow facilitates seamless synchronization between Entra (Microsoft Azure AD) and Zammad. It automates the following processes: Fetch Entra Group Members: Retrieves users from a designated Entra group. These users are candidates for synchronization. Create Universal User Object: Extracts key user information, such as email, phone, and name, and formats it for Zammad compatibility. Synchronize with Zammad: Identifies users in Zammad who need updates based on Entra data. Adds new users from Entra to Zammad. Deactivates users in Zammad if they are no longer in the Entra group. Key Features Dynamic Matching: Compares users from Entra with existing Zammad users based on email and updates records accordingly. Efficient Management: Automatically creates, updates, or deactivates Zammad users based on their status in Entra. Custom Fields: Supports custom field mapping, ensuring enriched user profiles in Zammad. Setup Instructions Microsoft Entra Integration: Ensure proper API permissions for accessing Entra groups and members. Configure Microsoft OAuth2 credentials in n8n. Zammad Integration: Set up Zammad API credentials with appropriate access rights. Customize the workflow to include additional fields or map existing fields as needed. Run Workflow: Trigger the workflow manually or set up an automation schedule (e.g., daily sync). Review created/updated/deactivated users in Zammad. Use Cases IT Administration: Keep your support system in sync with the organization’s Entra data. User Onboarding: Automatically onboard new hires into Zammad based on Entra groups. Access Management: Ensure accurate and up-to-date user records in Zammad. Prerequisites Access to an Entra (Azure AD) environment with group data. A Zammad instance with API credentials for user management. A custom field in Zammad User Object (entra_key) of type String. A custom field in Zammad User Object (entraobjecttype) of type `Single selection field with two key value pairs user = User contact = Contact` --- This workflow is fully customizable and can be adapted to your organization’s specific needs. Save time and reduce manual errors by automating your user sync process with this template! If you have found an error or have any suggestions, please report them here on Github.
By SirhexalotAssign Zammad users to organizations based on email domain
This n8n workflow automates the assignment of existing users to organizations in Zammad based on their email domains, utilizing Zammad’s "domain-based assignment" feature. Use Case Automate the post-hoc assignment of existing users to organizations in Zammad by leveraging their email domains. This ensures efficient management of user-organization relationships using Zammad’s "domain-based assignment" feature. Requirements An active Zammad account with API access. Existing users and organizations in Zammad with proper email and domain configurations. Zammad organizations must have domain-based assignment enabled. Credentials Set up your Zammad API credentials in n8n to allow the workflow to interact with your Zammad instance securely. If you have found an error or have any suggestions, please report them here on Github.
By SirhexalotUpdate Zammad roles by Excel
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 .json file into your n8n instance. Set Variables: zammadbaseurl: Your Zammad instance URL. excelsourceurl: 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.
By SirhexalotUpdate all Zammad roles to default values
This n8n workflow allows you to reset all user roles in Zammad to specified default roles. It ensures consistency in role management across your Zammad instance. Features Retrieve all active users from Zammad. Update each user's roles to predefined default role IDs. Exclude specific users by their IDs from the update process. Simple configuration for default roles and excluded users. Usage Import the Workflow: Upload the provided .json file into your n8n instance. Configure Variables: zammadbaseurl: Your Zammad instance URL. zammadapikey: Your Zammad API key. default_roles: List of default role IDs to apply to all users. excludezammadusersbyid: List of user IDs to exclude from the update. Run the Workflow: Execute the workflow to update roles automatically. Issues and Suggestions For issues or suggestions, visit the GitHub Repository.
By Sirhexalot