Library / AI Agents & Assistants
AI Agents & Assistants
Send daily AI briefings from Postgres to Telegram with OpenAI
On a schedule, it runs an AI agent with OpenAI / ChatGPT and Claude using Postgres, Telegram.
What it does
## Daily AI briefing from Postgres to Telegram Every morning this workflow reads pending approvals, overdue follow-ups and your pipeline from PostgreSQL, checks two services, and asks an AI agent (OpenAI) to write a short, prioritised briefing that lands in Telegram. ### Setup 1. Add Postgres, OpenAI and Telegram credentials. 2. Fill in the Config node (chat ID and the two health URLs). 3. Adapt the three SQL queries to your own tables. 4. Change the schedule if 08:00 does not suit you. ### Limitations - The SQL assumes action_logs and contacts tables; edit the queries for your schema. - A service counts as DOWN on any HTTP error or timeout (10 s). - Any chat model works: swap the OpenAI node for Gemini, Claude or a local model. - AI output is not stored; Telegram messages are limited to 4096 characters.
The steps
- Every day at 08:00
- Pending approvals
- Overdue follow-ups
- Pipeline summary
- Check service A health
- Check service B health
- Summarise service status
- Write the briefing
- OpenAI model
- Send to Telegram
- Config
Similar automations
Reports, Analytics & DashboardsCreate Weekly Animal Rights Briefings from U.S. House Bills18 stepsCRM & Sales PipelineGenerate live sales demo briefings from HubSpot, web research, Slack and Sheets with20 stepsReports, Analytics & DashboardsSend Daily Portfolio Stock News Briefings to Telegram7 stepsAI Agents & AssistantsSend daily LinkedIn hiring trend voice notes with Apify, DeepSeek, ElevenLabs, Telegram31 steps