n8n Market News Summarizer: Gemini to Discord Webhook

Get a clean Discord “market brief” every 6 hours—plus on-demand queries via Webhook

n8n Market News Summarizer: Gemini to Discord Webhook automatically collects market and finance news from multiple sources, summarizes the latest headlines with Google Gemini, and posts a Discord-ready update to your admin channel. It also exposes a webhook command interface for on-demand lookups (market, stock, gold, USD/INR, and recent news) backed by n8n Data Tables.

What this workflow does

• Scheduled summaries (every 6 hours): Loads the latest stored market snapshot from an n8n Data Table, then fetches fresh USD/INR, gold price, and major index data from public APIs (including Yahoo Finance).
• Failure handling: Normalizes responses into a single metrics object and sends an alert to a Discord admin channel if all market sources fail.
• News aggregation + deduplication: Pulls RSS feeds from RBI, Economic Times Markets, Livemint Markets, CNBC Markets, and US Federal Reserve press releases, merges them, filters recent items, and removes duplicates using previously sent records in an n8n “sent news” Data Table.
• Gemini-based summarization: Builds a prompt containing market figures and shortlisted headlines, requests a JSON output summary from Google Gemini, and formats a finance update message for Discord.
• Persistence for future runs: Posts to Discord, upserts the new market snapshot into an n8n Data Table, and records sent news items for future command queries.
• Webhook command interface: Accepts POST requests on a webhook endpoint, parses a chat-style command, fetches the requested data (market/stock/compare/beststock/gold/usd/news/help), and posts the result.

Use cases

• Wallboard-style finance updates for operators: one automated Discord brief with market + deduped news.
• On-demand market intelligence: answer “USD/INR”, “gold”, or “recent news” questions via webhook commands.
• Resilient monitoring: notify admins when market sources fail, while still maintaining stored snapshots.

Technical details (n8n)

• Scheduling: runs every 6 hours
• Integrations: Discord, Google Gemini, Yahoo Finance, RSS sources, public FX/gold APIs
• Core nodes used: if, code, no op, merge, switch, discord
• State management: n8n Data Tables for market snapshots and “sent news” deduplication
• Webhook endpoint: command parsing and dynamic lookups via POST requests