n8n Workflow: Google Sheets → WordPress SEO Drafts w/ Gemini

Turn a Google Sheets topic into a validated SEO WordPress draft—automatically, every week

This n8n workflow pulls your selected topics from Google Sheets, uses Google Gemini to generate an SEO-ready HTML article and 3 images, uploads the media to WordPress, updates draft metadata back to the sheet, and sends a Gmail notification for visibility and reconciliation.

What this workflow does

• Runs weekly on a schedule trigger and reads Google Sheets rows where Pick is set to 1.
• Selects the first eligible row that isn’t already marked DraftReady or Published, then prepares the topic, SEO fields, slug, category slug, and image style inputs.
• Prevents duplicates by querying the WordPress REST API for an existing post with the same slug; if found, it updates the sheet with the post ID/URL and emails a reconciliation notice via Gmail.
• If no duplicate exists and the row isn’t already Processing, it marks the row as Processing, fetches the WordPress category by slug, and proceeds.
• Uses Google Gemini to generate an <article> HTML block with required image placeholders, then validates the HTML for structure, unsafe elements, placeholders, and minimum length.
• Generates three image briefs, creates images with Gemini Image, converts them to JPEG, and uploads them to WordPress’s media library.
• Replaces image placeholders with the uploaded image URLs, creates a WordPress draft, sets the featured image and excerpt, assigns the category, and commits DraftReady status and links back to Google Sheets.

Use cases

• Weekly content production for SaaS blogs driven by a Google Sheets editorial calendar.
• Engineering teams that want automated SEO drafts with image generation and HTML validation before posting.
• Operators who need duplicate detection (slug-based) and reconciliation alerts via Gmail.

Technical details

• Integrations: Google Sheets, WordPress REST API, Google Gemini (article + Gemini Image), Gmail
• Key n8n node types: if, set, code, gmail, split out, edit image