Monthly Gold SIP Insights via n8n: Google Sheets, Groq, Slack & Gmail

Get monthly gold SIP performance insights—automatically sent to Slack and your Gmail

This n8n workflow runs every month to pull the latest INR/XAU gold rate, calculate your gold SIP portfolio results from Google Sheets history, generate decision-based advisory insights using Groq, and deliver a polished HTML report to Slack and Gmail.

What this workflow does

• Monthly scheduled run: Triggered on a monthly schedule to keep your gold SIP tracking up to date.
• Fetch latest gold price: Retrieves the current INR/XAU gold rate via MetalpriceAPI. If the fetch fails, it sends an alert to a designated Slack channel.
• Read your SIP history from Google Sheets: Loads historical transactions from your sheet (including Date, SIPAmount, and Gold Price(1 gm)).
• Compute portfolio metrics: Calculates total invested amount, total grams accumulated, current portfolio value, average buy price, and P&L using the latest gold price.
• Classify the month + prepare a decision: Determines whether the month is a loss alert (<= -10%), suggests profit booking (>= 25%), or otherwise sends a neutral update.
• Generate actionable insights with Groq: Sends the portfolio summary and decision context to a Groq chat model to produce concise, actionable guidance.
• Deliver the report: Posts the final decision report to Slack and emails an HTML version via Gmail.

Use cases

• Automation engineers who want reliable, monthly gold SIP reporting in n8n.
• SaaS operators who want a clear example workflow combining Sheets + API + LLM + chat/email delivery.
• Investors who track gold SIP via Google Sheets and want P&L + decision guidance without manual work.

Technical details

• Triggers & logic: monthly schedule trigger, set, code, switch, merge
• Integrations: Google Sheets (OAuth2), MetalpriceAPI (INR/XAU), Groq, Slack, Gmail