This automation turns a Telegram bot into a standalone AI agent capable of receiving queries, conducting research, generating structured PDF reports, and managing user data. It’s ideal for those who want to offload repetitive information gathering and formatting tasks.
## Who it´s for
- Telegram bot owners needing automated report generation
- Analysts requesting up-to-date data via messenger
- Startups automating client reports with pay-per-query models
- Developers integrating AI agents into chatbots
- Managers handling knowledge management via Telegram
## What the automation does
- Receives text queries from users in Telegram
- Triggers LangChain agents to search information via Perplexity API
- Generates detailed HTML reports using OpenAI
- Converts HTML to PDF via PDFco API
- Sends the PDF report back to the user in Telegram
- Updates or creates user records in Supabase and Postgres
- Maintains conversation context using Postgres Chat Memory
- Manages wallet balance for paid operations
- Can be triggered by cron schedule for bulk reporting
## What´s included
- Ready-to-use n8n workflow
- Trigger logic: incoming Telegram message and cron schedule
- Integrations with Telegram, Supabase, Postgres, Perplexity API, PDFco, OpenAI
- Basic access control and wallet management logic
- Text guide for setup and adaptation
## Requirements for setup
- n8n account with webhook access
- Telegram bot with API token
- Supabase project with user tables
- PostgreSQL database for chat memory storage
- API keys: OpenAI, Perplexity, PDFco
## Benefits and outcomes
- Fully autonomous query processing without human intervention
- Fast delivery of professional reports in convenient PDF format
- Monetization potential via wallet balance tracking and paid queries
- Conversation history retention for personalized interaction
- Integration with databases for user management and analytics
- Scalability: one template can serve thousands of users
- Automatic data sync in Supabase and Postgres
## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via в чате.
Telegram bot
PDF report generation
automated research reports
AI agent on Telegram
Perplexity API integration
LangChain agents
Supabase wallet management
PostgreSQL chat memory
user query processing
OpenAI Telegram integration
automated analytics workflow
Supabase data update
PDFco API conversion
on-demand report request
research automation agent
No feedback yet