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
- Run manually
- Workflow input
- Run YouTube Transcript Actor
- Read transcript results
- Transcript available?
- Save transcript to Google Sheets
- Read caption status here
Similar automations
Content Writing & GenerationTurn YouTube Transcripts into Newsletter Drafts with GPT-4o7 stepsData Sync & ETLSave YouTube Transcripts to Airtable20 stepsContent Writing & GenerationAnalyse YouTube Videos for Summaries and Transcripts with Gemini15 stepsContent Writing & GenerationTurn YouTube Transcripts into Content Ideas in Airtable10 steps