YouTube to Google Sheets, ready X thread drafts
You find a great YouTube video idea, then lose an hour chasing “proof” it will work, pulling takeaways, and turning it into an X thread that actually holds attention. The worst part is the uncertainty. You do all that work and still wonder if the topic was a dud.
This is what marketing managers complain about in content standups. Creators feel it when they need daily output. And a social media manager at a small brand gets squeezed from both sides. This YouTube thread automation lets you start from winners and end with draft threads sitting in Google Sheets, ready to approve.
You will see how the workflow finds high-performing videos from your keywords, filters for real traction (not Shorts), and generates three thread angles per pick using AI, then saves everything back to one sheet you can run your week from.
How This Automation Works
The full n8n workflow, from trigger to final output:
n8n Workflow Template: YouTube to Google Sheets, ready X thread drafts
flowchart LR
subgraph sg0["On form submission Flow"]
direction LR
n0@{ icon: "mdi:swap-horizontal", form: "rounded", label: "Filter High-Performing Videos", pos: "b", h: 48 }
n1@{ icon: "mdi:cog", form: "rounded", label: "Top 5 Videos", 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/code.svg' width='40' height='40' /></div><br/>Structure Thread Data"]
n3@{ icon: "mdi:database", form: "rounded", label: "Save to Google Sheets", pos: "b", h: 48 }
n4["<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 videos"]
n5["<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 statistics"]
n6@{ icon: "mdi:brain", form: "rounded", label: "Anthropic Chat Model", pos: "b", h: 48 }
n7["<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/form.svg' width='40' height='40' /></div><br/>On form submission"]
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/code.svg' width='40' height='40' /></div><br/>Add context file"]
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/code.svg' width='40' height='40' /></div><br/>Clean data"]
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/code.svg' width='40' height='40' /></div><br/>Split Batch"]
n11@{ icon: "mdi:database", form: "rounded", label: "Add to Google Sheets", pos: "b", h: 48 }
n12["<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/>Extract Video Summary"]
n13@{ icon: "mdi:robot", form: "rounded", label: "Create Threads", pos: "b", h: 48 }
n14@{ icon: "mdi:swap-vertical", form: "rounded", label: "Key Word + Audience + Tone", pos: "b", h: 48 }
n15@{ icon: "mdi:swap-vertical", form: "rounded", label: "Keys: YT + Gemini", pos: "b", h: 48 }
n16@{ icon: "mdi:cog", form: "rounded", label: "Wait 30s", pos: "b", h: 48 }
n17@{ icon: "mdi:swap-horizontal", form: "rounded", label: "Filter by 'Yes'", pos: "b", h: 48 }
n18@{ icon: "mdi:database", form: "rounded", label: "Check if 'Yes'", pos: "b", h: 48 }
n16 --> n18
n9 --> n8
n4 --> n5
n10 --> n0
n1 --> n11
n18 --> n17
n13 --> n2
n5 --> n10
n17 --> n12
n8 --> n13
n15 --> n4
n7 --> n14
n11 --> n16
n6 -.-> n13
n12 --> n9
n2 --> n3
n14 --> n15
n0 --> n1
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 n7 trigger
class n13 ai
class n6 aiModel
class n0,n17 decision
class n3,n11,n18 database
class n4,n5,n12 api
class n2,n8,n9,n10 code
classDef customIcon fill:none,stroke:none
class n2,n4,n5,n7,n8,n9,n10,n12 customIcon
The Problem: Turning YouTube Research Into Postable Threads
Writing X threads is rarely the hard part. Picking the right topic is. Most teams start with a keyword, scroll YouTube for “good enough,” click into a few videos, skim comments, then try to reverse-engineer what made it pop. Then you still need structure, hooks, and a clean takeaway arc. Do that a few times per week and you’re burning whole mornings on research and rewrites, not publishing. And because it’s manual, the process breaks the moment your schedule gets busy.
The friction compounds. A lot.
- You end up guessing what “high-performing” means, so topics feel hit-or-miss even when you work hard.
- Manual video review turns into tab chaos, and ideas disappear the second you switch tasks.
- Threads get written in a rush, which means weak hooks, inconsistent formatting, and more editing than you expected.
- There’s no simple approval step, so work gets duplicated when someone changes direction mid-week.
The Solution: Approve Winning Videos, Then Generate 3 Thread Drafts
This n8n workflow flips the process around. Instead of starting from a blank doc, you start from YouTube videos that already proved they can earn attention. You submit a keyword, your target audience, and a preferred content style through a simple form. The workflow searches for recent YouTube videos (April 2025 and newer), pulls performance stats, and keeps only the real standouts (100K+ views, not Shorts). It then logs candidates into Google Sheets so you can approve what you actually want to use. Once you mark a row “Yes,” AI analyzes the approved video and generates three distinct X thread variations, formatted and saved back into the same sheet.
The workflow starts with a form entry and API setup, then uses YouTube search plus metrics to narrow down to proven winners. After a quick approval check in Google Sheets, Gemini extracts the key insights and Claude Sonnet generates thread drafts based on patterns pulled from 12.5M+ view threads. Everything ends where you work already: your spreadsheet.
What You Get: Automation vs. Results
| What This Workflow Automates | Results You’ll Get |
|---|---|
|
|
Example: What This Looks Like
Say you want to publish 5 threads per week based on “AI automation.” Manually, you might spend about 30 minutes finding and vetting a video, then another 45 minutes turning it into a decent thread, which is roughly 6 hours weekly. With this workflow, you submit one form (about 2 minutes), review up to 2 top video candidates in Google Sheets (maybe 10 minutes), then wait for the AI drafts to land. You’re down to under an hour of hands-on time, with 6 drafts ready to polish.
What You’ll Need
- n8n instance (try n8n Cloud free)
- Self-hosting option if you prefer (Hostinger works well)
- Google Sheets for approvals and storing thread drafts
- YouTube Data API to search videos and pull metrics
- Google Gemini API key (get it from Google AI Studio)
- Anthropic API to generate thread drafts with Claude
Skill level: Intermediate. You’ll connect a few accounts, paste API keys, and map columns in Google Sheets.
Don’t want to set this up yourself? Talk to an automation expert (free 15-minute consultation).
How It Works
You submit a keyword and audience. The workflow begins with a form entry, then sets the keyword, target audience, and tone so the AI knows what “good” looks like for your brand.
YouTube gets scanned for winners. n8n runs HTTP requests to find recent videos that match your keyword, pulls stats (views and engagement signals), and filters down to high performers only, excluding Shorts.
You approve inside Google Sheets. The top candidates are appended to a tracking spreadsheet. After a short wait (30 seconds), the workflow checks which rows you marked “Yes” for thread generation.
AI extracts insights and drafts threads. Gemini summarizes key ideas, tools, and strategies from the approved video, then Claude generates three thread variations using proven viral patterns. n8n formats the output so it’s readable and ready to post.
You can easily modify the filtering rules (like the 100K view threshold) to fit your niche and posting goals. See the full implementation guide below for customization options.
Step-by-Step Implementation Guide
Step 1: Configure the Form Trigger
This workflow starts when a new form submission arrives, then immediately assigns audience and tone inputs before pulling video data.
- Add the Form Entry Trigger node as the workflow trigger.
- Connect Form Entry Trigger to Set Keyword Audience Tone to pass the form fields into downstream steps.
- In Set Keyword Audience Tone, map the incoming form fields (keyword, audience, tone) to output fields used later in the workflow.
- Confirm the execution path continues from Set Keyword Audience Tone to Assign API Keys.
Step 2: Connect Google Sheets
Google Sheets is used for staging video candidates, reviewing approvals, and storing final thread drafts.
- Open Append to Sheets and select the target spreadsheet and worksheet for candidate videos.
- Open Review Approval Flag and select the spreadsheet/worksheet that stores approval status.
- Open Store in Sheets and select the final output worksheet for formatted thread drafts.
- Credential Required: Connect your Google Sheets credentials in each Google Sheets node.
Step 3: Set Up Video Data Processing
This section pulls videos, calculates performance, and limits the list before writing to Sheets.
- In Assign API Keys, store any API tokens needed by the downstream HTTP requests.
- Configure Fetch Video List to call your video source API and return candidate videos.
- Configure Retrieve Video Metrics to fetch metrics for each video returned by Fetch Video List.
- Use Segment Records to split or reshape metric data for evaluation.
- Define filtering criteria in Filter Top Performers to keep only high-performing videos.
- Limit results with Limit to Five Videos, then connect to Append to Sheets to stage the shortlist.
Step 4: Configure the Approval Loop and Enrichment
After staging the top videos, the workflow waits, checks approval, and enriches approved entries before AI drafting.
- Ensure Append to Sheets flows into Delay 30 Seconds to pause before approval checks.
- Confirm Delay 30 Seconds outputs to Review Approval Flag to read the approval column.
- Filter approved records in Filter Approved Items, then connect to Pull Video Summary.
- Use Sanitize Data to clean the summary, then Attach Context File to add any reference materials for AI drafting.
Step 5: Set Up AI Drafting and Formatting
Approved and enriched videos are sent to the AI agent to draft threads, then formatted for storage.
- Open Generate Thread Drafts and confirm it is connected to Anthropic Chat Engine as the language model.
- Credential Required: Connect your Anthropic credentials in Anthropic Chat Engine (credentials are added to the model node, not Generate Thread Drafts).
- Pass the sanitized summary and context from Attach Context File into Generate Thread Drafts for thread creation.
- Use Format Thread Output to standardize the final thread text before storage.
Step 6: Configure Output Nodes
The formatted threads are stored for review or publishing.
- Connect Format Thread Output to Store in Sheets to save the final drafts.
- Confirm the output columns in Store in Sheets match the structure produced by Format Thread Output.
Step 7: Test and Activate Your Workflow
Run a controlled test to verify the full execution path from form entry to final thread storage.
- Click Execute Workflow and submit a test entry to Form Entry Trigger.
- Verify that data flows from Set Keyword Audience Tone through Fetch Video List, Retrieve Video Metrics, and into Append to Sheets.
- After the wait, confirm approved items pass through Filter Approved Items, then into Generate Thread Drafts and Store in Sheets.
- When the test succeeds, toggle the workflow to Active for production use.
Common Gotchas
- Google Sheets OAuth credentials can expire or need specific permissions. If things break, check the Google Cloud Console consent screen and the connected account in n8n first.
- If you’re using Wait nodes or external processing, timing can vary. Bump up the 30-second wait if the approval check runs before you’ve had time to mark “Yes.”
- Claude and Gemini prompts that are left “default” will sound generic. Bake in your voice (tight, opinionated, story-first, etc.) early or you’ll be editing every thread.
Frequently Asked Questions
About 30 minutes if your API keys are ready.
No. You’ll mostly connect accounts and paste API keys. If you want to tweak prompts or formatting, light editing is enough.
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 API usage costs for YouTube, Gemini, and Anthropic, which depend on how many videos 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 you’ll change the AI output format. Replace the thread-specific instructions inside the “Generate Thread Drafts” step and adjust the “Format Thread Output” logic to write carousel slides (for example, 8–10 short panels) into Google Sheets. Common customizations include raising or lowering the 100K view filter, changing the “top 2 videos” cap, and adding a brand voice block so every draft sounds like you.
Usually it’s expired OAuth consent or the wrong Google account connected in n8n. Reconnect Google Sheets, confirm the spreadsheet is shared with the signed-in user, and double-check the sheet name and columns match what the workflow expects. If it fails after working for a while, look for permission changes or a refreshed token that didn’t save.
Plenty for a small team’s weekly pipeline.
For this use case, n8n is usually the more comfortable fit because you’re doing multi-step logic (search, stats, filtering, approval, AI analysis, formatting, then saving). Zapier or Make can do it, but the branching and AI-heavy parts tend to get expensive or awkward as you iterate. n8n also gives you the option to self-host, which matters if you run lots of executions. That said, if you only want “YouTube link in, summary out” with no approval loop, simpler tools can be fine. Talk to an automation expert if you want a recommendation based on your posting volume.
Once this is running, your “thread ideas” stop living in your head and start living in a sheet with drafts attached. Honestly, that’s the difference between posting sometimes and posting consistently.
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.
