Generate Structured Metadata from Monday.com Items
detail.loadingPreview
This workflow extracts data from a Monday.com item, including sub-items and linked items, and structures it for further processing.
About This Workflow
This n8n workflow is designed to retrieve detailed information from a specific Monday.com item. It then processes sub-items and linked items associated with the main item, making the extracted data available in a structured format. This is useful for generating reports, updating other systems, or creating enriched metadata.
Key Features
- Fetches a specific Monday.com item using its ID.
- Extracts data from specific columns like 'Subitems', 'Additional Contacts', 'Zoom Date', and 'person' using custom JavaScript code.
- Parses JSON values from column data.
- Navigates through linked items (pulses) to retrieve their details.
- Splits arrays of sub-items and linked pulses for individual processing.
- Converts extracted data to JSON format for easier manipulation.
- Merges data from different sources.
How To Use
- Trigger: The workflow starts manually by clicking "Test workflow".
- GET ITEM: The
GET ITEMnode (ID:a4d2e3a7-05a9-434a-a4e5-d6ed3d538091) fetches the main Monday.com item specified byitemId: "5775061188". - Column Extraction: Several
codenodes (COLUMN BY NAME,COLUMN BY ID,GET BOARD RELATION,PULL SUBITEMS) are triggered to extract data from specific columns of the main item.COLUMN BY NAME(ID:e55be301-0a6a-43a6-8a07-becc39e0a254) targets the 'Zoom Date' column.COLUMN BY ID(ID:463966c2-27e2-429c-8f8b-b3c279592f0d) targets a column with the ID 'person'.GET BOARD RELATION(ID:22e3ec96-4e83-42fa-aa25-ce0d7445df15) specifically looks for the 'Additional Contacts' column.PULL SUBITEMS(ID:7e8c25dc-7ccd-44b5-a4b1-33def99fc811) is designed to extract values from a 'Subitems' column.
- Subitem Processing: If sub-items are found in the 'Subitems' column:
SPLIT SUBITEMS(ID:82464748-cf9a-4792-8790-f07c06c1525d) splits the sub-item data based onlinkedPulseIds.linkedPulseId.GET EACH SUBITEM(ID:96a780da-be73-41c8-bf53-b2a05061a340) fetches the details of each individual sub-item using the Monday.comgetoperation.
- Linked Item Processing: If 'Additional Contacts' or similar linked items are found:
GET LINKEDPULSES(ID:5ce40a46-1513-498a-9e92-8dd96e508f34) parses thelinkedPulseIdsfrom the 'Additional Contacts' column data.SPLIT LINKED PULSES(ID:33b0aeff-18aa-4ee9-97b3-7c3a44cf96fc) splits the array of linked pulse IDs.PULL LINKEDPULSE(ID:a7bcc413-8d7e-4941-a81a-7a99fe14b01d) fetches the details of each linked pulse item.
- Data Conversion and Merging:
Convert to File(ID:06099adf-7f2f-4c32-84b8-e2458e39f95c) converts the output to a JSON format.Merge(ID:397c5d7b-76e4-4a0e-bd39-31c10571d68a) combines the various pieces of extracted and processed data.
- Optional Upload: The
MONDAY UPLOADnode (ID:5993e15a-1a1b-436e-b994-bf3acee16da0) is present but disabled. It's configured to upload a file to a Monday.com column via the API, suggesting a potential extension for outputting generated metadata back into Monday.com.
Apps Used
Workflow JSON
{
"id": "b04d28de-ccd2-4f03-85d2-08c3eda84b4d",
"name": "Generate Structured Metadata from Monday.com Items",
"nodes": 10,
"category": "Data Processing",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: b04d28de-ccd2...
About the Author
SaaS_Connector
Integration Guru
Connecting CRM, Notion, and Slack to automate your life.
Statistics
Related Workflows
Discover more workflows you might like
Multilingual Metadata Generation from Gmail and Google Sheets
Automate structured metadata generation in English and Chinese by processing Gmail emails and Google Sheets data.
Generate Structured Metadata in English and Chinese
This workflow demonstrates how to generate structured metadata in both English and Chinese. It fetches data, processes it, and saves it in a structured format.
Generate Structured Metadata with Multiple Languages
This workflow demonstrates generating structured metadata, specifically supporting both English and Chinese output.