Quick overview
Quick overview Qualify Real Estate Leads From Gmail And Build A Google Sheets Mini CRM Automatically classify real estate inquiries from Gmail, score lead urgency, prevent duplicate records, save new leads to Google Sheets, create an activity log, send priority-based internal alerts, and reply to the lead. How it works Triggers every minute and searches Gmail for messages newer than one day whose subject matches lead/contact/inquiry terms. Extracts received time, sender name, sender email, subject, and a cleaned message snippet from the email content. Appends the extracted lead details as a new row in a Google Sheets tab. Sends an internal notification email with the captured lead details using Gmail. Setup Connect a Gmail OAuth2 credential for both reading lead emails and sending the notification email. Connect a Google Sheets OAuth2 credential and set the target spreadsheet ID and sheet name (default: Leads) in the Google Sheets node. Create the Leads sheet with columns: Received At, Name, Email, From, Subject, Message, Source (or update the column mapping to match your headers). Update the Gmail search query and polling settings to match how your lead emails are identified. Replace your-team@example.com with the internal recipient address for notifications. An n8n automation workflow template by Faraz Shoaib.
Faraz Shoaib
web
free
Others in the same category, ranked by how often they are opened.
