Quick overview
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. An n8n automation workflow template by Bala Turimella.
Bala Turimella
web
free
Others in the same category, ranked by how often they are opened.
