Send Google Analytics Data to AI 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 the 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 and compares the data from this week to the week before: - Views based on countries - The top performing pages - Google Search Console performance [Watch YouTube tutorial here](https://www.youtube.com/watch?v=KlWFhz9M9g) [Get my SEO A.I. agent system here](https://2828633406999.gumroad.com/l/rumjahn) ## How it works - The workflow gathers Google Analytics data 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 have already chosen the correct dimensions and metrics. - At the end, it passes the data to openrouter.ai for A.I. analysis. - 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](https://rumjahn.com/)

Platform

n8n

Category

Data & Analytics

Price

Free

Creator

Keith Rumjahn

• code
• baserow
• stickyNote
• httpRequest
• manualTrigger
• googleAnalytics
• scheduleTrigger