Broadcast rate-limited Telegram messages from Google Sheets via Jitterflow
UnknownWhat this workflow does
This workflow has 27 nodes and runs on Telegram events (message) (plus 2 other triggers). Along the way it connects Telegram, Google Sheets and Jitterflow (community).
How it runs
Trigger: On Telegram events (message) (plus 2 other triggers).
- Bot replies (Edit Fields (Set)): sets 7 fields: chatId, name, username…
- Read broadcasts (Google Sheets): uses Google Sheets
- List undelivered messages (Jitterflow): list (dlq)
- Which command? (Switch): routes items into 2 branches
- Ready to send (Filter): keeps only the items that match a condition
- Telegram messages only (Filter): keeps only the items that match a condition
- Save subscriber (Google Sheets): append or update
- Mark unsubscribed (Google Sheets): update
- Reply: unsubscribed (Telegram): uses Telegram
- Reply: how to subscribe (Telegram): uses Telegram
…plus 14 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that n8n-nodes-jitterflow is verified or supports 3.0 (used in Queue message for subscriber, List undelivered messages, Clear DLQ entry).
Nodes used (11)
- Telegram Trigger
n8n-nodes-base.telegramTrigger - Edit Fields (Set)
n8n-nodes-base.set - Switch
n8n-nodes-base.switch - Google Sheets
n8n-nodes-base.googleSheets - Telegram
n8n-nodes-base.telegram - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Filter
n8n-nodes-base.filter - Limit
n8n-nodes-base.limit - If
n8n-nodes-base.if - Jitterflow
n8n-nodes-jitterflow.jitterflow - Aggregate
n8n-nodes-base.aggregate
From the author
Quick overview This workflow manages Telegram bot subscribers in Google Sheets and broadcasts messages from a sheet using Jitterflow to rate-limit delivery with retries and deduplication, plus a daily cleanup that marks blocked or missing chats based on…