Create SEO-optimized WordPress posts from Google Sheets with OpenAI GPT-4o and DALL·E 3

Description

Quick overview
Automatically generates SEO-optimized 'SEO-Writing.ai' Style 'Health and lifestyle' category WordPress blog drafts from a Google Sheet queue using Open AI (GPT-4o) for content and DALL·E 3 for featured images.

How it works
Runs manually when you click “Test workflow”.
Reads rows from Google Sheets where the Status column is set to Pending and processes them in batches.
Sends each row’s topic, category, keywords, and meta description to an OpenAI-powered agent to generate a structured JSON article with HTML body content.
Uses OpenAI to create a realistic featured-image prompt and generates an image with DALL·E 3.
Uploads the generated image to the WordPress Media Library via the WordPress REST API.
Creates a new WordPress post in draft status using the generated title and content.
Updates the corresponding row in Google Sheets to set Status to Done, then waits one minute before continuing to the next item.

Setup
Connect your Google Sheets OAuth credentials and set the correct spreadsheet ID, sheet/tab, and column names (including a Status column with Pending/Done values).
Add your OpenAI API credentials and ensure the selected models are available (GPT-4o for text and DALL·E 3 for images).
Connect your WordPress credentials for the WordPress node and replace the media upload URL (https://your-website.com/wp-json/wp/v2/media) with your site’s domain.
Configure HTTP Basic Auth (application password recommended) for the WordPress media upload request and ensure WordPress accepts REST media uploads for your user role.