The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"name": "Procedimiento ETL",
"nodes": [
{
"parameters": {
"content": "## Variables",
"height": 217.0756044906389,
"width": 929.8721112077363
},
"id": "1a71e00d-c2f8-49d9-9e20-4f8e01a70909",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
320,
420
]
},
{
"parameters": {
"workflowId": {
"__rl": true,
"value": "0GZC2HmaN6HG4RmY",
"mode": "list",
"cachedResultName": "Procedimiento SQL a XLSX con truncar"
},
"mode": "each",
"options": {
"waitForSubWorkflow": true
}
},
"id": "ba820363-5e86-49d1-b809-d97f3e09d50d",
"name": "Execute Workflow Download",
"type": "n8n-nodes-base.executeWorkflow",
"typeVersion": 1.1,
"position": [
380,
660
]
},
{
"parameters": {
"fileSelector": "={{ $('Execute Workflow Trigger').item.json.folderName }}{{ $('Execute Workflow Trigger').item.json.fileName }}{{ $('Execute Workflow Trigger').item.json.extName }}",
"options": {
"fileExtension": "={{ $('Execute Workflow Trigger').item.json.extName }}",
"fileName": "={{ $('Execute Workflow Trigger').item.json.fileName }}_{{ $('Names').item.json.startDate }}_{{ $('Names').item.json.endDate }}{{ $('Execute Workflow Trigger').item.json.extName }}",
"dataPropertyName": "data"
}
},
"id": "9bdffb2a-a155-4ae7-aa40-69b53b284d37",
"name": "Read/Write Files from Disk",
"type": "n8n-nodes-base.readWriteFile",
"typeVersion": 1,
"position": [
580,
660
],
"executeOnce": true,
"alwaysOutputData": false,
"notesInFlow": false
},
{
"parameters": {
"parentId": "={{ $('Execute Workflow Trigger').item.json.folderID }}",
"binaryData": true
},
"id": "546a5855-5ca3-4648-a3be-f512a327194b",
"name": "Microsoft OneDrive",
"type": "n8n-nodes-base.microsoftOneDrive",
"typeVersion": 1,
"position": [
760,
660
],
"credentials": {
"microsoftOneDriveOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"resource": "folder",
"operation": "search",
"query": "dashboard"
},
"id": "0162d558-e381-4b7f-b4b0-1d06b5525225",
"name": "Microsoft OneDrive1",
"type": "n8n-nodes-base.microsoftOneDrive",
"typeVersion": 1,
"position": [
960,
660
],
"credentials": {
"microsoftOneDriveOAuth2Api": {
"name": "<your credential>"
}
},
"disabled": true
},
{
"parameters": {
"values": {
"string": [
{
"name": "folderName",
"value": "={{ $('Execute Workflow Trigger').item.json.folderName }}"
},
{
"name": "procedureName",
"value": "={{ $('Execute Workflow Trigger').item.json.procedureName }}"
},
{
"name": "fileName",
"value": "={{ $('Execute Workflow Trigger').item.json.fileName }}"
},
{
"name": "extName",
"value": "={{ $('Execute Workflow Trigger').item.json.extName }}"
}
]
},
"options": {}
},
"id": "33c8fff3-054c-43a6-9a14-a506440a5f22",
"name": "Names",
"type": "n8n-nodes-base.set",
"position": [
1140,
460
],
"typeVersion": 1
},
{
"parameters": {},
"id": "239eaa75-88f7-46af-9447-f34cdcf6311c",
"name": "Execute Workflow Trigger",
"type": "n8n-nodes-base.executeWorkflowTrigger",
"typeVersion": 1,
"position": [
380,
460
]
},
{
"parameters": {
"workflowId": {
"__rl": true,
"value": "08k9xdf0VByNBZM2",
"mode": "list",
"cachedResultName": "Fechas"
},
"options": {
"waitForSubWorkflow": true
}
},
"id": "3a0c8303-1bcc-43ff-84ed-c400e3d9ff8f",
"name": "Execute Workflow Dates",
"type": "n8n-nodes-base.executeWorkflow",
"typeVersion": 1.1,
"position": [
580,
460
]
},
{
"parameters": {
"values": {
"string": [
{
"name": "startDate",
"value": "={{ $('Execute Workflow Dates').item.json.startMonthly }}"
},
{
"name": "endDate",
"value": "={{ $('Execute Workflow Dates').item.json.endMonthly }}"
},
{
"name": "addDate",
"value": "={{ $('Execute Workflow Dates').item.json.addMonthly }}"
}
]
},
"options": {}
},
"id": "8d25b7c5-345f-4b08-9c38-b09386887977",
"name": "Names0",
"type": "n8n-nodes-base.set",
"position": [
960,
460
],
"typeVersion": 1
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 2
},
"conditions": [
{
"id": "478170f4-537a-42d4-8627-b7e93fa58d25",
"leftValue": "={{ $('Execute Workflow Trigger').item.json.Monthly }}",
"rightValue": "",
"operator": {
"type": "string",
"operation": "exists",
"singleValue": true
}
}
],
"combinator": "and"
},
"options": {}
},
"id": "4d426d42-5a6f-41e4-aab4-83a105e9f3c5",
"name": "If Monthly",
"type": "n8n-nodes-base.if",
"typeVersion": 2.2,
"position": [
760,
460
]
}
],
"connections": {
"Execute Workflow Download": {
"main": [
[
{
"node": "Read/Write Files from Disk",
"type": "main",
"index": 0
}
]
]
},
"Read/Write Files from Disk": {
"main": [
[
{
"node": "Microsoft OneDrive",
"type": "main",
"index": 0
}
]
]
},
"Names": {
"main": [
[
{
"node": "Execute Workflow Download",
"type": "main",
"index": 0
}
]
]
},
"Execute Workflow Trigger": {
"main": [
[
{
"node": "Execute Workflow Dates",
"type": "main",
"index": 0
}
]
]
},
"Execute Workflow Dates": {
"main": [
[
{
"node": "If Monthly",
"type": "main",
"index": 0
}
]
]
},
"Names0": {
"main": [
[
{
"node": "Names",
"type": "main",
"index": 0
}
]
]
},
"If Monthly": {
"main": [
[
{
"node": "Names0",
"type": "main",
"index": 0
}
],
[
{
"node": "Names",
"type": "main",
"index": 0
}
]
]
}
},
"active": false,
"settings": {
"executionOrder": "v1",
"timezone": "America/Bogota",
"callerPolicy": "workflowsFromSameOwner"
},
"versionId": "bc9f95ec-7e7e-4f95-9f52-3c40327cd073",
"meta": {
"templateCredsSetupCompleted": true
},
"id": "zHVOCIcKp1yNh0KU",
"tags": []
}
Credentials you'll need
Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.
microsoftOneDriveOAuth2Api
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
Procedimiento ETL. Uses readWriteFile, microsoftOneDrive, executeWorkflowTrigger. Event-driven trigger; 10 nodes.
Source: https://github.com/alfarodaniel/ETL-Ambulatorios/blob/b5caacf5509134abba40f7a402e60f1f24b151d8/n8n/Procedimiento_ETL.json — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
This workflow contains community nodes that are only compatible with the self-hosted version of n8n. It creates a nested folder in your OneDrive's My Files You could be creating folders like:
Execute Workflow Trigger, Microsoft One Drive, N8N Nodes Datastore
🎯 Purpose: Generate audio files from text scripts stored in Google Drive.
Execute Workflow Trigger, Google Drive, Read Write File +1
JobFilter — 04 Vault Writer (sub-workflow). Uses executeWorkflowTrigger, readWriteFile. Event-driven trigger; 4 nodes.
Execute Workflow Trigger, Read Write File
Reagendamiento. Uses executeWorkflowTrigger, redis, n8n-nodes-evolution-api, dataTable. Event-driven trigger; 73 nodes.
Execute Workflow Trigger, Redis, N8N Nodes Evolution Api +2
Agendamiento. Uses n8n-nodes-evolution-api, redis, dataTable, executeWorkflowTrigger. Event-driven trigger; 60 nodes.
N8N Nodes Evolution Api, Redis, Data Table +2