Block 1 - Schedule Trigger
- Type / Role
- n8n-nodes-base.scheduleTrigger - scheduleTrigger
- Config choices
- Version 1.2
Send Google Analytics data to A.I. to analyze then save results in Baserow
Workflow preview
100%
$20/month : Unlimited workflows
2500 executions/month
THE #1 IN WEB SCRAPING
Scrape any website without limits
HOSTINGER 
Early Deal
DISCOUNT 20% Try free
Early DealDISCOUNT 20%
Self-hosted n8n
Unlimited workflows - from $4.99/mo
#1 hub for scraping, AI & automation
6000+ actors - $5 credits/mo
Important notice
This workflow is provided as-is. Please review and test before using in production.
1. Workflow Overview
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 p...
Best for
- Market Research automation workflows
- AI Summarization automation workflows
- advanced n8n builders looking for reusable templates
Tools used
n8n-nodes-base.scheduletrigger, n8n-nodes-base.manualtrigger, n8n-nodes-base.stickynote, n8n-nodes-base.googleanalytics, n8n-nodes-base.code, n8n-nodes-base.httprequest, n8n-nodes-base.baserow
Source and attribution
This workflow is cataloged by N8N Workflows and links back to its original n8n.io source page by Keith Rumjahn.
Original n8n.io source1.1 Workflow description
- Title
- Send Google Analytics data to A.I. to analyze then save results in Baserow
- Workflow name
- Send Google Analytics data to A.I. to analyze then save results in Baserow
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 suggestions from data
Use case
Instead of hiring an SEO expert, I run this report weekly. It checks compares the data from this week to the week before:
- Views based on countries
- The top performing pages
- Google search console performance
Get my SEO A.I. agent system here
How it works
- The workflow gathers google analytics for the past 7 days then it gathers the data for the week before for comparison.
- It does this 3 times to get: views per country, engagement per page and google search console results for organic search results.
- The google analytics nodes has already chosen the correct dimensions and metrics.
- At the end, it passes the data to openrouter.ai for A.I. analyse.
- Finally it saves to baserow.
How to use this
- Input your Google analytics credentials
- Input your property ID
- Input your Openrouter.ai credentials
- Input your baserow credentials
- You will need to create a baserow database with columns: Name, Country Views, Page Views, Search Report, Blog (name of your blog).
Created by Rumjahn
1.2 Logical Blocks
This catalog entry is organized from the workflow JSON. The node-level section below shows the executable blocks available for review before importing the template.
2. Block-by-Block Analysis
Block 2 - When clicking ‘Test workflow’
- Type / Role
- n8n-nodes-base.manualTrigger - manualTrigger
- Config choices
- Version 1
Block 3 - Sticky Note
- Type / Role
- n8n-nodes-base.stickyNote - stickyNote
- Config choices
- Version 1
Block 4 - Sticky Note1
- Type / Role
- n8n-nodes-base.stickyNote - stickyNote
- Config choices
- Version 1
Block 5 - Get Page Engagement Stats for this week
- Type / Role
- n8n-nodes-base.googleAnalytics - googleAnalytics
- Config choices
- Version 2
Block 6 - Get Page Engagement Stats for prior week
- Type / Role
- n8n-nodes-base.googleAnalytics - googleAnalytics
- Config choices
- Version 2
Block 7 - Parse data from Google Analytics
- Type / Role
- n8n-nodes-base.code - code
- Config choices
- Version 2
Block 8 - Parse GA data
- Type / Role
- n8n-nodes-base.code - code
- Config choices
- Version 2
Block 9 - Get Google Search Results for this week
- Type / Role
- n8n-nodes-base.googleAnalytics - googleAnalytics
- Config choices
- Version 2
Block 10 - Get Google Search Results for last week
- Type / Role
- n8n-nodes-base.googleAnalytics - googleAnalytics
- Config choices
- Version 2
Block 11 - Parse Google Analytics Data
- Type / Role
- n8n-nodes-base.code - code
- Config choices
- Version 2
Block 12 - Parse Google Analytics Data1
- Type / Role
- n8n-nodes-base.code - code
- Config choices
- Version 2
Block 13 - Get Country views data for this week
- Type / Role
- n8n-nodes-base.googleAnalytics - googleAnalytics
- Config choices
- Version 2
Block 14 - Get Country views data for last week
- Type / Role
- n8n-nodes-base.googleAnalytics - googleAnalytics
- Config choices
- Version 2
Block 15 - Parse Google analytics data
- Type / Role
- n8n-nodes-base.code - code
- Config choices
- Version 2
Block 16 - Parse Google analytics data1
- Type / Role
- n8n-nodes-base.code - code
- Config choices
- Version 2
Block 17 - Send page data to A.I.
- Type / Role
- n8n-nodes-base.httpRequest - httpRequest
- Config choices
- Version 4.2
Block 18 - Send page Search data to A.I.
- Type / Role
- n8n-nodes-base.httpRequest - httpRequest
- Config choices
- Version 4.2
Block 19 - Send country view data to A.I.
- Type / Role
- n8n-nodes-base.httpRequest - httpRequest
- Config choices
- Version 4.2
Block 20 - Save A.I. output to Baserow
- Type / Role
- n8n-nodes-base.baserow - baserow
- Config choices
- Version 1
Block 21 - Sticky Note2
- Type / Role
- n8n-nodes-base.stickyNote - stickyNote
- Config choices
- Version 1
Block 22 - Sticky Note3
- Type / Role
- n8n-nodes-base.stickyNote - stickyNote
- Config choices
- Version 1
3. Summary Table
| Workflow | Send Google Analytics data to A.I. to analyze then save results in Baserow |
|---|---|
| Complexity | advanced |
| Nodes | 22 |
| Categories | Market Research, AI Summarization |
| Author | Keith Rumjahn |
| Published | 01 Nov 2024 |
4. Reproducing the Workflow from Scratch
-
1. Download the workflow JSON
Use the JSON export at /data/workflows/2517/2517.json as the source template for this automation.
-
2. Import the template into n8n
Open n8n, import the downloaded JSON, and review each node before activating the workflow.
-
3. Configure credentials and variables
Replace placeholder credentials, API keys, webhook URLs, account IDs, and environment-specific values with your own settings.
-
4. Test with sample data
Run the workflow manually or in a staging workspace, inspect node output, and confirm downstream systems receive the expected data.
-
5. Activate and monitor
Enable the workflow only after testing, then monitor executions, errors, and rate limits during the first production runs.
5. General Notes & Resources
Review imported nodes carefully before activation. This catalog entry is intended to help you inspect the workflow structure, understand required services, and find related templates faster.
Node names, credentials, schedules, webhook paths, and external service limits may need adjustment for your workspace.
Frequently asked questions
What does Send Google Analytics data to A.I. to analyze then save results in Baserow do?
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 p...
What do I need before importing this workflow?
Review the workflow JSON, configure any required credentials in n8n, and test the automation in a safe workspace before using it in production.
Can I customize this workflow?
Yes. Use the block-by-block analysis and the downloadable JSON to inspect each node, then adjust credentials, prompts, schedules, filters, or destinations for your Market Research, AI Summarization use case.