📊 Send daily AI news digest to Slack with OpenAI and PostgreSQL
⚡ 15 views · 📊 Market Research & Insights
💡 Pro Tip — For competitive intelligence, ScraperNode can automate the data collection — Yelp reviews, Glassdoor company data, and Crunchbase profiles all return structured JSON you can feed straight into this workflow.
Description
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
- Runs every day at 08:00 using a schedule trigger.
- Queries NewsAPI for the five most recent English articles matching the configured AI and tech-startup keywords.
- Splits the API response into individual article items and keeps only articles whose description matches specified AI-related terms.
- Sends each retained article to OpenAI (gpt-4o-mini) to produce a structured JSON analysis including summary, category, sentiment, importance score, trend keywords, and “why it matters.”
- Combines the original article fields with the AI-generated insights, checks PostgreSQL to see if the article URL already exists, and inserts only new articles into the ai_news table.
- Aggregates the stored items into a daily payload with top trend keywords and asks OpenAI to write an executive digest based strictly on that payload.
- Posts the generated digest to Slack along with the number of processed articles and the top trends list.
Setup
- Provide a NewsAPI API key and set it in the HTTP request query parameter for apiKey.
- Add an OpenAI credential for the two OpenAI steps and confirm the selected model (gpt-4o-mini) is available in your account.
- Configure a PostgreSQL connection (for example Supabase Postgres) and ensure a public.ai_news table exists with columns used in the insert (article_url, headline, summary, category, importance_score, sentiment, trend_keywords, why_it_matters, source, image_url, published_at, content).
- Add a Slack credential and select the destination channel where the daily digest should be posted.
- Adjust the schedule time, NewsAPI query (q, language, pageSize), and any keyword filters to match your monitoring needs.
Additional info
Add-ons
The workflow can be extended further with:
- Email digest delivery
- Microsoft Teams notifications
- AI-powered sentiment dashboards
- Weekly or monthly digest generation
- Real-time breaking AI news alerts
- Web dashboard visualization
- Advanced trend scoring
- Multi-source RSS aggregation
- AI stock market tracking
- Topic-based digest segmentation
Use Case Examples
1. Internal AI Monitoring
Companies can automatically track AI industry developments and share daily insights with teams via Slack.
2. Startup Research
Founders can monitor AI competitors, funding announcements, product launches, and industry movements.
3. AI Content Research
Marketing and content teams can use summarized AI news for newsletters, blogs, and social media planning.
4. Executive Reporting
Leadership teams can receive concise AI industry summaries without manually reviewing multiple news websites.
5. Technology Trend Analysis
Researchers and analysts can identify trending AI technologies, companies, and market shifts automatically.
Additional use cases can be implemented depending on business requirements and workflow customization.
Troubleshooting Guide
| Issue | Possible Cause | Solution |
|---|---|---|
| No articles fetched | Invalid NewsAPI key | Verify API credentials |
| Empty AI analysis output | OpenAI quota or prompt issue | Check API usage and prompts |
| Duplicate articles inserted | Duplicate validation misconfigured | Verify IF node conditions |
| Slack messages not delivered | Invalid Slack credentials | Reconnect Slack integration |
| PostgreSQL insert fails | Table schema mismatch | Verify database columns |
| Trend analysis returns empty | Missing trend keywords | Validate OpenAI response format |
| JSON parse errors | Invalid AI response formatting | Enforce strict JSON prompt output |
| Workflow stops midway | Node execution failure | Review execution logs in n8n |
Need Help?
If you need assistance customizing or scaling this workflow, our expert n8n developers at WeblineIndia can help you with:
- n8n workflow customization
- AI automation development
- OpenAI integrations
- Supabase and PostgreSQL setup
- Slack and business integrations
- Enterprise workflow automation
- AI-powered reporting systems
- Production deployment support
Whether you need workflow enhancements, custom dashboards, advanced AI integrations or entirely new automation systems, WeblineIndia can help build scalable automation solutions tailored to your business needs.
🔗 Nodes Used
HTTP Request, Postgres, Slack, Schedule Trigger, OpenAI
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File