AutomationMart
Home/Browse/Automated stock sentiment analysis with Google Gemini and EODHD News API
n8n

Automated stock sentiment analysis with Google Gemini and EODHD News API

n8nn8n12 modulesv1.0
Google SheetsGemini

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 investment decisions. This workflow is designed for investors, traders, and financial analysts who want to automate the process of monitoring news and gauging market sentiment for specific stocks. It seamlessly integrates with Google Sheets fo

At a glance

Automated stock sentiment analysis with Google Gemini and EODHD News API is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Google Sheets, Gemini. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Google Sheets, Gemini
Modules
12
Price
Free
Version
v1.0
Automated stock sentiment analysis with Google Gemini and EODHD News API workflow diagram

About this workflow

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 investment decisions. This workflow is designed for investors, traders, and financial analysts who want to automate the process of monitoring news and gauging market sentiment for specific stocks. It seamlessly integrates with Google Sheets for input and output, making it easy to track a portfolio of stocks. Key Features & Benefits Automated Daily Analysis: The workflow is triggered daily, providing you with fresh sentiment analysis just in time for the market open. Dynamic Stock Tracking: Easily manage your list of tracked stocks from a simple Google Sheet. AI-Powered Insights: Utilizes Google Gemini's sophisticated language model to analyze news content for its potential impact on stock prices, including a sentiment score and a detailed rationale. Comprehensive News Aggregation: Fetches the latest news articles from EODHD for each of your specified stock tickers. Error Handling & Validation: Includes built-in checks for invalid stock tickers and formats the AI output for reliable data logging. Centralized Reporting: Automatically logs the sentiment score, rationale, and date into a Google Sheet for easy tracking and historical analysis. How It Works This workflow follows a systematic process to deliver automated sentiment analysis: 1. Scheduled Trigger: The workflow begins each day at a specified time. 2. Fetch Stock Tickers: It reads a list of stock tickers from your designated Google Sheet. 3. Loop and Fetch News: For each ticker, it retrieves the latest news articles using the EODHD API. 4. AI Sentiment Analysis: The collected news articles are then passed to a Google Gemini-powered AI agent. The agent is prompted to act as a stock sentiment analyzer, evaluating the news and generating: A sentiment score from -1 (strong negative) to 1 (strong positive). A detailed rationale explaining the basis for the score. 5. Data Formatting & Validation: The AI's output is parsed and validated to ensure it is in the correct JSON format. 6. Log to Google Sheets: The final sentiment score and rationale are appended to your Google Sheet, alongside the corresponding stock ticker and the current date. Nodes Used Schedule Trigger Google Sheets SplitInBatches HttpRequest (EODHD) If Code (JavaScript) AI Agent (LangChain) Google Gemini Chat Model This workflow is a valuable tool for anyone looking to harness the power of AI for financial market analysis. Deploy this automated solution to save time, gain a competitive edge, and make more data-driven trading decisions.

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

Create AI generated videos 4x cheaper than veo3 with Google Sheets & Fal.AI

Turn Your Ideas into Videos—Right from Google Sheets! This workflow helps you make cool 5-second videos using Fal.AI and Kling 2.1, just by typing your idea into a Google Sheet. You can even choose if you want your video to have sound or not. It’s super easy—no tech skills needed! And the best? 4x Cheaper than Veo3 model with similar quality! Why use this? Just type your idea in a sheet—no fancy tools or uploads. Get a video link back in the same sheet. Works with or without sound—your choice!

Free

BrowserAct Flipboard News Scraper & Google Sheets Sync

This template provides a fully automated workflow for collecting news from Flipboard and saving it into Google Sheets. The process starts with BrowserAct, which opens the Flipboard page, scrolls through the content, and extracts each article’s title, summary, reference link, and image. The raw output is then parsed through a JSON module to convert the data into a clean, structured format. Next, the workflow creates a new sheet named with the completion timestamp, ensuring each run is organized a

Free

Send weekly personalized pet health tips with GPT-4o-mini, Gmail and Google Sheets

Send personalized pet care tips from Google Sheets with AI Automate weekly pet wellness emails with AI-generated, location and age-specific advice. Who's it for Pet care businesses, veterinary clinics, pet subscription services, and animal shelters sending regular wellness content to pet owners. How it works 1. Loads pets data from Google Sheets 2. Filters pets who haven't received email in 7+ days 3. Calculates age from birthdate (formats as "2 years and 3 months

Free

Add new Inoreader articles to Google Sheets as rows

Stay organized and never miss important updates by automatically tracking articles from Inoreader and logging them into Google Sheets. With this template, every time a new article is published in your Inoreader feed, Make will seamlessly add a new row in your Google Sheets, allowing you to maintain a comprehensive archive of articles for easy reference and analysis. Perfect for researchers, content curators, or anyone looking to streamline their reading list!

Free

AI-powered HR interview system with BeyondPresence

What problem does it solve? Manual candidate screening is time-consuming and inconsistent. This workflow automates initial interviews, providing 24/7 availability, consistent questioning, and objective assessments for every candidate. Who is it for? - HR teams handling high-volume recruiting - Small businesses without dedicated recruiters - Companies scaling their hiring process - Remote-first organizations needing asynchronous screening What this workflow does Creates AI interviewers from job d

Free

Batch archive TikTok videos from links in Google Sheets to Google Drive

This template helps you archive TikTok videos from a Google Sheets list into Google Drive in an organized way. How it works Reads rows from the Tasks sheet where status = PENDING and tiktok_url is not empty. Calls the Apify Actor liul/tiktok-video-audio-downloader to fetch video metadata and a downloadable video URL. Downloads the video and uploads it to Google Drive into a daily subfolder named YYYY-MM-DD under your chosen parent folder. Generates a shareable link for the uploaded file. U

Free

Convert 3-view drawings to 360° videos with GPT-4o-Image and Kling API

What this workflow does? This workflow converts orthographic three-view drawings into 360° rotation videos through PiAPI's GPT-4o-Image and Kling APIs (unofficial). The workflow could be set with our 3D Figurine Orthographic Views workflow for generation. Who is the workflow for? - Designers: Generate inspiration into 3D designs and make them spin to gain concrete details in a efficient way. - Online shoppers: Show protential products from all angles in videos and preview overall texture of mod

Free

Cv resume PDF parsing with multimodal vision AI

This n8n workflow demonstrates how we can use Multimodal LLMs to parse and extract from PDF documents in n8n. In this particular scenario, we're passing a candidate's CV/resume to an AI which filters out unqualified applications. However, this sneaky candidate has added in hidden prompt to bypass our bot! Whatever will we do? No fret, using AI Vision is one approach to solve this problem... read on! How it works Our candidate's CV/Resume is a PDF downloaded via Google Drive for this demonstrati

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint — instant download
  • Setup guide PDF included
  • 5 downloads · valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free