SNS Daily Report Dashboard
Real-time property management dashboard for SNS portfolio using ResMan API and Google Sheets integration.
Live Dashboard: https://sns-daily-report.vercel.app
Last Updated: November 4, 2026
Quick Start
View Live:
Visit sns-daily-report.vercel.app
Local Development:
cd "C:\Users\ymosh\Claude\ROI\SNS Daily Report"
python generate_dashboard.py
Then open dashboard_live.html in a browser.
Overview
This dashboard provides a unified view of:
- Unit Status - Occupancy, vacancies, NTV, evictions across 9 properties
- Traffic Metrics - Lead generation, applicants, and lease signing progress
- Expiring Leases - 4-month forecast with renewal tracking
- Renovation Status - Renovated / Partial / Classic breakdown per property
- Financial Summary - Income, credits, net revenue, and delinquency tracking
Companion pages
Files
| File | Description |
|---|
generate_dashboard.py | Main script - fetches data and generates HTML |
dashboard_live.html | Generated dashboard (open in browser) |
SNS_STYLEGUIDE.md | SNS design system documentation |
DEVELOPMENT.md | Technical documentation and API reference |
.github/workflows/refresh.yml | GitHub Actions - auto-refresh every 4 hours |
api/index.py | Vercel serverless function - triggers manual refresh |
api/get_leases.py | Vercel API - fetch leases for renewal letters |
api/get_charges.py | Vercel API - fetch deposit and recurring charges |
api/push_monday.py | Vercel API - push data to Monday.com |
renewal_summary.json | Current-month renewal buckets + % per property (regenerated every 4h, consumed by n8n) |
vercel.json | Vercel deployment configuration |
requirements.txt | Python dependencies |
renewal_letters.html | Renewal letter generation tool |
renewals.html | Renewals Dashboard — /renewals page (see section below) |
renewals_data.json | Baked JSON that powers renewals.html (committed by sync-renewals.yml) |
renewals_sync/ | Python scripts that pull ResMan → Sheet and Sheet → renewals_data.json |
api/get_renewals.py | Live fallback that reads the Google Sheet directly (used mid-refresh for immediate feedback) |
api/trigger_renewals_sync.py | Dispatches sync-renewals.yml from the Refresh button |
api/sync_status.py | Reports the last sync-renewals.yml run status |
api/last_sync.py | Reports the last successful run time (shown in the chip) |
Data Sources
ResMan Legacy API
- Endpoint:
https://api.myresman.com
- Auth: POST with JSON body (
IntegrationPartnerID, APIKey, AccountID)
- Endpoints Used:
Account/GetProperties - List all propertiesProperty/GetUnitStatus - Unit vacancy & ready status (VacancyStatus, Status fields)Leasing/GetApplicantsAndCurrentResidents - Identify eviction units
ResMan Partners API
- Endpoint:
https://partners-api.myresman.com
- Auth: GET with Basic Auth (PartnerID:APIKey) + Header
ResMan-Account-Id
- Timeout: 30 seconds with 2 retries (3-second delay between retries)
- Endpoints Used:
GET /Leasing/Leases - Lease data with history for renewalsGET /Units/Availability - Unit vacancy, occupancy, move-out dates (primary endpoint)GET /Units - Unit details, renovation status, availableForOnlineMarketing fieldGET /WorkOrders - Open work orders and new orders in last 24hGET /Transactions/Receivables - Owed account balances as of a date (used for Receivable MTD / Del %)
Google Sheets (Traffic)
- Sheet ID:
1D8eBjdcClYf9L4DNQg2cKDE1Wuwkc5AOSQcRCPmz18A
- Tab: Traffic (gid=343109953)
- Access: Public (view only)
Google Sheets (Financial)
- Sheet ID:
1TF3cpVlGcllKMJnkPOB_fHmFgN-wwb1qbiJ05l8JMNU
- Tab: transactions (gid=0) - Income charges and credits
- Tab: Del (gid=763378106) - Delinquency data (Current, Under Eviction, Formers)
- Access: Public (view only)
- Source: n8n automation from ResMan
Properties (9)
| Region | Properties |
|---|
| Tampa | 49thStr |
| Orlando | TV, MOC, MUSO |
| Jacksonville | AP, SJ, ROP, ORT |
| Ft. Lauderdale | EAST |
This is the beginning of the README. Read the rest at the original. Read the full README ↗
