Templates / Export Zammad objects (users, roles, groups, organizations) to Excel

Export Zammad objects (users, roles, groups, organizations) to Excel

Ready for 3.0

by Sirhexalot ✓ · 1,112 views · created 2024-12-01 · Document Extraction

Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.

What this workflow does

This workflow has 18 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Zammad.

How it runs

Trigger: Manually, when you click “Execute workflow”.

  1. Get all Users (Zammad): get many
  2. Basic Variables (Edit Fields (Set)): sets 2 fields: zammad_base_url, zammad_api_key
  3. Get all Organizations (Zammad): get many (organization)
  4. Zammad Univeral User Object (Edit Fields (Set)): sets or maps fields
  5. Get all Roles (HTTP Request): calls an HTTP API
  6. Get all Groups (HTTP Request): calls an HTTP API
  7. Zammad Univeral Organization Object (Edit Fields (Set)): sets or maps fields
  8. If: checks a condition and branches into true / false
  9. Zammad Univeral Role Object (Edit Fields (Set)): sets or maps fields
  10. Zammad Univeral Group Object (Edit Fields (Set)): sets or maps fields

…plus 7 more steps. See the full node list below.

Services it uses

Zammad

Before you upgrade to n8n 3.0

Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.

Nodes used (6)

From the author

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 -…

Excerpt from Sirhexalot's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.