UK Property Deal Scoring: Google Sheets + Telegram Alerts (n8n)

Score UK property deals automatically—then alert investors via Telegram when it’s a “Hot” opportunity (n8n + Google Sheets)

This n8n workflow ingests UK property listings from Rightmove, Zoopla, and Realtor, normalizes and deduplicates them, runs a deterministic underwriting & 10-point scoring model, appends results to Google Sheets, and sends Hot deal alerts via Telegram (plus email).

What this workflow does

• Runs on demand, on a daily schedule (every day at 6am), or when your scraper POSTs to the Rightmove/Zoopla/Realtor webhook URLs.
• Pulls queued listings from an optional HTTP endpoint using SCRAPER_PULL_URL.
• Normalizes listings from all sources into a common structure, removes empty placeholder items, and deduplicates by a normalized address key.
• Computes underwriting metrics: calculates ARV from provided comps (or falls back to provided ARV/price), then derives discount, yield, repairs, max offer prices, cashflow, ROI, and a strategy classification.
• Scores deals using a 10-point matrix and assigns a tier: Hot, Warm, or Cold.
• Appends each deal as a flattened record to a specified Google Sheets tab (GSHEET_ID, GSHEET_TAB).
• Notifies investors: sends Hot deals via SMTP email and a Telegram bot message; Warm and Cold deals are logged for audit.

Use cases

• Turn a property scraper into a production-ready deal scoring automation without manual spreadsheet work.
• Daily monitoring of UK listings with instant Telegram alerts for only the strongest opportunities.
• Maintain an auditable record of Warm/Cold** deals in Google Sheets for later review.

Technical details

• Triggers: webhook (Rightmove/Zoopla/Realtor), scheduled run (6am), or manual run.
• Logic & processing nodes: if, set, code, normalization/deduplication, and deterministic scoring.
• Integrations: Google Sheets, Telegram, and email send (SMTP), controlled by INVESTOR_EMAILS and TELEGRAM_CHAT_ID.