{"product_id":"n8n-workflow-google-sheets-wordpress-seo-drafts-w-gemini","title":"n8n Workflow: Google Sheets → WordPress SEO Drafts w\/ Gemini","description":"\u003ch3\u003eTurn a Google Sheets topic into a validated SEO WordPress draft—automatically, every week\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow pulls your selected topics from \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, uses \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e to generate an SEO-ready HTML article and 3 images, uploads the media to \u003cstrong\u003eWordPress\u003c\/strong\u003e, updates draft metadata back to the sheet, and sends a \u003cstrong\u003eGmail\u003c\/strong\u003e notification for visibility and reconciliation.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns weekly\u003c\/strong\u003e on a schedule trigger and reads Google Sheets rows where \u003cem\u003ePick\u003c\/em\u003e is set to \u003cstrong\u003e1\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eSelects the \u003cstrong\u003efirst eligible row\u003c\/strong\u003e that isn’t already marked \u003cstrong\u003eDraftReady\u003c\/strong\u003e or \u003cstrong\u003ePublished\u003c\/strong\u003e, then prepares the topic, SEO fields, slug, category slug, and image style inputs.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePrevents duplicates\u003c\/strong\u003e by querying the \u003cstrong\u003eWordPress REST API\u003c\/strong\u003e 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 \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eIf no duplicate exists and the row isn’t already \u003cstrong\u003eProcessing\u003c\/strong\u003e, it marks the row as \u003cstrong\u003eProcessing\u003c\/strong\u003e, fetches the WordPress category by slug, and proceeds.\u003c\/li\u003e\n  \u003cli\u003eUses \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e to generate an \u003cstrong\u003e\u0026lt;article\u0026gt;\u003c\/strong\u003e HTML block with \u003cstrong\u003erequired image placeholders\u003c\/strong\u003e, then validates the HTML for structure, unsafe elements, placeholders, and minimum length.\u003c\/li\u003e\n  \u003cli\u003eGenerates \u003cstrong\u003ethree image briefs\u003c\/strong\u003e, creates images with \u003cstrong\u003eGemini Image\u003c\/strong\u003e, converts them to \u003cstrong\u003eJPEG\u003c\/strong\u003e, and uploads them to WordPress’s media library.\u003c\/li\u003e\n  \u003cli\u003eReplaces image placeholders with the uploaded \u003cstrong\u003eimage URLs\u003c\/strong\u003e, creates a \u003cstrong\u003eWordPress draft\u003c\/strong\u003e, sets the featured image and excerpt, assigns the category, and commits \u003cstrong\u003eDraftReady\u003c\/strong\u003e status and links back to Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eWeekly content production for SaaS blogs driven by a Google Sheets editorial calendar.\u003c\/li\u003e\n  \u003cli\u003eEngineering teams that want automated SEO drafts with image generation and HTML validation before posting.\u003c\/li\u003e\n  \u003cli\u003eOperators who need duplicate detection (slug-based) and reconciliation alerts via Gmail.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Google Sheets, WordPress REST API, Google Gemini (article + Gemini Image), Gmail\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eKey n8n node types:\u003c\/strong\u003e \u003cem\u003eif\u003c\/em\u003e, \u003cem\u003eset\u003c\/em\u003e, \u003cem\u003ecode\u003c\/em\u003e, \u003cem\u003egmail\u003c\/em\u003e, \u003cem\u003esplit out\u003c\/em\u003e, \u003cem\u003eedit image\u003c\/em\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45938272862387,"sku":"N8N-19001","price":30.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/2x0l-6X5mtu7FjdAIlKjB_nT4Lahcy.png?v=1788341079","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-google-sheets-wordpress-seo-drafts-w-gemini","provider":"N8N Commerce","version":"1.0","type":"link"}