{"product_id":"n8n-workflow-telegram-channel-intelligence-w-apify-openai","title":"n8n Workflow: Telegram Channel Intelligence w\/ Apify \u0026 OpenAI","description":"\u003ch3\u003eTurn public Telegram channels into scored intelligence—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow runs hourly (or on-demand) to scrape posts from public Telegram channels using \u003cstrong\u003eApify\u003c\/strong\u003e, batch-analyze them with \u003cstrong\u003eOpenAI\u003c\/strong\u003e against your intelligence goal, save qualified results to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and send a concise digest to a \u003cstrong\u003eTelegram chat\u003c\/strong\u003e—while preventing duplicate delivery.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSchedules and ledger setup:\u003c\/strong\u003e Executes on an hourly schedule (or manually) and ensures a “delivery-ledger” table exists to track what has already been processed.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBuilds the Apify request:\u003c\/strong\u003e Reads the list of public Telegram channel handles, along with analysis thresholds and limits, validates inputs, and constructs the Apify Actor payload.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScrapes and normalizes posts:\u003c\/strong\u003e Starts the \u003cstrong\u003eApify Telegram Channel Posts Scraper\u003c\/strong\u003e, downloads the dataset, normalizes post fields, and generates a stable key per post.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBatch scoring with OpenAI:\u003c\/strong\u003e Filters out posts already present in the delivery ledger, then sends the remaining posts to \u003cstrong\u003eOpenAI\u003c\/strong\u003e in one structured batch for relevance scoring, summaries, and “why it matters” notes.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets + Telegram digest:\u003c\/strong\u003e Keeps only posts meeting the minimum relevance score, upserts them into a Google Sheets tab, formats a Telegram digest of the top items, and sends it to a Telegram chat.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDuplicate prevention:\u003c\/strong\u003e Records evaluated post keys in the delivery ledger so future runs skip them.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eMonitor multiple public Telegram channels for topics relevant to your SaaS, research, or market intelligence goals.\u003c\/li\u003e\n  \u003cli\u003eGenerate a daily\/weekly-style briefing automatically via Telegram digest, backed by OpenAI scoring.\u003c\/li\u003e\n  \u003cli\u003eOperationalize Telegram intelligence into a searchable Google Sheets pipeline with deduplication.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApify integration:\u003c\/strong\u003e Add your Apify API token as HTTP Header Auth and ensure Actor \u003cstrong\u003eIXhSSJjFf5fz1XAir\u003c\/strong\u003e is available.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenAI integration:\u003c\/strong\u003e Provide an OpenAI API credential and choose a model for the batch analysis node.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets:\u003c\/strong\u003e Requires a prepared Google Sheets template (make your own copy).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow nodes mentioned:\u003c\/strong\u003e \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003eset\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, \u003cstrong\u003etelegram\u003c\/strong\u003e, \u003cstrong\u003edata table\u003c\/strong\u003e, \u003cstrong\u003esticky note\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45755360968883,"sku":"N8N-17734","price":51.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/3GBpU75fTNio5s7zAzy7Z_oAmkEQVu.png?v=1785661340","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-telegram-channel-intelligence-w-apify-openai","provider":"N8N Commerce","version":"1.0","type":"link"}