What it is:

An automation to plan → draft → finalize and publish your textual blog post ideas to your WordPress blog.

Works in stages and hands back control to you in between those. You can use a Google Spreadsheet for planning topics and configuring LLM models and prompts.

What it does:

Plans → drafts → finalizes blog post topics you specify in a Google Spreadsheet using an LLM with prompts that are also configured in that spreadsheet (including which model to use).

Saves the results in the corresponding columns of the “Schedule” sheet in the spreadsheet. Hands control back to the user for inspecting or changing the results and for setting the next “Action” for the workflow.

Finally, publishes the blog post to your WordPress instance.

Limitations:

Probably slightly over-engineered 😉

No media generation yet.

Some LLM models don’t work because of their output format.

How it works:

The workflow is triggered manually or scheduled every hour. It ingests a Google Spreadsheet to get:

– Config for prompts/context, etc.
– Blog topics and their status and next action.

Depending on each blog topic’s “Status” and “Action,” it then either uses an LLM for the next action (“plan” → “draft” → “final” actions) or publishes the written content to your WordPress instance (“publish” actions).

Set up steps:

1. Import the workflow.
2. Make your own copy of the Google Spreadsheet.
3. Update the credentials using your individual credentials for:
– Google Spreadsheets
– OpenRouter
4. Edit the “Settings” node and enter your individual values for:
– Your spreadsheet copy URL
– Your WordPress blog URL
– Your WordPress blog username
– Your WordPress blog app password (a 4×4 alphanumeric sequence), that you probably have to create first, for which your WordPress user has to have 2-factor authentication enabled.
5. In your own copy of the spreadsheet:
– Individualize the “Config” sheet’s “Value” column for the prompts/context/etc.
– Populate the “Schedule” sheet with at least one line in which you specify:
– A “Topic”
– A “Scheduled” date (YYYY-MM-DD HH:mm:ss)
– A “Status” of “idea”
– An “Action” of “plan” (to kick off that action).