What's in this guide
What I built and why
I had a 2-week content calendar with 14 video topics across 4 content pillars (AI News, AI Agents, Claude Code, and Higgsfield Short Films). I needed scripts for all of them, plus a bonus video I was filming that day.
Instead of writing each script from scratch, I used Claude Code to:
- Read my content calendar directly from Google Sheets
- Research 17 top creators in my niche and analyze what makes their content work
- Study viral hook formulas and script structures
- Write 15 complete scripts with hooks, dialogue, stage directions, production notes, and CTAs
- Export everything to a formatted Google Doc
The entire process took one Claude Code session. Here's exactly how to do it yourself.
What you need before starting
- Claude Code installed and running (you need a Claude Pro or Max subscription)
- A content calendar — even a rough list of topics works. Google Sheets, Notion, CSV, or just a text list.
- A niche/audience in mind — Claude needs to know who you're making content for
- Optional: Claude in Chrome extension — lets Claude read your Google Sheets directly from the browser
Don't have a content calendar yet? You can ask Claude Code to help you build one first. Just tell it your niche, posting frequency, and content pillars — it'll generate a full calendar for you.
Step 1: Feed Claude your content calendar
Give Claude your topics
You have a few options here depending on where your calendar lives:
Option A: Google Sheets (with browser extension)
If you have the Claude in Chrome extension installed, just paste the URL of your spreadsheet and ask Claude to read it. It will navigate to the sheet and extract all your topics automatically.
Option B: Copy-paste
The simplest approach. Just paste your list of topics directly into the chat. It doesn't need to be formatted perfectly.
Option C: CSV file
Export your calendar as a CSV and tell Claude the file path. It'll read it directly from your computer.
Here's my content calendar for the next 2 weeks. I have [X] videos planned across these content pillars: [list pillars].
[Paste your topics, dates, and any notes here]
I need scripts for all of these videos. But first, I want you to research what's working in my niche so the scripts are based on proven formats.Step 2: Research top creators in your niche
Ask Claude to find and analyze creators
This is where it gets powerful. Instead of just writing scripts from nothing, you're asking Claude to study what's already working and reverse-engineer it.
Find 10-20 top YouTube creators in my niche ([describe your niche]). For each creator, I need:
- Channel name and subscriber count
- Content focus and video style
- Posting frequency
- What hook patterns they use
- Why their content works
- Their most popular recent videos
Put this in a spreadsheet/CSV so I can reference it later.
Focus on creators who are:
- Active in 2025-2026
- Making content about [your topics]
- A mix of large and mid-size channelsClaude will search the web, pull data from multiple sources, and compile a creator analysis spreadsheet. This becomes your inspiration reference for every script.
Why this matters: Scripts based on proven formats outperform scripts written in a vacuum. You're not copying anyone — you're understanding what patterns drive engagement in your niche and applying those patterns to your unique content.
Get 3 Claude Code skills emailed 3x a week
Step 3: Analyze viral patterns and hooks
Get Claude to study what makes content go viral
On top of the creator research, ask Claude to study the mechanics of viral content in your space.
Now research what makes [your niche] YouTube videos go viral. I need:
1. Common hook patterns (what do the first 3-5 seconds look like?)
2. Script structures that perform well (problem-solution, tutorial, contrarian take, etc.)
3. Optimal video length for shorts/reels vs long-form
4. Title and thumbnail patterns that get clicks
5. CTA strategies that drive follows and engagement
Search for current data — I want what's working RIGHT NOW, not 2023 advice.Claude will compile a research document with hook templates, script formulas, and engagement strategies. This becomes the framework it uses to write your scripts.
Step 4: Generate the scripts
Have Claude write all your scripts
Now Claude has three things: your content calendar, creator research, and viral pattern analysis. This is where you tell it to write.
Now write scripts for all [X] videos in my content calendar. For each script include:
- A hook (first 3-5 seconds) based on the viral patterns you researched
- Full dialogue/voiceover with timestamps
- Stage directions (what's on screen, camera angles, energy level)
- Production notes (audio, visuals, editing style, B-roll ideas)
- Thumbnail and title options
- A CTA
- Which creator's style inspired the format
Save each script as a separate file in a /scripts folder on my Desktop.
Match the tone to my brand: [describe your vibe — casual, high-energy, educational, etc.]Claude will write each script one by one, tailored to the specific content pillar and format. Each script comes out as a complete production document — not just words on a page, but a full blueprint for filming.
Important: Review and personalize every script. Claude gives you a strong first draft, but your voice, your stories, and your personality are what make content actually work. Use these as 80% done drafts that you punch up with your own style.
Step 5: Export to Google Docs
Get everything into a format you can use
Once the scripts are written, ask Claude to compile and export them.
Compile all the scripts into a single formatted document with:
- A title page
- Table of contents
- Each script on its own page
- Formatted with headers, bold text, and stage directions
Export it as a .docx file so I can upload it to Google Drive.Claude will generate a .docx file on your Desktop. Upload it to Google Drive, and it automatically opens as a Google Doc you can edit, share, and reference while filming.
The exact prompts I used
Here's the full prompt sequence, condensed. You can copy these and modify them for your niche.
Prompt 1: Content calendar intake
[Paste your spreadsheet URL or content list]
These are my video topics for the next 2 weeks. I want you to create scripts for all of them, but first research top creators in my niche for inspiration.Prompt 2: Creator research
Find 10-20 top creators in [your niche] on YouTube. Analyze their content — hooks, video style, posting frequency, what makes them work. Save the results as a CSV spreadsheet on my Desktop.Prompt 3: Viral pattern analysis
Research viral video patterns for [your niche] content in 2025-2026. Hook formulas, script structures, thumbnail/title strategies, optimal lengths, CTA tactics.Prompt 4: Script generation
Now write scripts for all my videos based on the creator research and viral patterns. Include hooks, full dialogue, stage directions, production notes, thumbnail/title options, and CTAs. Save each as a file in ~/Desktop/scripts/Prompt 5: Export
Compile all scripts into a single .docx with a table of contents and formatting. Save to my Desktop.Tips for better results
Be specific about your brand voice
Tell Claude your energy level, tone, and style. "Casual and high-energy like a group chat" produces very different scripts than "calm and analytical like a podcast." The more specific you are, the less editing you'll do.
Give it examples of your past content
If you have scripts or captions from previous videos that performed well, paste a few in. Say "match this style." Claude will pick up your patterns.
Research before writing
The creator research step is what separates a generic AI script from one that's actually modeled on proven formats. Don't skip it. The 5 minutes of research saves hours of rewriting.
Use the scripts as first drafts, not final drafts
Read every script out loud before filming. If a line feels unnatural, change it. Your delivery and personality are the content — the script is just the skeleton.
Batch by content pillar
If you have multiple content pillars (news, tutorials, vlogs, etc.), ask Claude to write all scripts for one pillar at a time. This keeps the tone and format consistent within each category.
Update the research regularly
The creator and trend research goes stale. Run the research step every 2-4 weeks to keep your scripts aligned with what's currently working in your niche.
Save your prompts
Once you have a prompt sequence that works, save it. Next time you need scripts, you can run the same flow with a new content calendar and get results in minutes.
What you'll end up with
After one Claude Code session, you'll have:
- A creator inspiration spreadsheet with 10-20 analyzed channels in your niche
- A viral patterns reference with hook templates and script structures
- Complete scripts for every video in your content calendar — with hooks, dialogue, stage directions, production notes, and CTAs
- Everything exported to Google Docs for easy editing and sharing
The whole process takes about 30-60 minutes depending on how many videos you're scripting. That's a full production plan that would normally take days.
The scripts aren't perfect out of the box — nothing AI generates is. But they're 80% there, and that last 20% of personalization is where your voice makes the content yours.