Automation library · Content

Create WordPress articles in author style with Gemini

Started by an incoming Telegram message, and works across Google Sheets, Pinecone, Reddit, Telegram and one other. It puts Gemini, OpenRouter and one other behind a retrieval step, so answers are drawn from documents you supply rather than from the model alone. 113 steps, 4 branches, 1 loop or waits: large, and worth reading before you trust it with anything live.

LargeCalls a model: Gemini, OpenRouterRetrieval

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

The flow

Starts it 5Model 29Logic 13Service 13

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

  1. 1Schedule TriggerSchedule triggerStarts it
  2. 2StartExecute Workflow triggerStarts it
  3. 3Recursive Character Text SplitterText Splitter Recursive Character Text SplitterModel
  4. 4Embeddings Google Gemini1Embeddings Google GeminiModel
  5. 5Google Gemini Chat ModelLm Chat Google GeminiModel
  6. 6OpenRouter Chat ModelLm Chat Open RouterModel
  7. 7Embeddings Google GeminiEmbeddings Google GeminiModel
  8. 8Google Gemini Chat Model1Lm Chat Google GeminiModel
  9. 9Schedule Trigger2Schedule triggerStarts it
  10. 10Telegram TriggerTelegram triggerStarts it
  11. 11Google Gemini Chat Model8Lm Chat Google GeminiModel
  12. 12OpenRouter Chat Model3Lm Chat Open RouterModel
  13. 13Google Gemini Chat Model9Lm Chat Google GeminiModel
  14. 14OpenRouter Chat Model4Lm Chat Open RouterModel
  15. 15OpenRouter Chat Model1Lm Chat Open RouterModel
  16. 16Google Gemini Chat Model10Lm Chat Google GeminiModel
  17. 17OpenRouter Chat Model5Lm Chat Open RouterModel
  18. 18Google Gemini Chat Model11Lm Chat Google GeminiModel
  19. 19OpenRouter Chat Model6Lm Chat Open RouterModel
  20. 20Google Gemini Chat Model2Lm Chat Google GeminiModel
  21. 21OpenRouter Chat Model2Lm Chat Open RouterModel
  22. 22Google Gemini Chat Model3Lm Chat Google GeminiModel
  23. 23When clicking ‘Execute workflow’Manual triggerStarts it
  24. 24Calculate Filter TimeDate TimeLogic
  25. 25FetchBlogHTMLHttp RequestService
  26. 26Default Data Loader1Document Default Data LoaderModel
  27. 27Pinecone Vector Store1Vector Store PineconeModel
  28. 28AI AgentAgentModel
  29. 29AI Agent1AgentModel
  30. 30Pinecone Vector StoreVector Store PineconeModel
  31. 31Get many postsRedditService
  32. 32Source 1BrowserlessService
  33. 33Source 2BrowserlessService
  34. 34Source 3BrowserlessService
  35. 35SwitchSwitchLogic
  36. 36Basic LLM Chain5Chain LlmModel
  37. 37Basic LLM ChainChain LlmModel
  38. 38AI Agent3AgentModel
  39. 39Basic LLM Chain6Chain LlmModel
  40. 40Basic LLM Chain1Chain LlmModel
  41. 41AI Agent2AgentModel
  42. 42Get All Articles from SheetGoogle SheetsService
  43. 43FetchAuthorListGoogle SheetsService
  44. 44BlogSitemapFetchHttp RequestService
  45. 45HTML1HtmlLogic
  46. 46Update row in sheetGoogle SheetsService
  47. 47Code in JavaScriptCodeLogic
  48. 48Code in JavaScript1CodeLogic
  49. 49Remove Duplicates1Remove DuplicatesLogic
  50. 50HTMLHtmlLogic
  51. 51HTML3HtmlLogic
  52. 52HTML2HtmlLogic
  53. 53Edit Fields7SetLogic
  54. 54Parse Author DataCodeLogic
  55. 55Parse New TopicCodeLogic
  56. 56Parse New Topic1CodeLogic
  57. 57Get many posts2WordpressService
  58. 58Get row(s) in sheetGoogle SheetsService
  59. 59Get Author Style1Google SheetsService
  60. 60Get many posts1WordpressService

How it's built

Starts on
An incoming Telegram message
Steps
113, with 4 branches, 1 loop or waits
Size
Large: read it before trusting it with anything live
Connects to
Google Sheets, Pinecone, Reddit, Telegram, WordPress
Model
Gemini, OpenRouter, Perplexity
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 Google Sheets, Pinecone, Reddit, Telegram and WordPress accounts, and a key for Gemini and OpenRouter. You connect your own accounts after importing it; none are included.

What starts it?

It starts on an incoming Telegram message.

Does it use AI?

Yes. It calls Gemini, OpenRouter and Perplexity. 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 113 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 113 steps before you point it at anything that matters.