# Automation Workflows for B2B Operations: Identifying Repeatable Work

<a id="main-content"></a>

Operations &amp; Systems

February 7, 2026  ·  9 min read  ·  Victor Valentine Romo

On this page

1. [The Automation Audit: Finding Repeatable Work](<#the-automation-audit-finding-repeatable-work>)
2. [Workflow 1: Content Production Pipeline](<#workflow-1-content-production-pipeline>)
3. [Workflow 2: CRM Data Hygiene](<#workflow-2-crm-data-hygiene>)
4. [Workflow 3: Client Reporting](<#workflow-3-client-reporting>)
5. [Workflow 4: Email Triage and Response](<#workflow-4-email-triage-and-response>)
6. [Workflow 5: Lead Routing and Follow-Up](<#workflow-5-lead-routing-and-follow-up>)
7. [Building vs Buying Automation](<#building-vs-buying-automation>)
8. [Measuring Automation ROI](<#measuring-automation-roi>)
9. [Key Recap](<#key-recap>)
10. [FAQ](<#faq>)
11. [When This Doesn&amp;#39;t Apply](<#when-this-doesn-t-apply>)

> **Quick Summary**
>
>
>
> - **What this covers:** Practical guidance for building and scaling your online presence.
> - **Who it's for:** Business operators, consultants, and professionals using AI + search.
> - **Key takeaway:** Read the first section for the core framework, then apply what fits your situation.

Before building automation, track task-level time allocation. Identify predictable process work separately from creative work and judgment.

Automation candidates should have repeatable logic and clear inputs and outputs. Measure time saved after implementation rather than assuming a result.

The workflows below describe triggers, logic, and tools. Validate each workflow and measure its effect in your own operation.

<a id="the-automation-audit-finding-repeatable-work"></a>

## The Automation Audit: Finding Repeatable Work

Before automating anything, you need to know what to automate. The audit methodology:

<a id="step-1-track-every-task-for-two-weeks"></a>

### Step 1: Track Every Task for Two Weeks

Use a simple time log — I used a **Google Sheet** with columns for: task name, category, duration, frequency, and a boolean for "did this require judgment?"

Categories I tracked:

- **Content production** — research, drafting, editing, publishing
- **[CRM](</articles/best-crm-b2b-sales-teams/>) maintenance** — data entry, deduplication, tag management, reporting
- **Communication** — email, [Slack](</articles/async-communication-b2b-teams/>), client updates, meeting scheduling
- **Reporting** — [dashboard](</articles/operator-dashboard-business-health/>) updates, client reports, internal metrics
- **Admin** — invoicing, file management, tool configuration

<a id="step-2-score-each-task-for-automation-potential"></a>

### Step 2: Score Each Task for Automation Potential

After two weeks of logging, score every recurring task:

| Score | Criteria |
| --- | --- |
| 5 | Fully automatable — no judgment, predictable inputs/outputs |
| 4 | Mostly automatable — needs human review of output |
| 3 | Partially automatable — some steps are automatable, others need judgment |
| 2 | Minimally automatable — mostly judgment, some steps can be templated |
| 1 | Not automatable — pure creativity, relationship, or strategic thinking |

Tasks scoring 4-5 are automation candidates. Tasks scoring 3 are semi-automation candidates (automate the predictable steps, human handles the judgment steps). Tasks scoring 1-2 stay manual.

<a id="step-3-prioritize-by-time-frequency"></a>

### Step 3: Prioritize by Time × Frequency

A task taking 10 minutes but happening 20 times weekly (200 minutes) is a higher priority automation target than a task taking 60 minutes but happening once monthly. Multiply time per occurrence by weekly frequency to rank automation ROI.

Tasks with high automation scores become candidates for the first automation wave. Prioritize them using your recorded time allocation.

<a id="workflow-1-content-production-pipeline"></a>

## Workflow 1: Content Production Pipeline

**[Manual work](</articles/operations-automation-audit/>):** researching keywords, creating briefs, formatting articles, adding frontmatter, deploying files.

**Automation design:** the [AI content workflow](</articles/ai-content-production-workflow/>) handles brief generation, drafting, and formatting. Human time goes to quality review and strategic decisions.

<a id="the-automated-steps"></a>

### The Automated Steps

**Brief generation:** A **Claude Code or Codex CLI** skill reads the [topical map](</articles/topical-map-b2b-websites/>), selects the next articles in the priority queue, and generates structured content briefs including target keywords, H2/H3 outlines, internal linking targets, and FAQ questions. Trigger: weekly queue review command.

**Drafting:** Each brief feeds into a drafting prompt that loads voice specifications, reference articles, and the topical map context. **Claude Fable 5** produces the complete article draft. The drafting step runs in batch — 10 articles at once.

**Formatting:** A script adds frontmatter, standardizes [heading levels](</articles/accessible-headings-b2b-pages/>), validates internal link slugs, and formats entity names in bold. Review the formatting output before publication.

**Deployment:** A **Git** commit pushes formatted articles to the repository. The build system generates HTML, sitemap, and [schema markup](</articles/schema-markup-b2b-strategy/>) automatically.

<a id="the-human-steps-irreducible"></a>

### The Human Steps (Irreducible)

- Editorial quality review (3-5 minutes per article)
- Strategic priority selection (which articles to produce this week)
- Voice calibration adjustments (updating constraints based on output patterns)

<a id="workflow-2-crm-data-hygiene"></a>

## Workflow 2: CRM Data Hygiene

**Manual work:** manually reviewing new contacts for data [completeness](</articles/data-quality-dimensions-business-reports/>), scanning for duplicates, auditing tag compliance, updating stage accuracy.

**Automation design:** automated scans flag issues; human reviews and resolves flagged items.

<a id="the-automated-steps-2"></a>

### The Automated Steps

**Daily duplicate scan:** A **[Google Apps Script](</articles/google-apps-script-business-automation/>)** runs nightly, exporting contacts created in the last 24 hours from **a vertical CRM** via API. The script normalizes phone formats and checks against existing records for exact and fuzzy matches. Matches get flagged with `system:duplicate-review` tag.

**Weekly completeness audit:** Script scans all contacts modified in the past week. Contacts missing critical fields (email, phone, source tag, stage tag) get flagged with `system:data-incomplete`.

**Tag compliance check:** Script pulls all tags created in the past week. Any tag not in the approved taxonomy gets flagged for review with the agent who created it and the correct taxonomy alternative.

**Stage accuracy automation:** Contacts tagged `stage:hot-prospect` with no logged activity in 60+ days get automatically reclassified to `stage:nurture`. Contacts in `stage:new` with a logged call get automatically advanced to `stage:contacted`.

<a id="the-human-steps-irreducible-2"></a>

### The Human Steps (Irreducible)

- Reviewing and executing duplicate merges (automated merging is too risky — data loss potential)
- Evaluating flagged tag violations and coaching agents
- Spot-checking stage transitions for edge cases

<a id="workflow-3-client-reporting"></a>

## Workflow 3: Client Reporting

**Manual work:** pulling data from **[Google Search Console](</articles/google-search-console-advanced-techniques/>)**, **Ahrefs**, **Google Analytics**, compiling into client-facing reports, formatting, and sending.

**Automation design:** automated data pull and compilation, human reviews and adds commentary.

<a id="the-automated-steps-3"></a>

### The Automated Steps

**Data aggregation:** A **Google Apps Script** pulls weekly metrics from **Google Search Console** [API](</articles/api-first-business-operations/>) (impressions, clicks, CTR, position changes), **Google Analytics** API (sessions, conversions, bounce rate), and writes them to a client-specific **Google Sheet**.

**Report compilation:** A template sheet auto-populates with the week's data, calculates week-over-week and month-over-month changes, and highlights [metrics](</articles/business-metric-dictionary-template/>) that moved beyond threshold (&gt;10% change in either direction).

**Chart generation:** **[Google Sheets](</articles/google-sheets-crm-automation/>)** charts update automatically as data populates. Trend lines, comparison charts, and KPI dashboards regenerate without manual intervention.

<a id="the-human-steps-irreducible-3"></a>

### The Human Steps (Irreducible)

- Reading the compiled report and identifying the narrative (what happened, why, what to do next)
- Writing 2-3 paragraphs of strategic commentary
- Sending the report with context the numbers don't show

<a id="workflow-4-email-triage-and-response"></a>

## Workflow 4: Email Triage and Response

**Manual work:** processing 200+ emails, categorizing, routing, responding to routine inquiries.

**Automation design:** automated categorization and routing, human handles items requiring judgment.

<a id="the-automated-steps-4"></a>

### The Automated Steps

**Inbox categorization:** **Gmail** filters categorize incoming email by sender domain, [subject line](</articles/cold-email-subject-lines-b2b/>) keywords, and thread participation. Categories: client communication, prospect inquiry, vendor/tool notification, newsletter, and internal.

**Template responses:** Routine inquiries (pricing questions, scheduling requests, status updates) trigger template responses via **Gmail** canned responses. The templates include dynamic fields populated from my contact database.

**Calendar management:** Meeting requests auto-route to **Calendly** links based on the type of request. Discovery calls, client check-ins, and internal syncs each have dedicated booking pages with appropriate durations and preparation requirements.

<a id="the-human-steps-irreducible-4"></a>

### The Human Steps (Irreducible)

- Reading and responding to substantive client communication
- Evaluating prospect inquiries for fit before responding
- Making decisions on requests that don't match templates

<a id="workflow-5-lead-routing-and-follow-up"></a>

## Workflow 5: Lead Routing and Follow-Up

**Manual work:** monitoring inbound leads, assigning to agents, setting follow-up reminders, tracking response times.

**Automation design:** automated routing handles assignment, escalation handles missed response windows, human reviews exceptions.

<a id="the-automated-steps-5"></a>

### The Automated Steps

**Instant lead routing:** When a lead enters **a vertical CRM** from any source (web form, lead [marketplace](</articles/seo-moat-marketplace-platforms/>), phone call), the CRM auto-classifies by source tag, applies area tags based on property address or stated interest, and routes to the assigned agent based on geographic territory.

**Notification cascade:** Assigned agent receives push notification, SMS, and email simultaneously. No single notification channel is reliable — the cascade ensures the message reaches them.

**Escalation timer:** If no contact attempt is logged within 5 minutes, the lead escalates to the team lead. If no attempt within 15 minutes, the lead reassigns to the on-duty agent.

**Follow-up sequencing:** After initial contact, the contact enters an automated nurture sequence based on their stage and type. The sequence handles touchpoints at predetermined intervals without agent intervention.

<a id="the-human-steps-irreducible-5"></a>

### The Human Steps (Irreducible)

- Reviewing exception cases (routing conflicts, unclear geographic matches)
- Coaching agents on response quality (speed is automated, quality isn't)
- Adjusting routing rules when territory assignments change

<a id="building-vs-buying-automation"></a>

## Building vs Buying Automation

<a id="when-to-build-custom"></a>

### When to Build Custom

Build when:

- Your workflow is unique to your business and no tool covers it
- Integration between existing tools requires custom logic
- The automation is simple enough for **Google Apps Script**, shell scripts, or **Claude Code and Codex CLI** skills
- Cost sensitivity matters — custom automation has no per-seat recurring fees

<a id="when-to-buy-existing-tools"></a>

### When to Buy Existing Tools

Buy when:

- The workflow is common across industries (email marketing, CRM routing, reporting)
- Reliability matters more than flexibility — commercial tools have monitoring, alerting, and failover
- Time to implement matters — **Zapier** or **Make** connects two tools in minutes vs hours for custom code
- The team includes non-technical operators who need to modify workflows

<a id="the-hybrid-approach"></a>

### The Hybrid Approach

Most of my automations are hybrid. **a vertical CRM** handles CRM-native workflows (routing, action plans). **Google Apps Script** handles data processing that CRM can't do natively (scoring, enrichment, cross-system reporting). **Claude Code and Codex CLI** handle complex workflows that require AI judgment ([content production](</articles/ai-content-production-workflow/>), brief generation, quality review).

The stack: commercial tools for infrastructure, custom scripts for integration, AI for judgment-adjacent automation. Each layer handles what it's best at. Forcing any single layer to do everything creates brittleness.

<a id="measuring-automation-roi"></a>

## Measuring Automation ROI

Time saved is the obvious metric, but three others matter more:

**Error reduction:** Track the data quality issues found by automated scans. Review duplicates and their effects on subsequent work.

**Consistency:** Automated workflows execute the same way every time. The 200th lead gets the same routing speed, notification cascade, and follow-up sequence as the first. Manual processes degrade as operators fatigue, get distracted, or make exceptions.

**Capacity:** Measure recovered time and decide where to use it. Review delivery quality alongside time saved.

**Take Action: Work With Victor**

<a id="key-recap"></a>

## Key Recap

- **The Automation Audit: Finding Repeatable Work:** Before automating anything, you need to know what to automate.
- **Workflow 1: Content Production Pipeline:** Build when:

- Your workflow is unique to your business and no tool covers it
- Integration between existing tools requires custom logic
- The automation is simp

- **Workflow 2: CRM Data Hygiene:** Build when:

- Your workflow is unique to your business and no tool covers it
- Integration between existing tools requires custom logic
- The automation is simp

- **Workflow 3: Client Reporting:** Build when:

- Your workflow is unique to your business and no tool covers it
- Integration between existing tools requires custom logic
- The automation is simp

- **Workflow 4: Email Triage and Response:** Build when:

- Your workflow is unique to your business and no tool covers it
- Integration between existing tools requires custom logic
- The automation is simp

- **Workflow 5: Lead Routing and Follow-Up:** Build when:

- Your workflow is unique to your business and no tool covers it
- Integration between existing tools requires custom logic
- The automation is simp

<a id="faq"></a>

## FAQ

<a id="how-do-i-start-automating-if-i-have-no-technical-skills"></a>

### How do I start automating if I have no technical skills?

Start with **Zapier** or **Make** — both are visual workflow builders that connect tools without code. Automate one workflow that saves at least 30 minutes weekly. Once you've validated the approach, expand to the next workflow. Technical skills develop through doing. You don't need to become a developer — you need to understand triggers, conditions, and actions.

<a id="what-s-the-biggest-automation-mistake-you-ve-made"></a>

### <a id="what-39-s-the-biggest-automation-mistake-you-39-ve-made"></a>  What's the biggest automation mistake you've made?

Automating a broken process. I built an elaborate lead routing system before fixing the CRM data it routed against. The automation worked perfectly — it just perfectly executed bad logic against dirty data, producing consistently wrong agent assignments. Fix the process manually first. Automate the process that works, not the process that's broken.

<a id="how-do-i-maintain-automations-as-tools-update-their-apis"></a>

### How do I maintain automations as tools update their APIs?

Schedule a monthly automation health check. Run each workflow manually and verify the output matches expectations. API changes break integrations silently — the automation stops producing correct output but doesn't error visibly. The monthly check catches drift before it accumulates into business impact.

<a id="can-automation-replace-a-virtual-assistant"></a>

### Can automation replace a virtual assistant?

For structured, repeatable tasks — yes, at lower cost and higher reliability. For tasks requiring judgment, [context switching](</articles/time-blocking-b2b-operators/>), and human communication — no. The sweet spot is automating the 60-70% of a VA's task list that follows predictable logic, then hiring a VA at reduced hours for the 30-40% that requires human flexibility.

***

***

**Related Reading:**

- [The Operator's Stack: Tools, Systems, and Workflows](</articles/operator-tech-stack-tools/>)
- [Browser Automation With AI: Replacing 4 Hours Daily](</articles/browser-automation-ai-tools/>)
- [Zapier vs Custom Automation: When Low-Code Breaks](</articles/zapier-vs-custom-automation-b2b/>)

***

<a id="when-this-doesn-t-apply"></a>

## <a id="when-this-doesn-39-t-apply"></a>  When This Doesn't Apply

Skip this if your situation is fundamentally different from what's described above. Not every framework fits every business. Use the diagnostic in the first section to determine whether this approach matches your current stage and goals.

Read the method behind the writing.

The [Seventeen Principles](</principles/>) map how this work is done. The [work history](</experience/>) gives its background.
