Google analytics template n8n Workflow Template

n8n workflow template · 18 nodes · Google Analytics

Google analytics template is a free n8n workflow template that runs on a schedule and works with Google Analytics and Baserow. It has 18 nodes and no AI nodes. The notes inside the workflow say: “This workflow will check for country views, page engagement and google search console results. It will take this week's data and compare it to last week's data.” To run it, you add your own credentials for Google Analytics OAuth2.

Download JSON How to import into n8n

At a glance

Trigger
Schedule Trigger (Schedule Trigger)
Nodes
18
Apps
Google Analytics and Baserow
AI nodes
None
Credentials
1 type
Category
Content, SEO and social media

Apps and integrations

  • Google Analytics
  • Baserow

Node types used

  • Schedule Trigger
  • Manual Trigger
  • Google Analytics
  • Code
  • HTTP Request
  • Baserow

How it works

The text below comes from the sticky notes inside the workflow. We removed links, code samples and anything that looks like a key or token.

Send Google analytics to A.I. and save results to baserow

This workflow will check for country views, page engagement and google search console results. It will take this week's data and compare it to last week's data.

You can read more about this workflow here

Setup notes

The text below comes from the sticky notes inside the workflow. We removed links, code samples and anything that looks like a key or token.

Property ID

  1. Create your Google Analytics Credentials
  2. Enter your property ID.

Send data to A.I.

Fill in your Openrouter A.I. credentials. Use Header Auth.

  • Username: Authorization
  • Password: [redacted] {insert your API key}

Remember to add a space after bearer. Also, feel free to modify the prompt to A.1.

Send data to Baserow

Create a table first with the following columns

  • Country Views
  • Page Views
  • Search Report

Enter the name of your website under "Blog" field.

Nodes in this workflow

The 18 nodes in file order (sticky notes excluded). Branches and connections determine execution order in n8n:

  1. Schedule Trigger (Schedule Trigger)
  2. When clicking ‘Test workflow’ (Manual Trigger)
  3. Get Page Engagement Stats for this week (Google Analytics)
  4. Get Page Engagement Stats for prior week (Google Analytics)
  5. Parse data from Google Analytics (Code)
  6. Parse GA data (Code)
  7. Get Google Search Results for this week (Google Analytics)
  8. Get Google Search Results for last week (Google Analytics)
  9. Parse Google Analytics Data (Code)
  10. Parse Google Analytics Data1 (Code)
  11. Get Country views data for this week (Google Analytics)
  12. Get Country views data for last week (Google Analytics)
  13. Parse Google analytics data (Code)
  14. Parse Google analytics data1 (Code)
  15. Send page data to A.I. (HTTP Request)
  16. Send page Search data to A.I. (HTTP Request)
  17. Send country view data to A.I. (HTTP Request)
  18. Save A.I. output to Baserow (Baserow)

Credentials you need

  • Google Analytics OAuth2 – used by Get Country views data for this week, Get Google Search Results for last week, Get Google Search Results for this week and Get Page Engagement Stats for this week

Configure your own credentials after importing. Create each credential in n8n, then select it in the node.

How to import into n8n

  1. Download the JSON file with the button above.
  2. In n8n, open a new workflow, select the ... menu and choose Import from File. You can also paste the JSON straight into the editor canvas.
  3. Open each node that shows a warning and select or create its credential.
  4. Read the notes on the canvas, test the workflow with sample data, then activate it.

Do you need somewhere to run it? Read our guide to self-hosted n8n.

Need this customised?

We can adapt this workflow to your apps, data and process, then deploy and support it.

Contact Us