Building a Keyword-to-WordPress SEO Pipeline with n8n, Google Sheets & AI

Description and use

An automated n8n workflow using Google Sheets and AI generates SEO content and publishes it to WordPress, with Slack notifications keeping a human reviewer in the loop.

Problem

Publishing 40+ SEO articles a month is a production infrastructure problem; manual handoffs across tools become bottlenecks and optional steps are skipped.

Outcome

The pipeline reduces manual effort from 3–4 hours per post to under an hour per keyword, eliminates skipped meta fields and alt text, ensures consistent publishing cadence, and keeps a reviewer in the loop before live publishing.

Workflow

• Schedule or Webhook trigger
• Read pending keyword row from Google Sheets and lock it
• Set node to build context
• Switch node routes by content_type
• AI node generates structured content (JSON)
• Function node parses AI JSON
• WP Media Upload node uploads images
• WP Create Draft Post node creates draft with meta
• Google Sheets node updates status to published and draft_url
• Slack node notifies reviewer
• Error branch logs and sets status to failed

Evidence

Publishing 10 SEO articles a month is manageable. Publishing 40+ is a production infrastructure problem

Source

An n8n pipeline eliminates every mechanical step in that list while keeping a human in the loop before anything goes live.

Source