AI Agent Workflow Collection

Normalize a contributed comp set a Lee broker pastes, forwards, or uploads (a forwarded email with several brokerage comp tables, an xlsx/csv export, a pasted tab/pipe table, or a screenshot) into canonical AddCompRow records ready for ingestion via the leecompsaddwrite MCP tool. parseemail extracts the comp tables from a forwarded email body, attaches the contributing source (JLL, Foundry, etc.) to each row, and skips signature / confidentiality decoy tables. parsespreadsheet reads an xlsx or csv, picks the comp-shaped sheet(s) and skips prose/view tabs, and raises AmbiguousSheetError when more than one comp sheet is present so the operator can choose. parsetext parses a pasted tab- or pipe-delimited table. parseimage and llmfallback extract rows via an injected model-vision callable (the skill's own Claude runtime) for screenshots or blobs the deterministic parsers can't handle. detecttransactiontype decides lease vs. sale from the column headers. applyaliasmap folds contributor headers into the canonical keys, coerces numerics (strips $ , %), preserves the verbatim Transaction Type as txnsubtype, and keeps any unmapped columns in rawfieldsjson. validaterow flags (never drops) rows missing the minimum keys. dryrunsummary reports total + per-source counts + flagged rows for operator review, and buildwritepayload assembles the exact AddCompsPayload (with parserversion) for the leecompsaddwrite MCP tool — the MCP write itself is the model's job.

Pull a Lee-branded BAO-style Business Key Facts PDF (3-page landscape) for any NC address. Returns key statistics, households table, site map with 1/3/5 mile rings, education attainment + workforce charts, and population/housing growth with backward-rate context. Wraps the lee-raleigh-mcp pullbusinesskeyfacts tool.

Put your comps on a Lee-branded Google map for any NC listing. Deal mode — give it a subject address and it maps the comps around it (numbered pins, distance rings, and a matching numbered comp table) for a flyer / OM / BOV. Database mode — maps the whole internal comp set, filterable, or a broker's own deal history ("map every deal my team closed in this market"). Returns a shareable interactive map link (Lee-branded Google map, ~30-day link a broker can forward to a client), a print-ready static PNG, and a numbered csm- comp-table fragment. Answers "map the comps around [address]", "show the comps near my listing", "map of all our comps", "map my deal history for the pitch". Wraps the lee-raleigh-mcp pullcompmap tool.

Pull a CoStar comp set (sale or lease) for a Lee Raleigh broker, applying behavioral rules from the SOP. Drives CoStar via the Claude in Chrome extension. Use when the broker says 'pull comps,' 'comp pull,' 'CoStar comps,' or asks for sale/lease comparables in any market. Owns the kickoff rules (7-10 sweet spot, terminology check-in, narrow/loosen pattern), the cached DOM maps for both Sale Comps and Lease Activity pages, and the anti-pattern list that keeps the run from chasing dead ends.

Pull a multi-page Lee-branded Demographic and Income Profile for any NC address (~18 pages, content-driven via paged.js). Returns 1/3/5-mile rings with population/households/income/age/race breakdowns, four Esri-analog indices (Diversity, Median Net Worth, Wealth, Housing Affordability), 2020/2025/2030 projections via gipermitadjusted (Census BPS-aware) with giblended fallback, trend comparisons against State + US (Population, Households, Family HHs, Owner HUs), inline SVG charts per ring, plus a Lee-branded PDF (1-hour signed URL). Wraps the lee-raleigh-mcp pulldemographicdetail tool.

Pull a 1/3/5-mile demographic summary (single-page Lee infographic) for any NC address. Returns population, households, income, education, workforce mix, daytime population, and growth rates with per-metric methodology metadata, plus a Lee-branded PDF link (1-hour signed URL). Wraps the lee-raleigh-mcp pulldemographicsummary tool.

Map how far you can get from a property in 5, 10, and 15 minutes by car (or on foot / by bike) for any NC address. Use when a broker asks "what's within a 10-minute drive", wants a drive-time map for a flyer, OM, or BOV, wants trade-area reach instead of crude mile rings, or asks for drive-time isochrones. Returns per-band reach areas, isochrone GeoJSON, and a Lee-branded map card PDF. Wraps the lee-raleigh-mcp pulldrivetimeisochrones tool.

Pull external (CoStar) lease or sale comps for a Lee & Associates broker. Broker pastes a free-form comp request into chat; skill parses, calls the typed external-comps MCP tools (searchexternalsalecomps / searchexternalleasecomps / getexternalcompdetail), and produces a Markdown table in chat plus an Excel deliverable and draft email reply. PDF deferred to v1.1.

The DEFAULT comps skill for Lee & Associates — pull a unified "all comps" set covering BOTH internal Dealius AND external CoStar in one deliverable. Use whenever a broker asks for comps WITHOUT specifying internal or external (e.g. "pull industrial sale comps in Garner, 2yr", "any retail comps in Raleigh past year"). Runs both queries in parallel, normalizes both sources into one table tagged by Source (Internal — Dealius / External — CoStar), and produces one combined chat table, one Excel (an "All Comps" sheet plus per-source detail sheets), and one Lee-branded combined PDF. Keeps both rows when a property appears in both sources (no dedup). Handles sale and lease. Only defer to the separate internal-comps / external-comps skills when the broker explicitly asks for internal-only or external-only.

Pull internal lease comps from the Dealius mirror for Lee & Associates brokers. Broker pastes a free-form comp request into chat; skill parses, queries the leasecompssafe MCP, and produces a formatted Excel deliverable plus a draft email reply. Confidentiality enforced server-side. Always Excel — no email-summary branch.

Show the labor force around a commercial site sliced by industry, for any NC address. Returns the resident labor pool a tenant can recruit (LEHD LODES residence data) and the existing employer mix already in the area (LODES workplace data) for 1/3/5-mile rings, with the industrial-family workforce (manufacturing, wholesale, transportation & warehousing, construction) called out. Wraps the lee-raleigh-mcp pulllaborshed tool.

Make anything you're building for a Lee & Associates broker look on-brand — apply the Lee logo, the brand red, and the Avenir Next fonts to a flyer, one-pager, deck, chart, PDF, or email header right here in the chat. Use when a broker says "make me a PDF of this and make it look good," "brand this," "make this on-brand for Lee," "add the Lee logo," "use our brand colors," or is riffing on a deliverable and wants it polished to the Lee look. Ships Lee's official brand package on disk (logo, colors, guidelines, fonts) so you apply it without asking the broker for files. Also covers the one-time Claude Design setup for the marketing team.

Walks Will through yesterday's broker requests one-by-one — both plugin sessions AND off-plugin asks. For each, captures completion outcome, broker request source, and (for off-plugin asks) why the plugin wasn't used (pluginbroke / knowngap / newopportunity). Writes back to lee-raleigh-mcp; feeds the Friday rollup. Run daily.

Start a marketing flyer for a listing. Guided intake that pulls comps, demographics, and business key facts for a property, lets the broker add their own comps and choose exactly which data makes the flyer, then produces a flyer brief ready for Claude Design polish. Use when a broker says "build a flyer", "start a marketing flyer for an address", "make a one-pager for my listing", or wants to assemble listing marketing materials.

Answers "what tenants are in the market?" — searches the shared Lee Raleigh tenant-requirements pool for active tenant requirements matching an asset type, size, or location, and returns each match with the originating broker's contact so you can pair a listing. Size can be a single target SF (matched as a tolerance band, e.g. a 10,000 SF space pulls ~7,000-14,000 SF requirements) or an explicit min/max window. Location can be a city OR a county name that rolls up to its cities ("Wake County" matches Raleigh, Cary, Apex, Morrisville, Wake Forest, Garner, Fuquay-Varina...), and a tenant listed in several cities matches a search for any one of them. Use when a broker asks who is looking for space ("what tenants are in the market for 5-10k SF industrial in Garner?", "anyone seeking retail in Cary?", "tenants in Wake County?", "who's looking for land near Apex?"). Read-only; queries pulltenantsinmarket on lee-raleigh-mcp. Requirements are sourced from Triangle Pairlist broker blasts, ingested continuously since June 2026.

Ingests Triangle Pairlist tenant-requirement emails. On a schedule, reads the running user's inbox for [Triangle Pairlist] messages, screens each as a tenant requirement (a broker seeking space/investment) vs a listing (a broker marketing a property), extracts the requirement fields, and writes every screened email to the shared tenant-requirements store via leetenantrequirementwrite. Screens from small per-message extracts (never full threads) and processes strictly sequentially with write-as-you-go, so a run completes in one session for the rolling 2-day Pairlist corpus. Run on a Cowork Scheduled Task (any cadence from hourly to daily converges; each run drains the rolling 2-day window), pinned to Haiku. Reading uses the Gmail connector; writing uses lee-raleigh-mcp.

Area Amenities map kit for any NC address — the recognizable businesses (grocery, retail, restaurants, coffee, gyms, pharmacies, hotels, healthcare) near a listing, ranked by prominence with their brand logos, laid out on a basemap. Returns a downloadable designer kit (basemap + logo images + a placements manifest) the marketing team drops into Claude Design to compose the flyer's amenities map. Answers "what's around this site", "nearby businesses / amenities near [address]", "map the retail around [address]" for a flyer / OM / BOV. Wraps the lee-raleigh-mcp pullnearbybusinesses tool.

Look up the owner of record and owner mailing address for a US property address in the counties covered by the owner-graph bulk ingest (Wake, Durham, New Hanover, and Lee — NC). Returns the parcel's assessor record (owner name, mailing address, year built, lot size, building SF, assessed value, last sale, zoning, jurisdiction). Wraps the lee-raleigh-mcp ownerlookup tool.

Produce a deduplicated owner + mailing-address list for a Lee & Associates broker from county parcel data. Given an area + criteria request (subject address + radius + property type/land class + acreage or size), calls the lee-raleigh connector's pullownermailinglist tool against the statewide NC OneMap parcel mirror and returns a clean CSV of owner names + mailing addresses + site addresses in seconds, deduplicated by mailing address and filtered to private owners (drops government/exempt/HOA/cemetery parcels). Use for any "owners of within of " / "mailing list for " / "who owns the vacant land near " request. Covers Wake, Durham, New Hanover, Lee, Orange, Johnston, and Chatham counties (NC); coverage grows by county. v1 returns the CSV; Avery labels are a separate skill (gi-plugins 38).

Pull the full county property record for a US property address in the covered NC counties (Wake, Durham, New Hanover, Lee, Johnston, Orange, Chatham) — owner of record + mailing address, parcel ID (PIN), lot size, building SF, year built, tax assessed value, last sale date/price, zoning code with ordinance link, and building permits from the last 5 years. Returns the record inline, a flyer-ready Property Facts fragment, and a Lee-branded PDF card. Use for "what is this property," "property record card," "zoning for," "permits at," or pre-tour/pre-call homework on an address. Wraps the lee-raleigh-mcp pullparcellookup tool.

Map a process you run into a clean, linear, text-only process document — before any automation or AI build. A guided interview that works for any function at a commercial real estate firm (brokerage, marketing, operations, finance, research, leadership), then hands the finished map back to Grounded Intelligence to start the next phase. Use when someone wants to "map my process", "document my workflow", or "turn what I do into something AI can do".

Who serves this site? For any NC property address, pull the documented utility baseline a buyer or tenant asks about first - broadband (broker-verified row with FCC map link), electric utility (retail service territory, overlapping territories surfaced), water and sewer operators (county GIS + service-area maps + curated registry), and natural gas provider. Every row carries a confidence tag and source. Returns a flyer-ready si-card PDF plus structured JSON. Answers "who serves this site", "what utilities serve [address]", "site infrastructure for [address]", "is there water/sewer/gas at [site]" for industrial and land listings, BOVs, and OMs. Wraps the lee-raleigh-mcp pullsiteinfrastructure tool.

Traffic counts (vehicles per day / AADT) for the busiest roads near any NC address. Returns the top-5 nearby road segments ranked by road class then traffic volume, each with its annual average daily traffic, the count year, and distance from the site, plus a ready-to-place flyer card. Answers "how much traffic passes this site", "VPD on the nearby roads", "traffic counts near [address]" for a retail / QSR / flex listing. Wraps the lee-raleigh-mcp pullvpdlookup tool.