Generate portfolio exposure risk summaries with Sheets, Gemini, Slack, and Gmail

Portfolio Exposure Risk Summary Generator

> n8n + Google Sheets + Gemini + Slack + Gmail

This workflow automatically analyzes portfolio data from Google Sheets on a scheduled basis, calculates exposure metrics such as sector allocation and concentration and generates a professional risk summary using Google Gemini. The report is then sent via email, shared on Slack and logged for historical tracking.

Quick Implementation Steps

Connect your Google Sheets portfolio data Add Gemini API credentials Configure Gmail and Slack nodes Set schedule trigger timing Run once to verify output and logging

What It Does

This workflow performs a complete portfolio risk analysis pipeline. It starts by fetching portfolio data from a Google Sheet and validating whether the required data exists. If valid data is present, it calculates key exposure metrics such as total portfolio value, sector allocation and concentration levels using a Code node.

These calculated metrics are then passed to an AI model (Google Gemini), which generates a concise and professional risk summary. The workflow ensures the output is structured properly before preparing a final report.

The final output is distributed through multiple channels: an email report, a Slack notification and a log entry in Google Sheets. If no portfolio data is available, the workflow gracefully handles the scenario by generating a fallback report and logging it.

Who It's For

Financial analysts monitoring portfolio risk Investment advisors managing client portfolios Business owners tracking asset exposure Automation enthusiasts building financial workflows

Requirements to Use This Workflow

n8n account (cloud or self-hosted) Google Sheets with portfolio data Google Gemini API credentials Gmail account connected in n8n Slack workspace connected in n8n

How It Works & Setup Guide

Step 1: Schedule Trigger

Configure the "Schedule Risk Review" node Default: Weekly run (Monday at 9 AM)

Step 2: Connect Portfolio Data

Use "Read Portfolio From Sheet" node Ensure sheet contains columns like:

Asset Name Sector Quantity Price Market Value (optional)

Step 3: Validate Data

"Check Portfolio Data Exists" ensures valid entries exist If no data → fallback branch executes

Step 4: Calculate Exposure Metrics

Code node calculates:

Total portfolio value Sector exposure and percentages Top holding concentration Top 3 holdings

Step 5: Generate AI Risk Summary

"Generate Risk Summary" uses Gemini model Input includes calculated metrics Output is structured JSON with risk summary

Step 6: Parse AI Output

"Parse Risk Summary" ensures valid JSON output Handles fallback parsing if needed

Step 7: Prepare Final Report

"Prepare Risk Report Data" formats final fields:

Total value Top sector and exposure Top holding and concentration Risk summary Run date and ID

Step 8: Deliver Report

Email sent via Gmail node Slack message posted Data logged in Google Sheets

Step 9: Fallback Handling

If no portfolio data exists:

Default summary is generated Logged to sheet for consistency

How To Customize Nodes

Modify schedule timing in Schedule node Update Google Sheet structure as per your data Adjust Code node logic for additional metrics Customize AI prompt for different analysis styles Change email/Slack message formatting

Add‑ons

Add risk scoring system (low/medium/high) Integrate historical trend analysis Add client-specific reporting Include asset-level risk breakdown Connect dashboards (e.g., Google Data Studio)

Use Case Examples

Weekly portfolio risk monitoring Client portfolio reporting for advisors Internal investment review automation Risk alerts for concentrated holdings Portfolio diversification analysis

Troubleshooting Guide

| Issue | Possible Cause | Solution | | --------------------------- | ------------------------- | ----------------------------------- | | No data processed | Empty Google Sheet | Ensure portfolio data exists | | AI output not parsed | Invalid JSON response | Check prompt format or parsing node | | Email not sent | Gmail credentials missing | Reconnect Gmail account | | Slack message not delivered | Incorrect channel setup | Verify Slack channel ID | | Incorrect calculations | Missing numeric values | Validate sheet data types |

Need Help?

If you need assistance setting up this workflow, customizing it for your business or building advanced automation solutions, feel free to reach out to our n8n automation developers at WeblineIndia / Global. Our team specializes in building scalable and production-ready automation workflows tailored to your needs.

We can help you extend this workflow with advanced analytics, dashboards, integrations and enterprise-grade solutions.