Announce to everyone who subscribed on Telegram
People opt in with /subscribe, their chat is kept in Baserow, and your /announce goes out to all of them at once.
What it does
Each integration step this workflow runs, in order, what it is for, and the conditions and loops that decide when it runs.
- 1
TelegramNew message triggerStarts a run whenever anyone messages your bot, so subscribe, unsubscribe and announce commands are all picked up. - 2
BaserowList rowsReads the subscriber table to find who is already on the list and which rows belong to the sender. If
commandis “/subscribe”- 3
BaserowCreate rowAdds a row holding the chat ID, Telegram username and time of subscribing when someone sends /subscribe in a direct message. - 4
TelegramSend messageSends the announcement to every subscriber's chat, and replies to the sender with confirmations, refusals and the delivery report.
Otherwise, if
commandis “/unsubscribe”For each
myRowId- 5
BaserowDelete rowRemoves every row for the sender's chat when they send /unsubscribe, so they are off the next announcement.
- 5
- 6
TelegramSend message
Otherwise
For each
recipientId- 7
TelegramSend message
- 7
- 8
TelegramSend message
- 3
How it works
What happens on each run, in plain English.
Whenever someone messages your Telegram bot, the workflow looks for one of three commands. A /subscribe sent in a private chat adds that person to a Baserow table, /unsubscribe removes them straight away, and /announce from you sends whatever you typed after it to everyone on the table, each in their own chat with the bot. Any other message is left alone.
Your announcement goes out word for word, with one fixed line under it telling people how to unsubscribe, and no AI touches it. Only you can send one, and only from a direct message, so an /announce typed by anyone else is refused. A /subscribe from a group chat is refused rather than signing up the whole group. A chat stored twice is messaged once, one run reaches a limited number of people, and you get a report saying how many were reached and how many could not be delivered.
Before the first run you need a Telegram bot and a Baserow table with three columns named 'ChatId', 'Name' and 'Subscribed'.
Start from a workflow that already works.
Add "Announce to everyone who subscribed on Telegram" to your workspace, connect its apps, and make it yours. No credit card required.
Free plan available · No credit card required
