Skip to contentSkip to Content
DocsResourcesTemplatesWorkflow Design
Templates

Workflow design worksheet

A workflow mapped on this worksheet is detailed enough for your FDE to scope and build from — and detailed enough for you to judge whether automating it will actually deliver value. It’s also a useful diagnostic: if you can’t fill in the trigger, the decisions, and the failure modes, the workflow isn’t understood well enough to automate yet.

Map one workflow per worksheet. Start with your top scorer from the AI opportunity audit.

What to capture

Seven fields, in order:

  1. Name and owner — what the workflow is called and the one person accountable for it working.
  2. Trigger — the event that starts a run. Be precise: “an email with a PDF attachment arrives in accounts@” is a trigger; “when invoices come in” is not.
  3. Steps — what happens, in sequence, including the boring parts. Number them.
  4. Decision points — every place the path forks, and the rule that decides which branch. Decisions are where AI judgment or a human gate lives, so vague rules here become bugs later. The DOE framework explains how we separate these decisions from the deterministic steps around them.
  5. Data in / data out — what the workflow reads, and what it produces or changes, in which systems.
  6. Human review gates — the points where a person must approve before the workflow continues. If a mistake is expensive, there should be a gate in front of it.
  7. Failure modes — the ways runs go wrong today, and what should happen when they do. “It fails sometimes” is not a failure mode; “the PDF is an illegible scan” is.

Worked example: supplier invoice intake

A real pattern from the document-handling automations we build — extracting key information from invoices and entering it into an accounting tool (see workflow automation).

Name and owner: Supplier invoice intake — owned by the office manager.

Trigger: An email with a PDF attachment arrives in the accounts@ inbox.

Steps:

#StepDone by
1Classify the email — is the attachment a supplier invoice?System
2Extract fields: supplier, invoice number, date, amount, tax, PO referenceSystem
3Match the supplier and PO against existing recordsSystem
4Create a draft bill in the accounting toolSystem
5Review and approve flagged billsHuman
6Archive the PDF to the shared invoices folder and log the runSystem

Decision points:

DecisionRuleIf yesIf no
Is the attachment an invoice?Classification confidence above thresholdContinue to extractionLeave in inbox, notify office manager
Is the supplier known?Supplier matches an existing recordContinueFlag for human review
Is the amount under $5,000 CAD?Amount field vs thresholdCreate draft bill directlyRoute to approval gate first

Data in / data out:

DirectionDataSystem
InInvoice PDFEmail inbox
InSupplier and PO recordsAccounting tool
OutDraft billAccounting tool
OutArchived PDFShared drive folder
OutRun log entry and exception notificationsWorkflow system

Human review gates: new suppliers, amounts of $5,000 CAD or more, and any extraction below the confidence threshold. Everything else flows through and stays visible in the run log.

Failure modes:

FailureHow it shows upWhat should happen
Illegible or scanned-image PDFExtraction confidence is lowRoute to human queue with the original attached
Duplicate invoiceInvoice number already existsSkip creation, notify with a link to the existing bill
Missing PO referencePO field emptyCreate the draft bill but hold it at the approval gate
Non-invoice attachment (statement, receipt)Classifier flags mismatchLeave in inbox untouched

Blank template

Copy this into a document and fill it in — one workflow per copy:

WORKFLOW DESIGN WORKSHEET Name: ______________________ Owner: ______________________ Runs per week: _____ Hours/week it consumes today: _____ TRIGGER (the precise event that starts a run): - ___________________________________________________________ STEPS (in sequence; mark each Human or System-candidate): 1. __________________________________________ [Human/System] 2. __________________________________________ [Human/System] 3. __________________________________________ [Human/System] 4. __________________________________________ [Human/System] 5. __________________________________________ [Human/System] DECISION POINTS (where the path forks, and the rule): - Decision: ____________________ Rule: ______________________ If yes: ______________________ If no: _____________________ - Decision: ____________________ Rule: ______________________ If yes: ______________________ If no: _____________________ DATA IN (what the workflow reads, and from where): - ___________________________________________________________ - ___________________________________________________________ DATA OUT (what it produces or changes, and where): - ___________________________________________________________ - ___________________________________________________________ HUMAN REVIEW GATES (where a person must approve): - ___________________________________________________________ FAILURE MODES (how runs go wrong, and what should happen): - Failure: _____________________ Handling: __________________ - Failure: _____________________ Handling: __________________ - Failure: _____________________ Handling: __________________ EDGE CASES / NOTES: - ___________________________________________________________

What your FDE does with this

During week 0 of an engagement, your FDE maps your workflows in exactly this shape before anything is built — a completed worksheet shortens that work and sharpens the first sprint. The steps marked “System” become build candidates, the decision points determine where AI judgment versus fixed rules belong, and the failure modes become test cases. If you’re already a client, share completed worksheets with your FDE in Chat.

Next steps

Last updated on