This template runs on a schedule, reads stock tickers from Google Sheets, fetches the latest headlines from the EODHD News API in JavaScript, and asks Gemini for a sentiment score and rationale.
It then appends ticker, score, and rationale to the sheet. Connect Google Sheets and Google AI. Put the Google AI API key on the Google AI connection. Put the EODHD API key in that JavaScript node.
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 →Workflow preview
The scenario starts at the time you set, then reads the ticker list from Google Sheets.
JavaScript calls the EODHD News API for the current ticker. Put the EODHD API key in that JavaScript node.
Gemini reads the headlines and returns a sentiment score plus a short rationale. Put the Google AI API key on the Google AI connection.
Google Sheets gets a new row with ticker, score, and rationale.
Add a Google Sheets connection. Use one sheet for tickers and one for results, or one sheet with both tabs. Read the ticker column, then append result rows.
Add a JavaScript node that calls the EODHD News API for each ticker. Put the EODHD API key in that JavaScript node.
Add a Google AI connection and paste your Google AI API key there. Send Gemini the headlines and ask for a score and rationale.
Add a schedule trigger, for example each weekday after the close in your timezone. Run once and confirm ticker, score, and rationale land on the sheet.
FAQ
More templates
This template starts when someone mentions your Slack bot, sends the message text to ChatGPT, and posts the reply in that channel. Use it for status updates or a channel assistant. Put the Slack bot token on the Slack connection. ChatGPT is Latenode AI, so you do not paste an OpenAI key.
This template starts when you add a row in Google Sheets with product, keywords, and landing page. ChatGPT writes headlines and descriptions. JavaScript sends that copy to the Google Ads API, then Sheets stores the copy on the same row. Connect Google Sheets. ChatGPT is a Latenode AI step, so you do not paste an OpenAI key. Put the Google Ads developer token in the JavaScript node.
This template receives an incoming WhatsApp Business Cloud message on a Latenode webhook, pulls the text and sender phone in JavaScript, detects intent with Google Dialogflow ES, and sends the reply with WhatsApp Business Cloud. Connect WhatsApp Business Cloud and Dialogflow. Put the Cloud API token on the WhatsApp connection and the Google key on the Dialogflow connection.
