Score property investments using Claude (Anthropic), Google Sheets and Slack Workflow Solution

Workflow overview

Why this workflow matters

Relevant for managed services and support workflows. Supports knowledge capture and document intelligence use cases.

This workflow scrapes property listings, enriches them with market data, and uses Claude AI to score each listing's investment potential based on rental yield, capital growth trends, location desirability, and risk factors. How it works Trigger - Scheduled run initiates a scrape job Scrape Listings - Fetches property listings from target URL(s) via HTTP Parse Listings - Extracts structured data (price, bedrooms, suburb, etc.) Fetch Market Data - Pulls suburb median prices, rental yields, vacancy rates Fetch Demographics - Gets population growth, income levels, infrastructure data Combine Enrichment - Merges all data per listing AI Investment Scoring - Claude AI scores each listing (0–100) with rationale Filter Top Picks - Keeps listings above configurable score threshold Format Report - Builds a clean investment report Save to Google Sheets - Logs all scored listings for tracking Send Digest - Posts top picks to Slack or email Setup Steps Import workflow into AlekSystem Configure credentials: Anthropic API - Claude AI for investment scoring Google Sheets - Results & historical tracking Slack OAuth - Daily digest notifications RapidAPI / Zillow / Domain API - Property market data Set your target listing URLs in the 'Configure Scrape Targets' node Set your score threshold (default: 65) in 'Filter Top Picks' Set your Google Sheet ID and Slack channel Activate the workflow or POST to the webhook Sample Webhook Payload { "searchUrl": "https://www.domain.com.au/sale/sydney/?bedrooms=2-4&price=500000-900000", "suburb": "Parramatta", "maxListings": 20, "scoreThreshold": 65 } Scoring Criteria (Claude AI) Rental Yield** - Gross and estimated net yield vs suburb average Capital Growth** - 5-year suburb price trend Location Score** - Transport, schools, amenities proximity Vacancy Risk** - Suburb rental demand and vacancy rate Cash Flow** - Estimated weekly cash flow after mortgage Risk Flags** - Flood zones, high crime, oversupply signals Features Multi-source market enrichment AI-powered investment scoring with SWOT analysis Automated filtering of top-performing listings Google Sheets audit trail with historical scores Slack/email digest of daily top picks

Best fit

Need another direction?