Перейти к содержанию
НОВОЕМаркетплейс и trig8n Agent: продавайте то, что создали, и получайте планы и изменения, проверенные до того, как вы их увидите. Что нового

Библиотека / Веб-скрейпинг и исследования

Веб-скрейпинг и исследования

Сохранение транскриптов видео YouTube в Google Sheets через Apify

По ручному запуску получает выбранную дорожку субтитров для видео YouTube или Shorts по URL через Apify и добавляет транскрипт и метаданные строкой в Google Sheets.

Что делает

# Save YouTube transcripts to Google Sheets with Apify ### Who is this for? Researchers and content teams who want existing YouTube captions in a spreadsheet for review or later LLM workflows. ### What it does Enter one video or Shorts URL. Apify retrieves one selected caption track. The workflow saves its full fetched text, title, URL, channel, language, automatic-caption flag, and extraction time in one Google Sheets row. Missing captions and blocked requests follow a separate status branch, not blank transcript rows. ### Setup 1. Install the verified Apify node and import the workflow JSON. 2. Connect your own Apify and Google Sheets credentials. 3. Create a worksheet with the eight headers in the setup guide. 4. Set videoUrl, spreadsheetUrl, and sheetName in Workflow input, then execute manually. ### Requirements and cost Requires n8n with the Apify node, an Apify account, Google Sheets access, and a video with captions. Verified Apify nodes support n8n Cloud and self-hosted instances. The template has no separate fee. Actor runs are paid; check current pricing. Other service charges may apply. ### Customization and limits Change the Actor language settings if needed. This example requests text only, not SRT/VTT. Rerunning a successful URL appends another row. It does not transcribe, translate, summarize, or schedule runs. Source captions can contain errors or omit speech.

Шаги

  1. Run manually
  2. Workflow input
  3. Run YouTube Transcript Actor
  4. Read transcript results
  5. Transcript available?
  6. Save transcript to Google Sheets
  7. Read caption status here

Похожие автоматизации