How to Create a Property Management Dashboard in Google Sheets with ChatGPT

Building a property management dashboard can feel like a heavy lift, but with Google Sheets and a little help from ChatGPT, you can create a powerful command center to track your rental income, expenses, and tenant information. This guide will walk you through exactly how to set up your spreadsheet, what to ask ChatGPT, and how to combine everything into a single, easy-to-read dashboard.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Why Use Google Sheets for Property Management?

Before jumping into complex software, starting with Google Sheets is a smart, practical choice. It's completely free, accessible from any device, and built for collaboration. You can easily share it with a business partner, accountant, or virtual assistant without worrying about expensive licenses or software compatibility.

While dedicated property management software has its place, a well-built Google Sheet gives you something incredibly valuable: full control. You decide exactly which metrics matter to you, how they are calculated, and how they are displayed. It's a bespoke solution perfectly tailored to your portfolio, whether you have one rental property or twenty.

Step 1: Plan Your Dashboard and Structure Your Data

The secret to a useful dashboard isn't complicated formulas, it's clean, organized data. Before you write a single formula or prompt, you need a solid foundation. The best way to do this is to create separate tabs in your Google Sheet for each category of information. This prevents your spreadsheet from becoming a messy, unworkable file.

Start by creating these four essential tabs:

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Properties Tab

This is a master list of your rental units. It won't change often, but it's crucial for tying all your other data together.

• Property / Unit Address (e.g., 123 Main St, Apt 4B)
• Property Type (e.g., Single-Family, Duplex, Apartment)
• Bedrooms
• Bathrooms
• Square Feet
• Monthly Rent Amount

Income Tab

Here you'll log every payment you receive. Keeping this detailed makes financial tracking much easier.

• Date Received
• Property Address (use a dropdown from your Properties tab for consistency)
• Payer Name
• Amount Received
• Payment Type (e.g., Rent, Late Fee, Security Deposit)
• Notes

Expenses Tab

Just like with income, every dollar you spend needs to be tracked. Be specific with your expense categories.

• Date Paid
• Property Address
• Expense Category (e.g., Repairs, Utilities, Mortgage, Property Taxes, Insurance)
• Vendor/Payee
• Amount Paid
• Notes

Tenants & Leases Tab

This sheet tracks the human side of your operation: who is in your properties and the status of their leases.

• Property Address
• Tenant Name
• Tenant Phone
• Tenant Email
• Lease Start Date
• Lease End Date
• Security Deposit Amount
• Status (e.g., Active, Expired, Notice Given)

Step 2: Use ChatGPT to Generate Your Google Sheets Formulas

With your data neatly organized, this is where the fun begins. ChatGPT can act as your personal data analyst, writing the exact formulas you need to summarize all that information. The key is to write clear and specific prompts.

A good prompt for ChatGPT includes:

• The Goal: What do you want to calculate? (e.g., "Total rent received for January")
• The Google Sheet Tab: Where is the data? (e.g., "...on a tab named 'Income'")
• The Columns: Which columns should the formula look at? (e.g., "...where Column A has the dates and Column D has the amounts.")

Let's walk through a few practical examples.

Example 1: Calculate Total Monthly Income

On a new "Dashboard" tab, you want to see your total income for the current month. Your detailed income logs are on the 'Income' tab.

Your Prompt to ChatGPT:

I have a Google Sheet with a tab named 'Income'. The payment date is in column A and the payment amount is in column D. Give me a formula that sums all income 'Amount Received' in column D for the current month.

ChatGPT's Likely Response:

`=SUMIFS(Income!D:D, Income!A:A, ">="&EOMONTH(TODAY(),-1)+1, Income!A:A, "<="&EOMONTH(TODAY(),0))`

Simply copy this formula and paste it into a cell on your Dashboard. It automatically finds the first and last day of the current month and adds up all the corresponding payments from your Income tab.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Example 2: Summarize Expenses by Category

Seeing a high-level view of your spending is critical. You want to see how much you've spent on 'Repairs' vs. 'Utilities' vs. 'Mortgage' this year.

Your Prompt to ChatGPT:

I'm keeping my expenses in a Google Sheet on the 'Expenses' tab. The expense categories are in column C and the amounts are in column E. On my dashboard, I have a list of categories starting in cell A2 (A2=Repairs, A3=Utilities, etc.). Give me a formula I can put in cell B2 that will sum the total expenses for the category listed in cell A2.

ChatGPT's Likely Response:

`=SUMIF(Expenses!C:C, A2, Expenses!E:E)`

Now, paste that formula into cell B2 on your dashboard. You can drag the corner of the cell down, and it will automatically adjust to calculate the total for each of your expense categories - no manual retyping needed.

Example 3: Flag Leases Expiring Soon

Staying on top of lease renewals is crucial for minimizing vacancies. You want a formula that flags any leases ending in the next 60 days.

Your Prompt to ChatGPT:

In my 'Tenants & Leases' tab, lease end dates are in column F. I want a formula that checks the date in F2. If the date is between today and 60 days from now, it should return the text 'Renewal Due'. Otherwise, it should be blank.

ChatGPT's Likely Response:

`=IF(AND(F2>=TODAY(), F2<=TODAY()+60), "Renewal Due", "")`

You can paste this into a new column on your 'Tenants & Leases' tab. Now you can instantly see which tenants you need to contact about renewing their lease.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step 3: Build Your Visual Dashboard

Your "Dashboard" tab is where everything comes together. Its purpose is to show you the most important metrics at a glance, without forcing you to dig through rows of raw data. It should combine the key numbers you've calculated and the charts that visualize your trends.

Designing the Layout

Think about what you need to know on a daily or weekly basis. A good layout might look something like this:

1. Top Level KPIs: Create a section at the top for your most important numbers: Current Month's Income, Current Month's Expenses, and Net Operating Income. Use the formulas you generated with ChatGPT here.
2. Occupancy Snapshot: Include numbers like 'Total Active Leases' and 'Units Vacant'. You can use a COUNTIF formula for this. Just ask ChatGPT: "Count the total number of cells in the 'Tenants & Leases' tab in column H that say 'Active'."
3. Visualizations: Charts convert numbers into quick insights. You'll want to chart your data summaries, not the raw transaction logs.
4. Actionable Lists: Embed important lists directly onto your dashboard. For example, use the FILTER or QUERY function to pull a list of tenants whose leases are expiring soon right onto the main dashboard. A prompt could be: "Give me a QUERY formula that pulls the Tenant Name (column B) and Lease End Date (column F) from the 'Tenants & Leases' if the renewal status in Column I says 'Renewal Due'."

Spend some time making your dashboard clean and easy to read. Use larger fonts for key metrics, add cell borders to organize sections, and use colors intentionally to highlight important information like negative cash flow or upcoming deadlines.

Final Thoughts

Building a property management dashboard in Google Sheets with the help of ChatGPT is a fantastic way to gain clarity and control over your portfolio finances without a steep learning curve or high cost. By keeping your data organized and writing clear prompts, you can turn a simple spreadsheet into a powerful analytical tool.

Eventually, as your portfolio grows, you may find that managing and connecting all that data in a spreadsheet becomes a daily time-sink. That's actually why we built Graphed. We connect directly to your data sources - like QuickBooks for your financials or other platforms - and let you build automated, real-time dashboards just by asking questions in plain English. Instead of manually updating your Google Sheet, you can ask, "Show me a chart of income versus expenses by property for the last quarter," and get an always-on, live-updating dashboard instantly.