Back to Templates

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

Created by

Created by: Keith Rumjahn || rumjahn

Keith Rumjahn

Last update

Last update 4 months ago

Share


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

Watch youtube tutorial here

Get my SEO A.I. agent system here

Read my detailed case study 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