Prompt Chain: Weekly Case Status Report Generator

From Clio Notes to Attorney-Ready Summary in 15 Minutes

Tools: Clio + Claude Pro or ChatGPT Plus | Time to build: 1 hour | Difficulty: Intermediate Prerequisites: Comfortable using Claude for drafting — see Level 3 guide: "Use ChatGPT Plus for Legal Research Memos and Analysis"

What This Builds

Every Monday morning, instead of spending an hour pulling together case status information from Clio, emails, and your memory, you run a structured multi-step AI workflow that takes your Clio notes and produces a professional weekly status report for the supervising attorney — showing every active matter, what happened last week, and what's due this week.

Prerequisites

• Claude Pro or ChatGPT Plus account
• Clio access (you'll export a data summary — no API setup required for the basic version)
• A weekly reporting habit — this workflow rewards consistency

The Concept

A "prompt chain" is where the output of one AI prompt becomes the input to the next. Each step processes information differently:

• Step 1: Dump your raw notes into AI → get them cleaned and organized
• Step 2: Feed the organized notes into AI → get a formatted status report
• Step 3: Feed the status report into AI → get a concise executive summary

Think of it like an assembly line: raw materials in one end, polished product out the other, with each station doing a specific transformation.

Build It Step by Step

Part 1: Set Up Your Clio Data Export

At the end of each week (Friday afternoon or Monday morning), you'll pull case activity from Clio:

1. In Clio, go to "Reports" (or "Time" → "Billing")
2. Run a report for "Activity for the Week" filtered to your user and all active matters
3. Export as CSV or copy the activity list to your clipboard
4. Also open your calendar and note any significant events (court dates, client calls, depositions) from the past week

You now have your raw data: a list of activities, matters, and times from Clio plus calendar events.

Part 2: Step 1 Prompt — Organize the Raw Data

Open Claude Pro or ChatGPT Plus. Start a new conversation. Paste this prompt, then paste your raw Clio activity export and calendar notes below it:

STEP 1 - ORGANIZE RAW CASE DATA

You are helping a paralegal prepare a weekly case status report. Below is raw activity data from a case management system and calendar.

Please organize this data by matter/case name. For each matter, group:
- Time entries (activities logged this week)
- Calendar events from this week
- Any notes about status or developments

Output a clean grouped list organized by matter name. Remove duplicates. Preserve all significant activities.

RAW DATA:
[paste Clio export and calendar notes here]

What you get: A clean, organized list of what happened on each case this week — the messy Clio export transformed into readable groups.

Part 3: Step 2 Prompt — Generate the Status Report

Copy the output from Step 1. Start a new message (or new conversation) and paste:

STEP 2 - GENERATE STATUS REPORT

Using the organized case data below, generate a professional weekly case status report for the supervising attorney.

Format: For each matter, include:
- MATTER NAME (in bold)
- Status: [one sentence — where is this case right now?]
- This week: [bullet points of key activities completed]
- Next steps: [bullet points of what needs to happen this week]
- Deadlines: [any upcoming deadlines in the next 14 days]

Use professional language. Flag any matter with urgent deadlines or issues that need attorney attention with [URGENT] at the start.

ORGANIZED CASE DATA:
[paste Step 1 output here]

What you get: A formatted status report covering all active matters — ready for attorney review.

Part 4: Step 3 Prompt — Executive Summary (Optional)

For attorneys who are in court all week and just need the highlights:

STEP 3 - EXECUTIVE SUMMARY

From the status report below, create a 5-bullet executive summary covering only:
1. Matters with court deadlines in the next 14 days
2. Matters waiting on attorney action or decision
3. Any urgent issues that need attention today
4. Discovery deadlines approaching this month
5. New matters opened this week

STATUS REPORT:
[paste Step 2 output here]

What you get: A 5-bullet digest the attorney can read in 60 seconds.

Real Example: Full Chain in Action

Setup: A paralegal supporting 3 attorneys with 24 active matters. Monday morning, 8:45am.

Step 1 input: 47 Clio time entries from the past week, 6 calendar events.

Step 1 output: Organized list — 24 matters, each with their week's activities grouped together. What took 30 minutes to organize mentally took 30 seconds.

Step 2 output: Full status report — 2 pages covering all 24 matters. Two matters flagged [URGENT]: one with a motion due Thursday, one with a settlement conference on Wednesday requiring prep.

Step 3 output: 5-bullet executive summary. Attorney reads it at 9:00am, already knows what needs attention today.

Total time: 15 minutes of work, compared to 60–90 minutes of manual report preparation.

What to Do When It Breaks

• AI doesn't correctly group activities by matter → Add matter numbers or codes to your Clio activities so the AI has a consistent identifier to group by
• Status descriptions are generic ("case is ongoing") → Add more context to Step 1 by including your own notes: "Note: Johnson case — we're waiting for medical records, should arrive this week"
• Report is too long for the attorney to read → Skip Step 2, go directly from Step 1 to Step 3 (the executive summary) — less detail, faster read
• Clio export has messy formatting → Ask the AI in Step 1 to "ignore formatting inconsistencies and focus on the content"

Variations

• Simpler version: Skip the chain — just paste a bulleted list of what you worked on this week and ask Claude to "draft this into a case status report for my attorney"
• Extended version: Schedule a Friday reminder to run this process. Over time, save your Step 2 outputs to a running document in Clio as a case history log — valuable for billing disputes and long-running cases

What to Do Next

• This week: Run the chain once with last week's real data to see the output quality
• This month: Refine the prompts based on what your attorney actually wants to see
• Advanced: For firms with Clio's API enabled, Zapier can automate the Clio data export portion — so you only need to run Steps 2 and 3 manually

Advanced guide for paralegal professionals. This workflow processes internal case notes — ensure your firm's AI policy permits using AI tools with matter-level information before using external AI services.