Tenant Portal from One Google Sheet — Free & AI-Built

The after-hours phone is the tax nobody warns you about when you take on your first building. A text at 11:47 pm about a toilet that won't stop running in 4B. A voicemail at 6:15 am asking whether July's rent "went through okay." An email requesting — for the third time — a copy of a lease you've already sent.

None of these are emergencies. All of them interrupt. Across 40 or 80 doors, a property manager becomes a human answering machine for three questions: what's the status of my repair, did you receive my payment, and can you resend that document. Add owners expecting monthly statements without asking, and most of the job is relaying information that already sits in your rent roll.

Property management platforms will sell you a tenant portal, priced per unit per month, after a data migration you don't have time for. But if your rent roll is a Google Sheet — and for most independent managers it is — you can give every tenant and every owner a private page generated straight from it, and the phone traffic largely stops.

Step 1: Shape the Rent Roll into a Master Sheet

The master tab holds one row per unit:

Then give each unit its own tab: a running log of maintenance requests, a link to the signed lease PDF, and a short payment history. If you manage for owners, add a tab per owner holding links to their monthly statements. The Portal user column becomes each person's login.

Step 2: Create a Free Account

Go to lovespreadsheets.com and register — no charge. Building is free; the paid upgrades are private logins and your own web address — and for anything tenant-facing you'll want the logins.

Step 3: Describe the Portal Like You'd Brief an Assistant

Pick the Website template and write out, in ordinary English, what a tenant should find after signing in:

"Every unit on my master tab gets its own private page. A tenant sees the current status of their rent, can download their lease, and can file a maintenance request — including photos — that gets recorded in their unit's tab. Owners get a different kind of page that lists their monthly statements. No one can view any unit or owner page but their own."

Three things worth requesting explicitly:

• A request form that writes to the sheet — description, urgency, photos of the leak or the damage, all landing as a new line in that unit's tab
• A status tenants can check themselves — received → scheduled → done, so "any update on my repair?" answers itself
• Email in both directions — you're notified when a request arrives; the tenant is notified when its status moves

If the description feels clumsy, the AI Optimize button tightens it, and the AI may come back with a clarifying question or two before it starts. From there the build runs roughly 15–20 minutes.

Step 4: Hand Out the Logins

Each tenant and owner ends up with a distinct URL. Under Share, switch the site to Private and load the usernames from your Portal user column — passwords are hashed rather than kept as readable text, and a login opens only that person's page. Add your logo and colors, and point a domain like residents.corwinproperties.com at it if you want it to look like something you commissioned.

The part that changes your week is the return path. When Marisol files a faucet request at midnight, it's a new row in the 4B tab before you wake up. When you type "scheduled — Thursday AM" next to it, her portal already says so. Rent recorded in the sheet shows as received on her page before she thinks to call.

Why Property Managers Keep the Sheet

The three recurring questions retire. Repair status, rent received, lease copy — every one becomes self-serve, which is most of the after-hours phone traffic gone.

One rent roll drives every page. Forty units doesn't mean forty things to maintain; it means forty rows. Edit the row, and that unit's portal reflects it immediately.

Owners get white-glove treatment for free. Dropping a statement link into an owner's tab once a month gives them a portal that quietly makes you look bigger than you are.

Common Questions from Property Managers

Can a tenant see another unit's information? No. A login is tied to a single row and tab, so 4B can never browse to 5A — and owners can't open tenant pages either.

What happens when a unit turns over? Edit the row: new tenant name, new portal username, updated lease link. The old login stops working, the new one starts, and the unit's history stays in your sheet.

Do maintenance photos really end up in the spreadsheet? Yes — submissions flow back into the unit's tab, photos included, so your maintenance log builds itself without any retyping.

Build Yours

If your rent roll already lives in Google Sheets, the portal is a description away. Open lovespreadsheets.com, upload the sheet, and spell out what a tenant should see when they log in. The 11:47 pm toilet text can become a form submission you read at 8.