{"product_id":"gdelt-news-spike-scanner-w-gemini-sheets-slack","title":"GDELT News Spike Scanner w\/ Gemini, Sheets \u0026 Slack","description":"\u003ch3\u003eDetect unusual news spikes—then get Gemini market analysis in Slack \u0026amp; Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003eGDELT News Spike Scanner w\/ Gemini, Sheets \u0026amp; Slack\u003c\/strong\u003e workflow runs daily to scan GDELT News for your chosen theme, flags one-day news-volume spikes, and uses \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e to generate a sector + ticker impact analysis—automatically logged to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e and sent as an alert in \u003cstrong\u003eSlack\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cp\u003eBuilt for n8n automation, the workflow performs these steps:\u003c\/p\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDaily scheduled run:\u003c\/strong\u003e Executes every day at the configured hour using a schedule trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eQuery GDELT for your theme:\u003c\/strong\u003e Builds a GDELT query using your theme, sector, and watchlist tickers, then requests a \u003cstrong\u003e1-day news timeline\u003c\/strong\u003e from the \u003cstrong\u003eGDELT Doc API\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCompute spike vs baseline:\u003c\/strong\u003e Calculates the latest news-volume value, derives a \u003cstrong\u003e7-day baseline\u003c\/strong\u003e from prior timeline points, and flags a spike when it exceeds the \u003cstrong\u003e50% threshold\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eClassify the event:\u003c\/strong\u003e Assigns severity (\u003cstrong\u003eLOW \/ MEDIUM \/ HIGH\u003c\/strong\u003e) and categorizes the event based on theme keywords.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerate AI analysis with Gemini:\u003c\/strong\u003e Sends event metrics to \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e to produce a JSON output with event summary, narrative, sector impact, ticker-by-ticker impacts, market implication, and disclaimer.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLog and notify:\u003c\/strong\u003e Appends metrics + Gemini analysis to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e for historical tracking, then posts a formatted \u003cstrong\u003eSlack\u003c\/strong\u003e message to the selected channel.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eMonitor specific themes (e.g., regulation, geopolitical events) for sudden news surges that may affect a sector.\u003c\/li\u003e\n  \u003cli\u003eTrack a watchlist of tickers and receive instant Slack alerts with AI-generated impact commentary.\u003c\/li\u003e\n  \u003cli\u003eMaintain an auditable spike history in Google Sheets for backtesting or reporting.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e GDELT Doc API, \u003cstrong\u003eGoogle Gemini (PaLM\/AI Studio)\u003c\/strong\u003e, \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, \u003cstrong\u003eSlack\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes mentioned:\u003c\/strong\u003e if, set, code, merge, slack, sticky note\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup:\u003c\/strong\u003e Configure Gemini credentials + model, connect Google Sheets (spreadsheet ID + sheet tab; ensure columns exist or let n8n create them), and connect Slack credentials.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46192866492595,"sku":"N8N-20462","price":15.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/dZBbAeW2pHPDfHOoR7Q2m_4R4hq5FD.png?v=1791537735","url":"https:\/\/buyflowscripts.com\/products\/gdelt-news-spike-scanner-w-gemini-sheets-slack","provider":"N8N Commerce","version":"1.0","type":"link"}