Quick overview
Quick overview This workflow runs monthly to fetch the latest gold price, calculate your gold SIP portfolio performance from Google Sheets history, generate advisory insights with Groq, and send a decision-based report to Slack and Gmail. How it works Runs on a monthly schedule trigger. Fetches the latest INR/XAU gold rate from MetalpriceAPI and sends a Slack alert if the price fetch fails. Reads your historical SIP transactions from Google Sheets. Calculates total invested amount, total grams accumulated, current portfolio value, average buy price, and P&L using the latest gold price. Classifies the month as a loss alert (= 25%), or neutral update and prepares the corresponding decision message. Sends the portfolio summary and decision context to a Groq chat model to generate concise actionable insights. Posts the final report to a Slack channel and emails an HTML report via Gmail. Setup Create a Google Sheet for SIP tracking and ensure it includes the columns used in the workflow (Date, SIPAmount, and Gold Price(1 gm)), then connect Google Sheets OAuth2 and set the target spreadsheet and sheet. Add a MetalpriceAPI key (replace the hard-coded api_key query parameter) and confirm the base/currencies settings match your needs. Add a Groq API credential and select the model you want to use for the AI insights. Connect Slack credentials and set the target channel IDs for both the error alert and the monthly report messages. Connect Gmail credentials, replace the placeholder recipient address, and review the email subject/body fields to match your preferred wording. Additional info How To Customize Nodes Decision Thresholds** Modify conditions in Decision Engine AI Prompt** Customize prompt in AI Agent Change tone, length, or analysis depth Slack Message Format** Edit message template in Send Slack Notification Email Template** Customize HTML in Send Email Report Calculation Logic** Modify JS code in SIP Calculations Add-ons & Enhancements Add WhatsApp notifications using Twilio Store historical reports in a database Add charts using Google Sheets or external tools Integrate with portfolio dashboards (React, Next.js) Add multi-user support for SaaS use case Add risk scoring and investment recommendations Use Case Examples Personal gold investment tracking with automated insights Financial advisor dashboards for multiple clients Monthly investment reporting automation for fintech apps AI-powered portfolio monitoring system Automated alerts for profit booking or dip buying Troubleshooting Guide | Issue | Possible Cause | Solution | |------|--------------|---------| | No data from Google Sheets | Wrong sheet format | Ensure correct column names and sheet ID | | API not working | Missing/invalid API key | Add valid MetalPrice API key | | Slack message not sent | Incorrect channel or token | Verify Slack credentials | | AI output empty | Groq API issue | Check API key and model config | | Wrong calculations | Incorrect sheet data | Validate SIPAmount and Gold Price values | Need Help? If you need help setting up this workflow, customizing it for your business or adding advanced features like dashboards, SaaS integration or AI enhancements, then our n8n experts at WeblineIndia are happy to help. Reach out to WeblineIndia for: Custom n8n workflow development AI-powered automation solutions Full-stack fintech platforms Workflow optimization & scaling Let us help you turn automation into real business value. An n8n automation workflow template by WeblineIndia.
WeblineIndia
web
free
No benchmark results have been added yet.