Analyze client portfolio diversification using Google Sheets, OpenAI and Slack

Description

Client Portfolio Diversification Check using n8n, Google Sheets, OpenAI & Slack

This n8n workflow automatically analyzes client portfolio data from Google Sheets, evaluates sector allocation, risk level and diversification quality and generates AI-powered insights. It also sends real-time alerts to Slack for invalid data and overexposed sectors while saving reports back to Google Sheets.

Quick Implementation Steps

Create a Google Sheet with columns: Stock, Sector, Investment
Add another sheet for reports with columns: timestamp, riskLevel, diversificationLevel, report
Connect Google Sheets credentials in n8n
Add your OpenAI API key
Connect Slack OAuth and select a channel
Activate the workflow

What It Does

This workflow continuously monitors client portfolio data by fetching records from Google Sheets every hour. It cleans and validates the data, ensuring that only meaningful entries (valid sector and investment values) are processed. Any invalid entries are immediately flagged and reported via Slack.

Once validated, the workflow performs financial analysis by grouping investments by sector, calculating allocation percentages and determining the portfolio's risk level. It also detects overexposure in sectors exceeding 40% allocation and calculates a diversification score to measure balance.

To enhance decision-making, the workflow leverages AI to generate concise portfolio insights and actionable recommendations. These insights, along with computed metrics, are formatted into a report, sent to Slack and stored in Google Sheets for future reference.

Who It's For

Financial advisors managing client portfolios
Investment analysts tracking diversification
Wealth management firms
FinTech teams building automated insights
Individual investors seeking portfolio health checks

Requirements

To use this workflow, ensure the following:

1. Google Sheets

Input Sheet must include columns:
Stock
Sector
Investment
Output Sheet must include:
timestamp
riskLevel
diversificationLevel
report

2. n8n Setup

Self-hosted or cloud n8n instance

3. Credentials Required

Google Sheets OAuth2 credentials
OpenAI API key (used with gpt-4o-mini)
Slack OAuth2 credentials

4. Slack Channel

A Slack channel must be selected for alerts and reports

How It Works & Setup Guide

Step 1: Trigger Workflow

The workflow starts using Google Sheets Trigger
Runs automatically every hour

Step 2: Fetch Portfolio Data

Reads data from the configured Google Sheet

Step 3: Normalize Data

Converts:
Stock → uppercase
Sector → uppercase
Investment → numeric value

Step 4: Validate Data

Conditions checked:
Investment > 0
Sector is not empty
Sector ≠ "UNKNOWN"
Invalid data → Slack alert sent
Valid data → continues processing

Step 5: Compute Sector Allocation

Groups investments by sector
Calculates total portfolio value
Computes allocation percentage per sector

Step 6: Risk & Exposure Analysis

Risk Levels:
Low (<30%)
Medium (30–50%)
High (>50%)
Detects overexposed sectors (>40%)

Step 7: Diversification Score

Measures how evenly investments are distributed
Labels:
Excellent (>80)
Good (>60)
Moderate (>40)
Poor (≤40)

Step 8: AI Insights Generation

Uses OpenAI (gpt-4o-mini)
Generates:
Portfolio summary
Risks
Diversification feedback
Actionable recommendations

Step 9: Overexposure Decision

If overexposed → Slack alert triggered

Step 10: Report Formatting

Combines:
Risk level
Diversification level
Allocation breakdown
AI insights

Step 11: Save & Notify

Saves report in Google Sheets
Sends formatted report to Slack

How To Customize Nodes

Risk Logic**
Modify thresholds in Compute: Risk Score & Exposure

Diversification Calculation**
Adjust scoring logic in Compute: Diversification Score

AI Prompt**
Customize system prompt in AI: Portfolio Insights Generator
Change tone, length or recommendations style

Slack Messages**
Edit message templates in Slack nodes for alerts and reports

Validation Rules**
Add more conditions in Validate Data node (e.g., stock format)

Add-ons (Extend This Workflow)

Email alerts using SMTP node
Dashboard integration (e.g., Power BI / Looker Studio)
Historical trend analysis
Multi-client portfolio tracking
Automatic rebalancing suggestions
Integration with market data APIs

Use Case Examples

Client Portfolio Monitoring
Automatically track diversification and risk exposure

Wealth Advisory Automation
Provide AI-generated insights without manual analysis

Compliance & Risk Alerts
Detect and alert overexposed portfolios instantly

Investment Reporting
Generate structured reports for clients regularly

Personal Finance Tracking
Individuals monitoring their own investment portfolios

These are just a few examples. This workflow can be adapted for many other financial automation scenarios.

Troubleshooting Guide

| Issue | Possible Cause | Solution |
|------|--------------|---------|
| No data fetched | Incorrect Google Sheet ID | Verify document ID and sheet selection |
| Invalid data alerts | Missing or incorrect values | Ensure all rows have valid Sector and Investment |
| AI not generating insights | Missing OpenAI API key | Add and verify OpenAI credentials |
| Slack messages not sent | wrong Slack credentials or channel | Reconnect Slack OAuth and verify channel |
| Report not saved | wrong output sheet setup | Ensure output sheet exists with correct columns |
| Workflow not running | Trigger inactive | Activate workflow in n8n |

Need Help?

If you need assistance with:

Setting up this workflow
Customizing AI insights
Adding advanced features
Building similar automation workflows

Feel free to reach out to our n8n workflow developers at WeblineIndia for expert support.

We specialize in building scalable automation workflows tailored to your business needs.