Legal Department
Drawing Office — Schematics
Sanscript — Legal Solutions Bureau
FILE
SC-2026-006
Sec. 01 — Schematic library · Form SC-06
Title

The method, drawn. Eight working patterns for legal work.

Drawn
D. Kein
Checked
[X] Bureau
Sheet
SC-06.00
Rev
09/2026
Scale
NTS
Sheets
1 of 9
General notes
1

Legal work does not happen in legal tools. It happens in Jira, Gmail, a Google Sheet, Notion, a database and one very disciplined bot — all at once. Every sheet below is a real build designed by the lawyer on the matter, drawn the same way: inputs, a control layer, gated outputs. The technology changes; the method does not.

Dashed = manual · Solid = controlled · Diamond = gate · Double border = control system
Drawing register — sheet indexSC-06.00
Fig. Title
01Legal workflow under control
02Four sources, one truth
04Jira timesheets to payouts
05Team legal bot, bounded
06Packets from one Google Sheet
07AI assist under control
08The glue layer, versioned
09Signature routing with a pre-sign gate
Sec. 02 — Six principles

How the bureau works: six principles, then the same review cycle for every document.

01

Facts before labels

Start from what actually happens — who signs, who pays, where the data goes — and only then name it in legal terms.

02

Law that runs through what people already do

Rules go into the tools and steps your team already uses, not into extra signatures and forms.

03

The smallest change that works

One clause, one rider, one procedure: the narrowest fix that removes the risk.

04

A human decides, in writing

Every legal call is made by a lawyer and recorded with its reasons. AI drafts and checks; it does not decide.

05

Evidence boundaries

Each answer says what it rests on and where it stops. Unknowns are named, not guessed.

06

Independent review

Important documents get a second read against a checklist before they leave.

Review cycle — every document, every timeSC-06.RC
  1. 01Analysis
  2. 02Questions
  3. 03Decision
  4. 04Redline
  5. 05QA
Sec. 03 — The schematics

Eight sheets from the drawing office.

Real tools, real routes: Jira, Gmail, Sheets, Notion, n8n, Gemini, Drive, a database and a bot. Dashed lines are uncontrolled, manual movement. Solid lines are controlled flow. Every diamond is a gate: nothing passes it unchecked. Each sheet is drawn the same way — map the process, encode the logic, control the output — and Fig. 01 is the master pattern every other sheet wraps around one real build.

Fig. 01SC-06.01

Legal workflow under control

The master pattern behind every build: scattered inputs pass one control layer — source of truth, decision rules, validation gates — before anything reaches the outside world.

INPUTS CONTROL LAYER OUTPUTS SPREADSHEET INBOX DOCUMENT TEMPLATE TICKET POLICY SOURCE OF TRUTH DECISION RULES VALIDATION GATES GENERATED PACKET AUDIT TRAIL HANDOFF GUIDE ARCHIVE FIG. 01 — LEGAL WORKFLOW UNDER CONTROL FORM SC-06.01 · REV 07/2026 !!
Text description

Workflow schematic: scattered inputs pass through a control layer — source of truth, decision rules, validation gates — and become controlled outputs

CoreAny workflow
Fig. 02SC-06.02

Four sources, one truth

Jira, the auditor's mail thread, a Google Sheet and Notion all claim to hold the truth. APIs and n8n pull all four into one database — and the local HTML report becomes the only version everyone trusts.

FOUR PLACES GLUE ONE TRUTH JIRA GOOGLE SHEET AUDITOR MAIL NOTION API PULL N8N FLOW ONE DATABASE LOCAL HTML REPORT TASKS · API MANUAL EDITS XLSX IN THREADS WIKI TABLES DIRECT TO DB PARSE + MAP NORMALIZED ROWS ONE VIEW FOR EVERYONE ×4 ?! FIG. 02 — FOUR SOURCES, ONE TRUTH FORM SC-06.02 · REV 07/2026
Text description

Data consolidation schematic: Jira and a Google Sheet flow through direct API pulls, auditor mail and Notion flow through n8n, all into one normalized database that renders a local HTML report

JiraN8NNotionDB
Fig. 04SC-06.04

Jira timesheets to payouts

Worklogs leave Jira by API, pass hours-and-rate gates, and come back as payout packets in Google Workspace. Anomalies go to a human; approvals and payments get logged.

JIRA WORKLOGS RATE TABLE HOURS VS PLAN APPLY RATES ANOMALY TRAY PAYOUT PACKET APPROVAL PAYMENT + LOG HOURS BY API ONE SHEET HUMAN CHECK GOOGLE DOCS SIGN-OFF · MAIL BANK · LEDGER MONTHLY CYCLE CLOSE CALC APPROVE PAY FIG. 04 — JIRA TIMESHEETS TO PAYOUTS FORM SC-06.04 · REV 07/2026
Text description

Payout schematic: Jira worklogs and a rate table enter a payout engine that checks hours against plan and applies rates; anomalies go to a human tray; validated payouts become Google Docs packets, get approved, paid and logged on a monthly cycle

JiraWorkspacePayouts
Fig. 05SC-06.05

Team legal bot, bounded

A custom GPT does the first pass on incoming contracts using a versioned knowledge pack — pipeline, risk rubric, anti-overreview rules. Client secrets and personal data stay out; red and amber flags escalate to the lawyer.

CONTRACT IN PIPELINE RISK RUBRIC ANTI-OVERREVIEW CHECKLIST CUSTOM GPT — FIRST PASS CLAUSE MAP RISK SCORE R·A·Y·G OVERREVIEW FILTER STRUCTURED REVIEW DRAFT EMAIL RED / AMBER TO THE LAWYER PERSONAL DATA FROM THE TEAM KNOWLEDGE PACK — NO CLIENT DATA RISKS · RAYG CLIENT-READY STAYS OUT FIG. 05 — TEAM LEGAL BOT, BOUNDED FORM SC-06.05 · REV 07/2026
Text description

Legal bot schematic: contracts from the team enter a custom GPT loaded with a knowledge pack of pipeline, risk rubric, anti-overreview rules and checklist; it maps clauses, scores risk red-amber-yellow-green, outputs a structured review and client-ready draft email; red and amber findings escalate to the lawyer; personal data stays out

Custom GPTContractsBoundaries
Fig. 06SC-06.06

Packets from one Google Sheet

One Google Sheet plus approved templates. The merge engine fills, numbers and validates — failures go to a human tray, never to the client.

GOOGLE SHEET TEMPLATE LIBRARY FIELD MAPPING MERGE & NUMBER GENERATED PACKET RUN LOG EXCEPTION TRAY ONE SOURCE OF TRUTH GOOGLE DOCS WHO · WHEN · WHAT HUMAN REVIEW FAILS FIG. 06 — PACKETS FROM ONE GOOGLE SHEET FORM SC-06.06 · REV 07/2026
Text description

Document generation schematic: a Google Sheet and template library feed a merge engine; validated output becomes a generated packet with a run log, failures go to an exception tray

SheetsDocumentsGeneration
Fig. 07SC-06.07

AI assist under control

The model retrieves from approved sources only, drafts with citations and checks itself — but nothing leaves without a lawyer's sign-off. The model drafts; the lawyer decides.

QUESTION IN SOURCE LIBRARY RETRIEVAL DRAFT ANSWER CITATION CHECK ESCALATE TO COUNSEL LAWYER REVIEW ANSWER + CITATIONS APPROVED DOCS ONLY IN SCOPE? NO YES FINAL SAY — HUMAN REDRAFT FIG. 07 — AI ASSIST UNDER CONTROL FORM SC-06.07 · REV 07/2026
Text description

AI assist schematic: a question and an approved source library feed a model workspace of retrieval, drafting and citation checks; an in-scope gate routes work to a lawyer review gate before an answer with citations is released, out-of-scope questions escalate to counsel

AIKnowledge
Fig. 08SC-06.08

The glue layer, versioned

Cron fires at 06:00, webhooks fire whenever. Every n8n flow retries three times, writes a run log and alerts a human only when the duct tape actually tears. The glue is also code — versioned and logged.

TRIGGERS N8N FLOW OUTPUTS CRON 06:00 WEBHOOK MAIL TRIGGER FETCH APIS TRANSFORM UPSERT DB RUN LOG TG / MAIL ALERT DATA READY ON ERROR: RETRY ×3 EVERY EXECUTION ON FAILURE ONLY FOR THE NEXT STEP THE GLUE IS ALSO CODE — VERSIONED, LOGGED FIG. 08 — THE GLUE LAYER, VERSIONED FORM SC-06.08 · REV 07/2026
Text description

Automation glue schematic: cron, webhook and mail triggers enter one n8n flow of fetch, transform and database upsert with an on-error retry lane; outputs are a run log for every execution, alerts on failure only, and data ready for the next step

N8NAutomationReliability
Fig. 09SC-06.09

Signature routing with a pre-sign gate

No envelope goes out before the pre-sign check passes. Signing order is enforced, declines loop back, and executed sets sync and archive themselves.

FINAL DRAFT PRE-SIGN CHECK 1 · SIGNER A 2 · SIGNER B 3 · COUNTERSIGN EXECUTED SET CRM / CLM SYNC ARCHIVE + AUDIT CERT ENTITY NAMES EXHIBITS A–E SIG BLOCKS OK DECLINE FIG. 09 — SIGNATURE ROUTING FORM SC-06.09 · REV 07/2026
Text description

E-signature schematic: a final draft passes a pre-sign checklist of entity names, exhibits and signature blocks, then moves through an ordered signer chain; declines loop back, the executed set syncs to CRM and archives with an audit certificate

ExecutionE-sign

Recognize one of these sheets?

If your contracts, contractors or data also live in four places at once, that is where to start. Sanscript takes your version of it as the lawyer on the matter, writes the rules and hands the system to your team — with a guide to run it on its own.

Book a 20-minute call