n8n Real Estate Lead Scoring: OpenAI + PostgreSQL + Gmail/Slack

Turn new real estate leads into scored, routed, and contacted opportunities—automatically

This n8n workflow receives real estate leads via a webhook, validates them, stores them in PostgreSQL, uses OpenAI to score and classify lead quality (HOT/WARM/COLD), assigns the right agent by location, and then alerts your team in Slack and sends confirmations through Gmail (plus SMS for high-priority leads).

What this workflow does

• Receives leads via webhook: Accepts a POST request containing name, email, phone, budget, property_type, location, and message.
• Validates required fields: Rejects the request with an error response if email, phone, or budget is missing or invalid.
• Stores lead data in PostgreSQL: Inserts the lead into public.leads_tracking.
• Scores with OpenAI: Sends lead details to OpenAI to generate a lead score, lead type (HOT/WARM/COLD), and reasoning.
• Assigns an agent by location: Merges OpenAI results with the original lead and assigns a sales agent based on the lead’s location.
• Updates the same PostgreSQL record: Writes the AI score, lead type, assigned agent, and reasoning back to PostgreSQL.
• High-priority automation: If the score is above 80, sends an SMS via Twilio, a confirmation email via Gmail, posts a hot-lead alert to Slack, and returns success to the webhook caller.
• Follow-up reminder: Waits for a configured delay, then sends a Gmail follow-up email to the lead.

Use cases

• Qualify real estate inquiries from your website form and route them to the correct agent automatically.
• Use OpenAI lead scoring to prioritize outreach when a lead is likely “HOT” (score > 80).
• Notify sales immediately in Slack and confirm contact via Gmail/SMS without manual work.

Technical details

• Webhook Trigger to receive POST lead data.
• if / set / code / wait / gmail / merge nodes for logic, mapping, control flow, and email follow-up.
• OpenAI for scoring, classification, and reasoning.
• PostgreSQL (expects public.leads_tracking) for lead persistence and updates.
• Slack hot-lead alerts for high-score leads.

Ideal for n8n users, automation engineers, and SaaS operators building a reliable real estate lead scoring workflow with OpenAI + PostgreSQL + Gmail/Slack.