Transcribe YouTube playlists with SerpApi and Gmail into a JSON report
Needs changesWhat this workflow does
This workflow has 8 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Gmail. It also calls googleapis.com over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Fetch Playlist (HTTP Request): calls googleapis.com
- Extract Video IDs (Code): runs custom JavaScript code
- Fetch Transcript via SerpApi (HTTP Request): calls an HTTP API
- Aggregate Transcripts (Item Lists): reshapes item lists (legacy Item Lists node)
- Format Final Report (Code): runs custom JavaScript code
- Convert to File: converts data to a file (to json)
- Send Email (Gmail): uses Gmail
Services it uses
HTTP calls to: googleapis.com
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- Item Lists (legacy) in Aggregate Transcripts: replace with Split Out, Aggregate, Sort, Limit, Remove Duplicates or Summarize (match the operation used).
| Removed in 3.0 | Replace with |
|---|---|
| Item Lists (legacy) Aggregate Transcripts | Split Out, Aggregate, Sort, Limit, Remove Duplicates or Summarize (match the operation used) |
Nodes used (6)
- HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - Item Lists
n8n-nodes-base.itemLists - Convert to File
n8n-nodes-base.convertToFile - Gmail
n8n-nodes-base.gmail - Manual Trigger
n8n-nodes-base.manualTrigger
From the author
This workflow automatically fetches all videos from a specific YouTube playlist, extracts their transcripts using SerpApi, aggregates the text into a single JSON report, and emails the final file via Gmail. It's perfect for content creators, researchers, or…