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.