Send monthly gold SIP performance insights with Google Sheets, Groq, Slack and Gmail
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 15 nodes and runs on a schedule (every month at 09:00). Along the way it connects Groq Chat Model, Google Sheets, Slack and Gmail. It also calls api.metalpriceapi.com over HTTP.
How it runs
Trigger: On a schedule (every month at 09:00).
- Fetch Gold Price (HTTP Request): calls api.metalpriceapi.com
- Read Investment History (Google Sheets): uses Google Sheets
- Alert Gold Fetch Error (Slack): uses Slack
- SIP Calculations (Code): runs custom JavaScript code
- Decision Engine (Switch): routes items into 3 branches
- Prepare Loss Alert (Edit Fields (Set)): sets 12 fields: alertType, alertTitle, decisionMessage…
- Prepare Profit Booking (Edit Fields (Set)): sets 10 fields: alertType, alertTitle, decisionMessage…
- Prepare Neutral Status (Edit Fields (Set)): sets 10 fields: alertType, alertTitle, decisionMessage…
- Merge: merges the data from its input branches
- AI Agent: runs an AI agent, with model: Groq Chat Model
…plus 3 more steps. See the full node list below.
Services it uses
HTTP calls to: api.metalpriceapi.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (11)
- Groq Chat Model
@n8n/n8n-nodes-langchain.lmChatGroq - Schedule Trigger
n8n-nodes-base.scheduleTrigger - HTTP Request
n8n-nodes-base.httpRequest - Google Sheets
n8n-nodes-base.googleSheets - Slack
n8n-nodes-base.slack - Code
n8n-nodes-base.code - Switch
n8n-nodes-base.switch - Edit Fields (Set)
n8n-nodes-base.set - AI Agent
@n8n/n8n-nodes-langchain.agent - Gmail
n8n-nodes-base.gmail - Merge
n8n-nodes-base.merge
From the author
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 1. Runs…