Generate WordPress Content Drafts Using Perplexity Research

5 min setup

No coding required

Runs automatically

Build a content machine that works while you sleep. Each time you add a topic to your Google Sheets content spreadsheet, this workflow triggers Perplexity to dive deep into trend analysis, competitor research, and audience behavior patterns. MESA's AI tool, powered by ChatGPT, then generates comprehensive content briefs with key insights, angle recommendations, and talking points before creating initial WordPress drafts. Your editorial team receives fully researched content foundations instead of starting from scratch.

Set this up in 5 minutes →

Row Created

Create Chat Completion (Perplexity Research)

Prompt (AI Title Generation)

Create Post (WordPress Draft)

Trusted by 1,000+ Shopify merchants — from solo operators to scaling brands.

How it works

4 steps to start receiving automated WordPress drafts from your Google Sheets content planning

App connector: Google Sheets • Time to complete: 2 minutes

Why this matters: This trigger monitors your Google Sheets for new content ideas and kicks off the automation whenever you add a new row with blog post details.

This step watches your spreadsheet for new rows containing your content planning inputs like topic, keywords, audience, and content angle. You'll configure which specific spreadsheet to monitor and which sheet within that spreadsheet (defaulting to "Sheet1"). Once a new row appears with your content details, it automatically captures all the column data including {{googlesheets.data.Topic}}, {{googlesheets.data["Primary Keywords"]}}, and other planning fields to pass to the research step.

App connector: Perplexity • Time to complete: 0 minutes (Auto-configured)

Why this matters: This step takes your content planning inputs and uses Perplexity's web-connected AI to research and write a complete, SEO-optimized blog draft with current information and proper HTML formatting.

Perplexity receives all your spreadsheet data (topic, primary/secondary keywords, audience, content angle, and desired format) and generates a comprehensive blog post draft. The AI searches the web for current information, naturally weaves in your specified keywords, and structures the content with proper HTML tags like `<h2>`, `<h3>`, `<p>`, and `<ul>` for direct WordPress publishing. The response includes an engaging introduction, scannable sections, and a branded conclusion with call-to-action, all formatted as clean HTML ready for your WordPress editor.

App connector: AI • Time to complete: 0 minutes (Auto-configured)

Why this matters: This step extracts and optimizes the title from the Perplexity-generated content to ensure it's keyword-friendly and properly formatted for WordPress.

The AI analyzes the complete blog draft from {{perplexity.response}} and generates a refined, SEO-optimized title that incorporates your primary keywords while maintaining readability. This separate title generation ensures your WordPress post title is clean, compelling, and search-engine friendly rather than using a generic or poorly formatted title from the main content. The generated title gets passed as {{ai.response}} to the final WordPress creation step.

App connector: WordPress • Time to complete: 0 minutes (Auto-configured)

Why this matters: This step automatically creates a draft post in your WordPress site using the researched content and optimized title, ready for your review and publishing.

WordPress receives the AI-generated title from {{ai.response}} and the full HTML-formatted content from {{perplexity.response}} to create a new draft post. The post appears in your WordPress dashboard with all the proper formatting, headings, and structure intact, saving you from copying and pasting or reformatting content. You can then review, make any final edits, add featured images, and publish when ready.

Ready to start receiving automated WordPress drafts from your Google Sheets content planning

Get setup in 5 minutes.

Try this template →

Frequently asked questions

What happens if my Google Sheets columns have different names than the template expects?

The workflow looks for specific column headers like "Topic," "Primary Keywords," and "Audience." If your columns use different names, you'll need to either rename your columns to match or update the variable references in the Perplexity prompt to match your actual column names.

Can I control the writing style and brand voice of the generated content?

Yes, you can modify the Perplexity prompt in Step 2 to include specific brand guidelines, tone instructions, or writing style preferences. Add details about your brand personality, preferred sentence structure, or industry-specific language requirements directly in the prompt content.

Will this workflow create duplicate WordPress posts if I edit the same Google Sheets row multiple times?

No, this workflow only triggers on newly created rows. If you edit an existing row, it won't generate a new WordPress draft. To regenerate content for an edited row, you'd need to delete and recreate the row, or set up a separate workflow that triggers on row updates instead of row creation.

Make this template your own!

Customize this workflow even further:

Add content approval workflow

Insert email notifications or Slack messages before the WordPress step so you can review and approve content before it becomes a draft, preventing low-quality posts from reaching your CMS.

Connect to social media scheduling

Chain additional steps to automatically create social media posts, email newsletter content, or LinkedIn articles from the same research, maximizing your content reach across platforms.

Store performance data in tables

Save generated titles, keywords, and publish dates in MESA tables to track which topics and angles perform best, building your own content performance database.

Deploy AI agents for content quality control

Let AI agents evaluate the generated content against your brand guidelines and writing standards, automatically flagging posts that need human review or additional research.

"MESA has been a game changer for us. And, if you ever get stuck, their support team is always super helpful."

PetFriendly

"It's like Zapier but exactly designed for Shopify. I have been able to complete all the workflows that I've needed."

Zailys

"The MESA team has been amazing at helping us set up our automations. We would highly recommend this app!"

Rothy's

Ready to start receiving automated WordPress drafts from your Google Sheets content planning?

7-day free trial • 5 min setup • Cancel anytime

Start with this template — It's free

Need help? Our automation experts will help you personalize this workflow for free. Contact support