Publish blog posts from YouTube transcripts to WordPress and Telegram with Gemini
Needs changesWhat this workflow does
This AI workflow has 38 nodes and runs on a schedule (every day) (plus 2 other triggers). Along the way it connects Google Sheets, Google Docs, Telegram and Google Gemini Chat Model and 1 more. It also calls googleapis.com and youtube-transcript3.p.rapidapi.com over HTTP.
How it runs
Trigger: On a schedule (every day) (plus 2 other triggers).
- Fetch Playlist Items (HTTP Request): calls googleapis.com
- Fetch All Videos from Sheets (Google Sheets): uses Google Sheets
- Fetch Pending Posts from Sheets (Google Sheets): uses Google Sheets
- Split Playlist Items (Split Out): splits a list into separate items
- Read Existing Videos from Sheets (Google Sheets): uses Google Sheets
- Filter: keeps only the items that match a condition
- Choose Priority Post (Code): runs custom JavaScript code
- Set Video ID (Edit Fields (Set)): sets 1 field: videoID
- Filter New Videos Only (Merge): merges the data from its input branches
- Update Video as Processing (Google Sheets): update
…plus 22 more steps. See the full node list below.
Services it uses
HTTP calls to: googleapis.com, youtube-transcript3.p.rapidapi.com
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- AI Agent v1 (old agent modes) in Blog Post Generator Agent (v1.7): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) Blog Post Generator Agent (v1.7) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (17)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - HTTP Request
n8n-nodes-base.httpRequest - Split Out
n8n-nodes-base.splitOut - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - Merge
n8n-nodes-base.merge - Aggregate
n8n-nodes-base.aggregate - Code
n8n-nodes-base.code - Google Docs
n8n-nodes-base.googleDocs - Telegram
n8n-nodes-base.telegram - Filter
n8n-nodes-base.filter - AI Agent
@n8n/n8n-nodes-langchain.agent - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Google Sheets Tool
n8n-nodes-base.googleSheetsTool - Google Docs Tool
n8n-nodes-base.googleDocsTool - Wordpress
n8n-nodes-base.wordpress - Edit Image
n8n-nodes-base.editImage
From the author
Who is this for? Content creators, media teams, and bloggers who run a YouTube channel and want to automatically repurpose video content into SEO-ready blog posts — without manual writing. Ideal for anyone publishing news or educational content in any…