Skip to content
NEWMarketplace and the trig8n Agent: sell what you build, and get plans and changes that are tested before you see them. See what is new

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

  1. Every day at 08:00
  2. Pending approvals
  3. Overdue follow-ups
  4. Pipeline summary
  5. Check service A health
  6. Check service B health
  7. Summarise service status
  8. Write the briefing
  9. OpenAI model
  10. Send to Telegram
  11. Config

Similar automations