Fetch Airtable hierarchies up to level 3

# Fetch Airtable hierarchy up to level 3 with markdown-to-HTML conversion

This automation template solves the challenge of efficiently retrieving deeply nested, interconnected data from Airtable by recursively fetching child records up to level 3. It´s designed for users working with hierarchical structures—such as projects, tasks, campaigns, or products with components—who need a complete record tree in a single JSON output.

## Who it´s for
- Developers integrating Airtable with external systems via API.
- Analysts processing highly relational data across multiple tables.
- Product managers exporting hierarchical data for reports and dashboards.
- Automation specialists needing full record trees without manual queries.

## What the automation does
- Triggered manually via execute_workflow_trigger with base, table, and record ID.
- Retrieves the parent record and recursively fetches linked child records up to level 3.
- Filters out unnecessary link fields and prevents circular references.
- Converts rich-text fields from pseudo-markdown to HTML when needed.
- Outputs a clean, hierarchical JSON structure ready for frontend, CMS, or reporting use.

## What´s included
- Ready-to-use n8n workflow.
- Trigger and handler logic for recursive data fetching.
- Integrations with Airtable API using HTTP Request and JavaScript Code Node.
- Use of Aggregate and SplitInBatches nodes for flow control.
- Basic written instructions for setup and adaptation.

## Requirements for setup
- n8n account with workflow editing access.
- Airtable account with API key and read permissions on required tables.
- Clear understanding of your Airtable schema and relationships.

## Benefits and outcomes
- Saves time on manual data aggregation across linked records.
- Delivers structured JSON for integration with websites, APIs, and CMS.
- Ensures correct formatting via automatic markdown-to-HTML conversion.
- Simplifies handling of complex hierarchies without custom coding.
- Reusable across different data types (projects, campaigns, products).

## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via chat