據 AlphaMoat 統計,截至 2026-09,線上影片轉文字稿 累計下載 1,580 次、獲 0 個星標,在全部 5,078 個 AI 技能中排名第 4,716 位,在「辦公效率」分類(435 個)中排名第 383 位。
| 平台 | 累計安裝 | 累計下載 | 星標 | 評論 |
|---|---|---|---|---|
| ClawHub ↗ | 24 | 906 | - | - |
| SkillHub ↗ | 185 | 1580 | - | — |
各平台的計數口徑不同,統計時間不一致。
文件要求先用 yt-dlp 獲取可用字幕,再按影片語言選擇輸出:非中文影片生成原文和中文譯文,中文影片生成一份文件;沒有可用字幕時應說明限制。
資料釋出於 2026-10-27
以下是根據技能文件生成的示例,不代表實際執行結果。
2026-09 起統計方法調整:同名技能按作者分別統計,並覆蓋全部技能。圖中虛線為調整前的月份,與之後的資料不直接比較,也不計算跨越調整的增長。
| 月份 | 累計下載 | 環比 | 星標 |
|---|---|---|---|
| 2026-09 | 1580 | — | - |
| 2026-08 | 1177 | +18.5% | - |
| 2026-07 | 993 | +31.7% | - |
| 2026-06 | 754 | +22.0% | - |
| 2026-05 | 618 | — | - |
| 2026-03 | 346 | — | - |
以下是作者釋出的原始檔案,按純文字顯示,本站未做修改或稽核;其中的連結不可點選,命令請核實後再執行。抓取於 2026-10-23。
---
name: video-transcript
version: 1.0.0
description: Extract transcripts/subtitles from video URLs and deliver as .docx files. Use this skill whenever the user provides a video link (YouTube, Bilibili, or any yt-dlp supported platform) and asks for a transcript, subtitles, lecture notes, or spoken content in text form. Also trigger when user says "帮我把这个视频转成文字", "视频讲稿", "字幕文档", "transcript", "lecture notes from video", or pastes a video URL with any request to get the text content.
compatibility:
tools:
- exec
dependencies:
- name: yt-dlp
install: "pip install yt-dlp # or: winget install yt-dlp" check: "yt-dlp --version"
- name: node
install: "https://nodejs.org"
check: "node --version"
- name: docx (npm, local)
install: "cd ~/.agents/skills/video-transcript/scripts && npm install"
check: "node -e \"require('./node_modules/docx')\""
---
# Video Transcript Skill
Extract subtitles from a video URL and deliver clean .docx transcript files.
For non-Chinese videos, produce two files: original language + Chinese translation.
For Chinese videos, produce one file.
## Workflow
### Step 0 — First-time setup (once only)
Check if `node_modules` exists in the scripts directory. If not, run:
```powershell
$skillScripts = "$env:USERPROFILE\.agents\skills\video-transcript\scripts"
if (-not (Test-Path "$skillScripts\node_modules\docx")) {
Push-Location $skillScripts
npm install
Pop-Location
}
```
### Step 1 — Download subtitles with yt-dlp
Run in a temp directory (use `$env:TEMP\vt_<random>` on Windows):
```powershell
$tmp = "$env:TEMP\vt_$(Get-Random)"
New-Item -ItemType Directory -Force $tmp | Out-Null
```
**YouTube:**
```powershell
# Try manual subs first, fall back to auto-generated
yt-dlp --skip-download --write-subs --write-auto-subs --sub-langs "en,zh-Hans,zh-Hant,zh" --convert-subs srt -o "$tmp\sub" "<URL>"
```
**Bilibili:**
```powershell
yt-dlp --skip-download --write-subs --sub-langs "zh-Hans,zh,ai-zh" --convert-subs srt -o "$tmp\sub" "<URL>"
```
**Other platforms:** Use the same YouTube command — yt-dlp handles most platforms automatically.
After download, list what was fetched:
```powershell
Get-ChildItem $tmp -Filter "*.srt"
```
### Step 2 — Detect available subtitle files
Pick the best available file:
- Prefer manual subs over auto-generated (`.en.srt` over `.en-orig.srt` or `.en-auto.srt`)
- For Bilibili: pick `zh-Hans` or `ai-zh`
- If multiple languages exist, note them all
If NO subtitle file was downloaded:
- Tell the user: "该视频没有可用字幕,yt-dlp 无法提取文字内容。如需转录请使用 Whisper 语音识别(需额外安装)。"
- Stop here.
### Step 3 — Parse SRT to plain text
Read the .srt file and strip all timing/index lines. Keep only the spoken text lines.
SRT format to strip:
```
1
00:00:01,000 --> 00:00:03,500
This is the spoken text.
2
00:00:04,000 --> 00:00:06,000
More text here.
```
Output: plain text, one paragraph per subtitle block, blank lines between blocks removed (merge into flowing paragraphs). Also strip HTML tags like `<i>`, `<b>`, `<font ...>`.
Do this parsing yourself by reading the file content — no external tool needed.
### Step 4 — Translate if needed
Detect the subtitle language:
- If **Chinese** (zh, zh-Hans, zh-Hant): skip translation, one file only
- If **other language**: translate the full plain text to Chinese using your own translation capability
Translation guidelines:
- Produce natural, readable Chinese — not word-for-word
- Preserve paragraph structure
- Keep proper nouns, technical terms transliterated or explained inline if needed
- Do NOT add commentary or summaries — pure translation only
### Step 5 — Generate .docx files
Use the bundled script. The script path is:
`~/.agents/skills/video-transcript/scripts/make_docx.js`
Get the video title from yt-dlp output or use a sanitized version of the URL as fallback.
**For non-Chinese video (two files):**
```powershell
# Original
node "~/.agents/skills/video-transcript/scripts/make_docx.js" "$tmp\transcript_original.docx" "<VideoTitle> - Original" "<plain_text>"
# Chinese translation
node "~/.agents/skills/video-transcript/scripts/make_docx.js" "$tmp\transcript_zh.docx" "<VideoTitle> - 中文译稿" "<chinese_text>"
```
**For Chinese video (one file):**
```powershell
node "~/.agents/skills/video-transcript/scripts/make_docx.js" "$tmp\transcript_zh.docx" "<VideoTitle> - 讲稿" "<plain_text>"
```
For long texts, write content to a temp `.txt` file first and pipe it:
```powershell
$plain | Out-File -Encoding utf8 "$tmp\content.txt"
Get-Content "$tmp\content.txt" -Raw | node "~/.agents/skills/video-transcript/scripts/make_docx.js" "$tmp\transcript_original.docx" "<title>"
```
### Step 6 — Deliver to user
Tell the user the output file paths clearly:
- "原文讲稿:`C:\...\transcript_original.docx`"
- "中文译稿:`C:\...\transcript_zh.docx`"
Optionally show a short preview (first 200 chars) of the extracted text so the user can verify quality.
## Error handling
| Situation | Action |
|---|---|
| No subtitles found | Inform user, suggest Whisper as alternative |
| yt-dlp not found | `yt-dlp --version` to check; tell user to install if missing |
| node/docx error | Show error, check if `docx` npm package is installed globally |
| Private/geo-blocked video | Inform user the video is inaccessible |
## Notes
- Always clean up `$tmp` dir after delivering files, or leave it and tell the user the path
- The `make_docx.js` script resolves `docx` from global npm automatically
- For very long videos, translation may take a moment — let the user know
透過 MCP 在騰訊文件裡新建、編輯與管理線上文件的完整操作手冊。
在保留公式、格式和活頁簿結構的前提下建立、檢查或編輯 Excel 檔案。
處理 Word 與 DOCX 文件的作業指南,著重維持樣式、編號與版面。
透過命令列存取 Gmail、日曆、Drive、Contacts、Sheets 與 Docs。
PDF和圖片文字提取 將文件文字、表格與掃描頁識別整理為文字結果。
按主題與風格自動生成 PPT 檔案的技能。
透過 kdocs-cli 操作金山文件雲文件的官方技能。
用自然語言指令改 PDF 指定頁的小工具。
資料月份:2026-09 · 下載/星標/安裝數聚合自公開技能註冊庫(ClawHub、SkillHub),按月更新。口徑說明見資料方法。