{"product_id":"uk-property-investor-deals-google-sheets-alerts-via-email-telegram","title":"UK Property Investor Deals: Google Sheets Alerts via Email \u0026 Telegram","description":"\u003ch3\u003eTurn new UK property leads into investor-ready deal alerts—automatically via Email \u0026amp; Telegram\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow identifies below-market-value UK property deals by enriching data with Land Registry and Zoopla, creates personalised investor offer pack alerts, and sends matched notifications to investors through \u003cstrong\u003eemail (SMTP)\u003c\/strong\u003e and \u003cstrong\u003eTelegram\u003c\/strong\u003e. It also runs a weekly KPI report into \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e for continuous CRM visibility.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIngests qualified deals\u003c\/strong\u003e from an upstream workflow and reads your \u003cstrong\u003einvestor registry\u003c\/strong\u003e stored in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eQualifies and values property leads\u003c\/strong\u003e using Land Registry and Zoopla data to estimate value, then enriches owner details via Land Registry and Companies House.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMatches investors to deals\u003c\/strong\u003e based on budget, preferred strategies, yield targets, and target areas.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates personalised deal alerts\u003c\/strong\u003e and sends them to matched investors via:\n    \u003cul\u003e\n      \u003cli\u003e\n\u003cstrong\u003eEmail (SMTP)\u003c\/strong\u003e using your configured sender domain and reply-to handling\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003eTelegram\u003c\/strong\u003e posting to your specified chat\/channel\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWeekly KPI automation\u003c\/strong\u003e: every Monday at \u003cstrong\u003e08:00\u003c\/strong\u003e, it reads CRM leads from Google Sheets, calculates pipeline\/financial KPIs (lead volume, stages, conversion rates, discounts, yields, equity), and appends results to a \u003cstrong\u003eKPI_History\u003c\/strong\u003e dashboard sheet.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eProperty investment firms wanting \u003cstrong\u003ebelow-market-value UK property investor deals\u003c\/strong\u003e delivered instantly to the right investors.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers building a \u003cstrong\u003edeal alert\u003c\/strong\u003e system that keeps CRM performance measurable in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators running multi-channel outreach without manual follow-ups.\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 (OAuth)\u003c\/strong\u003e: investor registry, \u003cem\u003eRaw_Leads\u003c\/em\u003e CRM inputs, and \u003cem\u003eKPI_History\u003c\/em\u003e dashboard outputs.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEmail Send (SMTP)\u003c\/strong\u003e: configurable \u003cstrong\u003eEMAIL_DOMAIN\u003c\/strong\u003e and sender\/reply-to handling.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTelegram\u003c\/strong\u003e: credentials plus target chat\/channel for alerts.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHTTP Request\u003c\/strong\u003e for skip-trace enrichment, plus workflow callouts for valuation\/skip-trace\/offer pack generation (set via workflow IDs).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes used\u003c\/strong\u003e: code, filter, telegram, email send, sticky note, http request.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cstrong\u003eSetup inputs\u003c\/strong\u003e include setting \u003cem\u003eGOOGLE_SHEET_ID\u003c\/em\u003e, configuring SMTP and Telegram credentials, and (optionally) workflow IDs for alerts, skip-trace, and offer pack sub-workflows.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46010442580147,"sku":"N8N-19519","price":15.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/AzdJEw2l4GvwGn0xB6h3W_duHJduYX.png?v=1789290344","url":"https:\/\/buyflowscripts.com\/products\/uk-property-investor-deals-google-sheets-alerts-via-email-telegram","provider":"N8N Commerce","version":"1.0","type":"link"}