Generate daily investment ideas with Yahoo Finance and Google Gemini

AI-Powered Daily Investment Idea Generator via Yahoo Finance & Gemini This workflow serves as your personal quantitative analyst. It automatically fetches your active watchlist, grabs real-time prices and breaking news from Yahoo Finance and uses Google Gemini AI to analyze the data and highlight the top 2 to 3 daily investment opportunities. Quick Implementation Steps: 1. Import the Workflow: Copy the provided JSON and paste it directly into your n8n canvas. 2. Set Up Credentials: Add your Google Gemini API key to the Google Gemini Chat Model node. 3. Configure Data Tables: Ensure you have two n8n Data Tables ready—one for your Watchlist and one for the Daily Ideas output. 4. Activate: Toggle the workflow to "Active" so the Schedule Trigger runs automatically at 8:00 AM every day. What It Does This automated system takes the manual labor out of daily market research. Every morning, a Schedule Trigger wakes the workflow up and immediately connects to your internal n8n Data Table to pull a list of financial assets (like crypto or stocks) that you actively want to monitor. Once the watchlist is loaded, the workflow loops through each ticker individually. It sends direct requests to public Yahoo Finance endpoints to gather the most recent trading prices, market charts and top news headlines. A packaging node neatly formats this raw data so that nothing gets lost or overwritten as the loop continues through your entire list. After all tickers are processed, the workflow bundles the packaged data into a comprehensive market report. This report is handed off to a Google Gemini AI Agent equipped with a strict financial analyst prompt. The AI evaluates the news sentiment and catalysts, identifies the most compelling investment setups and formats them into a clean JSON structure. Finally, a code node processes the AI's output and logs the finalized ideas directly into your database for easy reading. Who It's For This workflow is perfect for day traders, crypto enthusiasts, financial analysts and data-driven investors. If you spend hours every morning reading news headlines and checking stock prices to find the best trading setups, this automation acts as an invaluable, time-saving assistant. Requirements to use this workflow To successfully run this workflow, you will need: An active account of n8n (must support Advanced AI nodes and internal Data Tables). A Google Gemini API Key (or an alternative LLM like Groq/OpenAI, if you choose to swap the model node). Active internet access to reach the Yahoo Finance API endpoints. Two pre-configured n8n Data Tables to handle the input (Watchlist) and output (Daily Ideas). How It Works & Set Up Setting up this workflow involves understanding the data flow and configuring your environment to prevent execution errors. 1. Data Table Schemas For smooth data retrieval and storage, your n8n Data Tables must be structured correctly: Input Table (Watchlist): Must contain a Status column (used to filter for "Active" items) and a Ticker column (e.g., BTC-USD, AAPL). Output Table (Daily Ideas): Must contain four string columns exactly matching the AI's output: Ticker, IdeaTitle, CatalystSummary and ConvictionLevel. 2. Yahoo Finance API Considerations The workflow utilizes public, undocumented Yahoo Finance endpoints (query1.finance.yahoo.com and query2.finance.yahoo.com). While these do not require an explicit API key, they are subject to strict rate limits. Making hundreds of rapid, back-to-back requests can result in a temporary IP ban (HTTP 429 errors). Keep your active watchlist size manageable (under 50 items) or introduce a brief Wait node inside the loop if you are processing massive lists. 3. Execution Flow The Schedule Trigger initiates the run at 8 AM. The Get Tickers from Watchlist node filters your database for "Active" assets. The Loop Over Items node pushes one ticker at a time to the HTTP Request nodes. The Packager node maps the complex Yahoo JSON responses into clean variables (Price Data,