Monitor Telegram channel intelligence with Apify, OpenAI, Google Sheets, and Telegram
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 20 nodes and runs on a schedule (every hour) (plus 1 other trigger). Along the way it connects OpenAI, Google Sheets and Telegram. It also calls api.apify.com over HTTP.
How it runs
Trigger: On a schedule (every hour) (plus 1 other trigger).
- Ensure Delivery Ledger (Data table): create (table)
- 1. Configure Channel Intelligence (Edit Fields (Set)): sets 6 fields: channels, Intelligence Goal, Minimum Relevance Score…
- Validate Channels and Build Actor Input (Code): runs custom JavaScript code
- 2. Run Telegram Channel Posts Scraper (HTTP Request): calls api.apify.com (POST)
- Download Telegram Post Results (HTTP Request): calls an HTTP API
- Normalize Public Telegram Posts (Code): runs custom JavaScript code
- Keep Undelivered Posts (Data table): row not exists
- Build One Intelligence Batch (Code): runs custom JavaScript code
- 3. Analyze Telegram Posts in One Batch (OpenAI): uses OpenAI
- Validate Intelligence Results (Code): runs custom JavaScript code
…plus 8 more steps. See the full node list below.
Services it uses
HTTP calls to: api.apify.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (10)
- Manual Trigger
n8n-nodes-base.manualTrigger - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Data table
n8n-nodes-base.dataTable - Edit Fields (Set)
n8n-nodes-base.set - Code
n8n-nodes-base.code - HTTP Request
n8n-nodes-base.httpRequest - OpenAI
@n8n/n8n-nodes-langchain.openAi - If
n8n-nodes-base.if - Google Sheets
n8n-nodes-base.googleSheets - Telegram
n8n-nodes-base.telegram
From the author
Quick overview This workflow runs hourly (or manually) to scrape posts from public Telegram channels via Apify, batch-scores them with OpenAI against an intelligence goal, saves qualified items to Google Sheets, and sends a short digest to a Telegram chat…