Hierarchical Airtable Data Fetcher with Markdown Conversion

This n8n workflow efficiently retrieves and structures hierarchical data from Airtable, supporting up to three levels of linked records. Designed for complex data relationships, it fetches parent records along with their child and grandchild records, organizes them in a nested JSON format, and converts rich text fields from pseudo-markdown to HTML. The workflow starts with a trigger that passes in record identifiers and configuration options. It then obtains the schema from Airtable, fetches the main record, and proceeds to retrieve linked records at multiple levels using HTTP requests. Special nodes filter and process fields, ensuring only relevant relationships (including inverses) are included. Markdown conversion nodes transform rich text fields into HTML, making data ready for presentation. Ideal for scenarios requiring detailed nested data extraction, such as generating comprehensive reports or preparing data for complex web applications.