Automation library · Content

WordPress auto-blogging pro with OpenAI and Google Docs

Started by a clock, and works across Google Docs, Google Drive, Google Sheets and WordPress. It hands the judgement calls to OpenAI. 62 steps, 2 branches, 4 loops or waits: large, and worth reading before you trust it with anything live.

LargeCalls a model: OpenAI

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

The flow

Starts it 4Model 15Logic 26Service 15

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

  1. 1Research ToolTool WorkflowModel
  2. 2When clicking ‘Test workflow’Manual triggerStarts it
  3. 3Structured Output Parser1Output Parser StructuredModel
  4. 4Research Tool1Tool WorkflowModel
  5. 5Structured Output Parser3Output Parser StructuredModel
  6. 6Structured Output Parser4Output Parser StructuredModel
  7. 7Google Sheets TriggerGoogle Sheets triggerStarts it
  8. 8Schedule TriggerSchedule triggerStarts it
  9. 9OpenAI Chat ModelLm Chat Open AiModel
  10. 10OpenAI Chat Model1Lm Chat Open AiModel
  11. 11OpenAI Chat Model2Lm Chat Open AiModel
  12. 12OpenAI Chat Model3Lm Chat Open AiModel
  13. 13Execute Workflow TriggerExecute Workflow triggerStarts it
  14. 14Initial ResearchAgentModel
  15. 15Blog PlannerChain LlmModel
  16. 16ResearcherAgentModel
  17. 17CopywriterChain LlmModel
  18. 18Limit to last postLimitLogic
  19. 19Edit Fields1SetLogic
  20. 20Check empty outputIfLogic
  21. 21Wait2WaitLogic
  22. 22SettingsSetLogic
  23. 23PerplexityAI APIHttp RequestService
  24. 24Create Drive folderGoogle DriveService
  25. 25Loop Over Items2Split In BatchesLogic
  26. 26Check inputsIfLogic
  27. 27Get Research ContentSetLogic
  28. 28Get outputSetLogic
  29. 29Get title chapter and contentSetLogic
  30. 30Get post sitemapHttp RequestService
  31. 31Generate featured imageOpen AiModel
  32. 32Split out chaptersSplit OutLogic
  33. 33Merge chapters title and textMergeLogic
  34. 34Get XML fileXmlLogic
  35. 35Upload featured image to DriveGoogle DriveService
  36. 36Resize featured imageEdit ImageService
  37. 37Loop Over ItemsSplit In BatchesLogic
  38. 38MergeMergeLogic
  39. 39Combine into articleCodeLogic
  40. 40Split out linksSplit OutLogic
  41. 41Merge2MergeLogic
  42. 42Generate chapter imageOpen AiModel
  43. 43Final article in MarkdownSetLogic
  44. 44Limit internal linksLimitLogic
  45. 45Wait featured imageMergeLogic
  46. 46Upload chapter images to DriveGoogle DriveService
  47. 47Resize ImageEdit ImageService
  48. 48Markdown to HTMLMarkdownLogic
  49. 49Aggregate internal linksAggregateLogic
  50. 50Upload featured imageHttp RequestService
  51. 51Merge1MergeLogic
  52. 52Upload chapter imagesHttp RequestService
  53. 53FInal article in HTMLSetLogic
  54. 54Update featured image meta dataHttp RequestService
  55. 55Wait1WaitLogic
  56. 56Update image meta dataHttp RequestService
  57. 57Post on WordpressWordpressService
  58. 58Set featured image for postHttp RequestService
  59. 59Set excerptHttp RequestService
  60. 60Create DocGoogle DocsService

How it's built

Starts on
A clock
Steps
62, with 2 branches, 4 loops or waits
Size
Large: read it before trusting it with anything live
Connects to
Google Docs, Google Drive, Google Sheets, WordPress
Model
OpenAI

Questions

What does it need to run?

An n8n account, plus your own Google Docs, Google Drive, 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. Model calls are billed by the provider, not by n8n.

How long does it take to set up?

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