{"product_id":"n8n-workflow-google-sheets-seo-blog-via-openai-http-api","title":"n8n Workflow: Google Sheets → SEO Blog via OpenAI HTTP API","description":"\u003ch3\u003eTurn Google Sheets blog ideas into SEO-ready pages with OpenAI + your CMS\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically watches a Google Sheets tab for new blog ideas, generates an SEO-ready article using OpenAI (GPT-4o-mini), and publishes the resulting page to your website via an HTTP API POST request—no manual writing-to-publish handoffs.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eTriggers every minute\u003c\/b\u003e when a new row is added to a specified worksheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eReads your new row data\u003c\/b\u003e, pulling the \u003cb\u003eIdea\u003c\/b\u003e value and applying defaults for \u003cb\u003elanguage\u003c\/b\u003e, \u003cb\u003ecategory\u003c\/b\u003e, \u003cb\u003estatus\u003c\/b\u003e, and a \u003cb\u003eUNIX timestamp\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eCalls OpenAI to generate content\u003c\/b\u003e by sending the blog idea and selected language to the \u003cb\u003eOpenAI\u003c\/b\u003e API, receiving a \u003cb\u003eJSON response\u003c\/b\u003e that includes an SEO title, meta fields, and \u003cb\u003eHTML article content\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eMaps fields into a page payload\u003c\/b\u003e (page title, description\/content, meta description, status, category, storefront, timestamp).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003ePublishes the page\u003c\/b\u003e by sending a \u003cb\u003ePOST\u003c\/b\u003e request to \u003cb\u003e\/api\/2.0\/pages\u003c\/b\u003e on your target site using \u003cb\u003eHTTP Basic Auth\u003c\/b\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eSaaS teams\u003c\/b\u003e that collect content topics in Google Sheets and want fast SEO publishing without constant operator involvement.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eAutomation engineers\u003c\/b\u003e building repeatable content pipelines with n8n, OpenAI, and a CMS HTTP API.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eSEO operators\u003c\/b\u003e who standardize language, category, and publication status while generating HTML articles and meta fields automatically.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003en8n nodes\/workflow components:\u003c\/b\u003e Google Sheets Trigger, Set, OpenAI via \u003cb\u003en8nn8n-nodes-langchainopen ai\u003c\/b\u003e, and HTTP Request.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eOpenAI model:\u003c\/b\u003e GPT-4o-mini (as configured in the workflow).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eCMS integration:\u003c\/b\u003e HTTP Request POST to \u003cb\u003e\/api\/2.0\/pages\u003c\/b\u003e with \u003cb\u003eHTTP Basic Auth\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eRequired sheet column:\u003c\/b\u003e an \u003cb\u003eIdea\u003c\/b\u003e column matching the workflow’s field reference.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45962330046643,"sku":"N8N-18909","price":21.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/tRSb_PiRPPs_vB1BOkoX_awFRWy8R.png?v=1788600516","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-google-sheets-seo-blog-via-openai-http-api","provider":"N8N Commerce","version":"1.0","type":"link"}