{ "edges": [ { "to": "cf40ba40-8ae8-496d-99e0-58cc26696b71", "from": "0f858928-0c10-4a5a-948c-51c26f760251", "toPort": "0", "fromPort": "ai_languageModel" }, { "to": "accacfb3-eb84-4a04-a989-06a7bc40bd42", "from": "f1a0f784-ef4f-434b-a81a-f7139320c042", "toPort": "0", "fromPort": "0" }, { "to": "cf40ba40-8ae8-496d-99e0-58cc26696b71", "from": "83a73f5a-3e44-4a5e-b4bd-0c6d35a30ccb", "toPort": "0", "fromPort": "ai_tool" }, { "to": "accacfb3-eb84-4a04-a989-06a7bc40bd42", "from": "c43c6e8e-74af-4e09-b644-ddcc90ad254a", "toPort": "0", "fromPort": "0" }, { "to": "cf40ba40-8ae8-496d-99e0-58cc26696b71", "from": "fa5914ff-493d-49c7-a126-3ca72c77c10c", "toPort": "0", "fromPort": "ai_tool" }, { "to": "accacfb3-eb84-4a04-a989-06a7bc40bd42", "from": "036b14f7-17ae-4706-9697-8d8d6947ad38", "toPort": "0", "fromPort": "0" }, { "to": "f1a0f784-ef4f-434b-a81a-f7139320c042", "from": "d345f473-39b7-411e-be74-71321543da10", "toPort": "0", "fromPort": "0" }, { "to": "c43c6e8e-74af-4e09-b644-ddcc90ad254a", "from": "d345f473-39b7-411e-be74-71321543da10", "toPort": "0", "fromPort": "0" }, { "to": "036b14f7-17ae-4706-9697-8d8d6947ad38", "from": "d345f473-39b7-411e-be74-71321543da10", "toPort": "0", "fromPort": "0" }, { "to": "732f471a-627a-459a-a945-ddab8c11b3f8", "from": "d345f473-39b7-411e-be74-71321543da10", "toPort": "0", "fromPort": "0" }, { "to": "d345f473-39b7-411e-be74-71321543da10", "from": "2376ee96-72ff-46c7-937e-b76fc254068f", "toPort": "0", "fromPort": "0" }, { "to": "accacfb3-eb84-4a04-a989-06a7bc40bd42", "from": "732f471a-627a-459a-a945-ddab8c11b3f8", "toPort": "0", "fromPort": "0" }, { "to": "cf40ba40-8ae8-496d-99e0-58cc26696b71", "from": "accacfb3-eb84-4a04-a989-06a7bc40bd42", "toPort": "0", "fromPort": "0" }, { "to": "9124a6fe-1fd9-46d8-bf9f-fb27447748d0", "from": "b8295ae9-075d-4a77-b196-ca814a01e9b1", "toPort": "0", "fromPort": "0" }, { "to": "6dc23772-a3de-4f13-995c-05a6f7f01e31", "from": "b8295ae9-075d-4a77-b196-ca814a01e9b1", "toPort": "0", "fromPort": "0" }, { "to": "cf40ba40-8ae8-496d-99e0-58cc26696b71", "from": "dc993877-ee14-4c3c-be5f-d6c71f44d0d4", "toPort": "0", "fromPort": "ai_outputParser" }, { "to": "b8295ae9-075d-4a77-b196-ca814a01e9b1", "from": "cf40ba40-8ae8-496d-99e0-58cc26696b71", "toPort": "0", "fromPort": "0" } ], "nodes": [ { "id": "2376ee96-72ff-46c7-937e-b76fc254068f", "name": "Daily Analysis Schedule", "type": "trigger", "params": { "kind": "n8n-nodes-base.scheduleTrigger", "rule": { "interval": [ { "triggerAtHour": 6 } ] } }, "position": [ -1056, 112 ] }, { "id": "d345f473-39b7-411e-be74-71321543da10", "name": "Workflow Configuration", "type": "set", "params": { "options": {}, "assignments": { "assignments": [ { "id": "id-1", "name": "mlsApiUrl", "type": "string", "value": "<__PLACEHOLDER_VALUE__MLS API endpoint URL__>" }, { "id": "id-2", "name": "publicRecordsApiUrl", "type": "string", "value": "<__PLACEHOLDER_VALUE__Public Records API endpoint URL__>" }, { "id": "id-3", "name": "demographicApiUrl", "type": "string", "value": "<__PLACEHOLDER_VALUE__Demographic Data API endpoint URL__>" }, { "id": "id-4", "name": "macroeconomicApiUrl", "type": "string", "value": "<__PLACEHOLDER_VALUE__Macroeconomic Data API endpoint URL__>" }, { "id": "id-5", "name": "targetMarket", "type": "string", "value": "<__PLACEHOLDER_VALUE__Target market or region (e.g., Austin, TX)__>" }, { "id": "id-6", "name": "investmentThreshold", "type": "number", "value": 75 }, { "id": "id-7", "name": "acquisitionTeamEmail", "type": "string", "value": "<__PLACEHOLDER_VALUE__Acquisition team email address__>" }, { "id": "id-8", "name": "slackChannel", "type": "string", "value": "<__PLACEHOLDER_VALUE__Slack channel ID for investor notifications__>" } ] }, "includeOtherFields": true }, "position": [ -832, 112 ] }, { "id": "f1a0f784-ef4f-434b-a81a-f7139320c042", "name": "Fetch MLS Data", "type": "http", "params": { "url": "={{ $('Workflow Configuration').first().json.mlsApiUrl }}", "options": {}, "sendQuery": true, "queryParameters": { "parameters": [ { "name": "market", "value": "={{ $('Workflow Configuration').first().json.targetMarket }}" } ] } }, "position": [ -608, -48 ] }, { "id": "c43c6e8e-74af-4e09-b644-ddcc90ad254a", "name": "Fetch Public Records", "type": "http", "params": { "url": "={{ $('Workflow Configuration').first().json.publicRecordsApiUrl }}", "options": {}, "sendQuery": true, "queryParameters": { "parameters": [ { "name": "region", "value": "={{ $('Workflow Configuration').first().json.targetMarket }}" } ] } }, "position": [ -608, 144 ] }, { "id": "036b14f7-17ae-4706-9697-8d8d6947ad38", "name": "Fetch Demographic Data", "type": "http", "params": { "url": "={{ $('Workflow Configuration').first().json.demographicApiUrl }}", "options": {}, "sendQuery": true, "queryParameters": { "parameters": [ { "name": "location", "value": "={{ $('Workflow Configuration').first().json.targetMarket }}" } ] } }, "position": [ -608, 336 ] }, { "id": "732f471a-627a-459a-a945-ddab8c11b3f8", "name": "Fetch Macroeconomic Data", "type": "http", "params": { "url": "={{ $('Workflow Configuration').first().json.macroeconomicApiUrl }}", "options": {} }, "position": [ -608, 528 ] }, { "id": "accacfb3-eb84-4a04-a989-06a7bc40bd42", "name": "Aggregate All Data Sources", "type": "passthrough", "params": { "mode": "aggregate", "options": {}, "aggregate": "aggregateAllItemData" }, "position": [ -384, 112 ] }, { "id": "cf40ba40-8ae8-496d-99e0-58cc26696b71", "name": "Investment Opportunity Analyzer", "type": "llm", "params": { "text": "=Analyze the following real estate market data for {{ $('Workflow Configuration').first().json.targetMarket }}:\n\nMLS Data: {{ JSON.stringify($json.mls_data) }}\nPublic Records: {{ JSON.stringify($json.public_records) }}\nDemographic Data: {{ JSON.stringify($json.demographic_data) }}\nMacroeconomic Data: {{ JSON.stringify($json.macroeconomic_data) }}\n\nIdentify emerging investment opportunities and predict future property value trends.", "prompt": "=Analyze the following real estate market data for {{ $('Workflow Configuration').first().json.targetMarket }}:\n\nMLS Data: {{ JSON.stringify($json.mls_data) }}\nPublic Records: {{ JSON.stringify($json.public_records) }}\nDemographic Data: {{ JSON.stringify($json.demographic_data) }}\nMacroeconomic Data: {{ JSON.stringify($json.macroeconomic_data) }}\n\nIdentify emerging investment opportunities and predict future property value trends.", "options": { "systemMessage": "You are an expert real estate investment analyst specializing in submarket trend analysis and opportunity identification.\n\nYour task is to:\n1. Analyze aggregated MLS, public records, demographic, and macroeconomic data\n2. Identify emerging investment opportunities based on:\n - Price trends and momentum\n - Supply and demand dynamics\n - Demographic shifts (population growth, income levels, employment)\n - Infrastructure development and zoning changes\n - Economic indicators (interest rates, GDP growth, employment rates)\n3. Predict future property value trends using:\n - Historical price appreciation patterns\n - Market cycle analysis\n - Comparative market analysis\n - Economic forecasting models\n4. Calculate an investment score (0-100) for each opportunity\n5. Provide actionable insights with specific property types, locations, and timing recommendations\n\nReturn your analysis in the structured JSON format defined by the output parser." }, "provider": "openai", "promptType": "define", "approximated": true, "systemMessage": "You are an expert real estate investment analyst specializing in submarket trend analysis and opportunity identification.\n\nYour task is to:\n1. Analyze aggregated MLS, public records, demographic, and macroeconomic data\n2. Identify emerging investment opportunities based on:\n - Price trends and momentum\n - Supply and demand dynamics\n - Demographic shifts (population growth, income levels, employment)\n - Infrastructure development and zoning changes\n - Economic indicators (interest rates, GDP growth, employment rates)\n3. Predict future property value trends using:\n - Historical price appreciation patterns\n - Market cycle analysis\n - Comparative market analysis\n - Economic forecasting models\n4. Calculate an investment score (0-100) for each opportunity\n5. Provide actionable insights with specific property types, locations, and timing recommendations\n\nReturn your analysis in the structured JSON format defined by the output parser.", "hasOutputParser": true }, "position": [ -48, 112 ] }, { "id": "0f858928-0c10-4a5a-948c-51c26f760251", "name": "OpenAI GPT-4", "type": "llm", "params": { "model": "gpt-4o", "options": {}, "provider": "openai", "builtInTools": {} }, "position": [ -160, 336 ] }, { "id": "dc993877-ee14-4c3c-be5f-d6c71f44d0d4", "name": "Structured Investment Output", "type": "passthrough", "params": { "mode": "noOp", "schemaType": "manual", "inputSchema": "{\n \"type\": \"object\",\n \"properties\": {\n \"opportunities\": {\n \"type\": \"array\",\n \"items\": {\n \"type\": \"object\",\n \"properties\": {\n \"location\": {\"type\": \"string\", \"description\": \"Specific submarket or neighborhood\"},\n \"propertyType\": {\"type\": \"string\", \"description\": \"Type of property (e.g., single-family, multifamily, commercial)\"},\n \"investmentScore\": {\"type\": \"number\", \"description\": \"Score from 0-100 indicating investment potential\"},\n \"currentMedianPrice\": {\"type\": \"number\", \"description\": \"Current median property price\"},\n \"predictedValueGrowth\": {\"type\": \"number\", \"description\": \"Predicted percentage growth over next 12 months\"},\n \"keyDrivers\": {\"type\": \"array\", \"items\": {\"type\": \"string\"}, \"description\": \"Main factors driving the opportunity\"},\n \"risks\": {\"type\": \"array\", \"items\": {\"type\": \"string\"}, \"description\": \"Potential risks to consider\"},\n \"recommendedAction\": {\"type\": \"string\", \"description\": \"Specific action recommendation\"},\n \"timeframe\": {\"type\": \"string\", \"description\": \"Recommended investment timeframe\"}\n },\n \"required\": [\"location\", \"propertyType\", \"investmentScore\", \"predictedValueGrowth\", \"keyDrivers\", \"recommendedAction\"]\n }\n },\n \"marketSummary\": {\n \"type\": \"string\",\n \"description\": \"Overall market condition summary\"\n },\n \"topOpportunity\": {\n \"type\": \"object\",\n \"properties\": {\n \"location\": {\"type\": \"string\"},\n \"reason\": {\"type\": \"string\"}\n }\n }\n },\n \"required\": [\"opportunities\", \"marketSummary\"]\n}" }, "position": [ 224, 336 ] }, { "id": "83a73f5a-3e44-4a5e-b4bd-0c6d35a30ccb", "name": "Calculator Tool", "type": "integration", "params": { "service": "toolcalculator", "operation": "run", "__originalType": "@n8n/n8n-nodes-langchain.toolCalculator" }, "position": [ -32, 336 ] }, { "id": "fa5914ff-493d-49c7-a126-3ca72c77c10c", "name": "Market Research Tool", "type": "http", "params": { "url": "<__PLACEHOLDER_VALUE__Additional market research API endpoint__>", "options": {}, "toolDescription": "Fetch additional real estate market data, property listings, or economic indicators from external APIs" }, "position": [ 96, 336 ] }, { "id": "b8295ae9-075d-4a77-b196-ca814a01e9b1", "name": "Check Investment Threshold", "type": "if", "params": { "options": {}, "conditions": { "options": { "leftValue": "", "caseSensitive": false, "typeValidation": "loose" }, "combinator": "and", "conditions": [ { "id": "id-1", "operator": { "type": "number", "operation": "gte" }, "leftValue": "={{ $('Investment Opportunity Analyzer').item.json.investmentScore }}", "rightValue": "={{ $('Workflow Configuration').first().json.investmentThreshold }}" } ] } }, "position": [ 432, 112 ] }, { "id": "9124a6fe-1fd9-46d8-bf9f-fb27447748d0", "name": "Email Acquisition Team", "type": "integration", "params": { "sendTo": "={{ $('Workflow Configuration').first().json.acquisitionTeamEmail }}", "message": "=

Investment Opportunity Alert

Market: {{ $('Workflow Configuration').first().json.targetMarket }}

Analysis Date: {{ $now.toFormat(\"yyyy-MM-dd HH:mm\") }}

\n\n

Top Opportunity

Location: {{ $json.topOpportunity.location }}

Reason: {{ $json.topOpportunity.reason }}

\n\n

Market Summary

\n\n

All Opportunities (Score ≥ {{ $('Workflow Configuration').first().json.investmentThreshold }})

\n\n \n \n \n \n \n \n \n {{ $json.opportunities.filter(o => o.investmentScore >= $('Workflow Configuration').first().json.investmentThreshold).map(o => `\n \n \n \n \n \n \n \n `).join(\"\") }}\n

Location	Property Type	Score	Predicted Growth	Action
${o.location}	${o.propertyType}	${o.investmentScore}	${o.predictedValueGrowth}%	${o.recommendedAction}

\n\n

This is an automated alert from the Submarket Trend Analyzer.

", "options": {}, "service": "gmail", "subject": "=🚨 High-Priority Investment Opportunity Detected - {{ $json.topOpportunity.location }}", "operation": "read" }, "position": [ 656, 16 ] }, { "id": "6dc23772-a3de-4f13-995c-05a6f7f01e31", "name": "Notify Investors on Slack", "type": "integration", "params": { "text": "=🚨 *Investment Opportunity Alert*\n\n*Market:* {{ $('Workflow Configuration').first().json.targetMarket }}\n*Analysis Date:* {{ $now.toFormat(\"yyyy-MM-dd HH:mm\") }}\n\n*Top Opportunity:* {{ $json.topOpportunity.location }}\n_{{ $json.topOpportunity.reason }}_\n\n*Market Summary:*\n{{ $json.marketSummary }}\n\n*High-Score Opportunities (≥{{ $('Workflow Configuration').first().json.investmentThreshold }}):*\n{{ $json.opportunities.filter(o => o.investmentScore >= $('Workflow Configuration').first().json.investmentThreshold).map(o => `• *${o.location}* (${o.propertyType}) - Score: ${o.investmentScore} | Growth: ${o.predictedValueGrowth}%`).join(\"\\n\") }}\n\n_Automated alert from Submarket Trend Analyzer_", "select": "channel", "service": "slack", "channelId": { "__rl": true, "mode": "id", "value": "={{ $('Workflow Configuration').first().json.slackChannel }}" }, "operation": "read", "otherOptions": {}, "authentication": "oAuth2" }, "position": [ 656, 208 ] } ] }

Analyze real estate submarket trends with GPT-4, Gmail, and Slack alerts