Retrieve Monday.com Row and All Data in a Single Node

This n8n workflow demonstrates how to retrieve a specific row from Monday.com and then extract all its associated data, including sub-items and column values, using a single Monday.com node call. It leverages sub-workflows and data manipulation to simplify complex data retrieval.

What it does

1. Triggers the Sub-workflow: The workflow starts when it's called by another n8n workflow (acting as a sub-workflow).
2. Retrieves Monday.com Item: It uses the Monday.com node to fetch a specific item (row) by its ID. It's configured to retrieve all available data, including sub-items and column values.
3. Processes Column Values: A "Code" node then processes the column_values array from the Monday.com item. It transforms this array into a more accessible object format, where each key is the column ID and the value is the raw value from Monday.com.
4. Extracts Sub-items (if any): If the Monday.com item has sub-items, the workflow extracts these into a separate array.
5. Merges Data: The column_values object and the sub_items array are merged back into the main item data, making all related information available in a unified structure.
6. Splits Out Sub-items: If sub-items were found, the workflow then splits them out as individual items, allowing for further processing of each sub-item.
7. Aggregates Data: Finally, if sub-items were processed, the workflow aggregates the original item and its sub-items back into a single output, providing a comprehensive view of the Monday.com row and all its nested data.

Prerequisites/Requirements

• n8n Instance: A running n8n instance.
• Monday.com Account: An active Monday.com account with an API key configured as an n8n credential.
• Monday.com Board/Item: A Monday.com board with at least one item (row) to test the retrieval.

Setup/Usage

1. Import the Workflow:
   • Download the provided JSON file.
   • In your n8n instance, go to "Workflows" and click "New".
   • Click the "Import from JSON" button and paste the workflow JSON or upload the file.
2. Configure Monday.com Credentials:
   • Locate the "Monday.com" node (ID: 309).
   • Click on the "Credential" field and select your existing Monday.com API Key credential. If you don't have one, click "Create New" and follow the prompts to add your Monday.com API Key.
3. Configure the Main Workflow (Calling Workflow):
   • This workflow is designed to be executed by another workflow using the "Execute Sub-workflow" node.
   • In your main workflow, add an "Execute Sub-workflow" node.
   • Configure it to call this workflow. You will need to pass the boardId and itemId of the Monday.com row you wish to retrieve as input data to this sub-workflow. For example, you can pass them as JSON: {"boardId": "YOUR_BOARD_ID", "itemId": "YOUR_ITEM_ID"}.
4. Activate the Workflow:
   • Once configured, activate the workflow by toggling the "Active" switch in the top right corner of the n8n editor.
5. Test the Workflow:
   • Execute your main workflow that calls this sub-workflow.
   • Observe the output of this workflow to see the retrieved Monday.com item data, including its column values and sub-items.

This workflow provides a robust and efficient way to pull comprehensive data for a Monday.com item, making it ideal for scenarios where you need to process all associated information in a single operation.