Love Spreadsheets
PricingContactAPI
Log inSign up free
Tutorials

Client Portal for Freelancers: Free from a Google Sheet

Love SpreadsheetsPublished Jul 21, 20265 min read

Freelancing has a scale illusion problem, and it cuts the wrong way. Agencies with mediocre work win projects because their onboarding email includes a portal login; solo operators doing better work send a Google Drive folder and hope. Clients notice the difference before they've seen a single deliverable.

The day-to-day tax is worse. "Quick status?" texts on a Tuesday night. The preview link you sent twice already, requested a third time. Feedback dribbling in across email, WhatsApp, and one memorable voicemail. And invoice #12, unpaid for five weeks, invisible to a client who genuinely forgot it exists — because nothing they look at ever shows it.

Here's the part nobody tells solo freelancers: the portal that fixes all of this doesn't require an agency budget or a developer. If you track projects in a spreadsheet — and you do — AI can turn that exact spreadsheet into a login-protected page for every client on it.

Step 1: The Project Sheet Does the Heavy Lifting

Structure one workbook: a top sheet listing every client, then a tab per client where their files and feedback will collect. The top sheet wants these eight fields:

Sheet columnFilled in
ClientAda's Bakehouse
ProjectWebsite redesign
StageRevisions
Preview linkstaging.adasbakehouse.com
Feedback dueJul 25
Invoice#12 — $2,400
Paid?No
Portal userada-bakehouse

Keep Stage to a handful of words a non-designer understands — Brief, First draft, Revisions, Final delivery — because those words are about to become a progress bar.

Step 2: Grab a Free Account

Sign up at lovespreadsheets.com — the build itself is free, which matters when you're a business of one. Client logins and a custom domain are paid add-ons; the logins are the piece that makes it a portal instead of a public page, so treat that as the real price tag.

lovespreadsheets.com
Describe what you want to build from your spreadsheet…
client_projects.xlsxSend →
Your free account, your sheet attached — client_projects.xlsx stays the source of truth.

Step 3: Say What Each Client Should See

Select the Website template and describe it the way you'd explain it to a client over coffee:

"Everyone on my client list gets their own private page: which stage their project is in, the live preview link, when I need their feedback by, and their invoice with whether it's been paid. They should also have a spot to drop feedback and files for me. One client, one page — nobody sees anyone else's project."

Three asks that pull real weight for a freelancer:

  • A feedback drop-box on every project — screenshots, marked-up PDFs, voice memos; whatever the client submits routes into their tab instead of your seventh inbox
  • A stage progress bar — Brief through Final delivery rendered visually, so "where are we?" is answered by a glance instead of a text
  • Invoices that stay visible — the unpaid line sits on the same page as the shiny preview link, doing the awkward reminding so you never have to

Upload the workbook and run the build — hit AI Optimize if your description feels rough, field the odd clarifying question, and give it 15–20 minutes.

lovespreadsheets.com
"Give everyone on my client list their own private page: project stage, live preview link, feedback due date, invoice paid status, and a spot to drop files for me."
client_projects.xlsx✦ AI OptimizeSend →
Plain English is the whole interface — AI Optimize tightens the wording if it needs it.
lovespreadsheets.com
Building your client portals
Reading your columns
Designing the app
·Wiring two-way sync
The AI builds while you watch (or play) — typically 15–20 minutes.

Step 4: One Person, Agency-Grade Client Experience

Each client gets a unique URL. Under Share, set it Private and enter the usernames from your sheet; passwords are hashed, and logging in reveals only that client's page. Your logo and colors go on top, and clients.yourstudio.com finishes the impression — no one looking at it can tell it wasn't built by a five-person ops team.

The loop runs itself after that. Client drops feedback in the box: it appears in their tab. You flip Stage to Final delivery or mark the invoice paid in the sheet: their page updates the moment you do. Your tools didn't change — your clients' view of you did.

lovespreadsheets.com
clients.inkwellstudio.co/adaCopy link
Private — team logins only+ Add team memberCustom domain: Connect
One link for the whole team — private logins and your own domain are the paid extras.
What you end up with
clients.inkwellstudio.co/ada
Project PortalLive appLogged in: Ada's Bakehouse
Website redesign
StageRevisions
Previewstaging site
Feedback
Round 2 notes dueJul 25
Homepage copy v2Uploaded
Payment
Invoice #12 — $2,400Unpaid
No more "any update?" emails — the client checks the stage, the preview link, and the unpaid invoice themselves.

Why Freelancers Keep the Sheet

You look like a studio without hiring one. A private branded portal in the kickoff email repositions you before the first deliverable — and repositioning is what rate increases are made of.

Visible invoices get paid faster. An unpaid invoice buried in email is easy to forget; one sitting next to the preview link every time the client checks progress is not. Passive persistence beats awkward reminder emails.

Overhead stays at zero. No client-management suite subscription, no separate tool to update at midnight. You edit the one spreadsheet you were editing anyway, and every portal follows.

Common Questions from Freelancers

I only have four clients — is this overkill? Four clients means four chances to look established, and the sheet takes an evening to set up. The portal earns its keep at any roster size because the cost doesn't grow with it.

What if a client ignores the portal and texts me anyway? Reply with their link. After two or three redirects, checking the page becomes the habit — especially once their feedback deadline and preview live there.

Can I run different project types through one sheet? Yes. A logo sprint, a website build, and a monthly retainer are just rows with different Stage words; each client's page renders whatever their row and tab contain.

Build Yours

You already maintain the spreadsheet; the upgrade is one prompt away. Go to lovespreadsheets.com, upload your project sheet, and describe the page each client deserves. By next week, "quick status?" can be a question your portal answers while you're asleep.

Skip the manual steps — build this in 60 seconds
Upload the sheet you already have and let AI turn it into a working app.
Try it free
More versions of this guide
Written by
Love Spreadsheets

The team turning other people's spreadsheets into software they actually trust — one sheet at a time.

Keep reading

Tutorials

Tax Calculator Lead Generation for Accountants

Jul 22, 20265 min read
Tutorials

Contractor Estimate Calculator That Wins You Leads

Jul 22, 20264 min read
Tutorials

Macro Calculator for Coaches: Grow Your List, Not Ads

Jul 22, 20264 min read

Your spreadsheet is already an app. Let's turn it on.

Upload your sheet and watch it become a working app — with a real engineer to finish the last mile with you.