Automated stock sentiment analysis with Google Gemini and EODHD News API
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 12 nodes and runs on a schedule (every day at 16:00). Along the way it connects Google Gemini Chat Model and Google Sheets. It also calls eodhd.com over HTTP.
How it runs
Trigger: On a schedule (every day at 16:00).
- Read_tickers_from_Sheet (Google Sheets): uses Google Sheets
- loop_over_tickers (Loop Over Items (Split in Batches)): loops over the items in batches
- Get articles from EODHD (HTTP Request): calls eodhd.com
- If: checks a condition and branches into true / false
- Write_in_google_sheets_invalid_ticker (Google Sheets): append
- join_articles_into_ (Code): runs custom JavaScript code
- AI Agent: runs an AI agent, with model: Google Gemini Chat Model
- format_output_as_json (Code): runs custom JavaScript code
- If: checks a condition and branches into true / false
- write_sentiment_to_sheets (Google Sheets): append
Services it uses
HTTP calls to: eodhd.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (8)
- AI Agent
@n8n/n8n-nodes-langchain.agent - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - HTTP Request
n8n-nodes-base.httpRequest - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - Code
n8n-nodes-base.code - Schedule Trigger
n8n-nodes-base.scheduleTrigger
From the author
Stay ahead of the market with this powerful, automated workflow that performs real-time sentiment analysis on stock market news. By leveraging the advanced capabilities of Google Gemini, this solution provides you with actionable insights to make informed…