Automatic Zillow Researcher + Home Service Quote Gen

Automatic Zillow Researcher + Home Service Quote Gen Workflow Overview This workflow automates the entire initial research phase for real estate investment opportunities. It triggers when a new property address is added to an Airtable base, enriches it with comprehensive data from Zillow, performs a detailed financial investment analysis, and uses AI to visually assess the property's condition. Based on the AI's assessment, it either flags the property as "move-in ready" or initiates a deeper AI-driven analysis to identify specific renovation needs, generate a contractor's summary, and update the record with a "fixer-upper" status and suggested upgrades. Technologies Used - Airtable: Acts as the central database (CRM) for property leads, triggering the workflow and storing all enriched data and AI analysis. - Zillow (via RapidAPI): The primary data source for real estate information, including property details, pricing, tax information, and photos. - OpenRouter (AI): Provides access to Large Language Models (LLMs) like Llama-4-Maverick for all AI-driven tasks. How AI is Integrated This workflow uses AI in three sophisticated stages to move beyond simple data retrieval and provide actionable, human-like analysis: 1. AI Vision for Triage (Curb Check): The AI first performs a quick visual assessment of the property's main photo to classify it as "new" or a "fixer". This crucial step efficiently segments properties, ensuring that only those requiring further attention are subjected to a more intensive analysis, saving time and resources. 2. Multi-Image Deep Dive Analysis: For properties classified as "fixer", the AI analyzes multiple property photos. Acting as a real estate expert, it identifies specific, actionable upgrade opportunities from each image, such as "outdated kitchen cabinets" or "worn carpeting," providing a granular list of potential value-add renovations. 3. AI Agent for Quoting & Summarization: The workflow's most advanced AI step uses an AI Agent that embodies the persona of a "General Contractor."