Crafting high-quality SEO content is crucial for any business looking to enhance its online presence. However, the process can be time-consuming and laborious, especially when you aim to produce content that ranks well on search engines and genuinely adds value to your audience. This guide will walk you through a streamlined method to automate the content creation process using AI tools like Claude and Perplexity AI, combined with Airtable and Make.com. By breaking the workflow into manageable steps, you can achieve a 90% ready-to-publish draft, requiring minimal manual adjustments.

The Problem with Traditional AI Content Generation

Many people start their AI-driven content creation journey by giving a simple prompt to an AI assistant like ChatGPT. They might ask it to act as an SEO expert and generate a 1,500-word article targeting a specific keyword. While this approach can produce results quickly, the output often lacks depth, structure, and the necessary polish. Users then spend considerable time refining the content, which defeats the purpose of automation.

The solution lies in breaking down the writing process into chunks and leveraging different tools for specific tasks. This method ensures a comprehensive, structured, and engaging output.

Step 1: Setting Up the Workflow with Airtable

Airtable serves as the central hub for organising and tracking your content creation process. Here's how to set it up:

1. Create a New Airtable Table:

   • Add fields for the following:

     • Main Keyword

     • Main Competitor

     • Status (e.g., Idea, Drafted, Scheduled, Published)

     • Topic Cluster

     • Google Doc Link

2. Design a Submission Form:

   • Use Airtable's form functionality to create a simple submission form.

   • Include fields for the keyword, competitor URL, and topic cluster.

   • Share the form with team members or external collaborators to submit content ideas easily.

Step 2: Automating Data Collection with Make.com

Make.com (formerly Integromat) connects Airtable to other tools, enabling seamless data flow. Follow these steps:

1. Create a Webhook:

   • Set up a webhook in Make.com to trigger the automation whenever the Airtable form is submitted.

2. Configure Airtable Integration:

   • Use the webhook to retrieve data from Airtable, including the main keyword, competitor URL, and topic cluster.

Step 3: Research with Perplexity AI

Perplexity AI is a powerful tool for generating comprehensive content outlines based on competitor analysis. Here’s how to use it:

1. Set Up a Prompt for Perplexity:

   • Craft a detailed prompt instructing Perplexity to analyse the competitor's content.

   • Ask for a detailed outline, semantically relevant keywords, and suggested FAQs.

2. Run the Automation:

   • Trigger Perplexity AI through Make.com to generate a well-structured outline based on the competitor's content.

Step 4: Drafting Content with Claude

Claude excels at producing human-like content. Use it to draft the article in stages:

1. Introduction:

   • Provide Claude with the outline and ask it to generate a compelling introduction.

2. Main Content:

   • Use Claude to write the body of the article based on the outline, ensuring it adheres to the provided structure.

   • Include bullet points and examples where appropriate to enhance readability.

3. FAQs and Title:

   • Ask Claude to generate a list of FAQs relevant to the topic and an SEO-optimised title.

Step 5: Storing and Reviewing Content

Once Claude completes the drafts, the content is automatically stored in a Google Doc for easy access and editing. This ensures all your drafts are centralised and can be reviewed by your team.

Step 6: Final Touches and Publishing

Although the AI-generated content will be comprehensive, it’s crucial to review and refine it before publishing. Edit for style, ensure all information is accurate, and align the tone with your brand voice. Add any personal insights or examples to make the content uniquely yours.

Benefits of This Automated Workflow

• Efficiency:

  • Dramatically reduces the time spent on content creation.

  • Produces 80-90% complete drafts with minimal manual input.

• Consistency:

  • Maintains a uniform structure and tone across all content pieces.

• Scalability:

  • Enables you to produce more content in less time, helping you target multiple keywords and expand your online presence.

Conclusion

By leveraging AI and automation tools, you can revolutionise your SEO content creation process. This workflow not only saves time but also ensures high-quality output that adds genuine value to your audience. Download the provided templates to get started, and customise the prompts and structure to suit your business needs. Remember, automation is a tool to enhance your content strategy, not replace the human touch—always refine and personalise the output before publishing.

Let us know your thoughts and share any improvements or tips you discover. Together, we can continually refine and optimise this process for better results. Happy writing!