Automated AI Stock Sentiment Analyzer
detail.loadingPreview
This workflow automates the crucial task of analyzing stock market news sentiment using AI. It fetches recent news for specified tickers, leverages Google Gemini to generate a sentiment score and rationale, and records the insights directly into a Google Sheet, saving hours of manual research.
About This Workflow
Dive into the future of financial analysis with this powerful n8n workflow. Designed to streamline your investment research, this bot automatically pulls a list of stock tickers from a Google Sheet, retrieves the latest news articles for each from EODHD, and then employs a sophisticated AI Agent powered by Google Gemini to perform in-depth sentiment analysis. The AI carefully evaluates news for its potential impact on stock prices, considering whether information is new or already priced-in, and provides a precise sentiment score along with a detailed rationale. All generated insights, including any invalid tickers, are meticulously logged back into your Google Sheet, offering a continuous, data-driven edge for your portfolio management.
Key Features
- AI-Powered Sentiment Analysis: Leverages Google Gemini (Gemini 2.0 Flash) for advanced, nuanced sentiment scoring (-1 to 1) and detailed rationales.
- Automated News Gathering: Automatically fetches the latest stock news (up to 10 articles) for specified tickers using the EODHD API.
- Google Sheets Integration: Seamlessly reads stock tickers from and writes comprehensive sentiment analysis results (including date, stock, score, and rationale) back to your Google Sheets.
- Market Efficiency Consideration: AI agent is explicitly prompted to analyze whether news is 'surprising' or 'already priced in' for a more accurate sentiment.
- Error Handling: Automatically logs "Invalid Ticker" for symbols where no news data can be retrieved.
How To Use
- Prepare Google Sheet: Create a Google Sheet with a column for 'ticker' where you list the stock symbols you want to analyze. Ensure the 'Read_tickers_from_Sheet' node is configured to read from this sheet and specific tab.
- Configure EODHD Credential: Set up your EODHD API key in the 'Get articles from EODHD' node as a 'Query Auth' credential.
- Configure Google Gemini Credential: Provide your Google Gemini API key in the 'Google Gemini Chat Model' node's credentials.
- Review AI Agent Prompt: The 'AI Agent' node is pre-configured with a detailed prompt for stock sentiment analysis. You can adjust the prompt for specific analysis nuances if needed.
- Set Output Google Sheet: Configure the 'Write_in_google_sheets_invalid_ticker' node (and any subsequent Google Sheets node for valid results) to append data to your desired output sheet, ensuring column headers match the output schema.
- Activate and Run: Activate the workflow. It will iterate through your tickers, fetch news, analyze sentiment, and populate your Google Sheet with results.
Apps Used
Workflow JSON
{
"id": "011aa648-45f2-42df-a194-2c7e7f8ed870",
"name": "Automated AI Stock Sentiment Analyzer",
"nodes": 6,
"category": "Operations",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: 011aa648-45f2...
About the Author
Crypto_Watcher
Web3 Developer
Automated trading bots and blockchain monitoring workflows.
Statistics
Related Workflows
Discover more workflows you might like
Google Sheets to Icypeas: Automated Bulk Domain Scanning
This workflow streamlines the process of performing bulk domain scans by integrating your Google Sheets data directly with the Icypeas platform. Automate the submission of company names from your spreadsheet to Icypeas for comprehensive domain information, saving valuable time and effort.
Instant WooCommerce Order Notifications via Telegram
When a new order is placed on your WooCommerce store, instantly receive detailed notifications directly to your Telegram chat. Stay on top of your e-commerce operations with real-time alerts, including order specifics and a direct link to view the order.
On-Demand Microsoft SQL Query Execution
This workflow allows you to manually trigger and execute any SQL query against your Microsoft SQL Server database. Perfect for ad-hoc data lookups, administrative tasks, or quick tests, giving you direct control over your database operations.