Scan GDELT news spikes with Gemini and log analysis to Sheets and Slack

Quick overview This workflow runs daily to query the GDELT News API for a chosen theme, detects unusual one-day news-volume spikes, uses Google Gemini to generate a market-impact analysis for a sector and watchlist tickers, logs the results to Google Sheets, and posts an alert to Slack. How it works 1. Runs every day at the configured hour using a schedule trigger. 2. Builds a GDELT query for the configured theme, sector, and watchlist tickers, then requests a 1-day news timeline from the GDELT Doc API. 3. Calculates the latest news-volume value, computes a 7-day baseline from prior timeline points, and flags the event if the spike exceeds the 50% threshold. 4. For detected spikes, assigns a severity level (LOW/MEDIUM/HIGH) and classifies the event category based on theme keywords. 5. Sends the event metrics to Google Gemini to produce a JSON analysis including an event summary, narrative, sector impact, ticker-by-ticker impacts, market implication, and disclaimer. 6. Appends the combined spike metrics and Gemini analysis to a Google Sheets log for historical tracking. 7. Posts a formatted Slack message with the spike details and AI analysis to the selected channel. Setup 1. Add a Google Gemini (PaLM/AI Studio) API credential and select the Gemini model you want to use. 2. Connect Google Sheets credentials, and set the target spreadsheet/document ID and sheet tab, ensuring the columns used by the workflow exist (or allow n8n to create them). 3. Connect Slack credentials and choose the channel where the alert should be posted. 4. Update the monitored theme, sector, and ticker list (and optionally the spike threshold in code) to match what you want to track. Additional info Add-ons The current workflow already combines scheduled monitoring, GDELT data collection, statistical spike detection, event classification, Gemini analysis, Google Sheets logging, and Slack alerting. The following are potential extensions that can be added to expand its usage: Email Alerts Add an email notification after event analysis so important alerts can also be delivered through email. Multiple Themes Run multiple themes through the workflow instead of monitoring only one configured theme. For example, separate monitoring could be created for different sectors or event categories. Additional Data Sources Add other news or market-data sources alongside GDELT to provide additional information before the Gemini analysis stage. Historical Trend Analysis Store historical results and compare current event activity against longer-term historical patterns. Database Storage Replace or supplement Google Sheets with a database for larger-scale event history and querying. Advanced Alert Rules Add conditions based on: - Severity - Spike percentage - Event type - Specific ticker impact - Sector impact This can help reduce unnecessary notifications. Dashboard Integration Connect the stored event data to a reporting or dashboard system to visualize event trends over time. Multi-Channel Notifications Add additional notification channels so different teams can receive alerts through their preferred communication system. These are extension ideas only. They are not part of the current workflow JSON. Use Case Examples 1. Semiconductor Export Monitoring The current workflow configuration monitors: text Theme: semiconductor export Sector: Semiconductors Tickers: NVDA, AMD, TSM, INTC, AVGO It can detect a significant increase in news activity around semiconductor exports and use Gemini to assess the potential impact on the configured watchlist. 2. Energy Event Monitoring The event classification logic supports themes containing oil or energy. A suitable configured theme can therefore be used to identify news spikes related to energy events and classify them as: text ENERGY 3. Supply Chain Monitoring Themes containing shipping or supply are classified as: text SUPPLY CHAIN This can be used to monitor unusual news activity around supply-chain-related themes. 4. Sector-Specifi