Google Sheet Topics to WordPress Drafts

This workflow turns a list of topics in a Google Sheet into draft posts in WordPress. Each row with the status “Ready” is sent to an AI model with clear instructions. The result is saved as an unpublished draft, the sheet is updated with a link, and you are notified to review. A person always edits and publishes.

At a glance

What it does and does not do

Before you start

• A Google account and a sheet laid out as in the table below.
• A WordPress site and a user with permission to create posts (an author or editor role is enough, do not use an administrator). Create an application password for the connection.
• An account with an AI provider supported by your platform, with a spending limit set.
• The SEO Article Writer skill, which supplies the instructions for the AI step.

Prepare the sheet

The AI instruction (copy and paste)

You are an SEO content writer. Write a draft article using the inputs below.
Topic: {{Topic}}
Primary keyword: {{Primary keyword}}
Audience: {{Audience}}
Notes and facts to use: {{Notes}}

Rules:
- Use the notes first. Do not invent statistics, quotes or sources. Put [verify] after any claim that needs a source.
- Answer the main question in the first two sentences.
- Use one H1-worthy title (return it separately), then H2 and H3 headings in the body.
- Use plain HTML only: p, h2, h3, ul, ol, li, strong, a.

Return ONLY valid JSON with exactly these keys and nothing else:
{"title": "", "slug": "", "excerpt": "", "meta_description": "", "content_html": ""}
The meta_description must be 140 to 155 characters.

Replace the double-brace placeholders with the field-mapping syntax of your platform.

Build steps

1. Trigger on Ready rows. Read rows where Status is “Ready”.
2. Lock the row. Set Status to “Processing” straight away so it cannot run twice.
3. Call the AI model with the instruction above and your row’s values.
4. Read the JSON result into separate fields.
5. Create the WordPress post with status draft, using the title, slug, excerpt and content.
6. Save the meta description into your SEO plugin’s field if your connection allows it. Otherwise add it to the sheet for manual entry.
7. Update the sheet: Status “Drafted”, the post’s edit link and the date.
8. Notify yourself by email or chat with the link.
9. Error path: on any failure set Status to “Error” and write the message in the Error column.

Platform guide

Names change as platforms update, so check the current module, action or node names in your tool. Some actions, such as HTTP calls and AI Builder, may need a paid or premium licence in Power Automate.

Test plan

Cost and limits

• Most platforms count each step or module run, so a nine-step run uses more than a three-step run.
• AI usage is billed separately by your AI provider. Set a monthly spending limit.
• Process a few rows per run while testing, and check retries, which can use extra usage.

Security and privacy

• Use an application password and a least-privilege WordPress user. Never share them in chat.
• Always create drafts, never published posts.
• Do not put confidential information in the Notes column.
• Review every draft for accuracy, originality and tone before publishing.

Variations

• Add an approval step: email the draft link and wait for approval before moving the row to “Approved”.
• Add images: create a featured image separately and attach it after review.
• Outline first: generate an outline into the sheet, approve it, then generate the article.

Troubleshooting

Related in the Library

Use it with the SEO Article Writer, the WordPress Content Editor Agent and the guide How to Automate WordPress Drafts from a Google Sheet. Tools: Make, Make MCP server.