Create a daily market brief from Google Sheets, Alpha Vantage, Reddit, OpenAI, and Slack

📊 Description

This workflow automatically creates a daily market intelligence brief for your stock portfolio. Instead of checking prices, news, and social media separately, it brings everything together into one clear update.
On a scheduled basis, the workflow reads your stock list from Google Sheets and processes each stock individually. It fetches the latest stock price data, recent market news, and investor sentiment from public sources. All this information is then analyzed by AI to identify what truly matters, filtering out noise and repeated information.
The AI generates a concise market summary that highlights overall sentiment, key drivers, risks, and one actionable insight for the day. The final result is sent directly to Slack as a clean, easy-to-read message, helping you stay informed without manual effort.
This workflow is ideal for anyone who wants a clear daily view of market conditions without spending hours monitoring multiple platforms.

⚙️ What This Workflow Does

• Runs automatically on a daily schedule
• Reads stock symbols from Google Sheets
• Fetches latest stock price data
• Collects recent market news
• Gathers investor sentiment from public discussions
• Uses AI to summarize market-moving signals
• Sends one actionable daily brief to Slack

✅ Key Benefits

• Saves time by automating market monitoring
• Reduces noise and highlights what actually matters
• Combines prices, news, and sentiment in one place
• Provides clear daily insights instead of raw data
• Easy to adjust for different portfolios or schedules

🧩 Features

• Scheduled daily execution
• Portfolio-based stock tracking
• Market news collection via RSS
• Social sentiment analysis from Reddit
• AI-driven market intelligence summary
• Structured output for alerts or reporting
• Slack integration for daily delivery

🔐 Requirements

• To use this workflow, you will need:
• Alpha Vantage API key for stock price data
• OpenAI account for AI analysis
• Google Sheets access for portfolio input
• Slack account for message delivery
• n8n instance (cloud or self-hosted)

🎯 Target Audience

• Stock investors
• Portfolio managers
• Market analysts
• Finance teams
• Founders and operators tracking markets
• Automation builders in finance