Optimize multi-property rents and analytics with GPT-4o and Google Sheets
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 37 nodes and runs on a schedule (every day at 06:00). Along the way it connects OpenAI Chat Model and Gmail.
How it runs
Trigger: On a schedule (every day at 06:00).
- Workflow Configuration (Edit Fields (Set)): sets 11 fields: rentRollsApiUrl, operatingCostsApiUrl, utilitiesApiUrl…
- Fetch Rent Rolls (HTTP Request): calls an HTTP API
- Fetch Operating Costs (HTTP Request): calls an HTTP API
- Fetch Utilities Data (HTTP Request): calls an HTTP API
- Fetch Mortgage Schedules (HTTP Request): calls an HTTP API
- Fetch Market Data (HTTP Request): calls an HTTP API
- Merge: merges the data from its input branches
- Summarize: summarizes / groups the items
- Aggregate: combines items into one
- Enrich with Market Context (Edit Fields (Set)): sets 4 fields: marketAverageRent, marketMedianRent, marketVacancyRate…
…plus 13 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (16)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - Merge
n8n-nodes-base.merge - Aggregate
n8n-nodes-base.aggregate - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Calculator
@n8n/n8n-nodes-langchain.toolCalculator - AI Agent Tool
@n8n/n8n-nodes-langchain.agentTool - Code
n8n-nodes-base.code - Summarize
n8n-nodes-base.summarize - Switch
n8n-nodes-base.switch - Split Out
n8n-nodes-base.splitOut - Call n8n Workflow Tool
@n8n/n8n-nodes-langchain.toolWorkflow - Gmail
n8n-nodes-base.gmail
From the author
How It Works This workflow automates comprehensive real estate investment analysis by orchestrating specialized AI agents to evaluate property data, market trends, and financial metrics. Designed for real estate investors, portfolio managers, and property…