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": "qmmXKcpJOCm9qaCk",
"meta": {
"templateCredsSetupCompleted": true
},
"name": "SERPBear analytics template",
"tags": [],
"nodes": [
{
"id": "2ad0eb40-6628-4c6b-bc15-7081e7712f1a",
"name": "When clicking \u2018Test workflow\u2019",
"type": "n8n-nodes-base.manualTrigger",
"position": [
260,
380
],
"parameters": {},
"typeVersion": 1
},
{
"id": "5a3c9ad8-a562-4bb0-bb11-c325552d8101",
"name": "Schedule Trigger",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
260,
160
],
"parameters": {
"rule": {
"interval": [
{
"field": "weeks"
}
]
}
},
"typeVersion": 1.2
},
{
"id": "bdfa7388-f9b3-4145-90de-2e58138e14bf",
"name": "Get data from SerpBear",
"type": "n8n-nodes-base.httpRequest",
"position": [
580,
260
],
"parameters": {
"url": "https://myserpbearinstance.com/api/keyword?id=22",
"options": {},
"sendQuery": true,
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth",
"queryParameters": {
"parameters": [
{
"name": "domain",
"value": "rumjahn.com"
}
]
}
},
"credentials": {
"httpHeaderAuth": {
"name": "<your credential>"
}
},
"executeOnce": false,
"typeVersion": 4.2,
"alwaysOutputData": false
},
{
"id": "c169f4e3-ab60-4b46-9f49-cf27a13dd7c6",
"name": "Parse data from SerpBear",
"type": "n8n-nodes-base.code",
"position": [
820,
260
],
"parameters": {
"jsCode": "const keywords = items[0].json.keywords;\nconst today = new Date().toISOString().split('T')[0];\n\n// Create summary for each keyword\nconst keywordSummaries = keywords.map(kw => {\n const position = kw.position || 0;\n const lastWeekPositions = Object.values(kw.history || {}).slice(-7);\n const avgPosition = lastWeekPositions.reduce((a, b) => a + b, 0) / lastWeekPositions.length;\n \n return {\n keyword: kw.keyword,\n currentPosition: position,\n averagePosition: Math.round(avgPosition * 10) / 10,\n trend: position < avgPosition ? 'improving' : position > avgPosition ? 'declining' : 'stable',\n url: kw.url || 'not ranking'\n };\n});\n\n// Create the prompt\nconst prompt = `Here's the SEO ranking data for rumjahn.com as of ${today}:\n\n${keywordSummaries.map(kw => `\nKeyword: \"${kw.keyword}\"\nCurrent Position: ${kw.currentPosition}\n7-Day Average: ${kw.averagePosition}\nTrend: ${kw.trend}\nRanking URL: ${kw.url}\n`).join('\\n')}\n\nPlease analyze this data and provide:\n1. Key observations about ranking performance\n2. Keywords showing the most improvement\n3. Keywords needing attention\n4. Suggested actions for improvement`;\n\nreturn {\n prompt\n};"
},
"typeVersion": 2
},
{
"id": "cc6e16a7-db46-42fe-837a-59ce635c906c",
"name": "Send data to A.I. for analysis",
"type": "n8n-nodes-base.httpRequest",
"position": [
1060,
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 keyword data for my site. Can you summarize the data into a table and then give me some suggestions:{{ encodeURIComponent($json.prompt)}}\" \n }\n ]\n}",
"sendBody": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth"
},
"credentials": {
"httpHeaderAuth": {
"name": "<your credential>"
}
},
"typeVersion": 4.2,
"alwaysOutputData": false
},
{
"id": "a623f06c-1dfe-4d04-a7fd-fed7049a7588",
"name": "Save data to Baserow",
"type": "n8n-nodes-base.baserow",
"position": [
1340,
260
],
"parameters": {
"tableId": 644,
"fieldsUi": {
"fieldValues": [
{
"fieldId": 6264,
"fieldValue": "={{ DateTime.now().toFormat('yyyy-MM-dd') }}"
},
{
"fieldId": 6265,
"fieldValue": "={{ $json.choices[0].message.content }}"
},
{
"fieldId": 6266,
"fieldValue": "Rumjahn"
}
]
},
"operation": "create",
"databaseId": 121
},
"credentials": {
"baserowApi": {
"name": "<your credential>"
}
},
"typeVersion": 1
},
{
"id": "e8048faf-bbed-4e48-b273-d1a50a767e76",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
220,
-360
],
"parameters": {
"color": 5,
"width": 614.709677419355,
"height": 208.51612903225802,
"content": "## Send Matomo analytics to A.I. and save results to baserow\n\nThis workflow will check the Google keywords for your site and it's rank.\n\n[\ud83d\udca1 You can read more about this workflow here](https://rumjahn.com/how-to-create-an-a-i-agent-to-analyze-serpbear-keyword-rankings-using-n8n-for-free-without-any-coding-skills-required/)"
},
"typeVersion": 1
},
{
"id": "1a18e685-79db-423f-992a-5e0d4ddeb672",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
520,
-80
],
"parameters": {
"width": 214.75050403225822,
"height": 531.7318548387107,
"content": "## Get SERPBear Data\n \n1. Enter your SerpBear API keys and URL. You need to find your website ID which is probably 1.\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": "99895baf-75d0-4af2-87de-5b8951186e78",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
980,
-60
],
"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": "07d03511-98b0-4f4a-8e68-96ca177fb246",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
1240,
-40
],
"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": "8b7e7da7-1965-4ca4-8e15-889eda819723",
"connections": {
"Schedule Trigger": {
"main": [
[
{
"node": "Get data from SerpBear",
"type": "main",
"index": 0
}
]
]
},
"Get data from SerpBear": {
"main": [
[
{
"node": "Parse data from SerpBear",
"type": "main",
"index": 0
}
]
]
},
"Parse data from SerpBear": {
"main": [
[
{
"node": "Send data to A.I. for analysis",
"type": "main",
"index": 0
}
]
]
},
"Send data to A.I. for analysis": {
"main": [
[
{
"node": "Save data to Baserow",
"type": "main",
"index": 0
}
]
]
},
"When clicking \u2018Test workflow\u2019": {
"main": [
[
{
"node": "Get data from SerpBear",
"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
This workflow automates the retrieval and analysis of SERP rankings from SerpBear, delivering actionable insights into your website's search performance without manual effort. It's ideal for digital marketers, SEO specialists, or small business owners who need regular visibility into keyword positions and trends to refine strategies. The key step involves fetching raw data via HTTP requests from SerpBear, parsing it through code, and storing the processed results in Baserow for easy access and reporting.
Use this template when you want event-driven or scheduled SERP monitoring to track competitors or campaign impacts, especially if you're already using Baserow for data management. Avoid it for real-time alerts, as it's better suited for batch processing; opt for simpler tools if you lack API access to SerpBear. Common variations include adding email notifications for ranking drops or integrating with Google Sheets instead of Baserow for collaborative review.
About this workflow
SERPBear analytics template. 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.
Matomo Analytics Report. 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.