n8n Workflow: Google Sheets → SEO Blog via OpenAI HTTP API

Turn Google Sheets blog ideas into SEO-ready pages with OpenAI + your CMS

This 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.

What this workflow does

• Triggers every minute when a new row is added to a specified worksheet.
• Reads your new row data, pulling the Idea value and applying defaults for language, category, status, and a UNIX timestamp.
• Calls OpenAI to generate content by sending the blog idea and selected language to the OpenAI API, receiving a JSON response that includes an SEO title, meta fields, and HTML article content.
• Maps fields into a page payload (page title, description/content, meta description, status, category, storefront, timestamp).
• Publishes the page by sending a POST request to /api/2.0/pages on your target site using HTTP Basic Auth.

Use cases

• SaaS teams that collect content topics in Google Sheets and want fast SEO publishing without constant operator involvement.
• Automation engineers building repeatable content pipelines with n8n, OpenAI, and a CMS HTTP API.
• SEO operators who standardize language, category, and publication status while generating HTML articles and meta fields automatically.

Technical details

• n8n nodes/workflow components: Google Sheets Trigger, Set, OpenAI via n8nn8n-nodes-langchainopen ai, and HTTP Request.
• OpenAI model: GPT-4o-mini (as configured in the workflow).
• CMS integration: HTTP Request POST to /api/2.0/pages with HTTP Basic Auth.
• Required sheet column: an Idea column matching the workflow’s field reference.