Daily digest of past-due rent (3/7/14/30-day windows) from the RentRoll Google Sheet. Alerts landlord/PM only — never auto-sends to tenants. The landlord handles state-compliant notice + follow-up.

Rent Payment Tracker

Daily digest of past-due rent. Alerts the landlord; never the tenant.

What it does

Reads your RentRoll Sheet, finds units where rent is overdue (3+, 7+, 14+, 30+ days), totals the outstanding balance, and sends the breakdown to you. Catches the unit you forgot about because the spreadsheet rotted.

What it does NOT do

No auto-sends to tenants. Tenant-facing notices (pay-or-quit, late-fee assessment, eviction warnings) have state-specific format, timing, and content requirements. A bot sending the wrong notice can: - Invalidate a future eviction (notice was defective) - Trigger retaliation claims (notice was timing-coincident with a tenant complaint) - Violate fair-housing or anti-harassment laws

The landlord/PM reviews the digest and sends compliant notices through their normal channel. The workflow's workflow is the reminder, not the action.

Setup

1. Google Sheet

Tab RentRoll with this header:

unit	tenant	rent_amount	due_date	paid_date	status	notes

due_date and paid_date: YYYY-MM-DD
status: open | paid | partial | nsf | waived
Maintenance: at the start of each rent cycle, advance due_date and clear paid_date on each row. Or use an Apps Script to rotate.

2. Credential + contact + placeholders

Standard pattern. Replace in workflow.yaml: - <<GOOGLE_WORKSPACE_CREDENTIAL>> - <<RENT_ROLL_SHEET_ID>> - <<LANDLORD_PUBLISHER>>

3. Schedule

Daily 8:00 AM (after most overnight bank deposits clear).