Templates / Send Google Analytics data to A.I. to analyze then save results in Baserow

Send Google Analytics data to A.I. to analyze then save results in Baserow

Ready for 3.0

by Keith Rumjahn ✓ · 6,567 views · created 2024-11-01 · Market Research, AI Summarization

Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.

What this workflow does

This workflow has 18 nodes and runs on a schedule (every week) (plus 1 other trigger). Along the way it connects Google Analytics and Baserow. It also calls openrouter.ai over HTTP.

How it runs

Trigger: On a schedule (every week) (plus 1 other trigger).

  1. Get Page Engagement Stats for this week (Google Analytics): uses Google Analytics
  2. Parse data from Google Analytics (Code): runs custom JavaScript code
  3. Get Page Engagement Stats for prior week (Google Analytics): uses Google Analytics
  4. Parse GA data (Code): runs custom JavaScript code
  5. Get Google Search Results for this week (Google Analytics): uses Google Analytics
  6. Parse Google Analytics Data (Code): runs custom JavaScript code
  7. Get Google Search Results for last week (Google Analytics): uses Google Analytics
  8. Parse Google Analytics Data (Code): runs custom JavaScript code
  9. Get Country views data for this week (Google Analytics): uses Google Analytics
  10. Parse Google analytics data (Code): runs custom JavaScript code

…plus 6 more steps. See the full node list below.

Services it uses

Google AnalyticsBaserow

HTTP calls to: openrouter.ai

Before you upgrade to n8n 3.0

Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.

Nodes used (6)

From the author

Who's this for? - If you own a website and need to analyze your Google analytics data - If you need to create an SEO report on which pages are getting most traffic or how your google search terms are performing - If you want to grow your site based on…

Excerpt from Keith Rumjahn's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.