Библиотека / Веб-скрейпинг и исследования
Веб-скрейпинг и исследования
Сохранение транскриптов видео 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.
Шаги
- Run manually
- Workflow input
- Run YouTube Transcript Actor
- Read transcript results
- Transcript available?
- Save transcript to Google Sheets
- Read caption status here
Похожие автоматизации
Написание и генерация контентаГенерация метаданных YouTube для новых видео с Mistral и ApifyШагов: 15Веб-скрейпинг и исследованияSummarize new YouTube videos with Apify and OpenAI and log to Notion and SlackШагов: 19Веб-скрейпинг и исследованияПоиск видео YouTube и сохранение результатов в PostgresШагов: 29Веб-скрейпинг и исследованияПоиск трендовых видео YouTube и генерация заголовков с OpenAIШагов: 11