How to Build a Rental Listing Google Sheet Your Whole Team Can Trust
TL;DR
- When a renter texts about a unit, the answer is only as good as your listing sheet.
- Here is a simple Google Sheets setup for agents, small brokerages and landlords: one row per unit, dropdowns for status, protected columns and a weekly check.
On this page
- How to Build a Rental Listing Google Sheet Your Whole Team Can Trust
- 1. One row per unit, one column per fact
- 2. Use dropdowns for anything with a fixed set of answers
- 3. Make stale rows impossible to miss
- 4. Protect the columns people shouldn't edit
- 5. Know how to undo a bad edit
- 6. Add a five-minute weekly check
- Why this matters for texting renters
- FAQ

How to Build a Rental Listing Google Sheet Your Whole Team Can Trust
A renter texts, "Is the 2-bed on Kedzie still available?" Whoever answers, a teammate, an assistant or software, opens the same place to check: your listing sheet. If that sheet says "available" for a unit that rented last Tuesday, the renter gets a wrong answer and you get a frustrating follow-up.
Plenty of Chicago agents, small brokerages and landlords already keep listings in Google Sheets. The problem usually isn't the tool. It's that the sheet grew one column at a time with no rules. This guide walks through a setup that keeps it clean, using features documented in Google's own Docs Editors Help pages, linked in each section.
1. One row per unit, one column per fact
Start with a structure that never changes. Each row is one rentable unit. Each column holds one fact, written the same way every time. A practical starting set:
| Column | Example | Why it matters |
|---|---|---|
| Unit ID | KED-2B-2F | A short, unique name everyone uses |
| Address and unit | 1234 N Kedzie, 2F | What the renter sees |
| Neighborhood | Logan Square | Renters often ask by area |
| Bedrooms | 2 | Lets you match a "2-bed" question |
| Bathrooms | 1 | Common second question |
| Rent | 1850 | Numbers only, no "$" or "/mo" |
| Available date | 2026-12-01 | One date format for the whole sheet |
| Status | Available | Controlled by a dropdown (next step) |
| Showing notes | Occupied, 24h notice | What the person booking needs to know |
| Last updated | 2026-11-04 | Tells you if a row has gone stale |
Two rules save the most headaches. Keep numbers as numbers, so "2" bedrooms rather than "two bed," and keep one date format across the whole sheet. Mixed formats are what make a sheet hard to sort, filter or read quickly. They also drop units out of a Finder tab that matches bedrooms, budget and move-in date.
2. Use dropdowns for anything with a fixed set of answers
Status is where most sheets drift: "Avail," "available!!," "pending?," "RENTED." Google Sheets lets you create an in-cell dropdown list using data validation. Set the Status column to a short list, for example:
- Available
- Application pending
- Rented
- Off market
Do the same for neighborhood if your inventory sits in a handful of areas. Dropdowns turn a free-text guess into a choice, and they make filtering by status reliable.
3. Make stale rows impossible to miss
Conditional formatting changes a cell's look based on a rule. Two rules are worth adding:
- Color the Status column. Green for Available, amber for Application pending, gray for Rented. Anyone scanning the sheet sees the real picture in a second.
- Flag old updates. Highlight the "Last updated" cell when the date is more than, say, 7 days old. That row is the one most likely to be wrong.
4. Protect the columns people shouldn't edit
On a shared sheet, someone will eventually overwrite a rent figure or paste over a column. Google Sheets lets you protect a range or a whole sheet so only certain people can edit it, or so editors see a warning first.
A simple split for a small team:
- Protected (owner or listing manager only): Unit ID, address, rent, bedrooms, bathrooms.
- Open to the team: Status, available date, showing notes, last updated.
This keeps the facts that change rarely locked down while still letting the people closest to each unit update what changes often.
5. Know how to undo a bad edit
Mistakes happen. Google Sheets keeps a history of changes, and you can see what changed and who changed it, including restoring an earlier version. Before you rearrange columns or bulk-paste new listings, it's worth naming the current version so you can find it again quickly.
6. Add a five-minute weekly check
A sheet stays accurate because someone looks at it on a schedule, not because the setup is perfect. Pick one time each week and run the same short list:
- Filter Status to "Available." Is every one of those units truly open?
- Look for highlighted "Last updated" cells and confirm or fix those rows.
- Move anything rented to "Rented" rather than deleting the row, so its history stays.
- Check that new units have every column filled in.
If you also manage showings in Google Calendar, our guide to setting up Google Calendar for showings pairs well with this routine.
Why this matters for texting renters
Renters increasingly reach out by text (more on that here), and they expect a straight answer about availability. A clean sheet is what makes a straight answer possible, whether a person answers or an assistant does. It also helps when you're juggling inquiries from several sites at once, which we covered in managing rental inquiries from multiple sites.
This is the setup Sarah AI by NextGen Fusion AI is built around. Sarah is an SMS assistant that replies to property-inquiry texts 24/7, asks your qualifying questions, matches listings from your Google Sheet and books showings on your Google Calendar, with reminders and reschedules handled by text. You can take over any conversation from the dashboard. Setup is free and the first month is $1.
Book a demo of Sarah AI to see it work with your own listing sheet.
FAQ
Should I use one sheet for every property or one per building? For most solo agents and small teams, one sheet with one row per unit is easier to keep current. Add a Building or Owner column if you need to filter.
Should I delete rows when a unit rents? Usually no. Set the status to Rented instead. You keep the history, and the row is ready when the unit turns over.
Who should be allowed to edit rent and unit details? Keep those to the owner or one listing manager by protecting those columns, and let the wider team update status, dates and showing notes.
How often should the sheet be reviewed? At least weekly, plus any time a unit rents or a new one comes on. The "Last updated" column makes stale rows easy to spot.
Related
Text Sarah now.
Free 2-week supervised pilot.
(844) 681-7964Sarah is AI. Reply STOP anytime.
