Identifying Automation Opportunities
How to find, score, and prioritize automation candidates in your business — the audit framework, ROI calculation, and why starting with the right workflow matters more than starting fast.
Premium Course Content
This lesson is part of a premium course. Upgrade to Pro to unlock all premium courses and content.
- Access all premium courses
- 1000+ AI skill templates included
- New content added weekly
Finding the Gold
🔄 Lesson 2 mapped the automation landscape — RPA, workflow tools, AI, and agents. Now comes the question that determines success: which processes should you actually automate?
The U.S. Small Business Administration advises: “Start by identifying specific use cases that AI can help your business with and then research the right tools.” But most businesses skip this step. They see a cool tool and look for things to automate with it. That’s backwards. Start with the pain. Then find the tool.
The Process Audit
Spend one week tracking how your team spends time. For each task that takes more than 30 minutes per week, record:
| Field | What to Capture | Example |
|---|---|---|
| Task name | What is it? | “Weekly sales report compilation” |
| Time spent | Hours per week | 3 hours |
| Frequency | How often? | Every Monday |
| Steps involved | How many distinct actions? | 8 steps |
| Data type | Structured or unstructured? | Structured (spreadsheet data) |
| Judgment required? | Does it need human decisions? | No — same formulas every week |
| Error rate | How often do mistakes happen? | 10% (manual copy-paste errors) |
| Systems involved | Which tools? | Google Sheets, Salesforce, Gmail |
✅ Quick Check: Can you name your team’s top 3 most time-consuming repetitive tasks right now — without checking? If yes, you’ve intuitively identified your automation candidates. If not, the audit will surface them.
The Scoring Framework
Score each candidate on three dimensions (1-5 each):
Automation Potential (AP): How repeatable and predictable is the process?
- 5 = Identical steps every time, structured data
- 3 = Mostly repeatable, some variation
- 1 = Highly variable, lots of judgment calls
Business Impact (BI): What’s the time/cost/error savings?
- 5 = 5+ hours/week saved, high error reduction
- 3 = 2-4 hours/week, moderate improvement
- 1 = Less than 1 hour/week, minimal impact
Implementation Ease (IE): How straightforward is the automation?
- 5 = APIs available, data is clean, simple logic
- 3 = Some integration work needed, moderate complexity
- 1 = Legacy systems, messy data, complex rules
Priority Score = AP × BI × IE
A process scoring 5 × 5 × 5 = 125 is a slam dunk. One scoring 2 × 2 × 2 = 8 should wait. Anything above 50 is worth pursuing. Between 20-50, evaluate case by case. Below 20, skip for now.
Calculating ROI
Before building anything, do the math:
Annual manual cost: Hours per week × loaded hourly rate × 52 weeks
Annual automation cost: Tool subscription + setup time (hours × hourly rate) + maintenance (hours/month × 12 × hourly rate)
Annual ROI: (Manual cost - automation cost) / automation cost × 100
Example:
- Task: 4 hours/week at $45/hour loaded cost = $9,360/year
- Tool: $50/month = $600/year
- Setup: 10 hours × $45 = $450 (one-time)
- Maintenance: 1 hour/month × $45 × 12 = $540/year
- Year 1 ROI: ($9,360 - $1,590) / $1,590 = 489%
- Year 2+ ROI: ($9,360 - $1,140) / $1,140 = 721%
✅ Quick Check: Pick your #1 automation candidate. Can you calculate its annual manual cost right now? Hours per week × hourly rate × 52. That number is what you’re paying to not automate.
Common Automation Candidates by Department
| Department | High-Value Candidates | Typical Time Savings |
|---|---|---|
| Sales | Lead scoring, CRM updates, follow-up emails, proposal generation | 5-10 hours/week |
| Marketing | Social media scheduling, report compilation, email campaigns, A/B test tracking | 8-12 hours/week |
| Finance | Invoice processing, expense reports, reconciliation, payroll prep | 10-15 hours/week |
| HR | Onboarding checklists, PTO tracking, offer letter generation | 5-8 hours/week |
| Operations | Order processing, inventory updates, vendor communications | 10-20 hours/week |
| Customer Support | Ticket routing, FAQ responses, status updates, escalation alerts | 15-20 hours/week |
The Process Documentation Step
Before automating, document the current process completely:
- Map every step — not just the main flow, but the exceptions
- Identify decision points — where does someone make a judgment call?
- Note data sources — which systems feed into this process?
- Record edge cases — what happens when the normal flow breaks?
- Measure baseline — current time, error rate, and throughput
This documentation becomes your automation blueprint. Skip it, and you’ll build a workflow that handles 80% of cases but chokes on the 20% that matter most.
Key Takeaways
- Start with a process audit: track every task over 30 minutes/week for one week
- Use the scoring framework (AP × BI × IE) to objectively prioritize candidates — anything above 50 is worth pursuing
- Calculate ROI before building: annual manual cost vs. automation cost (tool + setup + maintenance)
- Small business automation ROI ranges from 200-500% because tools cost $20-200/month while labor savings compound
- Document the process completely before automating — edge cases and exceptions are where automations break
- The best candidates combine high time investment, high repeatability, and easy implementation
Up Next
You’ve identified what to automate and calculated the ROI. Now you need the right tool. Lesson 4 compares the three leading no-code automation platforms — Zapier, Make, and n8n — with honest assessments of what each does best and where each falls short.