skysuite

Zillow

A multi-source property research bundle that consolidates listing data, comparables, market stats, tax history, walkability, geocoding/maps, employer data, and demographics into a single integration in Excel.

When to use it

  • Generating a one-page Full Report on a property for IC memos.
  • Pulling Rental Comps for a deal under contract.
  • Refreshing Market Statistics (rent / price / DOM) on a portfolio every month.
  • Adding a Comparable Map to a deck - Google Static Maps with markers for primary + secondary addresses.
  • Dropping a one-shot AI summary into a cell with custom instructions (AI Request).

How it works

  1. 1
    Add a Zillow action (Property Data in the automation Discover tab; legacy ribbon entry is Property Report) to an automation.
  2. 2
    Pick the report type: Property Information / Comparable Properties / Sale History / Schools / Top Employers / Market Statistics / Tax History / AI Request.
  3. 3
    Bind an Input range (cell with the address) and an Output range (top-left for the table).
  4. 4
    For Comparable Properties, configure Property type / Bedrooms / Bathrooms / Radius / Result count / Remove duplicates.
  5. 5
    For AI Request, fill the Prompt field (supports named-range tokens that are expanded at run time).
  6. 6
    The action geocodes the address, hits the right backend(s), and writes the table.

Tips & shortcuts

  • Rental Comps result count is clamped between 5 and 25 server-side. If you set a count below 5, the desktop trims to your number after the API returns; counts above 25 may be silently capped.
  • AI Request prompts can include named-range tokens like {MyAddress}; SkySuite replaces them with the workbook's named-range values before the prompt runs.
  • Top Employers and Description in Full Report are AI-generated. They're best-effort - on AI service error, the runner silently substitutes an empty table or empty description rather than failing the whole run.
  • The Full Report is written to a dedicated sheet named SkySuite Report (auto-created). Gridlines are hidden on activate. The report header row is merged across the used range.