Bilibili Transcript v2.2

High-accuracy Bilibili video transcription with multi-language AI subtitle support.

Overview

This skill provides a complete transcription workflow for Bilibili videos:

1. Extract Video Metadata - Title, author, publish date, duration
2. Smart Subtitle Detection - Priority: CC subtitles → AI subtitles (multi-language) → Whisper transcription
3. Multi-language AI Subtitle Support - Auto-detects: ai-zh, ai-en, ai-ja, ai-es, ai-ar, ai-pt, ai-ko, ai-de, ai-fr
4. Browser Cookie Support - WSL Chromium or Windows Edge for member-only videos
5. Formatted Output - Saves as structured TXT file with metadata + summary placeholder + full transcript
6. Simplified Chinese - Automatically converts Traditional to Simplified Chinese

What's New in v2.2

• ✅ Fixed cookie detection - Now uses browser config directory instead of SQLite file (avoids encoding errors)
• ✅ One-stop solution - CC subtitles → AI subtitles → Whisper transcription, all in one script
• ✅ Better WSL support - Automatically detects WSL Chromium and Windows Edge cookies
• ✅ Smart fallback - Seamlessly switches between subtitle sources without user intervention

What's New in v2.1

• ✅ Improved cookie handling - Fixed UTF-8 encoding issues with snap Chromium
• ✅ Three-tier fallback - CC subtitles → AI subtitles → Whisper transcription
• ✅ Better error handling - Gracefully degrades when cookie sources fail

What's New in v2.0

• ✅ Multi-language AI subtitles - Supports 9 languages: Chinese, English, Japanese, Spanish, Arabic, Portuguese, Korean, German, French
• ✅ WSL Chromium support - Better cookie extraction than Windows Edge
• ✅ Correct subtitle download - Uses --write-subs --write-auto-subs combo
• ✅ Language auto-detection - Automatically finds available AI subtitle language

AI Subtitle Language Codes

Bilibili uses ai- prefix for AI-generated subtitles:

Code	Language	语言
ai-zh	Chinese	中文
ai-en	English	英文
ai-ja	Japanese	日文
ai-es	Spanish	西班牙文
ai-ar	Arabic	阿拉伯文
ai-pt	Portuguese	葡萄牙文
ai-ko	Korean	韩文
ai-de	German	德文
ai-fr	French	法文

Requirements

Hardware (Your Setup)

• GPU: NVIDIA RTX 4070 Super (12GB VRAM) - ✅ Perfect for medium model
• WSL Memory: 16GB (configured)
• WSL CPU: 6 cores (configured)

Software

• yt-dlp - Video/audio download
• ffmpeg - Audio processing
• whisper - Speech-to-text (local, no API key)
• opencc - Traditional to Simplified Chinese conversion (optional)

Browser (for AI subtitles)

• WSL Chromium (recommended) - Log in to Bilibili in WSL
• Windows Edge - Alternative option

Workflow

Step 1: Run Transcription Script

./scripts/bilibili_transcript.sh "https://www.bilibili.com/video/BVxxxxx"

Priority order: 1. CC Subtitles (manual) - Fastest, highest accuracy 2. AI Subtitles (auto-generated) - Fast, good accuracy, multi-language 3. Whisper Transcription - Slowest, ~95% accuracy, works for all videos

Step 2: Generate Detailed Summary

After the script completes, read the generated TXT file and: 1. Read the full transcript (第二部分) 2. Generate a comprehensive summary (第一部分) 3. Save the updated file

Step 3: Present to User

In Discord, post: - Brief summary in message - Attach the TXT file for full content

Setup WSL Chromium Login

For best results with AI subtitles:

1. Start WSL Chromium: bash chromium-browser &

2. Navigate to bilibili.com

3. Log in with your Bilibili account

4. Run the transcription script

The script will automatically use Chromium's cookies to access member-only AI subtitles.

Usage Examples

Example 1: Basic Transcription (Default Output)

./scripts/bilibili_transcript.sh "https://www.bilibili.com/video/BV1Z1wJzgEAj/"
# Output: workspace/Bilibili transcript/[VideoTitle]_BVxxxxx_transcript.txt

Example 2: Custom Output Directory

./scripts/bilibili_transcript.sh "https://www.bilibili.com/video/BV1Z1wJzgEAj/" ~/Documents

Notes

Model Selection

• Your config: RTX 4070 Super 12GB + 16GB RAM + 6 cores
• Default: medium model (~95% accuracy, balanced speed) ✅
• Fallback: If GPU unavailable, automatically uses CPU (slower)

Accuracy Comparison

Source	Accuracy	Speed	Best For
CC Subtitles	100%	⚡ Instant	All videos with manual subtitles
AI Subtitles (ai-zh)	~90%	⚡ Instant	Chinese videos
AI Subtitles (ai-en)	~85%	⚡ Instant	English videos
Whisper medium	~95%	🐢 Slow	No subtitle videos

Default Output Directory

• Location: workspace/Bilibili transcript/
• Created automatically on first run
• All transcript files organized in one place

File Naming

Output files are named: [VideoTitle]_[BVID]_transcript.txt - Special characters (including Chinese punctuation) are replaced with underscores - Title truncated to 50 characters - Example: 股票分红_是从左口袋掏右口袋吗_BV1ddzUYTE27_transcript.txt

Subtitle Priority

The script tries subtitles in this order: 1. Manual CC subtitles (zh-CN, zh-TW, en, ja, etc.) 2. AI subtitles (any available language: ai-zh, ai-en, ai-ja, etc.) 3. Whisper voice transcription (fallback)

This ensures fastest processing while maintaining high accuracy.