How it works

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

google sheets logo icon

Row Created
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.

Create Chat Completion (Perplexity Research)
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.

Prompt (AI Title Generation)
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.

WordPress logo icon

Create Post (WordPress Draft)
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.

Make it 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.

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.
What is a template?
Templates are pre-made workflows by our team of experts. Instead of building a workflow from scratch, these have all the steps needed to complete the task.
Can I personalize a template?
Yes! Every step can be customized to meet your exact requirements. Additionally, you can even add more steps and make it more sophisticated.
Are templates free?
Yes! Our entire library containing hundreds of templates are free to use and customize to your exact needs.

Related templates you'll love

Recommended workflows that pair well with this template

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

Join thousands who've automated their work and saved an average of 3.5 hours every week.

Start with this template — It's free
7-day free trial • 5 min setup • Cancel anytime