Umami analytics template n8n Workflow Template

n8n workflow template · 11 nodes · Baserow

Umami analytics template is a free n8n workflow template that runs on a schedule and works with Baserow. It has 11 nodes and no AI nodes. The notes inside the workflow say: “You can find out more about the stats available in the Umami API” To run it, you add your own credentials for Baserow API and HTTP Header Auth.

Download JSON How to import into n8n

At a glance

Trigger
Schedule Trigger (Schedule Trigger)
Nodes
11
Apps
Baserow
AI nodes
None
Credentials
2 types
Category
Spreadsheets, databases and docs

Apps and integrations

  • Baserow

Node types used

  • Manual Trigger
  • Schedule Trigger
  • HTTP Request
  • Code
  • 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 data from Umami to A.I. and then save to Baserow

You can find out more about the stats available in the Umami API

Read the case study here.

Get summary stats from Umami

It will get: Pageviews, Visitors, Visits, Bounces, Total Time

You need to change the URL to your website. website}/api/websites/{website ID}/

You can find your ID by going to your Umami account -> Settings -> Edit (next to domain)

Get page specific stats for this week and last

Calls Umami to get this week and last week's data. It will get the views for each page visited on your website for comparison.

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.

Send data to A.I.

To use Openrouter, you need to register for an account. Then add header authorization credentials. Username: Authroization Password: [redacted] {Your API Key} It's Bearer space {API key}.

Send data to A.I.

To use Openrouter, you need to register for an account. Then add header authorization credentials. Username: Authroization Password: [redacted] {Your API Key} It's Bearer space {API key}.

Save analysis to baserow

You need to create a table in advance to save.

  • Date (date)
  • Summary (Long text)
  • Top pages (Long text)
  • Blog name (Long text)

Nodes in this workflow

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

  1. When clicking ‘Test workflow’ (Manual Trigger)
  2. Schedule Trigger (Schedule Trigger)
  3. Get view stats from Umami (HTTP Request)
  4. Parse Umami data (Code)
  5. Send data to A.I. (HTTP Request)
  6. Get page data from Umami (HTTP Request)
  7. Parse Umami data1 (Code)
  8. Get page view data from Umami (HTTP Request)
  9. Parse Umami (Code)
  10. Send data to A.I.1 (HTTP Request)
  11. Save data to Baserow (Baserow)

Credentials you need

  • Baserow API – used by Save data to Baserow
  • HTTP Header Auth – used by Get page data from Umami, Get page view data from Umami, Get view stats from Umami and Send data to A.I. and others

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