Turn website traffic into simple SEO tasks. It reads Matomo visit logs, finds repeat visitors, compares this week with last week, and turns patterns into clear suggestions for content and SEO. Great for marketers who want quick guidance without digging through long reports.

A schedule or a test button starts each run. Data comes from Matomo through an API call. A code step filters people who visited more than three times and formats their actions into a short summary. That text goes to an AI model through OpenRouter, which returns practical ideas and next steps. The result is saved in a Baserow table with the date, a note, and your site name so you can build a simple history of weekly insights.

You will need a Matomo token, an OpenRouter API key, and a Baserow table with Date, Note, and Blog fields. Expect a weekly note that shows shifts in behavior and suggests actions you can take right away. Teams can use it to plan small updates, repeat what works, and track how changes affect returning visitors over time.

• Manual and scheduled runs so you can test on demand and also run every week
• HTTP request to Matomo to pull last visits with a date range and site id
• Code step that formats visitor actions and focuses on people with more than three visits
• HTTP request to OpenRouter that sends the summary and returns simple SEO ideas
• Baserow create action that stores the date, the AI note, and your site name
• Configurable prompt so you can change tone or goals without changing the flow

• Reduce manual report work from 2 hours to 10 minutes
• Streamline weekly analytics review by about 70 percent
• Improve data accuracy by removing copy and paste errors
• Connect Matomo, an AI service, and Baserow in one flow
• Keep a clear history of weekly insights for easy follow up

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Matomo, OpenRouter and Baserow. See the Tools Required section above for links to create accounts with these services.
3. In your Matomo dashboard, create an auth token in Administration > Personal > Security > Auth tokens. Note your site id for the website you want to track.
4. Open the Get data from Matomo node. Set the URL to your Matomo domain. Keep method as POST, send body enabled, and content type as form data. Add body fields for module API, method Live.getLastVisitsDetails, idSite with your site id, period range, date for this week and last week, and token auth with your token.
5. Open the Code node and review the logic for more than three visits. Edit the prompt text if you want a different tone or focus.
6. In the n8n credentials manager, create a new Header Auth credential for OpenRouter. Set the header name to Authorization and the value to Bearer followed by your API key with a space after Bearer.
7. Assign the OpenRouter credential to the Send data to A.I. for analysis node. Confirm the endpoint is the OpenRouter chat completions URL and the JSON body includes your chosen model.
8. In Baserow, create or confirm a table with columns named Date, Note, and Blog. Generate a personal API token in your account settings.
9. In the n8n credentials manager, create a new Baserow credential with your API token. If you self host, set the correct base URL.
10. Open the Store results in Baserow node. Select your database and table. Map Date to a today expression, map Note to the AI message content from the previous node, and set Blog to your site name.
11. Open the Schedule Trigger and set the interval to run every week. Save the workflow and activate it.
12. Click Test workflow to run once. Check the execution. Confirm the AI response has content and that a new row appears in your Baserow table.
13. If you get an unauthorized error from OpenRouter, check the Authorization header and the space after Bearer. If Matomo returns an error, confirm the site id and token. If no Baserow row is created, verify the table and field names and that the credential is selected.