Generate a daily multi-asset market report with TwelveData, Groq and Google Sheets
Ready for 3.0What this workflow does
This AI workflow has 17 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Groq Chat Model, Gmail and Google Sheets.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Environment Config (Edit Fields (Set)): sets 2 fields: api_base_url, twelve_api_key
- Set Market Assets (Edit Fields (Set)): sets 3 fields: Indices, Forex, Commodities
- split assests & Symbols (Code): runs custom JavaScript code
- Rate Controlled Queue (Loop Over Items (Split in Batches)): loops over the items in batches
- Normalize Market Data (Code): runs custom JavaScript code
- API Throttle (Wait): waits 15 seconds
- AI Market Insights (AI Agent): runs an AI agent, with model: Insights
- Fetch Asset Prices (HTTP Request): calls an HTTP API
- Parse AI Output (Code): runs custom JavaScript code
- Validate API Response (If): checks a condition and branches into true / false
…plus 5 more steps. See the full node list below.
Services it uses
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)
- Edit Fields (Set)
n8n-nodes-base.set - AI Agent
@n8n/n8n-nodes-langchain.agent - Groq Chat Model
@n8n/n8n-nodes-langchain.lmChatGroq - Code
n8n-nodes-base.code - Gmail
n8n-nodes-base.gmail - Manual Trigger
n8n-nodes-base.manualTrigger - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Wait
n8n-nodes-base.wait - Google Sheets
n8n-nodes-base.googleSheets - HTTP Request
n8n-nodes-base.httpRequest - If
n8n-nodes-base.if
From the author
Multi-Asset Daily Market Snapshot This workflow fully automates the creation of a daily multi-asset market report. It retrieves live pricing data for specified indices, forex pairs and commodities using the TwelveData API, manages rate limits safely and feeds…