Publish blog posts from YouTube transcripts to WordPress and Telegram with Gemini

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

What it does

This workflow runs three fully automated pipelines that take a YouTube video all the way to a published WordPress post:

Pipeline 1 — Transcript Collector runs on a schedule, fetches new videos from your YouTube playlist via the YouTube Data API, retrieves their full transcripts via RapidAPI, saves each transcript to a Google Doc, and logs metadata to Google Sheets.

Pipeline 2 — AI Blog Generator picks up unprocessed transcripts, sends them to a Gemini AI Agent that reads the transcript and your existing published posts (for internal linking), then generates structured blog content: title, body (HTML), summary, tags, Telegram caption, image prompt, and publish priority. Results are saved to a second Google Sheet as pending.

Pipeline 3 — Publisher runs every 3 hours, selects the highest-priority pending post (urgent > normal > evergreen), publishes it to WordPress, generates a featured image via an AI image API, uploads and attaches it to the post, then announces it to a Telegram channel.

How to set up