Monitor portfolio correlation and diversification with Google Sheets and Slack

by WeblineIndia ✓ · 14 views · created 2026-10-06 · Crypto Trading, AI Summarization

What this workflow does

This workflow has 16 nodes and runs on a schedule (every month at 09:00). Along the way it connects Google Sheets and Slack. It also calls 192.168.101.63:5678 over HTTP.

How it runs

Trigger: On a schedule (every month at 09:00).

1. Load Portfolio Holdings (Google Sheets): uses Google Sheets
2. Validate Portfolio Holdings (If): checks a condition and branches into true / false
3. Calculate Portfolio Weights (Code): runs custom JavaScript code
4. Fetch Historical Market Data (HTTP Request): calls 192.168.101.63:5678 (POST)
5. Consolidate Historical Price Data (Code): runs custom JavaScript code
6. Calculate Pairwise Correlations (Code): runs custom JavaScript code
7. Calculate Diversification Metrics (Code): runs custom JavaScript code
8. Build Correlation Chart Configuration (Code): runs custom JavaScript code
9. Prepare Diversification Summary Record (Code): runs custom JavaScript code
10. Prepare Pairwise Correlation Records (Code): runs custom JavaScript code

…plus 5 more steps. See the full node list below.

Services it uses

Google SheetsSlack

HTTP calls to: 192.168.101.63:5678

Before you upgrade to n8n 3.0

Nodes used (6)

• Ifn8n-nodes-base.if
• Coden8n-nodes-base.code
• Schedule Triggern8n-nodes-base.scheduleTrigger
• Google Sheetsn8n-nodes-base.googleSheets
• HTTP Requestn8n-nodes-base.httpRequest
• Slackn8n-nodes-base.slack

From the author

Quick overview This workflow runs monthly to read portfolio holdings from Google Sheets, fetch 90 days of historical prices via an HTTP endpoint, calculate pairwise correlations and a diversification score, store results back to Google Sheets, generate a…

View the original on n8n.io → Check your own copy