Collect public Telegram channel posts into Google Sheets
- Level Intermediate
- Setup1–3 hrs (estimated)
- Evidence Anecdotal
- CostNot stated in source
- No-codeNo
What they did
An n8n workflow collects public Telegram channel posts into a sheet for a news tracker, matching rows by post ID so a failed import can be retried without duplicates: importing 34 posts twice left 34 rows.
How it went
Specific test (34 posts x2 = 34 rows). Uses the author's paid Actor (~$0.03 per 25 posts)
Worth knowing
- Specific test (34 posts x2 = 34 rows). Uses the author's paid Actor (~$0.03 per 25 posts).
- FLAG: uses the poster's paid Apify Actor (disclosed).
Prompt
Cleaned version rewritten from the source — not a direct quote.
Every [morning], collect new posts from these public Telegram channels: [list]. Add one row per post to [sheet] with date, channel, text and link, matched on post ID so nothing is duplicated. If the sheet step fails, retry the same batch.
Recommended
Try it in Grok Bot
- Copy the prompt (button below).
- Open Grok Bot chat and paste it. Replace any [bracketed] placeholders.
- Connect the listed tools (Google Sheets, Telegram) as connectors when Grok Bot asks.
- If the task repeats, ask: "Make this a daily routine."
Alternatives: the same prompt works in n8n, Claude, ChatGPT Agent, OpenClaw.
Set it up
Tools: Google Sheets, Telegram · Stack: n8n + Apify + Google Sheets
- Read the original source for full context.
- Connect the tools your agent needs.
- Paste the prompt and replace [bracketed] placeholders.
- Run once manually and check the output before scheduling it.
Generic suggested steps, not from the source.
Evidence
Specific test (34 posts x2 = 34 rows). Uses the author's paid Actor (~$0.03 per 25 posts)
Source: Web · Verified by us: not yet · Report broken or outdated