Automation library · Content

Automate RSS content to blog posts with WordPress and LinkedIn

Started by another system calling it, and works across Gmail, Google Sheets, LinkedIn, RSS and two others. It hands the judgement calls to OpenAI. 36 steps, 3 branches, 3 loops or waits: large, and worth reading before you trust it with anything live.

LargeCalls a model: OpenAI

Download free
36 stepsLarge: read it before trusting it with anything live
3Branches: places the flow splits
3Loops or waits
6Services it connects to

The flow

Starts it 3Model 3Logic 16Service 14

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

  1. 1Schedule TriggerSchedule triggerStarts it
  2. 2OpenAI Chat Model1Lm Chat Open AiModel
  3. 3Approval WebhookWebhookStarts it
  4. 4Fetch RowGoogle Sheets triggerStarts it
  5. 5RSS TechCrunchRss Feed ReadService
  6. 6RSS TheVergeRss Feed ReadService
  7. 7Generate Blog PostAgentModel
  8. 8Update Approve StatusGoogle SheetsService
  9. 9Check StatusSwitchLogic
  10. 10Merge RSS FeedsMergeLogic
  11. 11Set Blog Creation DateCodeLogic
  12. 12Check if Already PublishedIfLogic
  13. 13Notify RejectionGmailService
  14. 14Wait for Status UpdateWaitLogic
  15. 15Date FilterIfLogic
  16. 16Set FieldsSetLogic
  17. 17Apply Blog TemplateCodeLogic
  18. 18Limit ArticlesLimitLogic
  19. 19Format Fields for StorageCodeLogic
  20. 20Store Blog Posts FinalGoogle SheetsService
  21. 21Extract ContentFunctionLogic
  22. 22Add Featured ImageCodeLogic
  23. 23Loop Over Blog PostsSplit In BatchesLogic
  24. 24Fetch Full ArticleHttp RequestService
  25. 25Store Blog Posts InitialGoogle SheetsService
  26. 26NNotify Telegram on CompletionTelegramService
  27. 27Delay Between PostsWaitLogic
  28. 28Extract Article BodyHtml ExtractService
  29. 29Prepare Fields Foor NotificationSetLogic
  30. 30Post to LinkedInLinked InService
  31. 31Post to WordpressWordpressService
  32. 32Copy of the RenderedBlogGmailService
  33. 33Convert to MarkdownFunctionLogic
  34. 34Notify for ReviewGmailService
  35. 35Update Publish StatusGoogle SheetsService
  36. 36Generate SEO KeywordsOpen AiModel

How it's built

Starts on
Another system calling it
Steps
36, with 3 branches, 3 loops or waits
Size
Large: read it before trusting it with anything live
Connects to
Gmail, Google Sheets, LinkedIn, RSS, Telegram, WordPress
Model
OpenAI

Questions

What does it need to run?

An n8n account, plus your own Gmail, Google Sheets, LinkedIn, RSS, Telegram 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 another system calling it.

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 36 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 36 steps before you point it at anything that matters.