{"product_id":"n8n-workflow-create-wordpress-seo-posts-from-google-sheets-openai","title":"n8n Workflow: Create WordPress SEO Posts from Google Sheets + OpenAI","description":"\u003ch3\u003eTurn a Google Sheets queue into SEO-ready WordPress drafts—automatically\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003en8n workflow\u003c\/strong\u003e creates \u003cstrong\u003eSEO-optimized WordPress blog drafts\u003c\/strong\u003e from your \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e using \u003cstrong\u003eOpenAI (GPT-4o)\u003c\/strong\u003e for structured article content and \u003cstrong\u003eDALL·E 3\u003c\/strong\u003e for realistic featured images—then publishes each post as a \u003cstrong\u003edraft\u003c\/strong\u003e and marks the row as \u003cstrong\u003eDone\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns manually\u003c\/strong\u003e when you click \u003cem\u003e“Test workflow”\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003eReads rows from \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e where the \u003cstrong\u003eStatus\u003c\/strong\u003e column is set to \u003cstrong\u003ePending\u003c\/strong\u003e, processing items in \u003cstrong\u003ebatches\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eFor each row, sends the \u003cstrong\u003etopic, category, keywords, and meta description\u003c\/strong\u003e to an \u003cstrong\u003eOpenAI-powered agent\u003c\/strong\u003e to generate a \u003cstrong\u003estructured JSON article\u003c\/strong\u003e with an \u003cstrong\u003eHTML body\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eGenerates a \u003cstrong\u003efeatured-image prompt\u003c\/strong\u003e with OpenAI and creates an image using \u003cstrong\u003eDALL·E 3\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eUploads the image to the \u003cstrong\u003eWordPress Media Library\u003c\/strong\u003e via the WordPress \u003cstrong\u003eREST API\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eCreates a new \u003cstrong\u003eWordPress post\u003c\/strong\u003e in \u003cstrong\u003edraft status\u003c\/strong\u003e using the generated title and content.\u003c\/li\u003e\n  \u003cli\u003eUpdates the source Google Sheets row to \u003cstrong\u003eStatus = Done\u003c\/strong\u003e, then \u003cstrong\u003ewaits one minute\u003c\/strong\u003e before moving to the next item.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eMaintain a content pipeline for \u003cstrong\u003ehealth and lifestyle\u003c\/strong\u003e topics in Google Sheets and generate \u003cstrong\u003eSEO-Writing.ai style\u003c\/strong\u003e drafts in WordPress.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers and SaaS operators: produce consistent \u003cstrong\u003eSEO posts\u003c\/strong\u003e without manual writing\/editing for every draft.\u003c\/li\u003e\n  \u003cli\u003eQueue-based publishing: keep \u003cstrong\u003ePending\/Done\u003c\/strong\u003e statuses to track progress end-to-end.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets OAuth\u003c\/strong\u003e: spreadsheet ID, tab\/sheet name, and column names (including \u003cstrong\u003eStatus\u003c\/strong\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenAI\u003c\/strong\u003e: \u003cstrong\u003eGPT-4o\u003c\/strong\u003e for text\/JSON article generation; \u003cstrong\u003eDALL·E 3\u003c\/strong\u003e for featured images.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWordPress\u003c\/strong\u003e: create posts via WordPress node; upload media using \u003ccode\u003e\/wp-json\/wp\/v2\/media\u003c\/code\u003e (replace with your domain).\u003c\/li\u003e\n  \u003cli\u003en8n nodes: \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003eno op\u003c\/strong\u003e, \u003cstrong\u003ewait\u003c\/strong\u003e, \u003cstrong\u003ewordpress\u003c\/strong\u003e, \u003cstrong\u003esticky note\u003c\/strong\u003e, \u003cstrong\u003eHTTP Request\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45916547383475,"sku":"N8N-18770","price":62.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/SrQoWq7oD19u-_xd1Zqtr_P3GVlc38.png?v=1788035124","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-create-wordpress-seo-posts-from-google-sheets-openai","provider":"N8N Commerce","version":"1.0","type":"link"}