Automation library · Content

Automate SEO blog creation + social media with OpenAI

Started by a clock, and works across Gmail, Google Sheets, Notion, WordPress and one other. It puts OpenAI behind a retrieval step, so answers are drawn from documents you supply rather than from the model alone. 56 steps: large, and worth reading before you trust it with anything live.

LargeCalls a model: OpenAIRetrieval

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

The flow

Starts it 3Model 19Logic 13Service 21

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

  1. 1When clicking ‘Test workflow’Manual triggerStarts it
  2. 2When Executed by Another WorkflowExecute Workflow triggerStarts it
  3. 3OpenAI 4.1 mini4Lm Chat Open AiModel
  4. 4Simple MemoryMemory Buffer WindowModel
  5. 5Google SheetsGoogle Sheets ToolService
  6. 6get brand briefTool WorkflowModel
  7. 7Structured Output Parser1Output Parser StructuredModel
  8. 8Schedule TriggerSchedule triggerStarts it
  9. 9OpenAI 4.1 miniLm Chat Open AiModel
  10. 10OpenAI 4.1 mini2Lm Chat Open AiModel
  11. 11OpenAI 4.1 mini3Lm Chat Open AiModel
  12. 12OpenAI 4.1 mini1Lm Chat Open AiModel
  13. 13Social Media ContentOutput Parser StructuredModel
  14. 14gpt-4.1 miniLm Chat Open AiModel
  15. 15Idea creatorAgentModel
  16. 16NotionNotionService
  17. 17Write prompt to create imageChain LlmModel
  18. 18Content writerChain LlmModel
  19. 19Excerpt creatorChain LlmModel
  20. 20Write prompt to search imageChain LlmModel
  21. 21Social Media Content CreatorAgentModel
  22. 22Category rewriteCodeLogic
  23. 23AggregateAggregateLogic
  24. 24OpenAIOpen AiModel
  25. 25Cleanup HTML SetLogic
  26. 26WordPress excerpt addHttp RequestService
  27. 27Get Image from PexcelHttp RequestService
  28. 28Edit Fields2SetLogic
  29. 29Edit Fields1SetLogic
  30. 30XTwitterService
  31. 31OpenAI1Open AiModel
  32. 32OpenAI2Open AiModel
  33. 33Perplexity Research1Http RequestService
  34. 34Edit FieldsSetLogic
  35. 35Upload Image to Wordpress2Http RequestService
  36. 36WordpressWordpressService
  37. 37MarkdownMarkdownLogic
  38. 38Download ImageHttp RequestService
  39. 39Merge4MergeLogic
  40. 40Merge3MergeLogic
  41. 41MergeMergeLogic
  42. 42Post image CloudinaryHttp RequestService
  43. 43Post image Cloudinary1Http RequestService
  44. 44Cleanup LinksSetLogic
  45. 45Set Image on Wordpress Post2Http RequestService
  46. 46Update list of blog postGoogle SheetsService
  47. 47Upload Image to WordpressHttp RequestService
  48. 48Facebook Post1Facebook Graph ApiService
  49. 49Upload media to InstagramFacebook Graph ApiService
  50. 50Aggregate1AggregateLogic
  51. 51Update base postGoogle SheetsService
  52. 52Set Image on Wordpress PostHttp RequestService
  53. 53Publish Post on IGFacebook Graph ApiService
  54. 54Add too Data BankGoogle SheetsService
  55. 55Edit Fields3SetLogic
  56. 56GmailGmailService

How it's built

Starts on
A clock
Steps
56
Size
Large: read it before trusting it with anything live
Connects to
Gmail, Google Sheets, Notion, WordPress, X
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, Notion, WordPress and X 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 56 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 56 steps before you point it at anything that matters.