Generate SEO blog drafts from Google Sheets to WordPress with OpenAI

Description

Generate SEO-friendly WordPress blog drafts from a Google Sheets queue using OpenAI. This workflow writes full HTML blog content, selects a relevant Pexels featured image with a second AI Agent, uploads the image to WordPress, creates the post as a draft, routes posts to the correct WordPress site, updates the sheet with the draft/post URL, logs failures, and sends a Gmail completion email.

What This Workflow Does

This workflow automates the blog draft creation process from Google Sheets to WordPress.

It can:

- Read pending blog requests from Google Sheets - Process only rows where done is unchecked, empty, or set to false - Generate SEO-friendly blog drafts with OpenAI - Create a WordPress-ready HTML article with H2/H3 headings, paragraphs, lists, and internal links - Generate a blog title, SEO meta title, SEO meta description, URL slug, primary keyword, and image search query - Search Pexels for relevant landscape images - Use a second AI Agent to choose the most suitable featured image - Generate natural image alt text - Store selected image details back into Google Sheets - Upload the selected image to the WordPress media library - Create the WordPress post as a draft - Set the uploaded image as the featured image - Route posts to the correct WordPress site based on the website column - Update the sheet with the WordPress draft/post URL and mark the row as complete - Log failures, empty runs, and completion events with timestamps - Send a Gmail completion email after all rows are processed

Who Is This For?

This workflow is useful for: