Send daily AI news digest to Slack with OpenAI and PostgreSQL
Ready for 3.0What this workflow does
This AI workflow has 13 nodes and runs on a schedule (every day at 08:00). Along the way it connects OpenAI, Postgres and Slack. It also calls newsapi.org over HTTP.
How it runs
Trigger: On a schedule (every day at 08:00).
- Fetch Latest News Articles (HTTP Request): calls newsapi.org
- Process Individual Articles (Code): runs custom JavaScript code
- Filter AI Related News (If): checks a condition and branches into true / false
- Analyze News with AI (OpenAI): uses OpenAI
- Merge: merges the data from its input branches
- Parse AI Analysis Response (Code): runs custom JavaScript code
- Check Existing Articles (Postgres): run a query
- Validate Duplicate Articles (If): checks a condition and branches into true / false
- Store News Insights (Postgres): uses Postgres
- Prepare Daily Digest Payload (Code): runs custom JavaScript code
…plus 2 more steps. See the full node list below.
Services it uses
HTTP calls to: 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 (8)
- HTTP Request
n8n-nodes-base.httpRequest - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - OpenAI
@n8n/n8n-nodes-langchain.openAi - Merge
n8n-nodes-base.merge - Postgres
n8n-nodes-base.postgres - Slack
n8n-nodes-base.slack
From the author
Quick overview This workflow runs daily to fetch AI-related articles from NewsAPI, analyzes each one with OpenAI, stores unique insights in PostgreSQL, then generates an executive-style daily digest and posts it to a Slack channel. How it works 1. Runs every…