AI-Powered SEO Analyzer for Google Analytics using OpenRouter & Baserow

Unlock AI-Driven SEO Insights with this AI Agent

This AI Agent automates the weekly analysis of your Google Analytics 4 data, delivering actionable SEO recommendations directly to your Baserow database. It fetches key metrics for page engagement, Google Search Console performance, and country-specific views for both the current and previous week. This comparative data is then processed by a powerful Large Language Model (LLM) via OpenRouter (configurable, defaults to Llama 3.1 70B) to generate a concise markdown report and five tailored SEO improvement suggestions for each data category (page views, search results, country views). Stop manually crunching numbers and let this agent be your automated SEO expert.

Key Features & Benefits

• Automated GA4 Data Collection: Regularly pulls vital statistics on page engagement (views, active users, views per user, event count), search performance (clicks, impressions, CTR, average position), and audience geography (users by country).
• AI-Powered SEO Analysis: Leverages an LLM (e.g., Llama 3.1 70B via OpenRouter) to interpret complex analytics data, identify trends, and generate human-readable SEO insights.
• Comparative Reporting Ability: Compares current week's data against the previous week, highlighting changes and areas for attention.
• Actionable Recommendation Generation: Provides five specific, AI-generated suggestions to improve SEO for each analyzed data set (page performance, search visibility, country targeting).
• Structured Output: Delivers analysis and suggestions in markdown format, perfect for easy reading and integration into reports.
• Automated Data Archival: Automatically saves the AI's analysis and your website name to a Baserow table for historical tracking and review.
• Customizable & Schedulable: Runs on a schedule (default: weekly) or can be triggered manually. Easily adapt the AI prompts and target LLM.

• An n8n instance (Cloud or self-hosted).
• Google Analytics 4 Property ID.
• Google Analytics credentials configured in n8n.
• OpenRouter API Key (or another LLM provider API key if modifying HTTP Request nodes).
• Baserow account, a Database ID, and a Table ID.
• A Baserow table with the following fields (or similar, adjust mappings if different):
  • 'Blog' (Text - for your website name)
  • 'Page Views AI Report' (Long Text)
  • 'Search AI Report' (Long Text)
  • 'Country Views AI Report' (Long Text)
  • 'Date' (Date)

1. Download the n8n workflow JSON file (ai-seo-ga-analyzer-v1.0.0.json).
2. Import the workflow into your n8n instance.
3. Configure Google Analytics Nodes: a. For all 'Google Analytics' nodes (e.g., 'Get Page Engagement Stats for this week', 'Get Page Engagement Stats for prior week'): Select or create your Google Analytics credentials in n8n. b. In each Google Analytics node, update the 'Property ID' parameter with your Google Analytics 4 Property ID.
4. Configure AI Request Nodes (HTTP Request to OpenRouter): a. Identify the three HTTP Request nodes: 'Send page data to A.I.', 'Send page Search data to A.I.', and 'Send country view data to A.I.'. b. For each of these nodes: Set 'Authentication' to 'Header Auth'. c. Create or select a 'Generic Credential Type' for 'HTTP Header Auth'. Configure it with: Name: Authorization, Value: Bearer YOUR_OPENROUTER_API_KEY (replace YOUR_OPENROUTER_API_KEY with your actual key). d. (Optional) Modify the model in the 'Body Parameters' (JSON) to use a different LLM available on OpenRouter. The default is meta-llama/llama-3.1-70b-instruct:free. e. (Optional) Customize the content of the user message in 'Body Parameters' to refine the AI's task for each report type.
5. Configure Baserow Node ('Save A.I. output to Baserow'): a. Select or create your Baserow credentials in n8n. b. Enter your Baserow 'Database ID' and 'Table ID'. c. Ensure your Baserow table columns match the fields listed in Prerequisites. Adjust the 'Fields' mapping in the Baserow node if your column names or IDs differ. d. In the Baserow node, update the value for the 'Blog' field (mapped to fieldId: 5833 by default) to your actual website's name.
6. Configure the 'Schedule Trigger' node to your desired frequency (default is weekly) or use the 'When clicking ‘Test workflow’' manual trigger for initial testing.
7. Activate the workflow.