Generate a daily multi-asset market report with TwelveData, Groq and Google Sheets

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 the normalized data into a Groq-powered AI (Llama-3). The AI generates a professional, institutional-grade market summary which is then automatically logged in Google Sheets and emailed to your inbox. Quick Implementation Steps 1. Import the Workflow: Upload the JSON file into your n8n workspace. 2. Add Your Keys: In the Environment Config node, paste your TwelveData API key. 3. Connect Accounts: Authenticate your Google Sheets, Gmail and Groq API credentials in their respective nodes. 4. Prepare the Sheet: Create a Google Sheet with two tabs ("Sheet1" for reports, "Error logs" for failures) matching the column headers defined in the Google Sheets nodes. 5. Execute: Click "Test Workflow" (or trigger it manually) to fetch data and receive your daily snapshot. What It Does This workflow acts as an automated quantitative analyst. It starts by establishing your target asset watchlists across three categories: Indices (e.g., SPY, QQQ), Forex (e.g., EUR/USD) and Commodities (e.g., Gold, Oil). It breaks these lists down and carefully queues them up to fetch daily pricing from the TwelveData API. To ensure it doesn't overwhelm the API and get blocked, it uses a batching system with a built-in 15-second throttle. As data flows in, the workflow actively monitors for errors. If an API call fails or hits a hard limit, it instantly logs the failure details into an "Error logs" Google Sheet and sends an emergency failure alert via Gmail. Successfully fetched data is normalized into a clean format, calculating daily percentage changes and basic bullish/bearish trends. Finally, the cleaned dataset is passed to a Llama-3 AI agent via Groq. Instructed to act as a macro strategist, the AI parses the numbers to generate a structured snapshot including a market summary, key movers, risk sentiment and actionable outlook. A custom script safely extracts these exact sections, logs the complete report into your main Google Sheet for historical tracking and delivers the final formatted text straight to your Gmail. Who’s It For This automation is ideal for - day traders, - macro analysts, - portfolio managers, - and financial newsletter writers. It is exceptionally useful for anyone who spends the first hour of their morning manually checking tickers and writing up market summaries to share with a team or clients. Requirements to Use This Workflow An active n8n instance. A TwelveData API Key for fetching real-time/daily financial market data. A Groq API account to utilize the Llama-3 language model. A Google Workspace account to authenticate both Google Sheets and Gmail nodes. A Google Sheet pre-configured with the exact column headers expected by the workflow. How It Works & How To Set Up 1. Configure the Environment Open the Environment Config node and input your twelveapikey. The base API URL is already set up for you. 2. Define Your Watchlist Open the Set Market Assets node. Here you will see comma-separated lists for Indices, Forex and Commodities. You can replace these ticker symbols with any standard symbols supported by TwelveData. 3. API Throttling & Fetching The Rate Controlled Queue node processes one ticker at a time, followed by a 15-second API Throttle wait. This ensures you comply with free-tier or basic API limits. The Fetch Asset Prices node automatically constructs the HTTP request for each symbol. 4. Error Handling Pipeline The Validate API Response node checks if the TwelveData response status is "ok". If not, the workflow branches downward, logging the specific error code and symbol to your Google Sheet and sending a localized Gmail alert, before continuing the loop. 5. AI Processing & Normalization Once all loops finish, the Normalize Market Data node calculates the price chan