{"product_id":"daily-ai-news-digest-to-slack-openai-postgresql-n8n-workflow","title":"Daily AI News Digest to Slack: OpenAI + PostgreSQL n8n Workflow","description":"\u003ch3\u003eGet a daily AI executive briefing directly in Slack—backed by NewsAPI + OpenAI + PostgreSQL\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically pulls the latest AI and tech-startup articles from NewsAPI, analyzes them with OpenAI (gpt-4o-mini), stores unique insights in PostgreSQL, then posts a polished daily executive-style digest to your Slack channel.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns daily at 08:00\u003c\/strong\u003e using an n8n schedule trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches news\u003c\/strong\u003e from NewsAPI: retrieves the \u003cem\u003efive most recent\u003c\/em\u003e English articles that match your configured AI\/tech-startup keywords.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters relevant items\u003c\/strong\u003e by splitting the response into article items and keeping only those whose \u003cem\u003edescription\u003c\/em\u003e matches specified AI-related terms.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAnalyzes each article with OpenAI\u003c\/strong\u003e (gpt-4o-mini) to generate structured JSON insights: summary, category, sentiment, importance score, trend keywords, and “why it matters.”\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDeduplicates in PostgreSQL\u003c\/strong\u003e by checking whether the article URL already exists in the \u003ccode\u003eai_news\u003c\/code\u003e table—then inserts only new articles.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates a daily digest\u003c\/strong\u003e by aggregating stored items into a daily payload (including top trend keywords) and asking OpenAI to write an executive digest based strictly on that payload.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePosts to Slack\u003c\/strong\u003e the generated digest plus the number of processed articles and the top trends list.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS operators tracking AI and startup developments without manual searching\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers building a reliable \u003cstrong\u003edaily AI news digest\u003c\/strong\u003e pipeline for a team channel\u003c\/li\u003e\n  \u003cli\u003eLeaders who want executive-ready summaries of trending AI themes, delivered automatically\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations \/ nodes:\u003c\/strong\u003e Schedule Trigger, HTTP (NewsAPI), IF, Code, Merge, OpenAI (gpt-4o-mini), PostgreSQL (e.g., Supabase Postgres), Slack, plus Sticky Note for workflow documentation.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRequired setup:\u003c\/strong\u003e configure a NewsAPI API key, add OpenAI credentials for both OpenAI steps, and set up PostgreSQL connectivity.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003eIdeal for n8n automation workflows where you want structured AI insights, deduped storage, and a Slack-ready daily briefing.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45978900627635,"sku":"N8N-19367","price":33.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/0oBSmmcqBuaXPV6CK83x__OYwpCcBR.png?v=1788858423","url":"https:\/\/buyflowscripts.com\/products\/daily-ai-news-digest-to-slack-openai-postgresql-n8n-workflow","provider":"N8N Commerce","version":"1.0","type":"link"}