Client Portal for Law Firms: Secure, from Google Sheets

Ask a legal receptionist what the phone rings about, and the answer is one question in a hundred costumes: "Any update on my case?" It is a reasonable question — litigation moves invisibly from the client's side — and also billable-hour quicksand, because the answer is usually a status the client could have read in ten seconds, if anywhere existed to read it.

Documents compound the problem. The firm needs a signed declaration and two years of pay stubs; the client emails them in four installments from two addresses, and a paralegal spends Thursday reconstructing which exhibits actually arrived. Sending things back out is no better — attaching a draft settlement agreement to ordinary email is a practice many firms tolerate and none are comfortable defending. Then there is the retainer: clients rarely know their balance until the replenishment letter arrives, which makes every replenishment letter a surprise.

Portals purpose-built for law firms exist, priced accordingly. But the record most small firms already keep — a spreadsheet of matters, statuses, dates, and balances — contains everything a client-facing portal needs. AI can now generate that portal directly from it, with the access controls confidentiality demands.

Step 1: The Matter Sheet

Build one workbook: a master roster with a row per client, and a tab per client to hold requested documents, received documents, and case-timeline entries. The roster columns:

Write Status entries in client-comprehensible terms — Discovery, Awaiting hearing, Negotiating settlement — since these will appear verbatim on the client's screen.

Step 2: The Account

Create a free account at lovespreadsheets.com. Constructing the portal costs nothing; per-client password-protected logins and a firm-domain address are paid features. For legal work, treat the logins as mandatory rather than optional — an open link is not an acceptable delivery mechanism for matter information.

Step 3: Specify the Client's View

Select the Website template and state, in ordinary language, what a represented client should see:

"Each client on the roster receives a private page showing their matter, its current status, the next court or filing date, and their remaining retainer balance. Include the list of documents we have requested and which have been received. Provide a secure upload area whose contents go to that client's tab. Access to one client's page must never reveal any other client's existence."

Three requests suited to a legal practice:

• A read-only matter timeline — filings, hearings, and milestones in order, so the client can trace what has happened without being able to alter a word of it
• Two-way document exchange — clients upload the declaration and pay stubs through their page; the firm posts drafts and filed copies to the tab, keeping exchanges out of email entirely
• Individually credentialed logins — one username per client, passwords stored hashed, each credential unlocking a single matter page and nothing beyond it

Upload the workbook and begin. AI Optimize will refine imprecise phrasing, the AI may pose a clarifying question before building, and the result is ready in roughly 15–20 minutes.

Step 4: The Update Call, Retired

Every client receives a distinct URL. In Share, set access to Private and enroll the usernames from the roster column. Apply the firm's logo and colors, and stand it up at portal.yourfirmname.com so the address on the engagement letter is the firm's own.

Operationally, nothing new is asked of staff. A paralegal logs "Motion filed, Jul 22" in the client's tab and the timeline reflects it at once; the client's uploaded pay stubs surface in the same tab, dated on arrival. When a status changes in the sheet, every affected portal is current before the phone can ring.

Why Law Firms Keep the Sheet

The record stays inside the firm's account. No matter data is exported into a portal vendor's database. The spreadsheet remains the authoritative file, under the firm's own Google account and its existing safeguards.

Transparency lowers call volume and raises trust. A client who can see Discovery, the August 11 hearing, and their balance stops calling for reassurance — and stops suspecting silence means neglect.

The retainer conversation stops being a surprise. A visible, current balance turns replenishment from an unwelcome letter into an expected event, which is better for collections and better for the relationship.

Common Questions from Law Firms

Does this satisfy our confidentiality obligations? The source data never leaves the firm's Google account, access requires hashed-password logins, and each credential is scoped to exactly one matter. Evaluate it under the same technology-competence review you apply to email, e-filing, and cloud storage.

Can opposing parties or the public find these pages? Private mode means no login, no page. There is no directory of clients to browse and no way to enumerate other matters from a valid login.

Is this a case management system? No — it is the client-facing layer most case management suites lack or charge steeply for. Your internal docketing continues wherever it lives today; the portal simply shows each client their slice of it.

Build Yours

The matter list your firm maintains already knows every answer clients call to ask. Take it to lovespreadsheets.com, describe the page a client should see, and let the build run. Within the hour, "any update on my case?" has a standing answer — one that never bills a minute.