Latenode
Google Sheets
JavaScript
Gemini

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 May 8, 2026Est. run: 25sEst. cost: $0.0016
How Latenode estimates time and cost

Latenode bills workflow runtime in CPU seconds. The first 10,000 CPU seconds are free each month, then usage follows pay-as-you-go CPU-second pricing. 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 CPU seconds 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.

17s$0.0011
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.

17s$0.0011
AI agents & chatbots

Automate WhatsApp responses with AI or predefined logic

The proposed automation system enables users to receive and respond to WhatsApp messages using a conversational AI or predefined logic. The system ingests incoming WhatsApp messages, processes them through AI-powered natural language understanding or pre-configured response rules, and then automatically sends relevant text responses back to the user. This solution is designed to help businesses and individuals efficiently manage their WhatsApp communications without the need for manual intervention, streamlining customer service or personal messaging workflows.

8s$0.0005