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

Go to Workflow
0 views
Built by Kevin Meneses Kevin Meneses
Created on March 24, 2026

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.

This workflow was created by Kevin Meneses and shared publicly on the n8n community template library. n8nFind indexes it for discovery — the workflow remains the property of its original creator.

Nodes Used (4)

Code
n8n-nodes-base.code
Gmail
n8n-nodes-base.gmail
Google Sheets
n8n-nodes-base.googleSheets
HTTP Request
n8n-nodes-base.httpRequest