Extract Zillow property data to Google Sheets with Scrape.do

🏠 Extract Zillow Property Data to Google Sheets with Scrape.do This template requires a self-hosted n8n instance to run. A complete n8n automation that extracts property listing data from Zillow URLs using Scrape.do web scraping API, parses key property information, and saves structured results into Google Sheets for real estate analysis, market research, and property tracking. 📋 Overview This workflow provides a lightweight real estate data extraction solution that pulls property details from Zillow listings and organizes them into a structured spreadsheet. Ideal for real estate professionals, investors, market analysts, and property managers who need automated property data collection without manual effort. Who is this for? - Real estate investors tracking properties - Market analysts conducting property research - Real estate agents monitoring listings - Property managers organizing data - Data analysts building real estate databases What problem does this workflow solve? - Eliminates manual copy-paste from Zillow - Processes multiple property URLs in bulk - Extracts structured data (price, address, zestimate, etc.) - Automates saving results into Google Sheets - Ensures repeatable & consistent data collection ⚙️ What this workflow does 1. Manual Trigger → Starts the workflow manually 2. Read Zillow URLs from Google Sheets → Reads property URLs from a Google Sheet 3. Scrape Zillow URL via Scrape.do → Fetches full HTML from Zillow (bypasses PerimeterX protection) 4. Parse Zillow Data → Extracts structured property information from HTML 5. Write Results to Google Sheets → Saves parsed data into a results sheet 📊 Output Data Points | Field | Description | Example | |-------|-------------|---------| | URL | Original Zillow listing URL | https://www.zillow.com/homedetails/... | | Price | Property listing price | $300,000 | | Address | Street address | 8926 Silver City | | City | City name | San Antonio | | State | State abbreviation | TX | | Days on Zillow | How long listed | 5 | | Zestimate | Zillow's estimated value | $297,800 | | Scraped At | Timestamp of extraction | 2025-01-29T12:00:00.000Z | ⚙️ Setup Prerequisites - n8n instance (self-hosted) - Google account with Sheets access - Scrape.do account with API token (Get 1000 free credits/month) Google Sheet Structure This workflow uses one Google Sheet with two tabs: Input Tab: "Sheet1" | Column | Type | Description | Example | |--------|------|-------------|---------| | URLs | URL | Zillow listing URL | https://www.zillow.com/homedetails/123... | Output Tab: "Results" | Column | Type | Description | Example | |--------|------|-------------|---------| | URL | URL | Original listing URL | https://www.zillow.com/homedetails/... | | Price | Text | Property price | $300,000 | | Address | Text | Street address | 8926 Silver City | | City | Text | City name | San Antonio | | State | Text | State code | TX | | Days on Zillow | Number | Days listed | 5 | | Zestimate | Text | Estimated value | $297,800 | | Scraped At | Timestamp | When scraped | 2025-01-29T12:00:00.000Z | 🛠 Step-by-Step Setup 1. Import Workflow: Copy the JSON → n8n → Workflows → + Add → Import from JSON 2. Configure Scrape.do API: - Sign up at Scrape.do Dashboard - Get your API token - In HTTP Request node, replace YOURSCRAPEDOTOKEN with your actual token - The workflow uses super=true for premium residential proxies (10 credits per request) 3. Configure Google Sheets: - Create a new Google Sheet - Add two tabs: "Sheet1" (input) and "Results" (output) - In Sheet1, add header "URLs" in cell A1 - Add Zillow URLs starting from A2 - Set up Google Sheets OAuth2 credentials in n8n - Replace YOURSPREADSHEETID with your actual Google Sheet ID - Replace YOURGOOGLESHEETSCREDENTIALID with your credential ID 4. Run & Test: - Add 1-2 test Zillow URLs in Sheet1 - Click "Execute workflow" - Check results in Results tab 🧰 How to Customize - Add more fields: Extend parsing logic in "Parse Zillow Data" node to capture additional d