# Triage stale property listings with Google Sheets, Gemini, and Slack

> Quick overview Demo Link: https://www.linkedin.com/feed/update/urn:li:activity:7503832069614215168/ This workflow runs daily to scan property listings in Google Sheets, detect stale or low-performing leads using portfolio benchmarks, generate a diagnosis with Google Gemini, and post actionable alerts to Slack while logging alert history back to the sheet. How it works 1. Runs every day at 8:00 AM on a schedule. 2. Reads all listing rows from a Google Sheets “Listings” spreadsheet. 3. Calculates days-on-market and conversion metrics, compares each listing to portfolio medians, and flags listings for review (or flags data-quality issues) while applying a 7-day alert cooldown and a 10-day grace period after price changes. 4. Writes the latest enquiry/viewing/offer snapshot back to Google Sheets to track trends over time. 5. For eligible flagged listings, sends the listing context to Google Gemini to return a JSON diagnosis (likely issue, suggested action, and severity). 6. Posts an alert 

- **Domain**: `n8n-workflow-19450.n8n.io`
- **Provider**: n8n.io (https://n8n.io)
- **Kind**: workflow
- **Live-responds (last probe)**: None
- **Signed card**: False
- **Streaming**: False
- **Quality score**: 40%

## URLs
- Agent card: https://n8n.io/workflows/19450
- Page (HTML): https://agenstry.com/agents/n8n-workflow-19450.n8n.io
- Documentation: https://n8n.io/workflows/19450