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 →
{
"nodes": [
{
"id": "20299349-bc2c-4aa8-b083-db31cb9aa278",
"name": "GET ALL COLUMNS",
"type": "n8n-nodes-base.code",
"position": [
1840,
-600
],
"parameters": {
"jsCode": "function createColumnValuesArray(data) {\n const result = {};\n data.forEach(item => {\n const name = item.id;\n result[name] = item;\n });\n\n return result;\n}\n\ncolumns = $input.last().json.column_values\ndata1 = { \"name\" : $input.last().json.name, \"id\" : $input.last().json.id }\ndata2 = createColumnValuesArray(columns)\n\nconst combinedData = { \"item\" : data1, columnValuesById: data2}\n\nreturn (combinedData)\n\n\n"
},
"typeVersion": 2
},
{
"id": "04c2550e-41d8-46f4-a131-2ea99dd4258a",
"name": "GET ALL RELATIONS",
"type": "n8n-nodes-base.code",
"position": [
1860,
-220
],
"parameters": {
"jsCode": "var data = $input.last().json.columnValuesById;\ni = 0;\nrelations = [];\nfor (var key in data) {\n if (data[key].type == \"board_relation\") {\n relations[i] = data[key];\n i++\n }\n}\n\nreturn relations;\n\n"
},
"typeVersion": 2
},
{
"id": "5796cb17-199b-4838-ae9c-c3636824bd13",
"name": "PULL LINKEDPULSE1",
"type": "n8n-nodes-base.mondayCom",
"position": [
1720,
-40
],
"parameters": {
"itemId": "=\n{{ $json.linkedPulse.linkedPulseId }}",
"resource": "boardItem",
"operation": "get"
},
"credentials": {
"mondayComApi": {
"name": "<your credential>"
}
},
"notesInFlow": true,
"typeVersion": 1
},
{
"id": "67a8a151-5875-4ec7-8fda-f797f3d3b198",
"name": "GET LINKEDPULSES1",
"type": "n8n-nodes-base.code",
"position": [
1340,
-40
],
"parameters": {
"mode": "runOnceForEachItem",
"jsCode": "data = $input.item.json.value\nid = $input.item.json.id\nname = $input.item.json.column.title\n\nconst linkedPulseID = JSON.parse(data).linkedPulseIds\n\nreturn { \"linkedPulse\": linkedPulseID, \"id\" : id, \"name\": name }\n"
},
"typeVersion": 2
},
{
"id": "5dbe451d-ec23-48bf-9193-55a03b8752a4",
"name": "SPLIT LINKED PULSES1",
"type": "n8n-nodes-base.splitOut",
"position": [
1540,
-40
],
"parameters": {
"include": "=",
"options": {},
"fieldToSplitOut": "linkedPulse"
},
"typeVersion": 1
},
{
"id": "536897b1-ed71-4888-9761-cb4a363f0a86",
"name": "SPLIT SUBITEMS1",
"type": "n8n-nodes-base.splitOut",
"position": [
1540,
200
],
"parameters": {
"include": "selectedOtherFields",
"options": {},
"fieldToSplitOut": "linkedPulseIds",
"fieldsToInclude": "linkedPulseIds[0].linkedPulseId"
},
"typeVersion": 1
},
{
"id": "57777d0c-77d0-4652-a798-2d347b12cfb4",
"name": "GET EACH SUBITEM1",
"type": "n8n-nodes-base.mondayCom",
"position": [
1700,
200
],
"parameters": {
"itemId": "=\n{{ $json.linkedPulseIds.linkedPulseId }}",
"resource": "boardItem",
"operation": "get"
},
"credentials": {
"mondayComApi": {
"name": "<your credential>"
}
},
"notesInFlow": true,
"typeVersion": 1
},
{
"id": "1a7574db-16bb-4d69-b91f-33b20e52c794",
"name": "GET ALL COLUMNS1",
"type": "n8n-nodes-base.code",
"position": [
1880,
200
],
"parameters": {
"mode": "runOnceForEachItem",
"jsCode": "function createColumnValuesArray(data) {\n const result = {};\n data.forEach(item => {\n const name = item.id;\n result[name] = item;\n });\n\n return result;\n}\n\ncolumns = $input.item.json.column_values\ndata1 = { \"name\" : $input.item.json.name, \"id\" : $input.item.json.id }\ndata2 = createColumnValuesArray(columns)\n\nconst combinedData = { ...data1, ...data2 }\n\nreturn (combinedData)\n\n\n"
},
"typeVersion": 2
},
{
"id": "ba95aef3-49b3-4a3e-a5fd-51ec04691949",
"name": "GET ALL COLUMNS2",
"type": "n8n-nodes-base.code",
"position": [
1840,
-420
],
"parameters": {
"jsCode": "function createColumnValuesArray(data) {\n const result = {};\n data.forEach(item => {\n if (item.type != \"subtasks\") {\n const name = item.column.title;\n result[name] = item;\n }\n });\n\n return result;\n}\n\ncolumns = $input.last().json.column_values\ndata = createColumnValuesArray(columns)\nreturn {\"columnValuesByName\": data}\n\n\n"
},
"typeVersion": 2
},
{
"id": "8c475537-efe6-4417-b293-e47abe817f7a",
"name": "Aggregate1",
"type": "n8n-nodes-base.aggregate",
"onError": "continueRegularOutput",
"position": [
2180,
100
],
"parameters": {
"options": {},
"aggregate": "aggregateAllItemData",
"destinationFieldName": "subitems"
},
"typeVersion": 1,
"alwaysOutputData": true
},
{
"id": "f96f5fb7-1701-4cf4-b572-2ed3d8376232",
"name": "PULL SUBITEMS",
"type": "n8n-nodes-base.code",
"position": [
1320,
200
],
"parameters": {
"jsCode": "//Search for \"Subitems\" column\nconst columnName = \"Subitems\"\nfunction getColumnValue(item, columnId) {\n const column = item.column_values.find(column => column.column.title === columnId);\n if (column) {\n return column\n } else {\n return null;\n }\n}\nconst columnValue = getColumnValue($input.last().json, columnName);\nreturn JSON.parse(columnValue.value);\n\n//ALT OPTION - direct access by column_values[0]\n//var ids = $input.last().json['column_values'][0]['value'];\n//return JSON.parse(ids)"
},
"typeVersion": 2
},
{
"id": "aa96e7e9-6c2a-46d4-95af-124609a7b524",
"name": "GET ITEM",
"type": "n8n-nodes-base.mondayCom",
"position": [
1180,
-600
],
"parameters": {
"itemId": "=\n{{ $input.item.json.pulse }}",
"resource": "boardItem",
"operation": "get"
},
"credentials": {
"mondayComApi": {
"name": "<your credential>"
}
},
"notesInFlow": true,
"typeVersion": 1
},
{
"id": "da23cad1-77f9-4035-8ad3-b322dadba853",
"name": "GET ALL COLUMNS3",
"type": "n8n-nodes-base.code",
"position": [
1880,
-40
],
"parameters": {
"mode": "runOnceForEachItem",
"jsCode": "function createColumnValuesArray(data) {\n const result = {};\n data.forEach(item => {\n const name = item.id;\n result[name] = item;\n });\n\n return result;\n}\n\ncolumns = $input.item.json.column_values\ndata1 = { \"name\" : $input.item.json.name, \"id\" : $input.item.json.id }\ndata2 = createColumnValuesArray(columns)\n\nconst combinedData = { \"item\" : data1, columnValuesById: data2}\n\nreturn (combinedData)\n\n\n"
},
"typeVersion": 2
},
{
"id": "9c27b7af-2568-4b07-b526-9c18ca52649f",
"name": "Merge4",
"type": "n8n-nodes-base.merge",
"position": [
2180,
-100
],
"parameters": {
"mode": "combine",
"options": {},
"combinationMode": "mergeByPosition"
},
"typeVersion": 2.1,
"alwaysOutputData": true
},
{
"id": "6f0008fd-b8f5-4161-8fbf-363b3d5a7794",
"name": "Aggregate",
"type": "n8n-nodes-base.aggregate",
"onError": "continueRegularOutput",
"position": [
2340,
-100
],
"parameters": {
"options": {},
"aggregate": "aggregateAllItemData",
"destinationFieldName": "boardrelations"
},
"typeVersion": 1,
"alwaysOutputData": true
},
{
"id": "d95b1e2a-405e-417b-8618-89af85b10350",
"name": "Merge",
"type": "n8n-nodes-base.merge",
"onError": "continueRegularOutput",
"position": [
2540,
0
],
"parameters": {
"mode": "combine",
"options": {},
"combinationMode": "mergeByPosition"
},
"typeVersion": 2.1,
"alwaysOutputData": true
},
{
"id": "e9d7977d-1fd3-4be8-ad90-b42a93bc1ea4",
"name": "Merge2",
"type": "n8n-nodes-base.merge",
"onError": "continueRegularOutput",
"position": [
2480,
-240
],
"parameters": {
"mode": "combine",
"options": {},
"combinationMode": "mergeByPosition"
},
"typeVersion": 2.1,
"alwaysOutputData": true
},
{
"id": "72e04613-f953-49b0-ad13-4bd5464cc55e",
"name": "Merge1",
"type": "n8n-nodes-base.merge",
"position": [
2680,
-160
],
"parameters": {
"mode": "combine",
"options": {},
"combinationMode": "mergeByPosition"
},
"typeVersion": 2.1
},
{
"id": "0846e8ee-8b58-40c2-8d3f-1e33f519bf55",
"name": "Execute Workflow Trigger",
"type": "n8n-nodes-base.executeWorkflowTrigger",
"position": [
980,
-600
],
"parameters": {},
"typeVersion": 1
},
{
"id": "1c753c05-3541-4579-a815-b3465f26d51c",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
1300,
-240
],
"parameters": {
"width": 752.1995067108865,
"height": 335.74971164936585,
"content": "PULL ALL BOARDRELATION COLUMNS AND THEIR DATA"
},
"typeVersion": 1
},
{
"id": "79c61e1f-6cbf-45ca-b0d3-31250fb7be18",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
1300,
120
],
"parameters": {
"width": 748.2468880082052,
"height": 237.44804034647325,
"content": "PULL ALL SUBITEMS AND THEIR COLUMN DATA\n"
},
"typeVersion": 1
},
{
"id": "b5da95d7-d0d8-4ad1-ab93-e06e6c823ed2",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
1720,
-640
],
"parameters": {
"color": 4,
"width": 325.58246828143024,
"height": 352.5605536332179,
"content": "PULL ALL COLUMN DATA AND INDEX BY ID AND NAME\n"
},
"typeVersion": 1
},
{
"id": "02125cbf-aa28-4cf1-a0ef-cf3cf45e76c2",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
2140,
-298.05978270268713
],
"parameters": {
"color": 5,
"width": 677.0818915801614,
"height": 605.5742002344051,
"content": "COMBINE ALL DATA INTO ONE JSON OUTPUT\n"
},
"typeVersion": 1
},
{
"id": "e96deeef-6fb5-4130-b422-752e0e0dc9c5",
"name": "Execute Workflow",
"type": "n8n-nodes-base.executeWorkflow",
"position": [
1180,
-780
],
"parameters": {
"options": {
"waitForSubWorkflow": true
},
"workflowId": "ZdGZh4qmOqTQe1oq"
},
"typeVersion": 1
},
{
"id": "955d8a6e-931c-411f-a26a-17f547370fd9",
"name": "Edit Fields",
"type": "n8n-nodes-base.set",
"position": [
980,
-780
],
"parameters": {
"fields": {
"values": [
{
"name": "pulse",
"stringValue": "4030768878"
}
]
},
"options": {}
},
"typeVersion": 3.2
},
{
"id": "f508d0cd-448c-482e-9eeb-d569f26dbaab",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
940,
-920
],
"parameters": {
"color": 6,
"width": 418.4714893828877,
"height": 302.08861782546296,
"content": "HOW TO USE\n-Copy these nodes into another workflow, and update the workflow id in the execute workflow node\n-Using the Edit Fields nodes, define the \u201cpulse\u201d variable which will tell the workflow which monday item to pull data from.\n"
},
"typeVersion": 1
}
],
"connections": {
"Merge": {
"main": [
[
{
"node": "Merge1",
"type": "main",
"index": 1
}
]
]
},
"Merge2": {
"main": [
[
{
"node": "Merge1",
"type": "main",
"index": 0
}
]
]
},
"Merge4": {
"main": [
[
{
"node": "Aggregate",
"type": "main",
"index": 0
}
]
]
},
"GET ITEM": {
"main": [
[
{
"node": "GET ALL COLUMNS",
"type": "main",
"index": 0
},
{
"node": "GET ALL COLUMNS2",
"type": "main",
"index": 0
},
{
"node": "PULL SUBITEMS",
"type": "main",
"index": 0
}
]
]
},
"Aggregate": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 0
}
]
]
},
"Aggregate1": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 1
}
]
]
},
"Edit Fields": {
"main": [
[
{
"node": "Execute Workflow",
"type": "main",
"index": 0
}
]
]
},
"PULL SUBITEMS": {
"main": [
[
{
"node": "SPLIT SUBITEMS1",
"type": "main",
"index": 0
}
]
]
},
"GET ALL COLUMNS": {
"main": [
[
{
"node": "GET ALL RELATIONS",
"type": "main",
"index": 0
},
{
"node": "Merge2",
"type": "main",
"index": 0
}
]
]
},
"SPLIT SUBITEMS1": {
"main": [
[
{
"node": "GET EACH SUBITEM1",
"type": "main",
"index": 0
}
]
]
},
"GET ALL COLUMNS1": {
"main": [
[
{
"node": "Aggregate1",
"type": "main",
"index": 0
}
]
]
},
"GET ALL COLUMNS2": {
"main": [
[
{
"node": "Merge2",
"type": "main",
"index": 1
}
]
]
},
"GET ALL COLUMNS3": {
"main": [
[
{
"node": "Merge4",
"type": "main",
"index": 1
}
]
]
},
"GET ALL RELATIONS": {
"main": [
[
{
"node": "GET LINKEDPULSES1",
"type": "main",
"index": 0
},
{
"node": "Merge4",
"type": "main",
"index": 0
}
]
]
},
"GET EACH SUBITEM1": {
"main": [
[
{
"node": "GET ALL COLUMNS1",
"type": "main",
"index": 0
}
]
]
},
"GET LINKEDPULSES1": {
"main": [
[
{
"node": "SPLIT LINKED PULSES1",
"type": "main",
"index": 0
}
]
]
},
"PULL LINKEDPULSE1": {
"main": [
[
{
"node": "GET ALL COLUMNS3",
"type": "main",
"index": 0
}
]
]
},
"SPLIT LINKED PULSES1": {
"main": [
[
{
"node": "PULL LINKEDPULSE1",
"type": "main",
"index": 0
}
]
]
},
"Execute Workflow Trigger": {
"main": [
[
{
"node": "GET ITEM",
"type": "main",
"index": 0
}
]
]
}
}
}
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.
mondayComApi
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
How this works
Efficiently fetch an entire monday.com board row, including all column values, linked items, and subitems, in one streamlined process to save time on data retrieval tasks. Ideal for analysts or developers building automations that require comprehensive board information without multiple API calls. The key step involves using the monday.com integration to pull the initial row, followed by code nodes to extract relations and subitems, ensuring everything is consolidated seamlessly.
Use this workflow when you need a complete snapshot of a row for reporting, notifications, or further processing in tools like executeWorkflowTrigger, especially in event-driven scenarios such as item updates. Avoid it for simple single-field queries, where a basic monday.com node suffices, or if your board lacks complex relations that justify the 26-node setup. Common variations include adapting it to focus only on subitems or integrating with email nodes for alerts on row changes.
About this workflow
Retrieve A Monday Com Row And All Data In A Single Node. Uses mondayCom, splitOut, executeWorkflowTrigger, stickyNote. Event-driven trigger; 26 nodes.
Source: https://github.com/Zie619/n8n-workflows — 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 is a building block designed to be called from other workflows via an Execute workflow node. When called from another workflow, and given the JSON input of a "pulse" field with the ID to
Monday.com, Execute Workflow Trigger
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
Prevent concurrent workflow runs using Redis. Uses executeWorkflowTrigger, manualTrigger, stickyNote, executeWorkflow. Event-driven trigger; 43 nodes.
Execute Workflow Trigger, Redis, Stop And Error
This workflow sets a small "lock" value in Redis so that only one copy of a long job can run at the same time. If another trigger fires while the job is still busy, the workflow sees the lock, stops e
Execute Workflow Trigger, Redis, Stop And Error