Airtable Hierarchical Record Fetcher (Up to 3 Levels)

This n8n workflow is designed to retrieve a primary Airtable record along with its related child and grandchild records in a fully hierarchical JSON format. It supports up to three levels of relationships: the parent record (level 1), directly linked child records (level 2), and optionally specified grandchild records (level 3). By using Airtable's filterByFormula for efficient batch fetching, it minimizes API usage and improves performance, making it suitable for complex databases with deep relational structures.

Key features include selective level 3 fetching to avoid unnecessary calls, conversion of Airtable rich text fields to proper HTML, and flexible input parameters for base ID, table ID, record ID, level 3 field IDs, and HTML processing toggle. The output is a comprehensive, nested JSON object ready for further processing in chatbots, reports, or APIs.

Ideal use cases include CRM data export for customer profiles with contacts and activities, content management systems needing article hierarchies with tags and comments, project management tools pulling tasks with subtasks and assignees, or chatbot integrations requiring structured knowledge base data. It saves significant development time compared to manual scripting, reduces API costs, and ensures data integrity across relationships.