# Score property deals, alert investors, and log CRM KPIs: n8n workflow > Started by a clock, and works across Email, Google Sheets and Telegram. 31 steps: large, and worth reading before you trust it with anything live. Source: https://millionrounds.com/workflow/score-property-deals-alert-investors-and-log-crm-kpis (Millionrounds; every figure on the page links to its filing or article) [Automation library](https://millionrounds.com/workflows) · [Alerts and monitoring](https://millionrounds.com/workflows?category=Alerts+and+monitoring#library) # Score property deals, alert investors, and log CRM KPIs Started by a clock, and works across Email, Google Sheets and Telegram. 31 steps: large, and worth reading before you trust it with anything live. Large [Download free](https://millionrounds.com/login?next=%2Fapp%2Fworkflow%2Fscore-property-deals-alert-investors-and-log-crm-kpis) **31 steps** Large: read it before trusting it with anything live **0** Branches: places the flow splits **0** Loops or waits **3** Services it connects to ## The flow Starts it 2 Logic 13 Service 16 The steps in the order they run, from what starts it. - 1 **Execute Workflow Trigger** Execute Workflow trigger *Starts it* - 2 **Weekly KPI Report (Mon 8am)** Schedule trigger *Starts it* - 3 **Advanced Offer Calculator** Code *Logic* - 4 **Prepare Skip Trace Queries** Code *Logic* - 5 **Build Comp Criteria** Code *Logic* - 6 **Get Investor Registry** Google Sheets *Service* - 7 **Read All CRM Leads** Google Sheets *Service* - 8 **Generate Investor Pack HTML** Code *Logic* - 9 **Land Registry Title Search** Http Request *Service* - 10 **Companies House (corporate owners)** Http Request *Service* - 11 **Skip Trace API (3rd Party)** Http Request *Service* - 12 **Geocode Postcode (OS API)** Http Request *Service* - 13 **Geocode Fallback (postcodes.io)** Http Request *Service* - 14 **Match Deal to Investors** Code *Logic* - 15 **Calculate KPIs** Code *Logic* - 16 **Convert to PDF** Http Request *Service* - 17 **Enrich Owner Data** Code *Logic* - 18 **Land Registry Sold Prices** Http Request *Service* - 19 **Active Listings Comps (Zoopla)** Http Request *Service* - 20 **Build Alert Email** Code *Logic* - 21 **Log KPIs to Dashboard Sheet** Google Sheets *Service* - 22 **Update CRM Deal Scores** Google Sheets *Service* - 23 **Update CRM with Owner Data** Google Sheets *Service* - 24 **Calculate Valuation & Offers** Code *Logic* - 25 **Send Email Alert** Email Send *Service* - 26 **Send Telegram Alert** Telegram *Service* - 27 **→ Trigger Investor Alerts** Execute Workflow *Logic* - 28 **→ Generate Offer Pack** Execute Workflow *Logic* - 29 **Update CRM with Valuation** Google Sheets *Service* - 30 **Filter: Grade A or B Deals** Filter *Logic* - 31 **→ Trigger Skip Trace** Execute Workflow *Logic* ## How it's built - **Starts on:** A clock - **Steps:** 31 - **Size:** Large: read it before trusting it with anything live - **Connects to:** Email, Google Sheets, Telegram - **Model:** None. This is plumbing, not judgement ## Questions What does it need to run? An n8n account, plus your own Email, Google Sheets and Telegram accounts. You connect your own accounts after importing it; none are included. What starts it? It starts on a clock. Does it use AI? No. Every step is fixed logic or a call to a service, so it does the same thing every time. How long does it take to set up? Take your time. At 31 steps it is large: read it before trusting it with anything live. How do I import it? Copy the workflow, open a new workflow in n8n and paste. The steps appear on the canvas, ready for your own accounts. **Before you run it** Nothing here has been tested by us. It is somebody's working automation, read and described from its own steps. Treat the connections it wants as a list of accounts it will touch, and read the 31 steps before you point it at anything that matters. ## Run it in n8n - **Create your n8n account** Free to start. n8n is where the workflow runs. [Create an n8n account ↗](https://millionrounds.com/n8n) - **Download the workflow** Free with a Millionrounds account. [Download free](https://millionrounds.com/login?next=%2Fapp%2Fworkflow%2Fscore-property-deals-alert-investors-and-log-crm-kpis) - **Paste it into n8n** Open a new workflow in n8n and paste. Then connect your own accounts. Stored with the author's traces removed: canvas notes, instance identifiers, saved credential names and any live document they had left behind. ## Connects to Each opens the other workflows that use it. [Email](https://millionrounds.com/workflows?service=Email#library)[Google Sheets](https://millionrounds.com/workflows?service=Google+Sheets#library)[Telegram](https://millionrounds.com/workflows?service=Telegram#library) ## Workflows like it Also alerts and monitoring, with the same services where possible, closest in size first. - [**Automate USDC balance between wallet and Aave with 1Shot API** 31 steps · Telegram](https://millionrounds.com/workflow/automate-usdc-balance-between-wallet-and-aave-with-1shot-api) - [**AI-Powered Stripe Customer Lifecycle Automation with Slack** 30 steps · Email, Slack](https://millionrounds.com/workflow/ai-powered-stripe-customer-lifecycle-automation-with-slack) - [**Automate delivery confirmation with Telegram Bot** 32 steps · Gmail, Google Drive](https://millionrounds.com/workflow/automate-delivery-confirmation-with-telegram-bot) - [**Receive Meta Ads ad account webhooks, log** 32 steps · Google Sheets, Slack](https://millionrounds.com/workflow/receive-meta-ads-ad-account-webhooks-log) - [**Reply to Instagram comments with Groq and Telegram** 32 steps · Google Sheets, Telegram](https://millionrounds.com/workflow/reply-to-instagram-comments-with-groq-and-telegram) - [**AI industry trend monitor 24/7 across X, Gmail, and websites** 30 steps · calls a model · Gmail, Google Sheets](https://millionrounds.com/workflow/ai-industry-trend-monitor-24-7-across-x-gmail-and-websites)