Create sustained capacity review tasks from OpenObserve metrics to Twenty CRM
UnknownWhat this workflow does
This workflow has 18 nodes and runs manually, when you click “Execute workflow” (plus 1 other trigger). Along the way it connects Openobserve (community) and Twentycrm (community).
How it runs
Trigger: Manually, when you click “Execute workflow” (plus 1 other trigger).
- Set Capacity Policy Parameters (Edit Fields (Set)): sets 10 fields: rule_key, promql, window_minutes…
- Validate Policy Configurations (Code): runs custom JavaScript code
- Retrieve Metrics History Data (Open Observe): range query (metric)
- Analyze Pressure Metrics (Code): runs custom JavaScript code
- Draft Capacity Recommendations (Code): runs custom JavaScript code
- Batch Process Resources (Loop Over Items (Split in Batches)): loops over the items in batches
- Summarize Capacity Findings (Code): runs custom JavaScript code
- Evaluate Task Creation Needs (If): checks a condition and branches into true / false
- Locate Review Task in CRM (Twenty): work with task
- Document Findings Without CRM Log (Code): runs custom JavaScript code
…plus 6 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 2 community packages, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that @blackswampai/n8n-nodes-openobserve is verified or supports 3.0 (used in Retrieve Metrics History Data).
- Check that @blackswampai/n8n-nodes-twentycrm is verified or supports 3.0 (used in Locate Review Task in CRM, Update Existing Review Task, Generate New Review Task).
Nodes used (8)
- Manual Trigger
n8n-nodes-base.manualTrigger - Edit Fields (Set)
n8n-nodes-base.set - Code
n8n-nodes-base.code - Open Observe
@blackswampai/n8n-nodes-openobserve.openObserve - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - If
n8n-nodes-base.if - Twenty
@blackswampai/n8n-nodes-twentycrm.twenty
From the author
Quick overview This workflow checks Prometheus-style infrastructure metrics in OpenObserve on a schedule, detects sustained pressure based on coverage and threshold rules, and then creates or updates a matching review task in Twenty CRM with evidence from the…