Publish Japanese SEO WordPress Posts from Google Sheets with GPT-4o

Automatically publish Japanese SEO WordPress posts from Google Sheets using GPT-4o

This n8n workflow pulls the next Japanese SEO keyword from your Google Sheets, generates a fully SEO-ready article with OpenAI (gpt-4o-mini / GPT-4o access), publishes it to WordPress, and logs the results back to the same sheet—running on a 25-minute schedule.

What this workflow does

• Scheduled execution: Runs every 25 minutes via a Schedule Trigger.
• Reads the next keyword: Connects to Google Sheets, targets the sheet named “Keywords”, and retrieves the next topic/keyword.
• Generates Japanese SEO content: Sends the keyword to OpenAI (gpt-4o-mini) to produce a Japanese SEO-ready result in JSON including: title, slug, category ID, meta description, and WordPress-ready HTML.
• Publishes to WordPress: Creates and publishes a new WordPress post using the generated title, slug, category ID, and HTML content.
• Updates your tracking sheet: Appends or updates the matching row by Keyword with publish status, post URL, category, and processing/published timestamps.

Use cases

• SEO teams and SaaS operators managing content pipelines from a simple Google Sheets queue.
• Automation engineers who want hands-off Japanese SEO publishing to WordPress with consistent metadata and formatting.
• Teams who need a repeatable workflow: generate → publish → track results in one place.

Technical details

• Integrations / nodes: Google Sheets, Schedule Trigger, OpenAI (gpt-4o-mini / GPT-4o access), and WordPress (REST API create post + assign category by ID).
• Workflow category: n8n automation workflow.
• Requires: WordPress REST API enabled, permission to create posts and assign categories by ID, and a Google Sheet with a “Keywords” tab including columns such as Keyword, Title, Category, Status, PostURL, PublishedDate, Processed, and ProcessedDate.