{"product_id":"n8n-workflow-repurpose-blog-posts-to-social-packs-telegram-sheets","title":"n8n Workflow: Repurpose Blog Posts to Social Packs (Telegram + Sheets)","description":"\u003ch3\u003eTurn any blog link into a ready-to-post social pack—automatically (Telegram + Google Sheets)\u003c\/h3\u003e\n\u003cp\u003eThis 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.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTelegram trigger:\u003c\/strong\u003e Runs when a new Telegram message is received.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eURL validation:\u003c\/strong\u003e If the message doesn’t include an article URL, it replies with usage instructions.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetch \u0026amp; extract content:\u003c\/strong\u003e Uses an HTTP request to fetch the page and extracts up to \u003cstrong\u003e10,000 characters\u003c\/strong\u003e of readable text.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eError handling + logging:\u003c\/strong\u003e If too little text is retrieved, it writes the failure to the Google Sheets \u003cstrong\u003e“Errors”\u003c\/strong\u003e tab and notifies you in Telegram that the page could not be read.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenAI content generation:\u003c\/strong\u003e Sends the article URL and extracted text to an OpenAI chat model to produce a \u003cstrong\u003eJSON social pack\u003c\/strong\u003e including:\n    \u003cul\u003e\n      \u003cli\u003eLinkedIn post\u003c\/li\u003e\n      \u003cli\u003eThree X posts\u003c\/li\u003e\n      \u003cli\u003eNewsletter blurb\u003c\/li\u003e\n      \u003cli\u003eHook\u003c\/li\u003e\n      \u003cli\u003ePull quote\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSave results:\u003c\/strong\u003e Parses the AI output and appends the full pack to the Google Sheets \u003cstrong\u003e“Packs”\u003c\/strong\u003e tab.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTelegram preview:\u003c\/strong\u003e Replies with the hook, the LinkedIn post, and the first X post.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSend a blog URL in Telegram and instantly get social-ready copy for \u003cstrong\u003eLinkedIn\u003c\/strong\u003e and \u003cstrong\u003eX\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eBuild a repeatable SaaS content engine: centralize generated packs in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e for approval and scheduling.\u003c\/li\u003e\n  \u003cli\u003eTrack failures when pages can’t be scraped and quickly retry with a working URL.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes:\u003c\/strong\u003e \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003eset\u003c\/code\u003e, \u003ccode\u003emerge\u003c\/code\u003e, \u003cstrong\u003eTelegram\u003c\/strong\u003e, \u003cstrong\u003eHTTP Request\u003c\/strong\u003e, and a \u003cstrong\u003eSticky Note\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenAI integration:\u003c\/strong\u003e Uses the \u003cstrong\u003egpt-4o-mini\u003c\/strong\u003e chat model (must be available in your OpenAI account).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets integration:\u003c\/strong\u003e Two tabs required—\u003cstrong\u003e“Packs”\u003c\/strong\u003e and \u003cstrong\u003e“Errors”\u003c\/strong\u003e (replace \u003ccode\u003eREPLACE_WITH_YOUR_SHEET_ID\u003c\/code\u003e in both Google Sheets nodes).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRequirement:\u003c\/strong\u003e Article pages must be publicly accessible.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46042472382643,"sku":"N8N-19623","price":78.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/1qj1h5qBm9b11Q1bS65Us_Z3N2dXhN.png?v=1789549930","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-repurpose-blog-posts-to-social-packs-telegram-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}