{"product_id":"enrich-notion-pages-in-n8n-expand-related-properties","title":"Enrich Notion Pages in n8n: Expand Related Properties","description":"\u003ch3\u003eEnrich Notion pages in n8n by expanding relation properties (including nested ones)\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow takes a Notion page object and a list of property names to expand, then resolves your Notion relation fields into the related page data—returning the original page object enriched with the requested nested properties.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cp\u003eBuilt to be called from another n8n workflow, it performs the following steps:\u003c\/p\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives inputs\u003c\/strong\u003e: a \u003cem\u003eNotion page object\u003c\/em\u003e and a \u003cem\u003eProperties\u003c\/em\u003e list (property names to expand).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSplits and iterates\u003c\/strong\u003e: the requested properties are split into individual items and processed one-by-one.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eResolves relations\u003c\/strong\u003e: for each property, it calls the \u003cstrong\u003e“Get Relation Info”\u003c\/strong\u003e sub-workflow (ID: \u003cstrong\u003e14yGdu1YOQ0RgCzZ\u003c\/strong\u003e) to convert the Notion relation property into related page data.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExpands nested properties recursively\u003c\/strong\u003e: if the property definition includes nested properties to expand and the resolved relation data is not empty, the workflow iterates through related items and recursively calls itself to expand nested relation fields.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAggregates results\u003c\/strong\u003e: resolved properties are collected across iterations.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMerges into the original page\u003c\/strong\u003e: the aggregated resolved property objects are merged back into the original Notion page and output as an enriched page.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eWhen your parent workflow fetches a Notion page, use this workflow to \u003cstrong\u003eexpand relation-based details\u003c\/strong\u003e for downstream processing.\u003c\/li\u003e\n  \u003cli\u003eBuild richer automations where a page’s related items must also have their own \u003cstrong\u003enested relation properties\u003c\/strong\u003e expanded.\u003c\/li\u003e\n  \u003cli\u003eSupport SaaS operations or reporting pipelines that need \u003cstrong\u003efully hydrated Notion data\u003c\/strong\u003e without manually joining relations.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegration\u003c\/strong\u003e: Notion (via the “Get Relation Info” sub-workflow, plus any Notion calls it performs).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\/logic used\u003c\/strong\u003e: \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003eset\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, \u003ccode\u003esplit out\u003c\/code\u003e, \u003ccode\u003eaggregate\u003c\/code\u003e, \u003ccode\u003esplit in batches\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow design\u003c\/strong\u003e: called via \u003cem\u003eExecute Workflow\u003c\/em\u003e from a parent n8n automation, returning an enriched page object.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46081437499571,"sku":"N8N-19861","price":21.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/FTjA2jXbADdXKOwurPMol_Q465yuRf.png?v=1790241339","url":"https:\/\/buyflowscripts.com\/products\/enrich-notion-pages-in-n8n-expand-related-properties","provider":"N8N Commerce","version":"1.0","type":"link"}