Detect client portfolio news impact with Gemini AI, Gmail, and Google Sheets
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 21 nodes and runs on a schedule (every day at 08:00). Along the way it connects Google Gemini, Gmail and Google Sheets. It also calls newsapi.org over HTTP.
How it runs
Trigger: On a schedule (every day at 08:00).
- Fetch Client Dataset (Google Sheets): uses Google Sheets
- Fetch Already Processed Articles (Google Sheets): uses Google Sheets
- Fetch Latest Finance News (HTTP Request): calls newsapi.org
- Build Client Dataset Array (Code): runs custom JavaScript code
- Build Logged URL List (Code): runs custom JavaScript code
- Check If News Articles Exist (If): checks a condition and branches into true / false
- Split News Articles (Code): runs custom JavaScript code
- Process Articles One-by-One (Loop Over Items (Split in Batches)): loops over the items in batches
- Check If Article Already Logged (Code): runs custom JavaScript code
- Check If Article Is New (If): checks a condition and branches into true / false
…plus 10 more steps. See the full node list below.
Services it uses
HTTP calls to: newsapi.org
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (10)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - HTTP Request
n8n-nodes-base.httpRequest - Google Gemini
@n8n/n8n-nodes-langchain.googleGemini - Edit Fields (Set)
n8n-nodes-base.set - If
n8n-nodes-base.if - Gmail
n8n-nodes-base.gmail - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Wait
n8n-nodes-base.wait
From the author
Client Portfolio News Impact Detection with AI & Gmail This workflow automatically fetches the latest business news, analyzes its impact on clients using AI and sends alerts for high-impact articles while logging all processed data in Google Sheets. It…