The flow
Starts it 1Model 1Logic 8Service 11
The steps in the order they run, from what starts it.
- 1Schedule Trigger1Schedule triggerStarts it
- 2Get post information from SpreadsheetGoogle SheetsService
- 3Compare date of spreadsheet and todaysIfLogic
- 4Edit FieldsSetLogic
- 5GET information from sitemapHttp RequestService
- 6XMLXmlLogic
- 7Split OutSplit OutLogic
- 8AggregateAggregateLogic
- 9Generate all the necessary information of postOpen AiModel
- 10Code in JavaScriptCodeLogic
- 11Send to Wordpress2WordpressService
- 12GET imageHttp RequestService
- 13Code in JavaScript1CodeLogic
- 14Edit Feature ImageEdit ImageService
- 15Upload feature imageHttp RequestService
- 16Added feature image meta informationHttp RequestService
- 17Design the postHtmlLogic
- 18Added post excerptHttp RequestService
- 19Post feature image meta informationHttp RequestService
- 20Added meta title, meta description and meta image for postHttp RequestService
- 21Send a Email to adminGmailService
How it's built
- Starts on
- A clock
- Steps
- 21, with 1 branch
- Size
- Large: read it before trusting it with anything live
- Connects to
- Gmail, Google Sheets, WordPress
- Model
- OpenAI
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. Model calls are billed by the provider, not by n8n.
How long does it take to set up?
Take your time. At 21 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.
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 21 steps before you point it at anything that matters.