Monday.com Useful Utilities

Published 8 months ago

This template is a set of building blocks to access Monday.com in ways not supported by the official Monday node.

Prerequisites

Included are setups to:

Find a column value by the column's name (instead of a numerical index which can change when board structure is changed)
Find a column value by the column's ID (again, instead of using a numerical index)
Pull a board relation column, and get all the related pulses
Pull an items subitems and split them out
Upload a file to an item's files field

Setup

Create a Monday.com credential
Update the nodes in the template to use your credential
Copy/Paste the nodes you need from this template into any other workflow
To retreive a column by name:
- Route a Monday.com node that gets an item to the COLUMN BY NAME node
- Edit the COLUMN BY NAME node, and enter the name in the first line of code.
To retreive a column by its ID:
- Follow Monday.com's instructions to locate the column's ID
- Route a Monday.com node that gets an item to the COLUMN BY ID node
  -Edit the COLUMN BY ID node, and enter the ID in the first line of code.
To retreive all linked pulses from a Board Relation column:
- Route a Monday.com node that gets an item to the GET BOARD RELATION node
- Edit the GET BOARD RELATION node to specify the column name.
- All linked pulses will be retrieved by the subsequent PULL LINKEDPULSE node
To pull all subitems from an item:
- Route a Monday.com node that gets an item to the PULL SUBITEMS node
- All subitems will be retrieved by the subsequent GET EACH SUBITEM node
To upload a File:
- Repalce the Convert to File node with whatever node you are using to output your binary file data
- Enable the MONDAY UPLOAD node
- If the destination column is named anything other then the default of "file" - edit the MONDAY UPLOAD node and change column_id:"file" in the first Value field to match the name of your file column

Implement complex processes faster with n8n