All work
ruen
Telegram
Case study · Telegram bot

Content bot: posts with sales links

A bot for bloggers, shops and experts. The owner builds an audience right inside the bot, without a channel, and sends it posts with link buttons to a product, booking or payment. Everything is managed from an admin menu inside Telegram — no dashboard or website needed.

I want a bot like this
0 dashboards
managed entirely in Telegram — no website or separate admin panel
1 button
under each post leads to a product, booking or payment
Scheduled
a delayed post goes out to every subscriber on its own, right on time
Your base
subscribers stay with you, and you can message anyone in one tap
The problem

Channel reach keeps dropping, but you need to sell every day

Not every subscriber sees channel posts, product links get lost in the text, and posting an announcement on time means sitting with your phone in hand. It's unclear which subscribers are active and who is worth a personal message.

The content bot delivers each post to every subscriber's DMs, puts a sales button under the text, publishes on schedule and shows who received the broadcast.

Creating a post

A post with a button in a minute

Text, photo or video, with or without a caption. A link button goes under the post: “View”, “Buy”, “Book”. Before sending there's a preview where you can edit the post, send it now, schedule it or save it as a draft.

  • button text up to 64 characters
  • the bot adds https:// to links without a protocol
  • edit content or button right from the preview
Post preview with a “View” button and an action menu
Drafts

Got an idea — save it, finish later

Unfinished posts live in drafts with their creation date. Open any of them, finish it and send it or put it on the schedule.

  • draft list with dates
  • pick up right where you left off
  • send or schedule from a draft
Draft list with creation dates
Scheduled publishing

The announcement goes out on time, even when you're busy

Date and time go in one line — for example, 02.11.2026 14:00. At the right moment the bot sends the post to every subscriber on its own.

  • date and time in one line
  • time zone set for the owner
  • a separate list of scheduled posts
Scheduling a post for a date and time
History

Every post — with dates and statuses

History shows each post: sent, scheduled or still a draft, when it was created and when it went out to subscribers.

  • statuses: sent, scheduled, draft
  • creation and send dates
  • the whole content history in one place
Post history with statuses and dates
Stats

See how many people actually got the post

Total subscribers, active and inactive, posts sent and scheduled. For the latest broadcast there's a report: recipients, delivered, errors, skipped.

  • active and inactive subscribers
  • sent and scheduled posts
  • a report on the latest broadcast
Subscriber and latest broadcast stats
Subscribers

Message anyone personally in one tap

A paginated subscriber list: name, username, activity status, ID. The username button opens the person's profile so you can message them right away — to answer a question or close a sale.

  • name, username, activity and ID
  • open the profile with a button
  • a personal line to every customer
Subscriber list with a link to each profile
What was built

A ready bot that can be deployed for any business

Admin menu in Telegram

The /admin command opens the menu for the owner only: create post, drafts, scheduled, history, users, stats.

Post builder

Text, photos and video, a link button, an editable preview, sending now, on schedule or to drafts.

Broadcast scheduler

Delayed publishing in the owner's time zone with a report on every broadcast.

Subscriber base

Activity tracking, a paginated list and a direct line to any subscriber.

Reliable setup

Python, aiogram 3 and PostgreSQL in Docker: auto-restart, database migrations, data in a separate volume, no domain required.

Grows with the task

Can add Telegram payments, segments and group broadcasts, a welcome funnel, base export and click stats.

Need a bot for your audience?

I'll build a Telegram bot for broadcasts, sales, bookings or support — around your processes. Describe your task on Telegram and I'll suggest options and an estimate.

Message me on Telegram