Skip to content
NEWMarketplace and the trig8n Agent: sell what you build, and get plans and changes that are tested before you see them. See what is new

Library / Web Scraping & Research

Web Scraping & Research

Save YouTube video transcripts to Google Sheets using Apify

On manual run, fetches one selected caption track for a YouTube video or Shorts URL via Apify and appends the transcript and metadata as a row in Google Sheets.

What it does

# 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.

The steps

  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

Similar automations