Daily AI Briefing: Postgres → Telegram via n8n & OpenAI

Get a prioritized daily status briefing in Telegram—automatically

This n8n workflow checks your PostgreSQL action logs, verifies two HTTP service health endpoints, and uses OpenAI to generate a short, urgency-ordered daily briefing—then posts it to your Telegram chat every morning at 08:00.

What this workflow does

• Scheduled run: Executes daily at 08:00 (configurable for your timezone/routine).
• PostgreSQL query pack: Fetches up to 10 action logs pending approval, up to 10 overdue follow-ups, and a pipeline status breakdown.
• Service health check: Calls two HTTP endpoints and converts their responses into a single UP/DOWN service status summary.
• AI-generated briefing: Sends the PostgreSQL results + service status summary to OpenAI to produce a plain-text bullet briefing, capped at 15 lines and ordered by urgency.
• Telegram delivery: Posts the generated briefing directly to your configured Telegram chat ID.

Use cases

• SaaS ops updates: Daily reminders of approvals, overdue follow-ups, and pipeline movement.
• Reliability monitoring: Quick “UP/DOWN” awareness for two critical services via HTTP health endpoints.
• Team standups without meetings: Share a consistent daily AI summary in Telegram for faster triage.

Technical details

• n8n nodes/tools: set, code, postgres, http request, telegram, and sticky note.
• Required credentials: PostgreSQL, OpenAI API key (chat model), Telegram bot token.
• Configuration points: Update the three SQL queries to match your tables/fields; set the two health-check URLs; set the Telegram chat ID.

Ideal if you want an n8n automation workflow that turns Postgres + service health + OpenAI into an actionable Telegram daily briefing.