Build Free Client Portals from One Google Sheet

Every client-services business ends up running the same ritual: the monthly status email. Attach the report, restate the invoice, answer "where are we on the project?" for the fourth time — multiplied by every client on the roster.

Felix Solutions, a 12-client marketing agency, was living that ritual monthly. The fix they wanted was obvious — a portal where each client logs in and sees their own status, reports, and invoices — but portal software either costs real money per client or means a custom build. What they actually did: turned the one Google Sheet they already used to track clients into twelve separate branded portals, with AI, on a free account. One sheet in, twelve portals out.

Here's the exact approach.

Step 1: Structure One Master Google Sheet

The whole system runs on a single spreadsheet:

• A master client list — one row per client, including the username each client will log in with
• One tab per client — that client's project statuses (in progress, on hold, done), links to monthly reports (Google Docs or PDFs), invoice lines with paid/unpaid status, and a section where client uploads will land

If you already track clients in a sheet, you're most of the way there; the per-client tabs are an afternoon of copy-paste.

Step 2: Sign Up for Love Spreadsheets

Create a free account at lovespreadsheets.com. Building the portals is free; client logins and a custom domain are the paid upgrades — and for portals, the logins are the part worth paying for.

Step 3: Tell the AI What to Build

Select the Website template — portals are really small websites wired to your sheet — and describe what each client should see:

"Each client from my master list gets their own page at a unique URL. On it: their project statuses from their tab, links to their monthly reports, their invoices with paid/unpaid status, and a place to upload files to us. Clients must only ever see their own page."

Worth asking for while you're there:

• Read-only vs editable sections — clients read status, but can upload documents
• Email notifications when something changes on their portal
• Your branding — logo and colors, so it reads as your product, not a tool

Upload the master sheet and run it. The AI Optimize button will sharpen a vague prompt, and after any clarifying questions the build takes about 15–20 minutes.

Step 4: You Have Client Portals

Every client now has their own URL. Hit Share, set the portals to Private, and add each client's username from the master list — passwords are stored hashed, and each login only opens that client's page.

Point a custom domain at it (portal.your-agency.com) and the whole thing feels like software you shipped.

The circle closes on your side too: when a client uploads a file, it lands in their row of your sheet. When you update a status or drop in a new report link, their portal updates. You maintain twelve portals by editing one spreadsheet.

Why One Sheet Beats Portal Software

One edit, every portal. There's no admin panel with twelve configurations. The master sheet is the admin panel, and you already know how to use it.

Client-proof by design. Clients see exactly what their tab exposes — no accidental cross-client leaks, no "why can I see another company's invoice?" emails.

The cost doesn't scale with clients. Portal software prices per seat or per client. A sheet-driven portal costs the same at 12 clients as at 40 — which changes what you can offer smaller accounts.

Common Questions

Can clients mess up my sheet? No. Their pages are read-only except where you allow input, and uploads flow into designated cells — they never touch the sheet itself.

Can we message through it? You can request a messaging area or a chatbot on each portal, and notifications by email when either side updates something.

What about onboarding a new client? Add a row to the master list, duplicate the client tab template, and their portal exists. That's the entire process.

Try It Yourself

If your client tracking already lives in a spreadsheet, you're one prompt away from portals. Head to lovespreadsheets.com, upload the master sheet, and describe what each client should see. The monthly status email can retire this month.