# Triage real estate seller leads with OpenAI, Google Sheets, and Gmail

> Quick overview This workflow captures real estate seller leads via an n8n form or webhook, validates and deduplicates them against Google Sheets, generates a structured pre-call brief with OpenAI, and routes alerts and lists via Gmail (and optional Slack) for follow-up. How it works 1. Receives a seller lead from the n8n form or a POST webhook request. 2. Normalizes the fields, validates required contact and value data, and emails you a rejection notice (and returns HTTP 422 for webhook callers) when the lead is invalid. 3. Reads the existing Leads tab in Google Sheets to detect repeat leads by phone/email and calculates rule-based underwriting “stoplights” (cash, subject-to, seller finance) plus a max cash offer estimate. 4. Uses an OpenAI chat model to produce a structured pre-call brief (summary, motivation score, questions, risks, next step), falling back to a rules-only brief if the AI step fails. 5. Writes the result to Google Sheets by updating the existing lead row or appending

- **Domain**: `n8n-workflow-21477.n8n.io`
- **Provider**: n8n.io (https://n8n.io)
- **Kind**: workflow
- **Live-responds (last probe)**: None
- **Signed card**: False
- **Streaming**: False
- **Quality score**: 40%

## URLs
- Agent card: https://n8n.io/workflows/21477
- Page (HTML): https://agenstry.com/agents/n8n-workflow-21477.n8n.io
- Documentation: https://n8n.io/workflows/21477
