Back to Templates
Real Estate Deal Analyzer using Google Sheets, AI (Groq) and Gmail
This workflow automates real estate investment analysis using Google Sheets and AI. It calculates ROI and rental yield, detects duplicate entries, generates AI-based recommendations and sends email reports. Simply connect your Google Sheets, Groq (AI) and Gmail accounts, then start adding property data.
Quick Implementation Steps
- Login to your n8n account.
- Connect your Google Sheets account (input + history sheets)
- Add Groq API credentials for AI analysis
- Connect Gmail for sending notifications
- Add property data (price, rent, expenses) in the sheet
- Run the workflow manually or activate it
What It Does
This workflow helps you analyze real estate investment opportunities automatically. Whenever a new property entry is added to your Google Sheet, it calculates important financial metrics such as annual rent, profit, rental yield and ROI.
It then checks whether the property already exists in your historical records. If it finds a duplicate, it stops further processing, marks the entry and sends a notification email.
For unique entries, the workflow uses AI to evaluate the investment and classify it as BUY, HOLD or AVOID, along with risk level, reasoning and improvement suggestions. Finally, it stores the result, sends a detailed email report and marks the row as processed.
Who It's For
- Real estate investors
- Property consultants
- Finance analysts
- Startup founders working in prop-tech
- Anyone managing property investments in Google Sheets
Requirements to Use This Workflow
- n8n account (cloud or self-hosted)
- Google Sheets account (with two sheets: main + history)
- Groq API credentials
- Gmail account
- Basic understanding of spreadsheets
How It Works & Set Up
Step 1: Trigger Setup
Workflow starts manually and fetches new entries from Google Sheets.
Step 2: Filter Unprocessed Data
Only rows with Processed = No and no duplicate flag are processed.
Step 3: Prepare Data
Converts price, rent and expenses into numeric format.
Step 4: Calculate Metrics
Calculates annual rent, profit, rental yield and ROI.
Step 5: Check Duplicate
Compares current entry with historical data.
Step 6: Conditional Routing
Duplicates go to alert flow; others go to AI analysis.
Step 7A: Duplicate Flow
Sends email and marks row as duplicate.
Step 7B: AI Analysis
Classifies property as BUY, HOLD or AVOID.
Step 8: Save Results
Stores analysis in history sheet.
Step 9: Email Report
Sends detailed investment report.
Step 10: Mark Processed
Updates row as processed.
How To Customize Nodes
- Modify ROI thresholds in AI node
- Improve duplicate detection logic
- Customize email templates
- Extend sheet fields
Add-ons
- Slack/WhatsApp alerts
- CRM integration
- Dashboard reporting
- Loan calculations
Use Case Examples
- Investment screening
- Portfolio tracking
- Duplicate prevention
- Automated reporting
- Real estate agency workflows
Troubleshooting Guide
| Issue | Possible Cause | Solution |
|---|---|---|
| No data processed | "Processed" field not set to "No" | Ensure new rows have Processed = No before running |
| Duplicate not detected | Matching only based on price | Enhance logic to include more fields like ID or address |
| AI output parsing error | AI response not in valid JSON format | Ensure prompt strictly returns JSON without extra text |
| Email not sent | Gmail credentials not connected | Reconnect Gmail account and test the node |
| Incorrect ROI values | Fields not treated as numbers | Check data types and ensure numeric values in the sheet |
| Workflow not triggering | Manual trigger not executed | Run workflow manually or add a trigger node |
Need Help?
WeblineIndia can help you customize, extend and build similar workflows tailored to your business needs.