n8n Workflow: Repurpose Blog Posts to Social Packs (Telegram + Sheets)

Turn any blog link into a ready-to-post social pack—automatically (Telegram + Google Sheets)

This n8n workflow watches for Telegram messages with an article URL, extracts the page text, uses OpenAI to generate a social media content pack, saves everything to Google Sheets, and replies back in Telegram with key highlights—so you can repurpose content faster with less manual work.

What this workflow does

• Telegram trigger: Runs when a new Telegram message is received.
• URL validation: If the message doesn’t include an article URL, it replies with usage instructions.
• Fetch & extract content: Uses an HTTP request to fetch the page and extracts up to 10,000 characters of readable text.
• Error handling + logging: If too little text is retrieved, it writes the failure to the Google Sheets “Errors” tab and notifies you in Telegram that the page could not be read.
• OpenAI content generation: Sends the article URL and extracted text to an OpenAI chat model to produce a JSON social pack including:
  • LinkedIn post
  • Three X posts
  • Newsletter blurb
  • Hook
  • Pull quote
• Save results: Parses the AI output and appends the full pack to the Google Sheets “Packs” tab.
• Telegram preview: Replies with the hook, the LinkedIn post, and the first X post.

Use cases

• Send a blog URL in Telegram and instantly get social-ready copy for LinkedIn and X.
• Build a repeatable SaaS content engine: centralize generated packs in Google Sheets for approval and scheduling.
• Track failures when pages can’t be scraped and quickly retry with a working URL.

Technical details

• n8n nodes: if, set, merge, Telegram, HTTP Request, and a Sticky Note.
• OpenAI integration: Uses the gpt-4o-mini chat model (must be available in your OpenAI account).
• Google Sheets integration: Two tabs required—“Packs” and “Errors” (replace REPLACE_WITH_YOUR_SHEET_ID in both Google Sheets nodes).
• Requirement: Article pages must be publicly accessible.