YouTube + Google Sheets: repurpose videos into posts
You know the drill. One good YouTube video turns into a week of “we should repurpose this”… and then nothing ships because the busywork is brutal.
This YouTube repurposing automation hits content marketers hardest. Social media managers feel it too, and so do founders who are the “content team” by default. The outcome is simple: turn one topic into three platform-ready drafts (with images) and put them somewhere you can actually review.
This workflow pulls an unsearched topic from Google Sheets, finds a relevant YouTube video, generates Instagram/Facebook/LinkedIn posts plus visuals, then saves everything back to Sheets so you can edit and schedule with confidence.
How This Automation Works
The full n8n workflow, from trigger to final output:
n8n Workflow Template: YouTube + Google Sheets: repurpose videos into posts
flowchart LR
subgraph sg0["Trigger Search Schedule Flow"]
direction LR
n0@{ icon: "mdi:play-circle", form: "rounded", label: "Trigger Search Schedule", pos: "b", h: 48 }
n1@{ icon: "mdi:database", form: "rounded", label: "Get Unsearched Topic from Go..", pos: "b", h: 48 }
n2["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/httprequest.dark.svg' width='40' height='40' /></div><br/>Search YouTube via Dumpling AI"]
n3["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Filter + Sort YouTube Videos"]
n4@{ icon: "mdi:cog", form: "rounded", label: "Prepare Video List for AI", pos: "b", h: 48 }
n5@{ icon: "mdi:robot", form: "rounded", label: "Select Best Video with GPT-4o", pos: "b", h: 48 }
n6["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/httprequest.dark.svg' width='40' height='40' /></div><br/>Get Transcript (Dumpling AI)"]
n7@{ icon: "mdi:robot", form: "rounded", label: "Generate Posts with GPT-4o", pos: "b", h: 48 }
n8["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/httprequest.dark.svg' width='40' height='40' /></div><br/>Generate Instagram Image (Du.."]
n9["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/httprequest.dark.svg' width='40' height='40' /></div><br/>Generate Facebook Image (Dum.."]
n10["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/httprequest.dark.svg' width='40' height='40' /></div><br/>Generate LinkedIn Image (Dum.."]
n11@{ icon: "mdi:swap-vertical", form: "rounded", label: "Format Instagram Post", pos: "b", h: 48 }
n12@{ icon: "mdi:swap-vertical", form: "rounded", label: "Format Facebook Post", pos: "b", h: 48 }
n13@{ icon: "mdi:swap-vertical", form: "rounded", label: "Format LinkedIn Post", pos: "b", h: 48 }
n14@{ icon: "mdi:database", form: "rounded", label: "Save Instagram Post to Sheet", pos: "b", h: 48 }
n15@{ icon: "mdi:database", form: "rounded", label: "Save Facebook Post to Sheet", pos: "b", h: 48 }
n16@{ icon: "mdi:database", form: "rounded", label: "Save LinkedIn Post to Sheet", pos: "b", h: 48 }
n17["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/merge.svg' width='40' height='40' /></div><br/>Merge Post Results"]
n18@{ icon: "mdi:database", form: "rounded", label: "Update Topic Status in Sheet", pos: "b", h: 48 }
n17 --> n18
n12 --> n15
n13 --> n16
n11 --> n14
n0 --> n1
n4 --> n5
n7 --> n8
n7 --> n9
n7 --> n10
n15 --> n17
n16 --> n17
n3 --> n4
n6 --> n7
n14 --> n17
n5 --> n6
n2 --> n3
n9 --> n12
n10 --> n13
n8 --> n11
n1 --> n2
end
%% Styling
classDef trigger fill:#e8f5e9,stroke:#388e3c,stroke-width:2px
classDef ai fill:#e3f2fd,stroke:#1976d2,stroke-width:2px
classDef aiModel fill:#e8eaf6,stroke:#3f51b5,stroke-width:2px
classDef decision fill:#fff8e1,stroke:#f9a825,stroke-width:2px
classDef database fill:#fce4ec,stroke:#c2185b,stroke-width:2px
classDef api fill:#fff3e0,stroke:#e65100,stroke-width:2px
classDef code fill:#f3e5f5,stroke:#7b1fa2,stroke-width:2px
classDef disabled stroke-dasharray: 5 5,opacity: 0.5
class n0 trigger
class n5,n7 ai
class n1,n14,n15,n16,n18 database
class n2,n6,n8,n9,n10 api
class n3 code
classDef customIcon fill:none,stroke:none
class n2,n3,n6,n8,n9,n10,n17 customIcon
The Problem: Repurposing YouTube Content Takes Forever
Repurposing sounds efficient until you actually do it. First you hunt for the right video, then you rewatch to find the angles, then you write three different versions so they don’t look copy-pasted. After that comes the image problem: you need something that fits the platform, matches the post, and doesn’t look like a random stock photo. Somewhere in the middle you lose track of what’s been done, what’s still a draft, and what’s ready to schedule. And the worst part is you repeat the same steps next week.
It adds up fast. Here’s where it usually breaks down.
- Finding a relevant, recent YouTube video can take about 30 minutes before you write a single word.
- Writing platform-specific drafts is mentally expensive, so it gets pushed to “later” and later never comes.
- Image creation becomes a bottleneck because resizing and matching visuals to each caption is slow and annoying.
- Without a central tracker, topics get reused by accident or ignored completely, which means inconsistent posting.
The Solution: Turn One Topic Into 3 Social Drafts (Automatically)
This workflow starts with what you already have: a simple list of topics in Google Sheets. On a schedule you choose, n8n grabs one topic that hasn’t been processed yet, searches YouTube for relevant videos (via Dumpling AI), and uses GPT-4o to pick the best match. Then it pulls the transcript, generates three distinct drafts tailored for Instagram, Facebook, and LinkedIn, and creates matching AI images for each post. Finally, it writes the drafts and image outputs into a “Social Media Post” sheet, and marks the original topic as searched so it won’t repeat. You end up with content you can review like a normal human, not content trapped in a chat window.
The workflow begins when the scheduled trigger runs. Dumpling AI handles YouTube search, transcript extraction, and image generation, while GPT-4o converts the transcript into platform-native copy. Google Sheets becomes the hub: one sheet feeds topics in, another collects posts out.
What You Get: Automation vs. Results
| What This Workflow Automates | Results You’ll Get |
|---|---|
|
|
Example: What This Looks Like
Say you repurpose three YouTube topics a week. Manually, a realistic breakdown is about 30 minutes to find a solid video, about 45 minutes to write three platform versions, and another 45 minutes to create or source three usable images. That’s roughly 2 hours per topic, or about 6 hours each week. With this workflow, you add the topics to Google Sheets once, then each run takes a couple minutes of your time to review and tweak the drafts after they land in the “Social Media Post” sheet.
What You’ll Need
- n8n instance (try n8n Cloud free)
- Self-hosting option if you prefer (Hostinger works well)
- Google Sheets to store topics and drafts
- Dumpling AI for YouTube search, transcript, images
- OpenAI API key (GPT-4o) (get it from your OpenAI dashboard)
Skill level: Intermediate. You’ll connect credentials, map a few fields, and confirm your sheet columns match.
Don’t want to set this up yourself? Talk to an automation expert (free 15-minute consultation).
How It Works
A scheduled run kicks things off. You decide the cadence (daily, a few times a week, whatever fits your calendar) and n8n runs automatically.
Google Sheets provides the next topic. The workflow reads your “YouTube Topics” sheet, picks one row where “Searched?” is not marked, then carries that topic forward so you get clean one-topic-at-a-time output.
Dumpling AI + GPT-4o do the heavy lifting. Dumpling searches YouTube and pulls transcripts, while GPT-4o chooses the most relevant video and writes platform-specific drafts based on what was actually said in the video (not guesses).
Drafts and images land back in Sheets. The workflow writes Instagram, Facebook, and LinkedIn content plus image outputs into your “Social Media Post” sheet, then marks the topic as processed so you don’t accidentally repeat it next run.
You can easily modify the platforms to add X/Twitter or Threads based on your needs. See the full implementation guide below for customization options.
Common Gotchas
- Google Sheets credentials can expire or need specific permissions. If things break, check the connected Google account access in n8n’s Credentials and confirm the sheet is shared with that account.
- If you’re using Wait nodes or external rendering, processing times vary. Bump up the wait duration if downstream nodes fail on empty responses.
- Default prompts in AI nodes are generic. Add your brand voice early or you’ll be editing outputs forever.
Frequently Asked Questions
About 30 minutes if your Sheets and API keys are ready.
No. You will connect your accounts and map a few Google Sheets fields. If you can follow a checklist, you’ll be fine.
Yes. n8n has a free self-hosted option and a free trial on n8n Cloud. Cloud plans start at $20/month for higher volume. You’ll also need to factor in Dumpling AI and OpenAI API usage, which depends on how many topics you process.
Two options: n8n Cloud (managed, easiest setup) or self-hosting on a VPS. For self-hosting, Hostinger VPS is affordable and handles n8n well. Self-hosting gives you unlimited executions but requires basic server management.
Yes, but expect a little prompt and mapping work. You can duplicate the platform “switch” logic and add another GPT-4o generation block with a new prompt for the voice and character limits you want. Then add new columns (or new rows) in your Social Media Post sheet so the workflow has somewhere to save the output. Common customizations include changing the writing style to match your brand, adding an approval step in Telegram, and altering the schedule so it runs only on content days.
Usually it’s the wrong Google account or missing permissions on the spreadsheet.
It can handle a lot, but your limits come from your n8n plan and API quotas. On n8n Cloud Starter you get a monthly execution cap, so high-volume teams may need a higher tier. If you self-host, there’s no hard execution limit, but your server still has to keep up. Practically, most teams run this a few times a day or a few times a week and stay comfortably within limits, especially if you process one topic per run.
For this workflow, n8n is usually a better fit because you can manage branching logic, looping, and multi-step AI generation without turning it into an expensive chain of premium actions. It’s also easier to keep everything in one place, including the “mark topic as processed” safety check. Zapier or Make can still work if you want something very simple, but once you add transcript fetching, post generation, and image creation, complexity shows up fast. If you’re unsure, Talk to an automation expert and describe your volume and review process.
You don’t need more content ideas. You need a reliable system that turns one strong video into usable drafts on a schedule. Set it up once, then spend your time on the final 10% that actually moves the needle.
Need Help Setting This Up?
Our automation experts can build and customize this workflow for your specific needs. Free 15-minute consultation—no commitment required.
