Apartment Sheets

A light-weight Model Context Protocol (MCP) server that lets Claude (or other platforms) to save and manage apartment listings to a shared Google Sheet.

Background

This project has been inspired by the hectic apartment hunting process we have here in NYC.

Why a Google Sheet?

1. Google provides a generous API service
2. There's no easier medium to share your apartment search with your roommate(s)/partner(s)

Notes

Because this is a MCP, use the AI platform of your choice to handle the web scraping, listing update, and more. All this MCP does is give your AI tool of choice the connectivity to your respective sheet

Tools Available

• save_listing : adds a new listing to your sheet
• get_listing : fetches all listings, with optional filters (Neighborhod and Status today)
• update_listing : update any field on an existing listing
• delete_listing : remove a listing from the sheet

Setup

*you have to clone this repo, duh!

1. Google Cloud Credentials

• Create a service account in Google Cloud Console
• Enable Google Sheets and Google Drive APIs
• Download the credentials JSON and save as credentials.json (place in root of project)
• Share your Google Sheet with the service account email as Editor

2. Install dependencies

python3 -m venv venv
source venv/bin/activate
pip install -r requirements.txt

3. Configure Claude desktop

Add to ~/Library/Application Support/Claude/claude_desktop_config.json:

{
  "mcpServers": {
    "nyc-apartment-tracker": {
      "command": "/path/to/venv/bin/python",
      "args": ["/path/to/server.py"],
      "cwd": "/path/to/nyc-apartment-mcp"
    }
  }
}

Environment variables

Variable	Default	Description
SHEET_NAME	NYC Apartment Listings	Name of your Google Sheet

Security Note

If you plan on pushing to git please mae sure to never commmit credentials.json!