Download Transcripts from CSV

Download Transcripts from CSV

Why? Manually downloading transcripts one-by-one is tedious and error-prone. This skill automates bulk transcript downloads with rate limiting, progress tracking, and resume capability.

Quick Start

# Standard usage (recommended)
ytscriber download --folder <channel-name> --delay 60

# Single video (adds to default collection and downloads)
ytscriber add "https://www.youtube.com/​watch?v=VIDEO_ID" --folder random

---

Workflow

1. Verify Prerequisites

Ensure you have a CSV file with video URLs:

• Created by extract-videos skill, OR
• Manually curated with url column

# Check CSV exists and has videos
head -5 ~/​Documents/​YTScriber/<channel-name>/​videos.csv

[!TIP] If you don't have a CSV yet, run extract-videos first to build your video list from a YouTube channel.

2. Run Download Command

ytscriber download --folder <folder-name> --delay 60

[!CAUTION] NEVER set --delay below 30 seconds. YouTube will block your IP if you make requests too quickly. The default of 60 seconds exists for a reason. You WILL get banned and may wait hours before downloading again.

3. Validate Downloads

After the command completes:

# Check how many transcripts downloaded
ls -la ~/​Documents/​YTScriber/<folder-name>/​transcripts/​*.md | wc -l

# Verify CSV status updated
grep -c "success" ~/​Documents/​YTScriber/<folder-name>/​videos.csv

The command automatically:

• Downloads transcripts as markdown with YAML frontmatter
• Updates CSV transcript_downloaded column with success/​error/​empty
• Skips already-downloaded videos on re-run

---

Output Format

Transcripts are saved as markdown with YAML frontmatter:

---
video_id: dQw4w9WgXcQ
video_url: https://www.youtube.com/​watch?v=dQw4w9WgXcQ
title: Building Resilient Microservices at Scale
author: Jane Smith
published_date: 2025-03-15
length_minutes: 42.5
views: 15234
description: "Video description..."
is_generated: True
---

[Transcript text as continuous paragraph]

---

Examples

Overnight Batch Processing

# Large channel - run overnight with safe delay
ytscriber download --folder aws-reinvent-2025 --delay 90 --verbose

Conference Playlist

# Smaller collection - minimum safe delay
ytscriber download --folder pycon-2024 --delay 30

---

Troubleshooting

---

Common Mistakes

1. Reducing delay to "speed up" - Do not set delay below 30 seconds. You will get IP banned. Use overnight runs for large batches.

2. Running without checking CSV first - Always verify your CSV exists and has videos before running. Empty CSVs waste time.

3. Not using resume capability - If interrupted, don't start over. Re-run the same command to resume from where you left off.

---

Quality Checklist

Before running:

• CSV file exists and has url column
• Folder name is correct
• Delay is 30+ seconds (60+ recommended)
• Sufficient time allocated (1 min per video minimum)

After running:

• Transcript count matches expected videos
• CSV transcript_downloaded column updated
• Spot-check 2-3 transcripts for valid content
• No empty or malformed markdown files