{"product_id":"n8n-workflow-triage-stale-property-leads-via-google-sheets","title":"n8n Workflow: Triage Stale Property Leads via Google Sheets","description":"\u003ch3\u003eDetect stale property leads automatically—then alert your team in Slack\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow scans your property listings in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e every day, spots \u003cstrong\u003estale or low-performing leads\u003c\/strong\u003e against portfolio benchmarks, generates a structured diagnosis with \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e, and posts actionable alerts to \u003cstrong\u003eSlack\u003c\/strong\u003e—while logging every alert back into your sheet.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns daily at 8:00 AM\u003c\/strong\u003e on a schedule.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads all listing rows\u003c\/strong\u003e from a Google Sheets spreadsheet (specifically the \u003cstrong\u003e“Listings”\u003c\/strong\u003e sheet).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates performance signals\u003c\/strong\u003e such as \u003cem\u003edays-on-market\u003c\/em\u003e and conversion metrics, then compares each listing to \u003cstrong\u003eportfolio medians\u003c\/strong\u003e to flag items for review.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHandles data-quality and timing rules\u003c\/strong\u003e: flags data-quality issues, applies a \u003cstrong\u003e7-day alert cooldown\u003c\/strong\u003e, and includes a \u003cstrong\u003e10-day grace period after price changes\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates tracking trends\u003c\/strong\u003e by writing the latest enquiry\/viewing\/offer snapshot back to Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates an AI diagnosis\u003c\/strong\u003e for eligible flagged listings: sends listing context to \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e and expects a \u003cstrong\u003eJSON diagnosis\u003c\/strong\u003e (likely issue, suggested action, severity).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePosts alerts to Slack\u003c\/strong\u003e with escalation for repeat flags and optional agent\/manager mentions, then increments alert count and records alert details back in the sheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFailure handling\u003c\/strong\u003e: if the workflow errors, it sends a failure notification to Slack including the workflow, node, and error details.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eReal-estate teams monitoring \u003cstrong\u003elead freshness\u003c\/strong\u003e and preventing lost opportunities.\u003c\/li\u003e\n  \u003cli\u003eOperators using n8n automation to enforce \u003cstrong\u003econsistent triage\u003c\/strong\u003e based on portfolio benchmarks.\u003c\/li\u003e\n  \u003cli\u003eTeams auditing underperforming listings and quickly assigning next steps via Slack alerts.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e via Google Service Account\u003c\/li\u003e\n  \u003cli\u003eNodes\/tech stack: \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003efilter\u003c\/strong\u003e, \u003cstrong\u003ehttp request\u003c\/strong\u003e, \u003cstrong\u003eslack\u003c\/strong\u003e, and a \u003cstrong\u003esticky note\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003eAI step: \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e with a JSON diagnosis output\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46001876631731,"sku":"N8N-19450","price":60.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/32RhQSc34n1fMDsutmAch_rHOUCG8b.png?v=1789118160","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-triage-stale-property-leads-via-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}