Send Google Analytics data to A.I. to analyze then save results in Baserow
Ready for 3.0What 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).
- Get Page Engagement Stats for this week (Google Analytics): uses Google Analytics
- Parse data from Google Analytics (Code): runs custom JavaScript code
- Get Page Engagement Stats for prior week (Google Analytics): uses Google Analytics
- Parse GA data (Code): runs custom JavaScript code
- Get Google Search Results for this week (Google Analytics): uses Google Analytics
- Parse Google Analytics Data (Code): runs custom JavaScript code
- Get Google Search Results for last week (Google Analytics): uses Google Analytics
- Parse Google Analytics Data (Code): runs custom JavaScript code
- Get Country views data for this week (Google Analytics): uses Google Analytics
- Parse Google analytics data (Code): runs custom JavaScript code
…plus 6 more steps. See the full node list below.
Services it uses
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)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Manual Trigger
n8n-nodes-base.manualTrigger - Google Analytics
n8n-nodes-base.googleAnalytics - Code
n8n-nodes-base.code - HTTP Request
n8n-nodes-base.httpRequest - Baserow
n8n-nodes-base.baserow
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…