n8n Workflow: Auto-Generate WordPress Posts from Google Sheets AI

Turn Google Sheets data into WordPress posts automatically—using AI

This n8n workflow auto-generates WordPress posts from your Google Sheets entries, leveraging Google Sheets AI to produce post content and then publishing it to your WordPress site—so you can scale content operations without manual writing.

What this workflow does

• Starts with a Manual Trigger so you can run the process on demand (or test it quickly before scheduling it elsewhere).
• Reads content from Google Sheets using the Google Sheets node as the single source of truth for your article ideas and fields.
• Uses Google Sheets AI to generate the WordPress post text based on the data in your sheet (e.g., prompts or context provided in the row).
• Prepares the post payload with a Set node to format the generated output into the structure required for WordPress.
• Publishes via WordPress using the WordPress node (and supporting HTTP Request steps where needed for the API interactions).
• Includes a Sticky Note in the workflow to document steps and make it easier to maintain and hand off.

Use cases

• SaaS content pipelines: maintain an ideas and metadata sheet, then auto-create corresponding WordPress posts.
• Editorial ops: generate draft posts from structured spreadsheet data for faster review and publishing.
• Marketing teams: scale multi-topic publishing by adding new rows to Google Sheets and triggering the workflow.
• Ops teams: convert internal knowledge captured in spreadsheets into consistent WordPress updates.

Technical details

• Nodes/steps: Manual Trigger, Google Sheets, Set, WordPress, HTTP Request, Sticky Note
• Core integrations: Google Sheets (source data + AI generation) → WordPress (publish generated posts)