💬 Real estate property search with SQL database and email delivery

⚡ 2,466 views · 💬 Lead Nurturing & AI Sales Agents

Description

Transform property searches into personalized experiences! This powerful automation delivers dream home matches straight to clients’ inboxes with professional CSV reports - all from a simple web form.

🚀 What this workflow does

Create a complete real estate search experience that works 24/7:

✨ Smart Web Form - Beautiful property search form captures client preferences
🧠 Dynamic SQL Builder - Intelligently creates optimized queries from user input
⚡ Lightning Database Search - Scans 1000+ properties in milliseconds
📊 Professional CSV Export - Excel-ready reports with complete property details
📧 Automated Email Delivery - Personalized emails with property previews and attachments

🎯 Perfect for:

💡 Why this workflow is a game-changer

> “From property search to professional report delivery in under 30 seconds!”

📊 Real Estate Data Source

Built on authentic US market data from the Github:

🛠️ Quick Setup Guide

Prerequisites Checklist ✅

Step 1: Import Real Estate Data 📥

  1. 🌟 Download the data
  2. 💾 Download CSV file (1000+ properties included)
  3. 🗄️ Create SQL Server table with this exact schema:
CREATE TABLE [REALTOR].[dbo].[realtor_usa_price] (
    brokered_by BIGINT,
    status NVARCHAR(50),
    price DECIMAL(12,2),
    bed INT,
    bath DECIMAL(3,1),
    acre_lot DECIMAL(10,8),
    street BIGINT,
    city NVARCHAR(100),
    state NVARCHAR(50),
    zip_code INT,
    house_size INT,
    prev_sold_date NVARCHAR(50)
);
  1. 📊 Import your CSV data into this table

Step 2: Configure Database Connection 🔗

  1. 🔐 Set up Microsoft SQL Server credentials in n8n
  2. ✅ Test connection to ensure everything works
  3. 🎯 Workflow is pre-configured for the table structure above

Step 3: Gmail Setup (The Magic Touch) 📧

  1. 🌐 Visit Google Cloud Console
  2. 🆕 Create new project (or use existing)
  3. 🔓 Enable Gmail API in API Library
  4. 🔑 Create OAuth2 credentials (Web Application)
  5. ⚙️ Add your n8n callback URL to authorized redirects
  6. 🔗 Configure Gmail OAuth2 credentials in n8n
  7. ✨ Authorize your Google account

Step 4: Launch Your Property Search Portal 🚀

  1. 📋 Import this workflow template (form is pre-configured)
  2. 🌍 Copy your webhook URL from the Property Search Form node
  3. 🔍 Test with a sample property search
  4. 📨 Check email delivery with CSV attachment
  5. 🎉 Go live and start impressing clients!

🎨 Customization Playground

🏷️ Personalize Your Brand

// Customize email subjects in the Gmail node
"🏠 Exclusive Properties Curated Just for You - ${results.length} Perfect Matches!"
"✨ Your Dream Home Portfolio - Handpicked by Our Experts"
"🎯 Hot Market Alert - ${results.length} Premium Properties Inside!"

🔧 Advanced Enhancements

🌍 Multi-Database Flexibility

// Easy database switching
// MySQL: Replace Microsoft SQL node → MySQL node
// PostgreSQL: Swap for PostgreSQL node  
// MongoDB: Use MongoDB node with JSON queries
// Even CSV files: Use CSV reading nodes for smaller datasets

🚀 Advanced Features & Extensions

🔥 Pro Tips for Power Users

🎯 Integration Possibilities

🔗 Expand Your Real Estate Automation

🌟 Related Workflow Ideas

🛠️ Technical Extensions

🚀 Get Started Now

  1. Import this workflow template
  2. Configure your database and Gmail
  3. Customize branding and messaging
  4. Launch your professional property search portal
  5. Watch client satisfaction soar!

🔗 Nodes Used

Microsoft SQL, Gmail, n8n Form Trigger, Convert to File

📥 Import

Download workflow.json and import into n8n: Workflow menu → Import from File

📖 Importing guide · 🔑 Credential setup