Zillow to Google Sheets, deals ranked and emailed
You find a listing that looks promising, then lose 30 minutes bouncing between tabs just to answer one question: “Is this actually a deal?” That back-and-forth gets old fast, and it’s where mistakes sneak in.
Real estate investors feel it most, honestly. But agents running quick screens and small teams managing multiple markets run into the same problem. This Zillow deal finder automation gives you a daily shortlist with the investing numbers already calculated.
In this guide, you’ll see how the workflow pulls new Zillow listings, calculates ROI-style metrics, logs everything to Google Sheets, and emails you a clean summary every morning.
How This Automation Works
Here’s the complete workflow you’ll be setting up:
n8n Workflow Template: Zillow to Google Sheets, deals ranked and emailed
flowchart LR
subgraph sg0["9am Flow"]
direction LR
n0@{ icon: "mdi:play-circle", form: "rounded", label: "9am Trigger", pos: "b", h: 48 }
n1@{ icon: "mdi:swap-vertical", form: "rounded", label: "Set Parameters", pos: "b", h: 48 }
n2["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/httprequest.dark.svg' width='40' height='40' /></div><br/>Zillow Search"]
n3@{ icon: "mdi:swap-vertical", form: "rounded", label: "Split Out", pos: "b", h: 48 }
n4["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/httprequest.dark.svg' width='40' height='40' /></div><br/>RentZestimate"]
n5@{ icon: "mdi:database", form: "rounded", label: "Google Sheets", pos: "b", h: 48 }
n6@{ icon: "mdi:message-outline", form: "rounded", label: "Gmail", pos: "b", h: 48 }
n7["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Investment Calculator"]
n3 --> n4
n0 --> n1
n5 --> n6
n4 --> n7
n2 --> n3
n1 --> n2
n7 --> n5
end
%% Styling
classDef trigger fill:#e8f5e9,stroke:#388e3c,stroke-width:2px
classDef ai fill:#e3f2fd,stroke:#1976d2,stroke-width:2px
classDef aiModel fill:#e8eaf6,stroke:#3f51b5,stroke-width:2px
classDef decision fill:#fff8e1,stroke:#f9a825,stroke-width:2px
classDef database fill:#fce4ec,stroke:#c2185b,stroke-width:2px
classDef api fill:#fff3e0,stroke:#e65100,stroke-width:2px
classDef code fill:#f3e5f5,stroke:#7b1fa2,stroke-width:2px
classDef disabled stroke-dasharray: 5 5,opacity: 0.5
class n0 trigger
class n5 database
class n2,n4 api
class n7 code
classDef customIcon fill:none,stroke:none
class n2,n4,n7 customIcon
Why This Matters: Deal analysis is slower than deal flow
Most people don’t struggle to find listings. The struggle is turning “new listing” into “yes/no” without burning your morning. You open Zillow, copy an address, hunt for rent estimates, then switch to a spreadsheet to run your numbers. Later, you realize you used the wrong down payment, or you forgot to account for vacancy, or the rent estimate was from a different property type. It’s not hard work. It’s repetitive work, and it makes you slower than the market.
The friction compounds. Here’s where it breaks down in real life.
- Manually reviewing 15–30 listings can easily eat about 2 hours, and that’s before you run any serious numbers.
- Rent estimates and listing data end up scattered across tabs, which makes it easy to compare the wrong figures.
- Your spreadsheet gets inconsistent because each “quick check” uses slightly different assumptions.
- By the time you’ve narrowed down a shortlist, the best opportunities are already getting offers.
What You’ll Build: A daily Zillow-to-Sheets deal scorer with email alerts
This workflow runs on a schedule (every morning at 9AM) and does the first pass of deal analysis for you. It starts by applying the search settings you define, like location, bed/bath minimums, price limits, and property type. Then it pulls fresh listings from the Zillow API, breaks them into individual properties, and fetches a rent estimate for each one. After that, it calculates investing metrics automatically, including down payment, cash-on-cash ROI, monthly cash flow, and common expense assumptions like maintenance and vacancy loss. Finally, it writes the results into a Google Sheet and sends you a Gmail summary so you can scan a ranked shortlist and move.
The workflow starts with your saved criteria and a scheduled trigger. Zillow listing data comes in, rent estimates get appended, and a calculation step turns raw numbers into decision-friendly metrics. The output lands in Google Sheets, then Gmail delivers the digest to you.
What You’re Building
| What Gets Automated | What You’ll Achieve |
|---|---|
|
|
Expected Results
Say your search returns 20 new listings in the morning. Manually, you might spend about 5 minutes per listing to pull details, check a rent estimate, and plug numbers into a spreadsheet, which is roughly 100 minutes. With this workflow, you spend a few minutes setting your criteria once, then each morning you simply open the email and scan the ranked sheet in about 10 minutes. That’s around 90 minutes back on any day your market is active.
Before You Start
- n8n instance (try n8n Cloud free)
- Self-hosting option if you prefer (Hostinger works well)
- Google Sheets for storing listings and metrics.
- Gmail to email the daily summary to you.
- RapidAPI Zillow API key (get it from your RapidAPI dashboard)
Skill level: Intermediate. You’ll connect accounts, map Sheet columns, and tweak a few assumptions in the metrics step.
Want someone to build this for you? Talk to an automation expert (free 15-minute consultation).
Step by Step
A scheduled morning run at 9AM. The workflow starts automatically, so you don’t have to remember to “check Zillow” before the day gets away from you.
Your search criteria gets applied. In n8n, you define key-value settings like location, minimum beds/baths, price bounds, and property type. Those settings are passed into the listing request so results match your buy box.
Listings are pulled and enriched. The Zillow API returns properties, then the workflow splits them into individual items and fetches a rent estimate for each one before calculations start.
Metrics are computed, saved, and emailed. A calculation step turns listing price and rent into down payment, monthly cash flow, and cash-on-cash ROI, then Google Sheets stores the rows and Gmail sends the digest.
You can easily modify the search settings to focus on a new city, zip code, or price band based on your needs. See the full implementation guide below for customization options.
Step-by-Step Implementation Guide
Step 1: Configure the Schedule Trigger
Set the workflow to run on a morning schedule so it can fetch new real estate listings daily.
- Add and open Morning Schedule Trigger.
- Configure the schedule to your preferred morning time (for example, daily at 7:00 AM).
- Connect Morning Schedule Trigger to Assign Search Settings.
Step 2: Connect Your Property Search Inputs
Define your search criteria and request property listings from your data source.
- Open Assign Search Settings and add fields for your search parameters (e.g., city, price range, property type).
- Open Property Listings Request and set the HTTP Method, URL, and any required headers or query parameters to call your listings API.
- Connect Assign Search Settings → Property Listings Request.
Step 3: Set Up Listing Processing and Deal Metrics
Split the returned listings into individual items, fetch rent estimates, and compute investment metrics.
- Open Distribute Items and ensure it splits each listing into a separate item.
- Open Fetch Rent Estimate and set the URL and parameters for your rent estimation API.
- Open Compute Deal Metrics and add code to calculate metrics such as cash flow, cap rate, or ROI.
- Confirm the execution flow: Property Listings Request → Distribute Items → Fetch Rent Estimate → Compute Deal Metrics.
Step 4: Configure Spreadsheet and Email Outputs
Write the computed metrics to a spreadsheet and send email alerts for promising deals.
- Open Update Spreadsheet and select the target spreadsheet and sheet for storing results.
- Credential Required: Connect your Google Sheets credentials.
- Open Send Email Alert and configure the To, Subject, and Body to include key deal metrics.
- Credential Required: Connect your Gmail credentials.
- Confirm the output flow: Compute Deal Metrics → Update Spreadsheet → Send Email Alert.
Step 5: Test and Activate Your Workflow
Validate the end-to-end flow before turning the automation on.
- Click Execute Workflow and verify that Property Listings Request returns items and Distribute Items splits them.
- Check that Fetch Rent Estimate returns data and Compute Deal Metrics produces expected fields.
- Confirm Update Spreadsheet writes a new row and Send Email Alert sends an email.
- When successful, toggle the workflow to Active for daily execution.
Troubleshooting Tips
- RapidAPI (Zillow API) credentials can expire or hit request limits. If the listing pull fails, check your RapidAPI dashboard usage and key status first.
- If you’re using external data calls for rent estimates, processing times vary. Bump up any wait/retry behavior (or add it) if downstream steps run before the rent response arrives.
- Google Sheets issues are usually column mapping. Confirm your sheet has the expected headers (Address, Price, Rent Zestimate, Cash on Cash ROI, Monthly Cash Flow, Down PMT) and that n8n is writing to the right tab.
Quick Answers
About 30 minutes if your accounts and sheet are ready.
No. You’ll connect credentials, map your Google Sheet columns, and adjust a few numbers in the existing calculation step.
Yes. n8n has a free self-hosted option and a free trial on n8n Cloud. Cloud plans start at $20/month for higher volume. You’ll also need to factor in RapidAPI Zillow usage fees, which depend on your request volume.
Two options: n8n Cloud (managed, easiest setup) or self-hosting on a VPS. For self-hosting, Hostinger VPS is affordable and handles n8n well. Self-hosting gives you unlimited executions but requires basic server management.
Yes, and it’s the whole point. You can change the “Assign Search Settings” step to target a new city, zip code, or property type, then keep the rest of the workflow intact. If you prefer a different rent source, swap the “Fetch Rent Estimate” request to another endpoint and keep the same output mapping. People also customize the “Compute Deal Metrics” step to use a different down payment assumption, add HOA, or tighten vacancy and maintenance rules.
Usually it’s an invalid or expired RapidAPI key, or you’ve hit the endpoint’s request limit for the day. Confirm the key in n8n matches the one in RapidAPI, then check usage and plan limits. If it only fails some mornings, it can also be a rate-limiting issue when the workflow pulls many listings at once.
It depends more on your API limits than on n8n. On n8n Cloud you can run this daily without issue for typical “one search, a few dozen listings” volume, and self-hosting removes execution caps entirely. Practically, most people keep it to tens of listings per run so the rent-estimate lookups stay fast and inexpensive.
Often, yes. This workflow mixes scheduled triggers, multi-step HTTP requests, splitting items, and a calculation step, and that’s where n8n tends to be more flexible. You can also self-host, which matters when you want daily runs without worrying about task pricing. Zapier and Make are fine for simpler “new row, send message” flows, but this is closer to a mini data pipeline. If you want help choosing, Talk to an automation expert and explain your deal volume and markets.
Once this is running, your mornings get simpler. The workflow handles the repetitive math and logging so you can focus on the handful of listings worth calling on.
Need Help Setting This Up?
Our automation experts can build and customize this workflow for your specific needs. Free 15-minute consultation—no commitment required.
