Extract YouTube transcripts via Google Sheets or API webhook
Ready for 3.0What this workflow does
This workflow has 10 nodes and runs on Google Sheets events (row added) (plus 1 other trigger). Along the way it connects Google Sheets. It also calls youtube-transcript.io over HTTP.
How it runs
Trigger: On Google Sheets events (row added) (plus 1 other trigger).
- Extract YouTube Video ID (Sheets) (Code): runs custom JavaScript code
- Extract YouTube Video ID (Webhook) (Code): runs custom JavaScript code
- Fetch Video Transcript Data (Sheets) (HTTP Request): calls youtube-transcript.io (POST)
- Fetch Video Transcript Data (Webhook) (HTTP Request): calls youtube-transcript.io (POST)
- Parse Transcript Text (Sheets) (Code): runs custom JavaScript code
- Parse Transcript Text (Webhook) (Code): runs custom JavaScript code
- Save Transcript to Sheet (Google Sheets): append
- Return Transcript Response (Respond to Webhook): sends the response back to the webhook caller
Services it uses
HTTP calls to: youtube-transcript.io
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (6)
- Google Sheets Trigger
n8n-nodes-base.googleSheetsTrigger - Code
n8n-nodes-base.code - HTTP Request
n8n-nodes-base.httpRequest - Google Sheets
n8n-nodes-base.googleSheets - Webhook
n8n-nodes-base.webhook - Respond to Webhook
n8n-nodes-base.respondToWebhook
From the author
YouTube Transcript Extractor This n8n template demonstrates how to extract transcripts from YouTube videos using two different approaches: automated Google Sheets monitoring and direct webhook API calls. Use cases: Content creation, research, accessibility,…