Automate Commodity Tracking with n8n & Google Sheets

Transform your commodity investment management with this powerful n8n automation that continuously monitors your portfolio in Google Sheets, detects allocation drift, and sends AI-powered rebalance alerts via Gmail when your holdings deviate from target percentages.

What this workflow does

This automated commodity portfolio tracker integrates Google Sheets, Gemini AI, and Gmail to provide intelligent investment monitoring. The workflow reads your holdings data from Google Sheets using the Read Holdings node, then combines it with predefined targets configured in the Workflow Settings node.

The system validates your portfolio data, calculates current allocation percentages via Calculate Portfolio Allocation, and identifies deviations through Detect Portfolio Drift. When deviations exceed your defined limits, Classify Alert Severity determines the urgency level.

Gemini AI powers the alert generation through Build Alert Prompt and Generate Alert Message nodes, creating human-readable notifications that are processed via Prepare Alert Payload and delivered through Gmail. Every workflow execution is automatically logged to a rebalance_log sheet for comprehensive audit tracking.

Use cases

• Commodity traders monitoring Gold, Silver, Oil, Copper, and Natural Gas allocations
• Investment managers maintaining balanced exposure across commodity sectors
• Portfolio analysts requiring automated drift detection and rebalancing alerts
• Financial advisors tracking multiple commodity-focused client portfolios

Technical details

Built with essential n8n nodes including if, set, code, gmail, merge, and sticky note components. The workflow seamlessly integrates Google Sheets for data storage, Gemini AI for intelligent alert generation, and Gmail for automated notifications.

Quick setup involves connecting Google Sheets, Gmail, and Gemini credentials, configuring your commodity holdings data, setting target allocations in the workflow settings, and creating the required rebalance_log sheet with tracking columns. The automated scheduler ensures continuous monitoring without manual intervention.