n8n

How to Aggregate Monday Data for Reporting?

Pull item data from Monday and combine it into one clean record for reports, sync jobs, and audits. Teams that manage projects, accounts, or campaigns in Monday can use it to view the main item, its subitems, and related items in one place.

It starts when another workflow calls it. The flow fetches a Monday item by ID, builds two maps of the columns by id and by name, and scans for relation columns. It then looks up all linked items found in those relations. It also finds the Subitems column, loads each subitem, and gathers their fields. Split nodes loop through each link and subitem, and Aggregate and Merge nodes assemble a single JSON output. The result includes the main columns, a subitems list, and a boardrelations list, ready for dashboards or a downstream sync.

You will need a Monday API token and a valid item ID. Set the pulse value and point the Execute Workflow node to the correct workflow ID if you run it from a parent flow. Expect faster reporting, fewer copy pastes, and consistent data for portfolio rollups, client records, and cross board summaries.

What are the key features?

  • Runs as a child flow using an Execute Workflow Trigger so other workflows can call it with an item ID.
  • Fetches a Monday item by ID and returns complete column values.
  • Indexes columns two ways, by id and by name, for flexible field mapping.
  • Finds board relation columns and loads each linked item automatically.
  • Discovers the Subitems column, pulls each subitem, and collects their fields.
  • Uses Split Out nodes to loop through links and subitems safely.
  • Merges all parts with Aggregate and Merge nodes to produce one clean JSON output.

What are the benefits?

  • Reduce manual item lookups from 30 minutes to 2 minutes per record
  • Automate up to 90 percent of data gathering across subitems and linked items
  • Improve data accuracy by removing most copy paste errors
  • Unify item, subitem, and relation data into one export ready for BI tools
  • Handle hundreds of linked items and subitems for large boards

How do you set it up?

  1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
  2. You'll need accounts with Monday.com. See the Tools Required section above for links to create accounts with these services.
  3. In Monday.com, generate a personal API token from your admin or developer settings. Keep this token secure.
  4. In n8n Cloud, open Credentials > New > search for Monday.com. If you are not sure which type to use, double click any Monday.com node, choose 'Credential to connect with' > 'Create new credential', and follow the on screen instructions.
  5. Assign the Monday.com credential to all Monday.com nodes in this workflow: GET ITEM, PULL LINKEDPULSE1, and GET EACH SUBITEM1.
  6. Open the Edit Fields node and set the pulse field to a real Monday item ID you want to pull.
  7. Open the Execute Workflow node and select the workflow ID of this child flow if you plan to run it from the included example. If you will call it from your own parent workflow, you can disable or remove this example node and call the child flow from your parent instead.
  8. Save and run a test. If using the included example, click Run Once on the parent section. Confirm the final Merge node output contains columns indexed by id and by name, a subitems array, and a boardrelations array.
  9. Validation tip: Test with an item that has at least one subitem and one relation. Compare counts with what you see in Monday to confirm accuracy.
  10. Troubleshooting: If linked items do not appear, ensure there is a board relation column on the item. If subitems are empty, confirm the Subitems column exists. For permission or 401 errors, check your API token scope and that the token owner can view the board.

Tools Required

$24 / mo or $20 / mo billed annually to use n8n in the cloud. However, the local or self-hosted n8n Community Edition is free.

Monday.com

Sign up

Free plan: $0 / mo; API access via personal token with 200 daily calls (Free/Trial limit).

Similar Templates

Join Futurise to access 1,200+ automation templates

Get instant access to ready-made automation workflows for n8n, Make.com, AI agents, and more. Download, customise, and deploy in minutes.