Latenode
Google sheets
Google AI

Automate stock sentiment analysis with EODHD News API and Google Gemini

This automated workflow leverages the Google Gemini AI model to analyze news sentiment for a list of stock tickers, providing actionable insights to help investors, traders, and financial analysts make informed decisions.

It fetches the latest news articles from the EODHD News API, processes them through the sentiment analysis model, and writes the results (ticker, sentiment score, rationale) to a Google Sheet. This solution is designed for those who want to automate the monitoring of market news and sentiment to stay ahead of the curve.

Updated Apr 12, 2026Est. run: 26sEst. cost: $0.0703
How Latenode estimates time and cost

Latenode bills workflow runs in credits: 1 credit = 30 seconds of processing. Minimum charge per run depends on your plan. Plug-and-Play (PnP) AI nodes are billed separately—each PnP token is $1 USD, charged pay-as-you-go at vendor cost plus a small processing fee, with no API keys required.

Full pricing — how credits work →
AI agents & chatbots

Workflow preview

What this template does

  • Fetches the latest news articles from the EODHD News API for a list of stock tickers.
  • Analyzes the sentiment of news articles using the Google Gemini AI model.
  • Writes the ticker, sentiment score, and rationale to a Google Sheet.
  • Provides actionable insights for investors, traders, and financial analysts.
  • Automates the monitoring of market news and sentiment to stay ahead of the curve.

How it works

1
Trigger

Read Stock Tickers from Google Sheet

The workflow starts by fetching a list of stock tickers from a Google Sheet. This provides the initial set of stock symbols that will be analyzed for news sentiment.

2
Logic

Iterate Over Tickers

For each stock ticker in the list, the workflow will perform the following steps to analyze the news sentiment.

3
Action

Fetch News Articles from EODHD API

The workflow uses the EODHD News API to retrieve the latest news articles for the current stock ticker being processed.

4
Logic

Validate Ticker

Before proceeding with sentiment analysis, the workflow checks if the current stock ticker is valid. If the ticker is invalid, the information is added to the Google Sheet.

5
AI

Analyze Sentiment with Google Gemini

The news articles for the valid stock ticker are passed through the Google Gemini AI model to perform sentiment analysis. The model provides a sentiment score and rationale for each article.

6
Action

Format Sentiment Analysis Results

The sentiment analysis results (ticker, sentiment score, and rationale) are processed and formatted to be written to the Google Sheet.

7
Action

Write Sentiment Data to Google Sheet

The formatted sentiment analysis results are added to the Google Sheet, providing a centralized record of the news sentiment for each stock ticker.

Setup guide

1

Add EODHD News API Credential

1. In the Latenode Credentials panel, add a new credential for the EODHD News API. 2. Enter your EODHD News API key in the credential settings.

2

Configure Google Gemini Node

1. In the Latenode visual builder, add a Google Gemini node. 2. In the node settings, select the appropriate Google Gemini model for sentiment analysis. 3. Map the input data (news articles) to the node's required input fields.

3

Add Google Sheets Credential

1. In the Latenode Credentials panel, add a new credential for Google Sheets. 2. Authorize Latenode to access your Google Sheets account.

4

Configure Google Sheets Node

1. In the Latenode visual builder, add a Google Sheets node. 2. In the node settings, specify the Google Sheets document and worksheet where you want to write the sentiment analysis results. 3. Map the sentiment analysis data (ticker, score, rationale) to the appropriate Google Sheets columns.

5

Configure Stock Tickers Input

1. In the Latenode visual builder, add a data input node or a Google Sheets node to read the list of stock tickers. 2. Ensure the input data is structured as a list or array of stock tickers.

Requirements

EODHD News API key to fetch the latest news articles
Google Cloud Platform (GCP) account with access to the Google Gemini AI service
Google Sheets account and access to create a new spreadsheet to store the analysis results
Permissions to access the EODHD News API and Google Gemini AI service within your GCP project
For providers without a native connector in Latenode, use the JavaScript step with that service's API credentials (stored in Latenode Keys / Secrets).

FAQ

Common questions about this template

Each run uses credits on your Latenode plan. We charge for processing time (1 credit = 30 seconds). Your actual cost depends on your plan and how long the run takes. See pricing plans for plans and how credits work.
Contact support →

More templates

You might also like

Browse all templates →
AI agents & chatbots

Automate Slack messaging with OpenAI GPT-3 completions

This automation allows users to automatically generate and send Slack messages based on specific prompts or triggers, leveraging the power of OpenAI's GPT-3 API. The automation is designed for AI, agents, and chatbot enthusiasts who want to create dynamic and personalized Slack communications without manual intervention. The automation connects to the Slack API and OpenAI's GPT-3 API to generate and send messages in response to defined triggers, such as specific keywords or phrases. This can be useful for automating routine updates, responding to customer inquiries, or generating creative content for Slack channels.

26s$0.0703
AI agents & chatbots

Transcribe Google Drive audio to text and send via email

This automation template helps users transcribe audio files stored in their Google Drive using the OpenAI Whisper AI model, and then automatically deliver the transcribed text via email. It provides a convenient way to convert audio recordings into text-based content that can be easily shared and referenced. The workflow is manually triggered, requiring the user to specify the Google Drive folder containing the audio files. The template then retrieves the files, transcribes them using the OpenAI Whisper API, and constructs an email message with the transcribed text, which is then sent to the designated recipient.

8s$0.0005
AI agents & chatbots

Automate Google Ads copywriting across multiple campaigns

This automation solution allows users to generate Google Ads headlines and descriptions directly within Google Sheets, using the OpenAI API to automate the ad copywriting process across multiple campaigns. The tool streamlines ad creation by leveraging AI-powered text generation, enabling marketers to efficiently produce high-performing ad copy at scale. By integrating with Google Sheets and the OpenAI API, this solution simplifies the ad creation workflow, saving time and improving campaign performance.

26s$0.0703