📊 Send Google Analytics data to A.I. to analyze then save results in Baserow
⚡ 6,471 views · 📊 Market Research & Insights
Description
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
Screenshot 20241101 at 11.07.21 PM.png Screenshot 20241101 at 11.07.31 PM.png
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
🔗 Nodes Used
HTTP Request, Google Analytics, Baserow, Schedule Trigger
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File