Automation library · Content

Autonomous blog publishing from YouTube videos with Sheets

Started by a clock, and works across Gmail, Google Sheets and WordPress. It puts OpenAI behind a retrieval step, so answers are drawn from documents you supply rather than from the model alone. 65 steps, 4 branches, 1 loop or waits: large, and worth reading before you trust it with anything live.

LargeCalls a model: OpenAIRetrieval

Download free
65 stepsLarge: read it before trusting it with anything live
4Branches: places the flow splits
1Loop or waits
3Services it connects to

The flow

Starts it 2Model 14Logic 23Service 21

The steps in the order they run, from what starts it. The first 60 of 65.

  1. 1ManualManual triggerStarts it
  2. 2Schedule TriggerSchedule triggerStarts it
  3. 3OpenAI Chat ModelLm Chat Open AiModel
  4. 4Simple MemoryMemory Buffer WindowModel
  5. 5Append Sheet keysGoogle Sheets ToolService
  6. 6Structured Output ParserOutput Parser StructuredModel
  7. 7db insert keyGoogle Sheets ToolService
  8. 8db consultigGoogle Sheets ToolService
  9. 9Structured Output Parser1Output Parser StructuredModel
  10. 10OpenAILm Chat Open AiModel
  11. 11Describe your ideaSetLogic
  12. 12New keyword genAgentModel
  13. 13Generate keysOpen AiModel
  14. 14Message a model1Open AiModel
  15. 15AI AgentAgentModel
  16. 16empty file checkGoogle SheetsService
  17. 17count intentIfLogic
  18. 18APIS ConfigsSetLogic
  19. 19Get False Key1Google SheetsService
  20. 20Merge URLsCodeLogic
  21. 21Message a modelOpen AiModel
  22. 22check empty fileCodeLogic
  23. 23Get False KeyGoogle SheetsService
  24. 24Agent 3Http RequestService
  25. 25Email sendSetLogic
  26. 26select keyCodeLogic
  27. 27GET Video UsedGoogle SheetsService
  28. 28If empty fileIfLogic
  29. 29select key altCodeLogic
  30. 30limit randomCodeLogic
  31. 31Error why1Stop And ErrorLogic
  32. 32KeywordsSetLogic
  33. 33Update row in sheetGoogle SheetsService
  34. 34Check duplicateCodeLogic
  35. 35Update row in sheet1Google SheetsService
  36. 36BLOG OPTIONSSetLogic
  37. 37Agent 1Http RequestService
  38. 38if duplicateIfLogic
  39. 39Today dateCodeLogic
  40. 40custom filterCodeLogic
  41. 41Add video in dbGoogle SheetsService
  42. 42Count False KeyGoogle SheetsService
  43. 43custom splitCodeLogic
  44. 44SummarizeSummarizeService
  45. 45Loop Over ItemsSplit In BatchesLogic
  46. 46IfIfLogic
  47. 47Rename KeysRename KeysService
  48. 48Agent Http RequestService
  49. 49Merge VideoCodeLogic
  50. 50AI TranslateOpen AiModel
  51. 51AI Generator PostOpen AiModel
  52. 52Markdown to htmlMarkdownLogic
  53. 53Create a postWordpressService
  54. 54Pexels search imageHttp RequestService
  55. 55Merge urlsCodeLogic
  56. 56Select imageOpen AiModel
  57. 57Download Pexels Image1Http RequestService
  58. 58Upload Image wpHttp RequestService
  59. 59Set Featured Image wpHttp RequestService
  60. 60meta descr and title genOpen AiModel

How it's built

Starts on
A clock
Steps
65, with 4 branches, 1 loop or waits
Size
Large: read it before trusting it with anything live
Connects to
Gmail, Google Sheets, WordPress
Model
OpenAI
Retrieval
Answers are drawn from documents you supply, not from the model alone

Questions

What does it need to run?

An n8n account, plus your own Gmail, Google Sheets and WordPress accounts, and a key for OpenAI. 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 OpenAI. Its answers draw on documents you give it, not on the model alone. Model calls are billed by the provider, not by n8n.

How long does it take to set up?

Take your time. At 65 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 65 steps before you point it at anything that matters.