Forecast property CAPEX and ROI weekly using Google Sheets and GPT-4o
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 20 nodes and runs on a schedule (every week at 06:00). Along the way it connects Google Sheets and OpenAI Chat Model.
How it runs
Trigger: On a schedule (every week at 06:00).
- Get Maintenance Data (Google Sheets): uses Google Sheets
- Get Property Data (Google Sheets): uses Google Sheets
- Get Tenant Feedback (Google Sheets): uses Google Sheets
- Combine All Data (Merge): merges the data from its input branches
- Main Prediction Agent (AI Agent): runs an AI agent, with model: Main Agent Model; 3 tools (ROI Simulator Agent, Quote Requester Agent, CAPEX Prioritizer Agent); output parser: Prediction Output Parser
- Split Predictions (Split Out): splits a list into separate items
- Format Results (Edit Fields (Set)): sets 9 fields: propertyId, issueType, urgencyLevel…
- Save Predictions (Google Sheets): append
- Update Budgeting System (HTTP Request): calls an HTTP API (POST)
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 (12)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - Merge
n8n-nodes-base.merge - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Split Out
n8n-nodes-base.splitOut - AI Agent Tool
@n8n/n8n-nodes-langchain.agentTool - Calculator
@n8n/n8n-nodes-langchain.toolCalculator - Code Tool
@n8n/n8n-nodes-langchain.toolCode - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest
From the author
How It Works This workflow automates weekly capital expenditure (CAPEX) forecasting for property portfolios using a multi-agent AI architecture. It targets property managers, asset managers, and facilities finance teams who need data-driven maintenance…