The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"id": "PRQhetYFkuhxntVH",
"meta": {
"templateCredsSetupCompleted": true
},
"name": "Matomo Analytics Report",
"tags": [],
"nodes": [
{
"id": "fd35d612-09a6-4dd3-836b-53d03b75f344",
"name": "When clicking \u2018Test workflow\u2019",
"type": "n8n-nodes-base.manualTrigger",
"position": [
120,
360
],
"parameters": {},
"typeVersion": 1
},
{
"id": "c8169606-3abd-4dd3-bd35-fdc0296fc0e1",
"name": "Schedule Trigger",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
120,
160
],
"parameters": {
"rule": {
"interval": [
{
"field": "weeks"
}
]
}
},
"typeVersion": 1.2
},
{
"id": "760a87e3-ed8f-4b1e-a46b-4ceb635020d4",
"name": "Get data from Matomo",
"type": "n8n-nodes-base.httpRequest",
"position": [
380,
260
],
"parameters": {
"url": "https://shrewd-lyrebird.pikapod.net/index.php",
"method": "POST",
"options": {},
"sendBody": true,
"contentType": "multipart-form-data",
"bodyParameters": {
"parameters": [
{
"name": "module",
"value": "API"
},
{
"name": "method",
"value": "Live.getLastVisitsDetails"
},
{
"name": "idSite",
"value": "3"
},
{
"name": "period",
"value": "range"
},
{
"name": "date",
"value": "last30"
},
{
"name": "format",
"value": "JSON"
},
{
"name": "segment",
"value": "visitCount>3"
},
{
"name": "filter_limit",
"value": "100"
},
{
"name": "showColumns",
"value": "actionDetails,visitIp,visitorId,visitCount"
},
{
"name": "token_auth",
"value": "{insert your auth token}"
}
]
}
},
"typeVersion": 4.1
},
{
"id": "f9e9a099-3131-4320-8a86-b9add4e43096",
"name": "Parse data from Matomo",
"type": "n8n-nodes-base.code",
"position": [
580,
260
],
"parameters": {
"jsCode": "// Get input data\nconst items = $input.all();\n\n// Format the visitor data into a clear prompt\nconst visitorData = items.map(item => {\n const visit = item.json;\n \n const visitorActions = visit.actionDetails.map(action => \n ` - Page ${action.pageviewPosition}: ${action.pageTitle}\\n URL: ${action.url}\\n Time Spent: ${action.timeSpentPretty}`\n ).join('\\n');\n\n return `- Visitor (ID: ${visit.visitorId}):\\n Visit Count: ${visit.visitCount}\\n${visitorActions}`;\n}).join('\\n\\n');\n\n// Create the prompt\nconst prompt = `Please analyze this visitor data:\\n\\n${visitorData}\\n\\nPlease provide insights on:\\n1. Common visitor paths\\n2. Popular pages\\n3. User engagement patterns\\n4. Recommendations for improvement`;\n\n// Return formatted for LLaMA\nreturn [{\n json: {\n messages: [\n {\n role: \"user\",\n content: prompt\n }\n ]\n }\n}];"
},
"typeVersion": 2
},
{
"id": "387832ee-8397-43f8-bf62-846e4a7a20d0",
"name": "Send data to A.I. for analysis",
"type": "n8n-nodes-base.httpRequest",
"position": [
760,
260
],
"parameters": {
"url": "https://openrouter.ai/api/v1/chat/completions",
"method": "POST",
"options": {},
"jsonBody": "={\n \"model\": \"meta-llama/llama-3.1-70b-instruct:free\",\n \"messages\": [\n {\n \"role\": \"user\",\n \"content\": \"You are an SEO expert. This is data of visitors who have visited my site more then 3 times and the pages they have visited. Can you give me insights into this data:{{ encodeURIComponent($json.messages[0].content)}}\" \n }\n ]\n}",
"sendBody": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth"
},
"credentials": {
"httpHeaderAuth": {
"name": "<your credential>"
}
},
"typeVersion": 4.2,
"alwaysOutputData": false
},
{
"id": "7ee29949-550e-4f3a-8420-49ca2608bbeb",
"name": "Store results in Baserow",
"type": "n8n-nodes-base.baserow",
"position": [
1060,
260
],
"parameters": {
"tableId": 643,
"fieldsUi": {
"fieldValues": [
{
"fieldId": 6261,
"fieldValue": "={{ DateTime.now().toFormat('yyyy-MM-dd') }}"
},
{
"fieldId": 6262,
"fieldValue": "={{ $json.choices[0].message.content }}"
},
{
"fieldId": 6263,
"fieldValue": "Your blog name"
}
]
},
"operation": "create",
"databaseId": 121
},
"credentials": {
"baserowApi": {
"name": "<your credential>"
}
},
"typeVersion": 1
},
{
"id": "684ca1c9-97c3-4464-8ce6-aa6019db0c04",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
80,
-360
],
"parameters": {
"color": 5,
"width": 615,
"height": 289,
"content": "## Send Matomo analytics to A.I. and save results to baserow\n\nThis workflow will check for visitors who have visited more than 3 times. It will take this week's data and compare it to last week's data and give SEO suggestions.\n\n[Watch youtube tutorial here](https://www.youtube.com/watch?v=hGzdhXyU-o8)\n\n[Get my SEO A.I. agent system here](https://2828633406999.gumroad.com/l/rumjahn)\n\n[\ud83d\udca1 You can read more about this workflow here](https://rumjahn.com/how-to-create-an-a-i-agent-to-analyze-matomo-analytics-using-n8n-for-free/)\n"
},
"typeVersion": 1
},
{
"id": "29723224-416e-46b4-a498-90888eb9a41b",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
320,
-20
],
"parameters": {
"width": 224.51612903225822,
"height": 461.4193548387107,
"content": "## Get Matomo Data\n \n1. Enter your Matomo API key at the bottom\n2. Navigate to Administration > Personal > Security > Auth tokens within your Matomo dashboard. Click on Create new token and provide a purpose for reference."
},
"typeVersion": 1
},
{
"id": "c694c855-c37a-4717-befd-d7a216f99e2d",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
700,
-20
],
"parameters": {
"color": 3,
"width": 225.99936321742769,
"height": 508.95792207792226,
"content": "## Send data to A.I.\n\nFill in your Openrouter A.I. credentials. Use Header Auth.\n- Username: Authorization\n- Password: Bearer {insert your API key}\n\nRemember to add a space after bearer. Also, feel free to modify the prompt to A.1."
},
"typeVersion": 1
},
{
"id": "fdd12783-0456-4fc7-8030-555f058f2fd2",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
960,
-20
],
"parameters": {
"color": 6,
"width": 331.32883116883124,
"height": 474.88,
"content": "## Send data to Baserow\n\nCreate a table first with the following columns:\n- Date\n- Note\n- Blog\n\nEnter the name of your website under \"Blog\" field."
},
"typeVersion": 1
}
],
"active": false,
"settings": {
"executionOrder": "v1"
},
"versionId": "21a1d486-5bb8-40b9-9032-6ab22d8baebc",
"connections": {
"Schedule Trigger": {
"main": [
[
{
"node": "Get data from Matomo",
"type": "main",
"index": 0
}
]
]
},
"Get data from Matomo": {
"main": [
[
{
"node": "Parse data from Matomo",
"type": "main",
"index": 0
}
]
]
},
"Parse data from Matomo": {
"main": [
[
{
"node": "Send data to A.I. for analysis",
"type": "main",
"index": 0
}
]
]
},
"Send data to A.I. for analysis": {
"main": [
[
{
"node": "Store results in Baserow",
"type": "main",
"index": 0
}
]
]
},
"When clicking \u2018Test workflow\u2019": {
"main": [
[
{
"node": "Get data from Matomo",
"type": "main",
"index": 0
}
]
]
}
}
}
Credentials you'll need
Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.
baserowApihttpHeaderAuth
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
How this works
Generate automated analytics reports from Matomo to uncover actionable insights into website performance without manual data wrangling, saving hours of repetitive analysis for marketing teams and business owners. This workflow fetches visitor metrics and engagement data directly from Matomo via HTTP requests, processes it through code for clarity, and stores the summarised results in Baserow for easy access and sharing. Ideal for those already using Matomo for tracking and Baserow for data management, it delivers regular reports to inform content strategies or campaign adjustments.
Use this workflow for routine monthly or weekly Matomo reports when you need consistent, structured insights integrated into your Baserow database, especially in growing teams handling multiple sites. Avoid it for one-off analyses or if your data volume exceeds Matomo's API limits, as it relies on scheduled pulls rather than real-time processing. Common variations include adding email notifications for report delivery or customising the code node to focus on specific metrics like conversion rates.
About this workflow
Matomo Analytics Report. Uses manualTrigger, scheduleTrigger, httpRequest, baserow. Event-driven trigger; 10 nodes.
Source: https://github.com/Zie619/n8n-workflows — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
Umami analytics template. Uses manualTrigger, scheduleTrigger, httpRequest, stickyNote. Event-driven trigger; 17 nodes.
Umami analytics template. Uses manualTrigger, scheduleTrigger, httpRequest, stickyNote. Event-driven trigger; 17 nodes.
SERPBear analytics template. Uses manualTrigger, scheduleTrigger, httpRequest, baserow. Event-driven trigger; 10 nodes.
SERPBear analytics template. Uses manualTrigger, scheduleTrigger, httpRequest, baserow. Event-driven trigger; 10 nodes.
Create Animated Stories using GPT-4o-mini, Midjourney, Kling and Creatomate API. Uses httpRequest, stickyNote, manualTrigger. Event-driven trigger; 51 nodes.