Export Telegram Posts to Google Sheets via n8n & Apify

Export public Telegram channel posts into Google Sheets—automatically with n8n + Apify

This n8n workflow scrapes public Telegram channel posts using Apify and upserts them into Google Sheets as clean, deduplicated rows—so you always have an organized spreadsheet of posts, timestamps, links, and engagement metrics.

What this workflow does

• Runs manually or on a schedule (daily at 09:00).
• Reads your configured list of `public Telegram channel handles` plus maximum post limits per channel and per run.
• Validates and normalizes channel handles, then builds the input payload for the Apify Telegram Channel Posts Scraper Actor.
• Starts the Apify actor run, waits for completion, and downloads the resulting dataset items.
• Deduplicates posts and formats each post into spreadsheet-ready fields (including hyperlinks, dates, subscriber counts, and engagement metrics).
• Appends or updates rows in Google Sheets using a stable “Post key”, ensuring reruns refresh existing posts instead of creating duplicates.

Use cases

• Track and analyze daily Telegram announcements from multiple public channels in one Google Sheet.
• Build a lightweight reporting pipeline for engagement metrics (views/forwards/likes, etc.) without manual copy-paste.
• Maintain an always-current archive of channel posts for marketing ops, community management, or SaaS analytics.

Technical details

• Nodes / components: set, code, sticky note, http request, google sheets, manual trigger.
• Apify integration: uses an Apify API token passed via HTTP Header Auth in the Apify HTTP Request steps.
• Google Sheets integration: uses OAuth2 to write to your chosen spreadsheet and sheet tab.
• Configuration: update channel handles and post limits in the initial configuration step.