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](https://n8n.partnerlinks.io/om1efg2qgvwi)

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.