Send a daily stock movers and news email digest via Google Sheets, EODHD and Gmail

Description

What this workflow does

This workflow automatically generates a daily stock market email digest, combining price movements and recent financial news into a clean, actionable report.

Instead of manually checking charts and news every morning, this workflow does it for you.

It combines:
Market data from EODHD APIs
Financial news with sentiment analysis
Smart processing using JavaScript (no raw data overload)
✉️ Automated email delivery via Gmail

Only relevant insights reach your inbox.

How it works (overview)
The workflow runs on a schedule (daily at 7 AM) or manually
It reads your stock watchlist from Google Sheets
It fetches:
Historical price data (last 14 days)
Latest news (last 7 days)
JavaScript processes the data:
Calculates daily % change
Filters recent news
Assigns sentiment (positive / neutral / negative)
A clean HTML email is generated
The digest is sent automatically via Gmail

👉 The result: a complete market snapshot in seconds

How to configure it
EODHD APIs (Market Data)
Add your API key in the ⚙️ Config node
Used for:
Price data
Financial news
Sentiment signals
Google Sheets
Add your credentials
Create a column named ticker
Add one stock per row (e.g. AAPL, TSLA, MSFT)
Gmail
Add your Gmail credentials
Set your recipient email
Schedule
Default: runs daily at 7 AM
You can adjust it easily in the Schedule node

Why this workflow is powerful

Most people:

Check multiple sites every morning
Waste time jumping between charts and news
Miss important market moves

This workflow:

✔ Automates everything
✔ Centralizes data
✔ Adds context with sentiment analysis
✔ Saves hours every week

📊 Data powered by EODHD APIs

This workflow uses EODHD APIs to retrieve:

Historical stock prices
Financial news
Sentiment indicators

👉 If you want to build your own financial automations, dashboards, or trading workflows:

Get started here (10% discount):
https://eodhd.com/pricing-special-10?via=kmg&ref1=Meneses

Final result

You get a daily email like this:

Top movers (price changes)
Curated news per stock
Sentiment insights
Clean, readable format

All generated automatically.