n8n Workflow: Triage Stale Property Leads via Google Sheets

Detect stale property leads automatically—then alert your team in Slack

This n8n workflow scans your property listings in Google Sheets every day, spots stale or low-performing leads against portfolio benchmarks, generates a structured diagnosis with Google Gemini, and posts actionable alerts to Slack—while logging every alert back into your sheet.

What this workflow does

• Runs daily at 8:00 AM on a schedule.
• Reads all listing rows from a Google Sheets spreadsheet (specifically the “Listings” sheet).
• Calculates performance signals such as days-on-market and conversion metrics, then compares each listing to portfolio medians to flag items for review.
• Handles data-quality and timing rules: flags data-quality issues, applies a 7-day alert cooldown, and includes a 10-day grace period after price changes.
• Updates tracking trends by writing the latest enquiry/viewing/offer snapshot back to Google Sheets.
• Generates an AI diagnosis for eligible flagged listings: sends listing context to Google Gemini and expects a JSON diagnosis (likely issue, suggested action, severity).
• Posts alerts to Slack with escalation for repeat flags and optional agent/manager mentions, then increments alert count and records alert details back in the sheet.
• Failure handling: if the workflow errors, it sends a failure notification to Slack including the workflow, node, and error details.

Use cases

• Real-estate teams monitoring lead freshness and preventing lost opportunities.
• Operators using n8n automation to enforce consistent triage based on portfolio benchmarks.
• Teams auditing underperforming listings and quickly assigning next steps via Slack alerts.

Technical details

• Google Sheets via Google Service Account
• Nodes/tech stack: set, code, filter, http request, slack, and a sticky note
• AI step: Google Gemini with a JSON diagnosis output