Automated SEO Content Engine with Claude AI, Scrapeless, and Competitor Analysis

This n8n workflow automates the generation of SEO-optimized content by leveraging AI for competitor analysis, content planning, and article creation. It streamlines the process from a simple keyword input to a fully structured content plan and article draft, with options to store data in Google Sheets and Supabase.

What it does

This workflow performs the following key steps:

1. Triggers Manually: The workflow is initiated manually, allowing you to provide a target keyword.
2. Initial Data Setup (Edit Fields): Sets up initial variables, including the targetKeyword from the manual trigger.
3. Competitor Analysis (AI Agent):
   • Utilizes an AI Agent (powered by Anthropic Chat Model) to act as an SEO expert.
   • It performs a Google search for the targetKeyword to identify top-ranking competitors.
   • It then analyzes the top 3 competitor URLs to extract their content structure, headings, and key themes.
   • This analysis helps in understanding the competitive landscape and identifying content gaps.
4. Content Plan Generation (AI Agent):
   • Based on the competitor analysis, the AI Agent generates a comprehensive content plan for a new article.
   • This plan includes the article title, meta description, main headings (H1), subheadings (H2, H3), and key points to cover under each section.
   • It also suggests relevant keywords to incorporate.
5. Article Draft Generation (AI Agent):
   • Using the generated content plan, the AI Agent drafts a full article.
   • It ensures the article adheres to SEO best practices, incorporates relevant keywords, and follows a logical structure.
6. Data Structuring (Structured Output Parser): The AI-generated content plan and article are parsed into a structured JSON format for easier handling and storage.
7. Data Aggregation: Combines the structured data from the content plan and article into a single item.
8. Data Storage (Google Sheets): The generated content plan and article are appended as new rows to a specified Google Sheet, providing a centralized record.
9. Data Storage (Supabase): The content plan and article are also inserted into a Supabase database, offering another persistent storage option.
10. Conditional Supabase Update (Filter & Code):
    • A filter checks if the Supabase insertion was successful.
    • If successful, a "Code" node is executed (though its specific action is not detailed in the JSON, it's typically for post-insertion logic or logging).

Prerequisites/Requirements

• n8n Instance: A running n8n instance (self-hosted or cloud).
• Anthropic (Claude AI) API Key: For the AI Agent and Chat Model nodes to function.
• Google Sheets Account: With a spreadsheet prepared for storing content data.
• Supabase Account: With a database and table configured to receive content data.

Setup/Usage

1. Import the workflow: Download the JSON and import it into your n8n instance.
2. Configure Credentials:
   • Set up your Anthropic API Key credential for the "Anthropic Chat Model" node.
   • Set up your Google Sheets credential for the "Google Sheets" node.
   • Set up your Supabase credential for the "Supabase" node.
3. Customize Google Sheets Node:
   • Specify the Spreadsheet ID and Sheet Name where you want to store the content plan and article.
4. Customize Supabase Node:
   • Specify the Table Name where you want to insert the content data.
5. Run the workflow: Click "Execute workflow" on the "Manual Trigger" node.
6. Provide Input: When prompted, enter your desired targetKeyword (e.g., "best vegan recipes for beginners").
7. Review Output: The workflow will then execute, generating the content plan and article, and storing them in your configured Google Sheet and Supabase database.