By practice type

Notion for in-house counsel: build a contract request tracker

In-house counsel can build a contract request tracker in Notion with a Requests database fed by an intake form: requester, counterparty, contract type, value band, deadline and urgency. Statuses run from New to Signed, an SLA formula flags overdue requests, and views by lawyer and type show workload and turnaround.

By Raghav Handa · Updated 27 October 2026 · 5 min read

Why do in-house teams need a contract request tracker?

In-house lawyers get contract requests through email, chat and corridor conversations. Requests arrive without key facts, priorities are unclear, and nobody can say how many are open. A tracker replaces that with one queue that business teams can submit into and see status.

Notion fits because a small legal team needs a flexible, quick-to-build system rather than an enterprise CLM platform. When volume, approvals and integrations grow, that decision changes; the honest limits are covered below. For tracking executed contracts and renewals after signature, see the lifecycle page.

What should the request form capture?

A good form asks for what you need to triage in under a minute. Notion forms and database templates can feed a Requests database; check your Notion plan for form features. Fields:

FieldTypeWhy
Requester and departmentPerson or textWho to contact and who pays
CounterpartyTextFor conflict and sanctions-type checks per your policy
Contract typeSelectNDA, MSA, SOW, Order form, Amendment, Employment, Other
PaperSelectOur paper or their paper
Value bandSelectBands you choose, such as Low, Medium, High
Needed byDateThe real deadline, not 'ASAP'
Business summaryTextWhat it is for and what matters most
Attachments or linkURLDraft, quote or proposal
Data involvedMulti-selectPersonal data, Confidential, None; triggers extra review

How do you design the Requests database?

Add internal properties the requester does not see:

  • Status: New, Triaged, In review, With counterparty, Awaiting business, Approved, Signed, Withdrawn.
  • Owner: the lawyer or paralegal responsible.
  • Priority: derived from needed-by date and value band.
  • Received date and Due date: Due = Received + SLA days for that contract type.
  • SLA status: a formula that shows Overdue when today is past Due and Status is not Signed or Withdrawn.
  • Playbook link: the relevant clause playbook or template.
  • Outcome: Signed on our paper, Signed on theirs, Lost, Withdrawn.

Notion formulas can compute due dates and flags from other properties; each view then filters on them. Create views for Triage (Status = New), My requests, Overdue, Awaiting business and Closed this month.

How should triage work?

Request typeRouteTarget
Standard NDA on our paperSelf-service template; paralegal sendsSame day
Low-value order form, standard termsPlaybook review by paralegal or junior lawyer2 business days
Customer or vendor MSALawyer review5 business days
Involves personal data or novel termsSenior lawyer plus specialist inputAgree case by case

Targets here are examples; set yours with the business and write them down. The aim is for most requests to be answered by a template, so lawyers spend time on the few that need judgment.

  1. 1

    Daily triage slot

    Open the New view once or twice a day. Assign owner, set type and priority.

  2. 2

    Acknowledge

    A Notion automation or a short email confirms receipt and the expected date.

  3. 3

    Work and update

    Owner updates status at each handoff, so requesters can check the board instead of asking.

  4. 4

    Close

    Mark Signed and link the executed copy in your contract repository.

What should you report to leadership?

The tracker's most important output is data. With received and closed dates you can show volume by contract type and by department, median turnaround, and requests that missed SLA. Present it monthly.

  • Volume by type shows which templates would save the most time.
  • Turnaround by owner shows capacity and bottlenecks.
  • Awaiting-business time shows delay that is not legal's.
  • Repeat counterparties show where a framework agreement would help.

Use Notion's table calculations or chart views for simple counts; export for deeper analysis. Do not invent benchmarks: compare your team against its own past months.

Where LawyerOS fits

We make LawyerOS, which is designed for law practices rather than in-house departments. Pro with AI has Matters, Actions, Clients, Team and Research databases that you can adapt: Matters as requests, Clients as internal business units. Starter has Matters and Deadlines only. You will need to add the form, SLA fields and statuses above.

Frequently asked questions

Can Notion work as a contract management tool for in-house legal?
Yes for small teams: a Requests database, an intake form and statuses cover triage and tracking. It is weaker than dedicated CLM software for approval workflows, e-signature integration and clause analysis, so assess volume and compliance needs.
What fields should a contract request form include?
Requester and department, counterparty, contract type, whose paper, value band, needed-by date, a business summary, a link to the draft, and whether personal or confidential data is involved. These let you triage without follow-up emails.
How do I set an SLA for contract requests in Notion?
Add a Due date formula that adds a number of days based on contract type to the received date, and an SLA flag that shows Overdue when today is past due and the request is open. Agree the targets with the business.
How do I stop requests arriving by email?
Offer a simple intake form, reply to emailed requests with the form link, and publish turnaround targets for requests made through it. Visible status on a shared view reduces chasing emails.
Is Notion acceptable for a company's legal department?
That is for your company's security and compliance teams to decide. Prepare Notion's security documentation, decide what material will be stored, and check your sector's regulations before moving confidential contracts.

Sources

About the author

Raghav Handa

Raghav Handa trained as a lawyer, then spent years building legal technology, from enterprise legal products to custom systems for law firms.

Want it built for you?

LawyerOS is a ready-made Notion workspace for matters, deadlines, time and invoices. Starter $49, Pro with AI $99, one-time.

See LawyerOS