name: property-to-sheets description: | Generate a UK property report and save it to Google Sheets as a formatted spreadsheet. Combines property data (comps, EPC, yield, stamp duty) with Google Sheets integration to produce a shareable, editable investment analysis. Use when someone says "put this in a spreadsheet", "save to Sheets", "I want a property spreadsheet", or needs property data in a format they can share or edit. Requires the Property MCP server and Google Sheets integration (via Strata/BOUCH Integrations MCP).

Property Report to Google Sheets

You generate a UK property investment report and save it directly to Google Sheets as a formatted, structured spreadsheet. The output is a shareable document that an investor, agent, or analyst can edit, annotate, and forward.

When to Use This Skill

• "Put this property analysis in a spreadsheet"
• "Save the report to Google Sheets"
• "I want a property spreadsheet I can share"
• "Create a Sheets report for this postcode"
• "Analyse [address] and put it in Sheets"
• Any property analysis request where the user wants an editable/shareable output

Required Setup

This skill requires two connections:

1. Property MCP server (property-shared) — for property data
2. Google Sheets integration (via Strata) — for creating and writing to spreadsheets

Property tools:

• property_comps — comparable sales with EPC enrichment
• property_epc — energy performance certificate
• rental_analysis — rental market aggregates
• rightmove_search — live listings
• property_yield — yield calculation
• stamp_duty — SDLT calculation

Sheets tools (via Strata):

• google_sheets_create_spreadsheet — create a new spreadsheet with data
• google_sheets_write_to_cell — write to specific cells (for updates)
• google_sheets_list_spreadsheets — check for existing spreadsheets

Workflow

Step 1: Gather Property Data

Follow the same data-gathering workflow as a standard property report:

1. Call property_comps with the postcode (filter by property_type if known)
2. Call property_epc if a street address is available
3. Call rental_analysis with median comp price as purchase_price
4. Call rightmove_search for live rental listings (channel: RENT)
5. Call property_yield for formal yield calculation
6. Call stamp_duty with the asking or median price

Collect all the numbers before creating the spreadsheet.

Step 2: Structure the Spreadsheet Data

Organise the data into a structured layout. The spreadsheet should have these sections:

Row mapping:

• Rows 1-2: Header (title, date, address)
• Rows 4-12: Comparable Sales summary
• Rows 14-22: Rental Analysis
• Rows 24-30: Yield Analysis
• Rows 32-36: Stamp Duty
• Rows 38-44: EPC Data (if available)
• Rows 46-55: Individual Comps (top 10)

Step 3: Create the Spreadsheet

Call google_sheets_create_spreadsheet (via Strata execute_action) with:

• title: "Property Report — [Address/Postcode] — [Date]"
• data: JSON object mapping row numbers to column letters to values

Structure the data parameter as follows:

{
  "1": {"A": "Property Report", "B": "[Address or Postcode]", "C": "[Date]"},
  "2": {"A": ""},
  "3": {"A": "COMPARABLE SALES", "B": "", "C": ""},
  "4": {"A": "Median Price", "B": "[value]", "C": "Source: Land Registry"},
  "5": {"A": "Mean Price", "B": "[value]", "C": ""},
  "6": {"A": "Price per sqft", "B": "[value]", "C": "EPC enriched"},
  "7": {"A": "Transaction Count", "B": "[value]", "C": "Last 24 months"},
  "8": {"A": "Price Range", "B": "[min] - [max]", "C": ""},
  "9": {"A": "Property Type Filter", "B": "[type or All]", "C": ""},
  "10": {"A": ""},
  "11": {"A": "RENTAL ANALYSIS", "B": "", "C": ""},
  "12": {"A": "Median Monthly Rent", "B": "[value]", "C": "Source: Rightmove"},
  "13": {"A": "Rental Listings", "B": "[count]", "C": "Currently on market"},
  "14": {"A": "Rent Range", "B": "[min] - [max]", "C": ""},
  "15": {"A": ""},
  "16": {"A": "YIELD", "B": "", "C": ""},
  "17": {"A": "Gross Yield", "B": "[value]%", "C": ""},
  "18": {"A": "Net Yield", "B": "[value]%", "C": "After service charge"},
  "19": {"A": ""},
  "20": {"A": "STAMP DUTY", "B": "", "C": ""},
  "21": {"A": "Purchase Price", "B": "[value]", "C": ""},
  "22": {"A": "SDLT Total", "B": "[value]", "C": "Additional property rate"},
  "23": {"A": "Effective Rate", "B": "[value]%", "C": ""},
  "24": {"A": ""},
  "25": {"A": "EPC", "B": "", "C": ""},
  "26": {"A": "Rating", "B": "[value]", "C": ""},
  "27": {"A": "Floor Area", "B": "[value] sqm", "C": ""},
  "28": {"A": "Construction Age", "B": "[value]", "C": ""}
}

Step 4: Add Individual Comps

If there are more than 5 comparable sales, add a second section with the top 10 individual transactions. Use google_sheets_write_to_cell to add each row:

• Column A: Address
• Column B: Price
• Column C: Date
• Column D: Property type
• Column E: Price per sqft (if EPC matched)
• Column F: EPC rating (if matched)

Step 5: Share the Link

The google_sheets_create_spreadsheet response includes a spreadsheetUrl. Present this to the user:

"Your property report is ready: [spreadsheet URL]"

If the user also wants an email with the link, offer to draft one via gmail_draft_email (if Gmail integration is available via Strata).

Output Format

In the conversation, present a brief summary alongside the link:

# Property Report: [Address/Postcode]

**Spreadsheet created**: [Google Sheets URL]

## Quick Summary
- Median comp price: £[X] ([N] sales)
- Gross yield: [X]%
- Stamp duty: £[X]
- EPC: [rating]

The full report with individual comps is in the spreadsheet.
[Optional: "Want me to email this to someone?"]

Key Principles

• Spreadsheet first. The whole point of this skill is the Sheets output. Don't produce a long text report — put the data in the spreadsheet and give the user a link.
• Clean structure. Section headers in column A, values in column B, source/notes in column C. Consistent, scannable.
• All numbers, no prose. The spreadsheet should be data, not paragraphs. Save the narrative for the conversation summary.
• Offer the email. Many users want to send the spreadsheet to someone. If Gmail is available, offer to draft it.
• Date everything. Property data decays. Put the date in the title and header so the user knows when the data was pulled.