OpenRuna
Sign in
← Workflows

Update Roles by Excel

9 nodes · manual, extractFromFile, httpRequest

Engine
n8n
Nodes
9
Trigger
scheduled/triggered
Source file
2022_Manual_Extractfromfile_Update_Webhook.json

Workflow flow

IntegrationsManualExtractFromFileHTTPMergeSet
100%
TRIGGER

When clicking "Execute Workflow"

Manual

Basic Variables

Set

Download Excel

HTTP

Extract from File

ExtractFromFile

Zammad Univeral User Object

Set

Find Zammad User by email

HTTP

Merge

Merge

Update User Roles

HTTP

8 steps · flows top to bottom, branches left to right

Browse by integration

manualextractFromFilehttpRequest
Browse all integrations →
Download n8n JSONDownload sanitized JSONDownload flow graph

Import into n8n

  1. Download the n8n JSON file (full or sanitized).
  2. In n8n: Workflows → Import from file.
  3. Open each node and reconnect credentials to your accounts.
  4. Test with manual execution before enabling triggers.

Sanitized JSON removes credential IDs — safer for sharing. Flow graph JSON is OpenRuna's lightweight format for diagrams and other tools, not n8n import.

View source corpus ↗

Overview

Update Roles by Excel (9-node n8n automation, manual, extractFromFile, httpRequest) is free on OpenRuna — view the graph and export the JSON to import into n8n.

What this workflow does

"Update Roles by Excel" automates a manual-to-extractFromFile flow in n8n across 9 nodes. 9 nodes · manual, extractFromFile, httpRequest It starts from a scheduled/triggered trigger and routes data through every node in order. OpenRuna shows the full flow diagram, an integration breakdown, and a one-click JSON export for n8n's "Import from file". Use it to learn integration patterns, fork it for your own use case, or deploy it quickly after reconnecting credentials.

Use cases

  • Benchmark it against your current manual integration to spot missing steps or redundant nodes.
  • Fork it to add error handling, retries, or a notification step without designing the 9-node flow from scratch.
  • Share it with your team as a documented reference for scheduled/triggered automations in the manual stack.
  • Study how data moves from manual to extractFromFile before building your own variant.

Example output

Imported into n8n, "Update Roles by Excel" exposes 9 configured nodes. Trigger type: scheduled/triggered. Integrations: manual, extractFromFile, httpRequest. Open each node after import to map credentials to your own manual and extractFromFile accounts. Run it once in test mode to verify any branch logic (Switch/IF nodes) before enabling production triggers.

Tips by platform

Claude

Paste the exported JSON for "Update Roles by Excel" into Claude and ask it to explain each of the 9 nodes. Claude is good at suggesting credential mappings for manual, extractFromFile, httpRequest, plus error-handling and idempotency improvements before you run it in production.

ChatGPT

Have ChatGPT generate a checklist for adapting "Update Roles by Excel" to your accounts — which manual, extractFromFile, httpRequest credentials to create and which node parameters to change first.

Cursor

Open the downloaded JSON in Cursor and use Agent mode to refactor hard-coded URLs into env vars, or to generate tests for any Code nodes. Keep the OpenRuna flow diagram open so you do not break connection order across the 9 nodes.

Frequently asked questions

How do I import "Update Roles by Excel" into n8n?
Click Download n8n JSON on this page, then in n8n choose Workflows → Import from file and select the downloaded file. Reconnect credentials on each node — the export carries credential IDs from the original author's instance, not working secrets.
Which integrations does "Update Roles by Excel" use?
It uses: manual, extractFromFile, httpRequest. The flow diagram above shows how each service connects across the 9 nodes. Filter OpenRuna by integration to find related workflows and tools.
Can I import a sanitized export without credentials?
Yes. Use "Download sanitized JSON" to strip credential references before sharing internally. You will still add your own manual and extractFromFile credentials in n8n after import.
What trigger type does "Update Roles by Excel" use?
Trigger type: scheduled/triggered. After import, confirm the trigger node (webhook, schedule, or app event) matches your environment, then activate the workflow when you are ready to run it.
Is "Update Roles by Excel" free to use?
OpenRuna catalogs community n8n workflows under open licenses. Check the source corpus link for the original license; commercial use may require verifying the third-party API terms for manual, extractFromFile, httpRequest.

Related resources