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

Description

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 n8n
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