NYC Brokerage Showing Feedback System

App that seamlessly collects apartment condition and showing feedback from agents and creates reports for agents, managers, and landlords for a large NYC brokerage.

NYC Brokerage Showing Feedback System

How it Works

Agents receive secure, mobile-optimized links to submit structured feedback after showings. Submissions capture pricing sentiment, location and condition notes, and client interest — giving management a clean, queryable record of every showing.

Managers access a reporting dashboard with sortable, filterable tables across listings, conditions, agents, and leads. Each listing surfaces AI-generated summaries synthesizing recent feedback trends, powered by GPT-4.

Automated reporting handles the rest: daily activity digests for managers, weekly performance emails for agents, and hourly syncing of CRM inquiries, all triggered via scheduled cron jobs.

Key Features

  • Feedback collection via tokenized forms with duplicate detection and mobile-first UI
  • Condition reports with structured fields and landlord-specific secure links
  • AI summaries generated nightly per listing (GPT-4), with privacy filtering to exclude client names
  • Listings dashboard with multi-tab reporting (listings, conditions, agents, leads), sortable by showings or inquiries independently
  • Automated notifications via email and SMS for condition form requests and feedback summaries
  • Export suite — PDF, Excel, and CSV exports across all report types
  • System health report — daily internal email summarizing cron activity, API errors, and communication logs
  • Lead tracking — incoming CRM leads routed, claimed, and tracked with a full event timeline

Tech: NextJS · Google Sheets · Google Apps Script · MongoDB · GPT-4