{"product_id":"uk-property-deal-scoring-google-sheets-telegram-alerts-n8n","title":"UK Property Deal Scoring: Google Sheets + Telegram Alerts (n8n)","description":"\u003ch3\u003eScore UK property deals automatically—then alert investors via Telegram when it’s a “Hot” opportunity (n8n + Google Sheets)\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow ingests UK property listings from \u003cstrong\u003eRightmove\u003c\/strong\u003e, \u003cstrong\u003eZoopla\u003c\/strong\u003e, and \u003cstrong\u003eRealtor\u003c\/strong\u003e, normalizes and deduplicates them, runs a deterministic underwriting \u0026amp; 10-point scoring model, appends results to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and sends \u003cstrong\u003eHot\u003c\/strong\u003e deal alerts via \u003cstrong\u003eTelegram\u003c\/strong\u003e (plus email).\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on demand\u003c\/strong\u003e, on a daily schedule (every day at \u003cstrong\u003e6am\u003c\/strong\u003e), or when your scraper \u003cstrong\u003ePOSTs\u003c\/strong\u003e to the Rightmove\/Zoopla\/Realtor webhook URLs.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePulls queued listings\u003c\/strong\u003e from an optional HTTP endpoint using \u003cstrong\u003eSCRAPER_PULL_URL\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes\u003c\/strong\u003e listings from all sources into a common structure, removes empty placeholder items, and \u003cstrong\u003ededuplicates\u003c\/strong\u003e by a normalized address key.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eComputes underwriting metrics\u003c\/strong\u003e: calculates \u003cstrong\u003eARV\u003c\/strong\u003e from provided comps (or falls back to provided ARV\/price), then derives discount, yield, repairs, max offer prices, cashflow, ROI, and a strategy classification.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScores deals\u003c\/strong\u003e using a \u003cstrong\u003e10-point matrix\u003c\/strong\u003e and assigns a tier: \u003cstrong\u003eHot\u003c\/strong\u003e, \u003cstrong\u003eWarm\u003c\/strong\u003e, or \u003cstrong\u003eCold\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends each deal\u003c\/strong\u003e as a flattened record to a specified Google Sheets tab (\u003cstrong\u003eGSHEET_ID\u003c\/strong\u003e, \u003cstrong\u003eGSHEET_TAB\u003c\/strong\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNotifies investors\u003c\/strong\u003e: sends \u003cstrong\u003eHot\u003c\/strong\u003e deals via \u003cstrong\u003eSMTP email\u003c\/strong\u003e and a \u003cstrong\u003eTelegram bot\u003c\/strong\u003e message; \u003cstrong\u003eWarm\u003c\/strong\u003e and \u003cstrong\u003eCold\u003c\/strong\u003e deals are logged for audit.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eTurn a property scraper into a production-ready \u003cstrong\u003edeal scoring automation\u003c\/strong\u003e without manual spreadsheet work.\u003c\/li\u003e\n  \u003cli\u003eDaily monitoring of UK listings with \u003cstrong\u003einstant Telegram alerts\u003c\/strong\u003e for only the strongest opportunities.\u003c\/li\u003e\n  \u003cli\u003eMaintain an auditable record of \u003cstrong\u003eWarm\/Cold**\u003c\/strong\u003e deals in Google Sheets for later review.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTriggers:\u003c\/strong\u003e webhook (Rightmove\/Zoopla\/Realtor), scheduled run (6am), or manual run.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogic \u0026amp; processing nodes:\u003c\/strong\u003e \u003cem\u003eif\u003c\/em\u003e, \u003cem\u003eset\u003c\/em\u003e, \u003cem\u003ecode\u003c\/em\u003e, normalization\/deduplication, and deterministic scoring.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Google Sheets, \u003cstrong\u003eTelegram\u003c\/strong\u003e, and \u003cstrong\u003eemail send\u003c\/strong\u003e (SMTP), controlled by \u003cstrong\u003eINVESTOR_EMAILS\u003c\/strong\u003e and \u003cstrong\u003eTELEGRAM_CHAT_ID\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45967662219443,"sku":"N8N-19241","price":39.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/7givHItrZTzu-Wv8Hb3Xg_v2SjBFil.png?v=1788686295","url":"https:\/\/buyflowscripts.com\/products\/uk-property-deal-scoring-google-sheets-telegram-alerts-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}