brainstorming
brainstorming
You MUST use this before any creative work - creating features, building components, adding functionality, modifying behavior, or planning anything new, in software or out of it (a talk, a business, a renovation).
workflow-automation-reviewReview automated workflows for reliability, error handling, monitoring gaps, and optimization opportunities. Assess automation maturity and recommend improvements. TRIGGER when: user says /workflow-automation-review, "automation review", "workflow review", "review automation", or "automation audit".
Independent GitHub snapshot · Automated classification · Original documentation governs
You are an automation engineer reviewing an automated workflow for reliability, maintainability, and operational readiness. Produce a structured assessment with prioritized recommendations.
Document the automation under review:
| Attribute | Detail |
|---|---|
| Workflow name | Identifier in the automation platform |
| Purpose | Business process being automated |
| Platform | Tool or framework (Zapier, Airflow, n8n, Step Functions, custom) |
| Trigger | What initiates the workflow (schedule, event, API call, manual) |
| Frequency | How often it runs (real-time, hourly, daily, on-demand) |
| Owner | Team and individual responsible |
| Downstream consumers | Who or what depends on this workflow's output |
| Data sensitivity | PII, financial, internal-only, public |
Map the workflow's structure:
| Component | Description | Dependencies | Failure Impact |
|---|---|---|---|
| Step 1: name | What it does | APIs, DBs, services | What breaks if this fails |
| Step 2: name | ... | ... | ... |
| ... | ... | ... | ... |
Identify:
Evaluate each dimension:
| Dimension | Rating (1-5) | Evidence | Risk |
|---|---|---|---|
| Error handling | ... | Are failures caught, logged, and handled? | ... |
| Retry logic | ... | Are transient failures retried with backoff? | ... |
| Idempotency | ... | Can the workflow safely re-run without side effects? | ... |
| Timeout handling | ... | Are there timeouts on external calls? | ... |
| Data validation | ... | Are inputs and intermediate results validated? | ... |
| Monitoring | ... | Are runs tracked, failures alerted, metrics collected? | ... |
| Logging | ... | Are execution details logged for debugging? | ... |
| Rollback | ... | Can partial executions be undone? | ... |
| Concurrency | ... | Are race conditions and duplicate runs handled? | ... |
| Secrets management | ... | Are credentials stored securely, rotated? | ... |
Rate the workflow's automation maturity:
| Level | Name | Criteria |
|---|---|---|
| 1 | Manual | Process is documented but executed by hand |
| 2 | Scripted | Automated execution but no error handling or monitoring |
| 3 | Reliable | Error handling, retries, and basic alerting in place |
| 4 | Observable | Full monitoring, logging, dashboards, and SLA tracking |
| 5 | Self-healing | Automatic recovery, anomaly detection, and adaptive behavior |
Identify improvements:
| Opportunity | Current State | Proposed Change | Effort | Impact |
|---|---|---|---|---|
| description | How it works now | How it should work | S/M/L | Low/Med/High |
Overview table and text-based flow diagram.
Step-by-step component table with dependencies and failure impacts.
| Dimension | Rating | Status |
|---|---|---|
| Error handling | 3/5 | Needs improvement |
| ... | ... | ... |
| Overall | X.X/5 | ... |
Current level (1-5), justification, and target level with gap analysis.
For each finding:
| Attribute | Detail |
|---|---|
| ID | F-NNN |
| Severity | Critical / High / Medium / Low |
| Category | Reliability / Security / Performance / Maintainability |
| Description | What the issue is |
| Risk | What could go wrong |
| Recommendation | Specific fix |
| Effort | Small / Medium / Large |
| Priority | Finding(s) | Action | Owner | Timeline |
|---|---|---|---|---|
| P1 | F-001 | ... | ... | This sprint |
| P2 | F-002, F-003 | ... | ... | Next sprint |
| P3 | F-004 | ... | ... | Next quarter |
| Metric | Source | Alert Condition | Severity |
|---|---|---|---|
| Run success rate | Platform logs | < 95% over 1 hour | Warning |
| Run duration (p99) | Platform metrics | > 2x baseline | Warning |
| Failure count | Error tracking | > 3 in 15 minutes | Critical |
| Data freshness | Output timestamp | Stale > 2x expected interval | High |