n8n Workflow: Create WordPress Drafts from Google Sheets with OpenAI

Turn “ready to submit” Google Sheets articles into WordPress drafts automatically—using OpenAI formatting

This n8n workflow pulls an article from your Google Sheets when it’s marked as 入稿待ち, formats the body into WordPress-ready HTML with OpenAI, and then creates a draft post in WordPress using the sheet’s タイトル.

What this workflow does

• Manual start: Click Execute workflow in n8n to run.
• Read the next article: The workflow finds the first matching Google Sheets row where 入稿ステータス equals 入稿待ち.
• Format content with OpenAI: It sends 完成本文 (the article body) to OpenAI to convert it into WordPress-ready HTML—without changing the original content.
• Create a WordPress draft: Using タイトル and the OpenAI-returned HTML, it creates the post in WordPress as a draft.

Use cases

• Content teams who draft articles in Google Sheets and need fast, consistent WordPress draft creation.
• SaaS operators managing multi-step publishing pipelines (approval in Sheets, publishing in WordPress).
• Automation engineers who want an n8n workflow that reliably bridges Google Sheets → OpenAI → WordPress.

Technical details

• n8n nodes / integrations: Google Sheets, OpenAI (for HTML formatting), WordPress (REST API) plus a manual trigger.
• Template included: Copy the free Google Sheets template from the provided link.
• Setup steps: Add Google Sheets credentials and select the copied spreadsheet + 記事管理 sheet; add OpenAI credentials and choose the model; set the Google Sheets filter to 入稿ステータス = 入稿待ち.
• Inputs required: 完成本文 (article body) and タイトル (WordPress post title).

Requirements: an n8n account, Google account, OpenAI API access, and a WordPress site with REST API access.