Umami Analytics to Baserow
detail.loadingPreview
Automate the collection and analysis of Umami analytics data and store it in Baserow.
🚀Ready to Deploy This Workflow?
About This Workflow
Overview
This workflow automates the process of fetching website analytics data from Umami, processing it, and then sending it to an AI for analysis. The AI-generated summary and insights are then stored in a Baserow table.
Key Features
- Fetches summary statistics (pageviews, visitors, visits, bounces, total time) from Umami.
- Retrieves page-specific statistics for the current and previous week.
- Sends processed data to an AI (e.g., OpenRouter) for SEO analysis.
- Stores the AI's insights into a Baserow database table.
How To Use
- Import the workflow: Add this workflow to your n8n instance.
- Configure Umami Credentials: Set up HTTP Header Authentication for your Umami API access.
- Configure AI Credentials: Set up HTTP Header Authentication for your chosen AI provider (e.g., OpenRouter).
- Set Environment Variables: Ensure
BASE_URLandAPI_BASE_URLare correctly configured in your n8n environment. - Configure Baserow Table: Create a Baserow table with columns: 'Date' (Date), 'Summary' (Long text), 'Top pages' (Long text), and 'Blog name' (Long text).
- Update URLs: Adjust the
BASE_URLin the Umami nodes to point to your specific Umami instance and website. - Test and Activate: Run the workflow to ensure it functions correctly and schedule it for regular execution.
Apps Used
Workflow JSON
{
"id": "0df79f38-b7de-4776-a2b9-0f74ca0b7b55",
"name": "Umami Analytics to Baserow",
"nodes": 0,
"category": "Analytics",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: 0df79f38-b7de...
About the Author
N8N_Community_Pick
Curator
Hand-picked high quality workflows from the global community.
Statistics
Verification Info
Related Workflows
Discover more workflows you might like
OpenSea Analytics Agent Tool
An AI-powered agent for retrieving and analyzing OpenSea NFT market data.
Matomo Analytics SEO Insights
Generates SEO insights from Matomo analytics for repeat visitors using an AI agent.
PostHog Event Tracker
Tracks events in PostHog by dynamically setting the event name.
Robust Concurrency Control for n8n Workflows with Redis
Prevent simultaneous execution of critical n8n workflows or tasks using a centralized, Redis-backed locking mechanism. This reusable utility workflow ensures data integrity and resource management by allowing other workflows to acquire, check, and release locks.
Automated Multi-Platform Social Media Publisher
Streamline your social media content creation and publishing with this n8n workflow. Simply fill out a web form with your caption, media (image or video), and target platforms, and let n8n automate the posting process across multiple social networks.
Weekly Cocktail Inspiration for Your Team
Automatically share engaging cocktail recipes with your team or community every week. This workflow fetches a random recipe, generates a beautiful visual card using Bannerbear, and posts it directly to your Rocket.Chat channel, fostering fun and connection.