AI-Powered SEO Analyzer for Google Analytics with Baserow Reporting

Unlock Actionable SEO Insights with this AI Agent

This n8n AI Agent automates your weekly SEO reporting and analysis. It connects to Google Analytics to fetch key metrics for page engagement, search performance, and country views for the current and previous week. This data is then fed to a powerful Large Language Model (Llama 3.1 70B via OpenRouter) which acts as your SEO expert. The AI compares the data, generates a summary table in markdown, and provides five actionable suggestions to improve your SEO. Finally, all these valuable insights are neatly organized and saved to your Baserow database, making it easy to track progress and make data-driven decisions.

Key Features & Benefits

• Automated Data Collection: Fetches weekly Google Analytics data (page views, active users, search console metrics, country-specific views) automatically, saving you hours of manual work.
• AI-Driven SEO Analysis: Leverages the Llama 3.1 70B model via OpenRouter to provide expert-level SEO analysis, including week-over-week performance comparisons and actionable improvement tips.
• Structured Reporting: Delivers insights in a clear markdown table format and saves them directly to Baserow for easy access and historical tracking.
• Customizable & Extensible: Easily modify AI prompts, select different Google Analytics metrics, or integrate with other tools in your stack.
• Scheduled Operation: Set it to run on a schedule (e.g., weekly) for consistent SEO monitoring without manual intervention.

• An n8n instance (Cloud or self-hosted).
• Google Analytics credentials with access to the GA4 API. You can create them here.
• Your Google Analytics Property ID. Find it here.
• An OpenRouter API Key. You can obtain one from OpenRouter.ai.
• A Baserow account and API Key.
• A Baserow table pre-configured with the following text fields: 'Name', 'Country Views', 'Page Views', 'Search Report', 'Blog', and a 'Date' field (Date type).

1. Download the n8n workflow JSON file.
2. Import the workflow into your n8n instance.
3. Configure Google Analytics Nodes:
   • For each of the six 'Google Analytics' nodes (e.g., 'Get Page Engagement Stats for this week'), select your Google Analytics credentials and enter your Property ID.
   • Review and adjust date ranges if necessary (they are set to fetch 'this week' and 'prior week' data dynamically).
4. Configure AI Call Nodes (HTTP Request):
   • For the three 'HTTP Request' nodes ('Send page data to A.I.', 'Send page Search data to A.I.', 'Send country view data to A.I.'), configure the authentication.
   • Select 'Header Auth' for Authentication.
   • Set the 'Name' to Authorization.
   • Set the 'Value' to Bearer YOUR_OPENROUTER_API_KEY (replace YOUR_OPENROUTER_API_KEY with your actual key, including the Bearer prefix and a space).
   • You can customize the AI model or the prompt within the 'JSON Body' parameter if desired.
5. Configure Baserow Node:
   • In the 'Save A.I. output to Baserow' node, select your Baserow credentials.
   • Enter your Baserow 'Database ID' and 'Table ID' where you want to save the reports.
   • Map the fields: Ensure the 'Fields' section correctly maps to your Baserow table columns (e.g., 'Blog' field for your website name, 'Page Views' for the AI output related to page data, etc.). Adjust the default 'Name of your blog' value.
6. Configure Trigger: The workflow includes a 'Schedule Trigger' (set to weekly by default) and a 'Manual Trigger'. Adjust the schedule as needed or use the manual trigger for testing.
7. Activate the workflow.