Real Estate Gmail Triage with Gemini & Sheets CRM (n8n)

Turn real estate inbox emails into CRM-ready data—automatically

This n8n workflow monitors a shared Gmail inbox, uses Google Gemini to classify and extract real estate details, updates your Google Sheets-based CRM, and creates Gmail reply drafts when needed—while logging every processed message.

What this workflow does

• Monitors Gmail every minute for new inbox emails, excluding messages sent by your own account and certain Gmail categories.
• Deduplicates by checking processed messages against an Email Log sheet.
• Prepares CRM context by loading the latest Leads, Properties, Sale Deals, and Rental Deals from Google Sheets.
• Processes emails one at a time: extracts the latest unquoted email content, then sends the email plus CRM context to Google Gemini for classification and structured field extraction.
• Updates Google Sheets CRM by appending or updating leads/properties, or writing validated field updates to the matching sale or rental deal.
• Uses “Needs Review” routing for low-confidence or unclear matches—avoiding changes when validation isn’t reliable.
• Creates replies and team notifications: when a reply is needed for leads/inquiries or rental listings, Gemini drafts a fact-based response and saves it as a Gmail draft in the original thread; for deal updates, it sends a summary email to the team via Gmail.
• Logs everything by appending a row to the Email Log with message metadata, classification, match IDs, actions taken, and whether a draft was created.

Use cases

• Inbound buyer/seller inquiries from a shared inbox that should become new Leads or updated records.
• Rental listing questions that require a Gmail draft reply and accurate rental deal context.
• Deal updates received by email that should automatically update Sale Deals / Rental Deals and alert a team.

Technical details

• Integrations: Gmail, Google Sheets, Google Gemini
• n8n nodes/logic: if, set, code, no op, gmail, switch
• Core behaviors: polling every minute, deduplication via Email Log, CRM-context loading, structured extraction, safe “Needs Review” routing, draft creation, and audit logging