Automated n8n Workflow Inventory & Management with Airtable
detail.loadingPreview
This n8n workflow provides a robust solution for centralizing your n8n workflow management by automatically syncing all workflow details to an Airtable base. Gain real-time visibility into your automations, track changes, and maintain a comprehensive inventory of your n8n environment.
About This Workflow
Maintaining oversight of numerous n8n workflows can be challenging. This powerful workflow solves that by connecting your n8n instance directly to Airtable. It periodically fetches a complete list of all your active and inactive workflows, extracts crucial metadata like their names, IDs, creation/update timestamps, associated error workflows, active status, timezone settings, and even detailed CRON schedules and node structures. Using conditional logic, it intelligently updates existing workflow records in your Airtable base or creates new ones, ensuring your Airtable inventory is always up-to-date. This provides a single source of truth for all your n8n automations, simplifying auditing, reporting, and team collaboration.
Key Features
- Automated Workflow Synchronization: Continuously syncs your entire n8n workflow catalog to an Airtable base.
- Comprehensive Metadata Capture: Extracts workflow ID, name, active status, creation/update dates, error workflow ID, timezone, execution settings, and detailed node configurations.
- Intelligent Record Management: Automatically updates existing Airtable records when workflow details change or creates new records for newly deployed workflows.
- CRON & Trigger Detection: Identifies if a workflow is CRON-scheduled or triggered by other events, capturing relevant scheduling details.
- Centralized Oversight: Provides a single, user-friendly Airtable interface for monitoring and managing all n8n automations.
How To Use
- Prepare Airtable Base:
- Create an Airtable base (e.g., "n8n Workflow Inventory") and a table named "Workflows".
- Add fields to the "Workflows" table corresponding to the data being extracted, such as:
workflowId(Single Line Text, mark as unique),name(Single Line Text),isActive(Checkbox),errorWorkflowId(Single Line Text),createdAt(Date field),updatedAt(Date field),nodes(Long Text),timezone(Single Line Text),CRON_details(Long Text),rawData(Long Text),isCRON(Checkbox),saveManualExecutions(Checkbox),isTrigger(Checkbox).
- Configure Airtable Credentials:
- In n8n, add your Airtable API Key credential. Ensure the 'Airtable', 'Airtable1', and 'Airtable2' nodes are configured to use this credential and your Airtable "Application" ID.
- Adjust n8n API Endpoint:
- In the 'Get All Workflows' node, update the
URLto point to your n8n instance's REST API endpoint (e.g.,http://your-n8n-domain:5678/rest/workflows). - (If not present in your full workflow): After 'SplitInBatches', add an HTTP Request node (name it "Get Workflow Details") to fetch individual workflow configurations (e.g.,
http://your-n8n-domain:5678/rest/workflows/{{$json.id}}). - (If not present in your full workflow): Ensure any 'Function' or 'Code' nodes (like inferred "Prepare data" and "Prepare data1") correctly parse the raw workflow JSON to extract complex fields such as
nodes,CRON_details,rawData,isCRON, andisTrigger.
- In the 'Get All Workflows' node, update the
- Execute & Schedule:
- Manually execute the workflow to perform an initial synchronization.
- For continuous tracking, replace the 'On clicking 'execute'' node with a 'Cron' node and configure a schedule (e.g., daily or hourly) to keep your Airtable inventory up-to-date.
Apps Used
Workflow JSON
{
"id": "612cc8b2-35ab-406a-9332-4043a2495830",
"name": "Automated n8n Workflow Inventory & Management with Airtable",
"nodes": 16,
"category": "Operations",
"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: 612cc8b2-35ab...
About the Author
N8N_Community_Pick
Curator
Hand-picked high quality workflows from the global community.
Statistics
Related Workflows
Discover more workflows you might like
Universal CSV to JSON API Converter
Effortlessly transform CSV data into structured JSON with this versatile n8n workflow. Integrate it into any application as a custom API endpoint, supporting various input methods including file uploads and raw text.
Instant WooCommerce Order Notifications via Telegram
When a new order is placed on your WooCommerce store, instantly receive detailed notifications directly to your Telegram chat. Stay on top of your e-commerce operations with real-time alerts, including order specifics and a direct link to view the order.
On-Demand Microsoft SQL Query Execution
This workflow allows you to manually trigger and execute any SQL query against your Microsoft SQL Server database. Perfect for ad-hoc data lookups, administrative tasks, or quick tests, giving you direct control over your database operations.