{"product_id":"export-telegram-posts-to-google-sheets-via-n8n-apify","title":"Export Telegram Posts to Google Sheets via n8n \u0026 Apify","description":"\u003ch3\u003eExport public Telegram channel posts into Google Sheets—automatically with n8n + Apify\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow scrapes public Telegram channel posts using \u003cstrong\u003eApify\u003c\/strong\u003e and upserts them into \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e as clean, deduplicated rows—so you always have an organized spreadsheet of posts, timestamps, links, and engagement metrics.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns manually or on a schedule\u003c\/strong\u003e (daily at \u003cstrong\u003e09:00\u003c\/strong\u003e).\u003c\/li\u003e\n  \u003cli\u003eReads your configured list of `public Telegram channel handles` plus \u003cstrong\u003emaximum post limits\u003c\/strong\u003e per channel and per run.\u003c\/li\u003e\n  \u003cli\u003eValidates and normalizes channel handles, then builds the \u003cstrong\u003einput payload\u003c\/strong\u003e for the \u003cstrong\u003eApify Telegram Channel Posts Scraper Actor\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eStarts the Apify actor run, waits for completion, and downloads the resulting \u003cstrong\u003edataset items\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDeduplicates posts\u003c\/strong\u003e and formats each post into spreadsheet-ready fields (including \u003cstrong\u003ehyperlinks\u003c\/strong\u003e, \u003cstrong\u003edates\u003c\/strong\u003e, subscriber counts, and \u003cstrong\u003eengagement metrics\u003c\/strong\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends or updates rows\u003c\/strong\u003e in Google Sheets using a stable \u003cstrong\u003e“Post key”\u003c\/strong\u003e, ensuring reruns refresh existing posts instead of creating duplicates.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eTrack and analyze daily Telegram announcements from multiple public channels in one Google Sheet.\u003c\/li\u003e\n  \u003cli\u003eBuild a lightweight reporting pipeline for engagement metrics (views\/forwards\/likes, etc.) without manual copy-paste.\u003c\/li\u003e\n  \u003cli\u003eMaintain an always-current archive of channel posts for marketing ops, community management, or SaaS analytics.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes \/ components\u003c\/strong\u003e: set, code, sticky note, http request, google sheets, manual trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApify integration\u003c\/strong\u003e: uses an \u003cstrong\u003eApify API token\u003c\/strong\u003e passed via HTTP Header Auth in the Apify HTTP Request steps.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets integration\u003c\/strong\u003e: uses \u003cstrong\u003eOAuth2\u003c\/strong\u003e to write to your chosen spreadsheet and sheet tab.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eConfiguration\u003c\/strong\u003e: update channel handles and post limits in the initial configuration step.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45755361001651,"sku":"N8N-17733","price":62.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/Vhh9NtJAQEvM06pEQzhby_V9Wkro1G.png?v=1785661361","url":"https:\/\/buyflowscripts.com\/products\/export-telegram-posts-to-google-sheets-via-n8n-apify","provider":"N8N Commerce","version":"1.0","type":"link"}