SEO Automation with Trend Analysis & AI

# Generate SEO articles by analyzing Google Trends and competitors with AI

This workflow automates keyword research, competitor analysis, and SEO article generation using real-time data from Google Trends and search results. Designed for teams that need to scale content production while staying aligned with market trends and search demand.

## Who it´s for
- SaaS marketers who regularly publish SEO content
- Blog owners looking to automate trend and competitor analysis
- Agencies scaling content creation without compromising quality
- SEO specialists making data-driven decisions on publishing priorities

## What the automation does
- Starts manually with a seed keyword (e.g., ´project management´)
- Fetches related queries from Google Trends and analyzes their popularity trends
- Ranks topics by priority (P0–P2) using AI evaluation
- Scrapes top 3 Google Search results per high-priority keyword via Scrapeless
- Aggregates competitor content and sends it to a LangChain agent powered by Anthropic Claude
- Generates a structured, original SEO article based on competitive insights
- Stores the final article in JSON format in Supabase
- Logs metadata (keywords, priority, date) into Google Sheets for campaign tracking

## What´s included
- Ready-to-use n8n workflow
- Trigger and handler logic based on manual execution
- Integrations with Google Trends, Google Search, Scrapeless, Google Sheets, Supabase, and Anthropic
- Basic text instructions for setup and adaptation

## Requirements for setup
- n8n account (cloud or self-hosted)
- Scrapeless API key
- Google Cloud project with Google Trends API enabled
- Supabase account with a configured table for article storage
- Google Sheets service account with edit permissions
- Anthropic API key (Claude model)

## Benefits and outcomes
- Reduces time spent on keyword research and competitor analysis
- Enables data-driven prioritization of content topics
- Centralizes output in Supabase and metadata tracking in Google Sheets
- Supports repeatable weekly content planning cycles
- Scales content output with consistent quality

## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via chat