Content Repurposing Template
Turn one blog post into a tweet thread, LinkedIn post and newsletter blurb in Google Sheets with =GPT(). Free AI template for repurposing content at scale.
You already paid for the thinking when you wrote the post — repurposing is collecting the change. This template takes one article per row and produces the tweet thread, the LinkedIn post and the newsletter blurb next to it, each written for its platform rather than cut down from the original.
Layout
| Column | Content |
|---|---|
| A | Post title + URL |
| B | Full post text (pasted) |
| C | X/Twitter thread |
| D | LinkedIn post |
| E | Newsletter blurb |
The formulas
Tweet thread (C2):
=GPT("Turn this post into a 6-tweet thread. Tweet 1 is a hook that creates curiosity, no hashtags, each tweet under 280 characters, last tweet links to the post. Number the tweets.", B2)
LinkedIn post (D2):
=GPT("Rewrite this post as a LinkedIn post: strong first line before the fold, short paragraphs, one concrete example kept, end with a question. No hashtag walls.", B2)
Newsletter blurb (E2):
=GPT("Write a 60-word newsletter blurb teasing this post: what the reader gets, why now, then 'Read more'. Don't give away the conclusion.", B2)
Variations
- Pull quotes:
=GPT_LIST("5 quotable one-liners from this post, each under 120 characters: "&B2)spills each quote into its own row — ready-made image-card copy. - More formats: the same source cell feeds an Instagram caption, a YouTube description or a Reddit-friendly plain version — one new column and prompt each.
- Skip the pasting:
=PERPLEXITY("Summarize the key points and examples of this article: ", A2)can build a working summary from the URL when you don’t have the text handy — review it before deriving posts from it.
Get started
- Install GPT for Sheets from the Google Workspace Marketplace (free tier included, no API keys needed).
- Copy the template or paste the formulas into your own sheet.
- Drag the formula down your rows, then use Replace all GPT formulas with results in the sidebar.
Related: Twitter thread prompts, social media calendar template.
FAQ
Do I paste the whole article into a cell?
Yes — a Google Sheets cell holds up to 50,000 characters, enough for almost any blog post. Every derivative formula then references that one cell, so the source stays in one place.
Won’t every derivative sound like a summary?
Only if you ask for a summary. Each prompt requests a platform-native piece — a hook-first thread, a story-driven LinkedIn post, a teaser blurb — so the formats differ in structure, not just length.
How many posts can I repurpose at once?
One row per article, three or more derivatives per row. At up to 10,000 results per hour, repurposing a 100-post archive into 300+ social assets is a single afternoon.