Developer & DevOps
Update roles with Excel
9 nodes
193
133
Automatic trigger
Workflow Description
Automate role updates by extracting data from Excel files, merging and transforming the information, then sending it via HTTP requests to update your system. Eliminate manual role management and reduce errors in permission assignments.
How it works
- 1.Start the workflow manually using the trigger node
- 2.Extract role data from the uploaded Excel file
- 3.Merge extracted data with predefined variables and mappings
- 4.Transform and standardize data into required format
- 5.Send consolidated data via HTTP POST request to your API
- 6.Log results and trigger notifications for verification
Use cases
- Mass update roles across large teams without manual data entry
- Automate scheduled permission synchronization from HR systems
- Reduce human errors in role assignment and compliance tracking
Requirements
- Properly formatted Excel file with role and identifier columns
- Active API endpoint that accepts HTTP requests for role updates
- Manual trigger access and appropriate authentication credentials
Service Value
Ready-made workflow template for automation delivery and service execution.
Apps Used
Manual Trigger
Twitter/X
Merge
Set
HTTP Request
Note
Details
Trigger
Automatic trigger
Nodes
9
Apps
6
Views
193
Downloads
133
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (9)
When clicking "Execute Workflow"
Manual Trigger
Extract from File
Extract From File
Merge
Merge
Basic Variables
Set
Zammad Univeral User Object
Set
Download Excel
HTTP Request
Find Zammad User by email
HTTP Request
Update User Roles
HTTP Request
Sticky Note
Sticky Note