# Analyze SerpBear Rankings to Baserow Source: https://openflow.run/en/templates/analyze-serpbear-rankings-to-baserow/ Content language: en Template revision: 9018120e802d4de0a097610157c565df858c0871 Analytics Analyze a domain’s SerpBear keyword rankings and save a report to Baserow. [Use in Open Flow](https://console.openflow.run/flows?importUrl=https%3A%2F%2Fraw.githubusercontent.com%2Foomol-lab%2Fawesome-workflow-templates%2F9018120e802d4de0a097610157c565df858c0871%2Fworkflows%2Fanalyze-serpbear-rankings-to-baserow%2Ftemplates%2Fanalyze-serpbear-rankings-to-baserow.openflow.json) * [Open Flow JSON](https://raw.githubusercontent.com/oomol-lab/awesome-workflow-templates/9018120e802d4de0a097610157c565df858c0871/workflows/analyze-serpbear-rankings-to-baserow/templates/analyze-serpbear-rankings-to-baserow.openflow.json) * [n8n JSON](https://raw.githubusercontent.com/oomol-lab/awesome-workflow-templates/9018120e802d4de0a097610157c565df858c0871/workflows/analyze-serpbear-rankings-to-baserow/templates/analyze-serpbear-rankings-to-baserow.n8n.json) ![Analyze SerpBear Rankings to Baserow workflow in Open Flow](https://openflow.run/_astro/preview-light.DlsWw7bV_Z12m7Eh.webp) Analyze a domain’s SerpBear keyword rankings and save a report to Baserow. ## Setup In **Configure SerpBear**, set your public HTTPS instance URL ending in /api/keywords and the tracked domain. Create a secret Variable containing the SerpBear API key and bind it to **Auth Token**. Connect OpenRouter in **Analyze keyword rankings** and select an available model. Connect Baserow Cloud in **Save report to Baserow**, choose a table with Date, Note and Blog fields, and set the blog name in **Prepare report row**. In n8n, set the SerpBear URL and domain in **Configure SerpBear**, configure Header Auth with name Authorization and value Bearer YOUR\_SERPBEAR\_API\_KEY, and configure OpenRouter Header Auth with name Authorization and value Bearer YOUR\_OPENROUTER\_API\_KEY. Select an available model in the OpenRouter request. Connect Baserow credentials and select the Date, Note and Blog fields. Activate one format. ## Behavior A manual run or weekly schedule reads all keywords returned for the configured domain, summarizes current rank and up to seven most recent recorded history entries, and asks the configured OpenRouter model for observations and actions. Empty keyword lists produce no report. Zero history positions are excluded from the average; a keyword with no ranked history or with position zero is labeled as having insufficient ranking data. Results depend on SerpBear data and model output; review reports before acting. The workflow stores one Date, Note and Blog row in Baserow. Read, model or write failure stops the run. A failed or uncertain row creation may already have succeeded; check Baserow before retrying. SerpBear must be reachable over HTTPS. Keep API keys and ranking data private. Open Flow uses UTC Sunday midnight; the source depended on the n8n instance timezone. n8n chooses a fixed second within the scheduled minute; Open Flow uses the minute boundary. Inspiration & credits ## Changes to the source * Query the documented /api/keywords endpoint by domain. The source queried one keyword but attempted to read a keyword list. * Sort dated history before choosing the latest seven recorded entries, handle absent history and zero positions, and escape the prompt as JSON instead of URL-encoding it. * Replace personal domain and table IDs, choose an available model, validate the response and set UTC explicitly. Adapted from [Analyze SerpBear keyword rankings](https://github.com/Zie619/n8n-workflows/blob/ae8cf6dc5b873cbb4f74587aa9180ed3a9f70682/workflows/Code/1965_Code_Schedule_Automation_Webhook.json) in [Zie619/n8n-workflows](https://github.com/Zie619/n8n-workflows). The matching [n8n listing](https://n8n.io/workflows/2565-summarize-serpbear-data-with-ai-via-openrouter-and-save-it-to-baserow/) credits Keith Rumjahn. The original template does not state a separate license. The collection’s [MIT notice](https://github.com/Zie619/n8n-workflows/blob/94007c1445d9258a7da116646b79473e7c7c3282/LICENSE) is pinned at a later revision. This is the collection notice at that revision; it does not establish a separate original template author’s license. Our changes are listed above; see [repository licensing](https://github.com/oomol-lab/awesome-workflow-templates/blob/9018120e802d4de0a097610157c565df858c0871/README.md#licensing). > MIT License > > Copyright (c) 2025 Zie619 > > Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the “Software”), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions: > > The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software. > > THE SOFTWARE IS PROVIDED “AS IS”, WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE. ## Apps used * [**Baserow**`baserow`](https://console.openflow.run/connections/baserow) * [**OpenRouter**`openrouter`](https://console.openflow.run/connections/openrouter) ## What you’ll need * Public HTTPS SerpBear instance, domain and API key * OpenRouter connection and available model * Baserow Cloud table with Date, Note and Blog fields * serpbear * openrouter * baserow * seo [View on GitHub](https://github.com/oomol-lab/awesome-workflow-templates/blob/9018120e802d4de0a097610157c565df858c0871/workflows/analyze-serpbear-rankings-to-baserow/README.md)