Comprehensive Monday.com Item Data Extractor - n8n Workflow

• Users needing a complete data snapshot of a Monday.com item (pulse).


• Automation specialists looking for advanced n8n templates for recursive data fetching.


• Teams integrating Monday.com data with external databases or analytics platforms.


• Developers seeking specific examples of using the n8n Code node for complex JSON transformation.

Extracting all related data—especially board relations and subitems—from a single Monday.com pulse usually requires multiple API calls and complex post-processing. This specialized n8n workflow solves this by orchestrating a sequence of Monday.com API calls and leveraging several advanced n8n node components, particularly the Code node, to transform and aggregate the data. This robust approach ensures you get a single, consolidated JSON output containing the main item, its column values indexed by both ID and Name, all linked pulses (board relations), and all associated subitems. Using this detailed n8n workflow saves significant development time compared to manually constructing complex API query structures.

This powerful n8n workflow begins execution when it is called as a sub-workflow, using the Execute Workflow Trigger n8n node, having received a pulse ID (the Monday item ID).

1. Initial Retrieval: The GET ITEM n8n node retrieves the full details of the specified Monday.com item.


2. Column Parsing: Two Code n8n node steps (GET ALL COLUMNS and GET ALL COLUMNS2) immediately process the initial data, indexing column values for easy lookup—by ID and by Name, respectively. This indexed data is essential for subsequent steps in this n8n workflow.


3. Subitem Processing: The PULL SUBITEMS n8n node extracts the list of subitem IDs. These IDs are split (SPLIT SUBITEMS1), and for each ID, the GET EACH SUBITEM1 Monday.com n8n node retrieves the full subitem data. All subitem data is then restructured and collected using the Aggregate1 n8n node.


4. Board Relation Processing: The GET ALL RELATIONS n8n node filters the main item's column data, isolating only the 'board_relation' types (linked pulses). This data is then processed and split (SPLIT LINKED PULSES1). For each linked pulse, the PULL LINKEDPULSE1 n8n node retrieves its full details, and this data is collected using the Aggregate n8n node.


5. Final Consolidation: Multiple Merge and Aggregate n8n node steps (Merge2, Merge4, Merge, Merge1) meticulously combine the main item data, the indexed column values, the subitem data, and the board relations data into a single, comprehensive output JSON object. This provides a clean, unified structure ready for the next step in your larger n8n templates.

To utilize this n8n workflow:

1. Import: Copy the provided n8n workflow JSON and import it into your n8n instance.


2. Credentials: Ensure your Monday.com credentials are set up and selected for the GET ITEM, PULL LINKEDPULSE1, and GET EACH SUBITEM1 n8n node configurations. The credential name used in the template is Monday.com account (ID: 5nd48DKapWBLcUBx).


3. Usage: This specific n8n workflow is designed to run as a subroutine. To test or use it:

Execute Workflow Trigger (n8n trigger): Acts as the starting point for this sub-workflow, receiving the item ID input from a parent n8n workflow.
Monday.com Node (GET ITEM, PULL LINKEDPULSE1, GET EACH SUBITEM1): These core n8n node blocks communicate with the Monday.com API. They are used to retrieve the primary item, all linked items (board relations), and all subitems based on dynamically passed IDs.
Code Node (GET ALL COLUMNS, GET ALL COLUMNS2, GET ALL COLUMNS1, PULL SUBITEMS, GET ALL RELATIONS): These specialized n8n node steps are crucial for data transformation. They parse the raw Monday.com API response, normalize the data structure, index column values (by ID or Title), and isolate specific data types like subitems or board relations, preparing them for splitting and aggregation.
Split Out Node (SPLIT LINKED PULSES1, SPLIT SUBITEMS1): This standard n8n node iterates over the arrays of linked pulse IDs and subitem IDs, allowing the subsequent Monday.com n8n node to fetch each item individually.
Aggregate Node (Aggregate, Aggregate1): These n8n node components collect all the individually processed linked pulses and subitems, gathering them into structured arrays before the final merge step of the n8n workflow.
Merge Node (Merge4, Merge2, Merge, Merge1): These nodes combine the disparate data streams (main item data, column indexes, board relations, subitems) into the final, consolidated JSON structure, completing the comprehensive data retrieval defined by this n8n templates logic.