Skip to content
Real Estate Tech

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
  1. How to Build a Rental Listing Google Sheet Your Whole Team Can Trust
  2. 1. One row per unit, one column per fact
  3. 2. Use dropdowns for anything with a fixed set of answers
  4. 3. Make stale rows impossible to miss
  5. 4. Protect the columns people shouldn't edit
  6. 5. Know how to undo a bad edit
  7. 6. Add a five-minute weekly check
  8. Why this matters for texting renters
  9. FAQ
Navy and teal illustration of a rental listing spreadsheet with color-coded status cells.

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
Example conversationScripted
Is this home still available?
Hi, I'm Sarah, an AI assistant. Which address did you see?
Example conversation. Sarah is AI.

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:

  1. Filter Status to "Available." Is every one of those units truly open?
  2. Look for highlighted "Last updated" cells and confirm or fix those rows.
  3. Move anything rented to "Rented" rather than deleting the row, so its history stays.
  4. 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

Shubham Mane

Co-founder, NextGen Fusion AI

Text Sarah now.

Free 2-week supervised pilot.

(844) 681-7964
Scan with your phone camera.

Sarah is AI. Reply STOP anytime.