📈 Send monthly gold SIP performance insights with Google Sheets, Groq, Slack and Gmail
⚡ 38 views · 📈 Crypto Trading & Stock Market
Description
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 (<= -10%), profit-booking suggestion (>= 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
- Modify conditions in
-
AI Prompt
- Customize prompt in
AI Agent - Change tone, length, or analysis depth
- Customize prompt in
-
Slack Message Format
- Edit message template in
Send Slack Notification
- Edit message template in
-
Email Template
- Customize HTML in
Send Email Report
- Customize HTML in
-
Calculation Logic
- Modify JS code in
SIP Calculations
- Modify JS code in
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.
🔗 Nodes Used
Google Sheets, HTTP Request, Slack, Gmail, Schedule Trigger, AI Agent
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File