Automation library · Content

Publish blog posts from YouTube transcripts

Started by a clock, and works across Google Docs, Google Sheets, Telegram and WordPress. It hands the judgement calls to Gemini. 38 steps: large, and worth reading before you trust it with anything live.

LargeCalls a model: Gemini

Download free
38 stepsLarge: read it before trusting it with anything live
0Branches: places the flow splits
0Loops or waits
4Services it connects to

The flow

Starts it 3Model 2Logic 9Service 24

The steps in the order they run, from what starts it.

  1. 1When Fetch Playlist ScheduledSchedule triggerStarts it
  2. 2When Blog Generation ScheduledSchedule triggerStarts it
  3. 3Google Gemini ModelLm Chat Google GeminiModel
  4. 4Fetch Internal Links ToolGoogle Sheets ToolService
  5. 5Fetch Transcript from Google DocsGoogle Docs ToolService
  6. 6When Publish ScheduledSchedule triggerStarts it
  7. 7Fetch Playlist ItemsHttp RequestService
  8. 8Fetch All Videos from SheetsGoogle SheetsService
  9. 9Blog Post Generator AgentAgentModel
  10. 10Fetch Pending Posts from SheetsGoogle SheetsService
  11. 11Split Playlist ItemsSplit OutLogic
  12. 12Read Existing Videos from SheetsGoogle SheetsService
  13. 13Filter Unprocessed VideosFilterLogic
  14. 14Parse AI OutputCodeLogic
  15. 15Choose Priority PostCodeLogic
  16. 16Set Video IDSetLogic
  17. 17Filter New Videos OnlyMergeLogic
  18. 18Update Video as ProcessingGoogle SheetsService
  19. 19Append Blog Post to SheetsGoogle SheetsService
  20. 20Publish to WordPressWordpressService
  21. 21Append New Videos to SheetsGoogle SheetsService
  22. 22Update Video as CompletedGoogle SheetsService
  23. 23Create AI Featured ImageHttp RequestService
  24. 24Fetch Transcript via RapidAPIHttp RequestService
  25. 25Notify Content GenerationTelegramService
  26. 26Download AI ImageHttp RequestService
  27. 27Split Transcript LinesSplit OutLogic
  28. 28Transform Image to WebPEdit ImageService
  29. 29Join Transcript LinesAggregateLogic
  30. 30Upload Image to WordPressHttp RequestService
  31. 31Clean and Aggregate TranscriptCodeLogic
  32. 32Associate Image with PostHttp RequestService
  33. 33Create Transcript Google DocGoogle DocsService
  34. 34Send to Telegram ChannelTelegramService
  35. 35Write to Transcript Google DocGoogle DocsService
  36. 36Update Post as PublishedGoogle SheetsService
  37. 37Update Doc Link in SheetsGoogle SheetsService
  38. 38Notify Transcript SavedTelegramService

How it's built

Starts on
A clock
Steps
38
Size
Large: read it before trusting it with anything live
Connects to
Google Docs, Google Sheets, Telegram, WordPress
Model
Gemini

Questions

What does it need to run?

An n8n account, plus your own Google Docs, Google Sheets, Telegram and WordPress accounts, and a key for Gemini. You connect your own accounts after importing it; none are included.

What starts it?

It starts on a clock.

Does it use AI?

Yes. It calls Gemini. Model calls are billed by the provider, not by n8n.

How long does it take to set up?

Take your time. At 38 steps it is large: read it before trusting it with anything live.

How do I import it?

Copy the workflow, open a new workflow in n8n and paste. The steps appear on the canvas, ready for your own accounts.

Before you run it

Nothing here has been tested by us. It is somebody's working automation, read and described from its own steps. Treat the connections it wants as a list of accounts it will touch, and read the 38 steps before you point it at anything that matters.