Generate weekly advisor talking points with Gemini, 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 14 nodes and runs on a schedule (every week at 08:00). Along the way it connects Google Gemini, Gmail and Google Sheets. It also calls alphavantage.co and newsapi.org over HTTP.
How it runs
Trigger: On a schedule (every week at 08:00).
- Fetch SPY Market Data (Alpha Vantage) (HTTP Request): calls alphavantage.co
- Fetch Top 5 Financial News Headlines (HTTP Request): calls newsapi.org
- Merge: merges the data from its input branches
- Set All Variables – Edit Here to Reconfigure (Edit Fields (Set)): sets 18 fields: advisorEmail, advisorName, firmName…
- Clean & Prepare Market Data (Code): runs custom JavaScript code
- Validate Data Before AI (If): checks a condition and branches into true / false
- Generate Weekly Briefing with Gemini (Google Gemini): uses Google Gemini
- Check – Did Gemini Return a Valid Response (If): checks a condition and branches into true / false
- Format AI Response as Clean HTML (Edit Fields (Set)): sets 11 fields: briefingHtml, advisorEmail, advisorName…
- Send Weekly Briefing Email via Gmail (Gmail): uses Gmail
…plus 1 more step. See the full node list below.
Services it uses
HTTP calls to: alphavantage.co, 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 - Merge
n8n-nodes-base.merge - Edit Fields (Set)
n8n-nodes-base.set - Google Gemini
@n8n/n8n-nodes-langchain.googleGemini - If
n8n-nodes-base.if - Gmail
n8n-nodes-base.gmail - No Operation, do nothing
n8n-nodes-base.noOp - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets
From the author
Weekly “Talking Points” Generator for Advisors This workflow automatically generates a weekly financial advisory briefing every Monday at 8 AM. It fetches live market data (SPY), collects top financial news, uses Google Gemini AI to generate client-ready…