Umami analytics template

Umami analytics template automates the collection and analysis of website statistics on a weekly basis, integrating data from Umami with AI insights and saving results to Baserow. This workflow simplifies performance tracking, enhances SEO strategies, and provides actionable insights for content optimization, ensuring you stay informed about your website's performance.

7/8/2025
17 nodes
Complex
schedulecomplexschedule triggersticky notebaserowautomationadvancedcronapiintegration
Categories:
Schedule TriggeredComplex Workflow
Integrations:
Schedule TriggerSticky NoteBaserow

Target Audience

Target Audience


- Website Owners: Those who want to analyze their website traffic and improve SEO performance.
- Digital Marketers: Professionals looking to leverage data insights for better marketing strategies.
- Content Creators: Individuals who need to understand audience behavior to create engaging content.
- Data Analysts: Experts who want to automate data gathering and reporting processes.

Problem Solved

Problem Solved


This workflow automates the process of gathering website analytics from Umami, analyzing the data with AI, and storing the insights in Baserow. It addresses the challenge of manual data collection and analysis, allowing users to focus on improving their website's performance based on actionable insights.

Workflow Steps

Workflow Steps


1. Trigger: The workflow can be initiated manually or scheduled to run every Thursday.
2. Data Retrieval: It fetches view statistics from Umami for the last 7 days and page-specific data for comparison between this week and last week.
3. Data Parsing: The retrieved data is processed to create a simplified structure containing key metrics such as pageviews, visitors, visits, bounces, and total time.
4. AI Analysis: The processed data is sent to an AI service (Openrouter) for generating insights and suggestions based on the analytics.
5. Data Comparison: The AI compares this week's data with last week's, providing a markdown table summary and improvement suggestions.
6. Storage: The results, including insights and analysis, are saved into a Baserow database for easy access and future reference.

Customization Guide

Customization Guide


- Change Schedule: Modify the schedule trigger settings to adjust the frequency of data retrieval.
- Update API URLs: Replace the Umami API URLs with your own website's API endpoints for accurate data collection.
- Adjust AI Prompts: Tailor the AI messages to fit your specific analysis needs or to focus on different metrics.
- Baserow Configuration: Ensure that the Baserow table structure matches the data being sent to it, adjusting field names and types as necessary.
Umami analytics template - N8N Workflow Directory