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 `twelve_api_key`. 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 changes. The `AI Market Insights` node then feeds this to Groq. You must select your Groq credentials in the attached `Insights` model node. **6. Final Delivery** The `Parse AI Output` node uses Regex to strictly format the AI's response. Finally, the `Log Daily Market Report` node saves the record and the `Send Today's market summary` node emails you the results. ## How To Customize Nodes * **Wait Node (API Throttle):** If you have a premium TwelveData API plan with higher rate limits, you can reduce or remove the 15-second wait time to make the workflow run instantly. * **AI Market Insights:** You can edit the System Message to change the AI's output tone or request additional sections (like "Crypto Outlook") if you add crypto tickers to your watchlist. * **Send Today's market summary:** The current email format is plain text. You

Platform

n8n

Category

Data & Analytics

Price

Free

Creator

Matt Buds

• Google Sheets
• HTTP Request
• If
• Edit Fields (Set)
• Loop Over Items (Split in Batches)
• Gmail
• Wait
• Code
• AI Agent
• Groq Chat Model