Get weekly SEO insights without writing reports by hand. The build pulls keyword rankings from SerpBear, asks an AI to write a short summary, and stores the note in Baserow. It suits marketers, content teams, and site owners who want steady updates and a clean history of changes.

Here is how it runs. A schedule or a manual test starts the flow. An HTTP request fetches your site’s keywords from SerpBear using your domain and site id. A Code step parses the list and creates a clear message for the AI. A second HTTP call sends that message to OpenRouter to get a readable summary. The reply is saved into Baserow with the date and your blog name. You get one place for weekly notes you can filter, sort, and share.

Setup needs your SerpBear API access, an OpenRouter API key, and a Baserow table with Date, Note, and Blog fields. Expect a steady weekly note and less time spent on reporting. Use it for content planning, weekly standups, or client updates where quick, clear SEO notes help decisions.

• Scheduled run collects keyword rankings on a weekly interval
• HTTP request pulls SerpBear data using domain and site id parameters
• Code node parses keywords and builds a clear summary prompt
• HTTP request to OpenRouter gets an AI written SEO summary
• Baserow create action saves Date, Note, and Blog in one row
• Manual trigger lets you test end to end before turning on the schedule

• Reduce manual SEO reporting from 60 minutes to 5 minutes each week
• Automate 90% of weekly keyword note writing with AI
• Improve accuracy by using live SerpBear data rather than copy and paste
• Centralize insights in Baserow for easy search and sharing
• Scale to hundreds of keywords without extra workload

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 SerpBear, OpenRouter and Baserow. See the Tools Required section above for links to create accounts with these services.
3. In SerpBear, confirm your instance URL, your API access, your site id, and your domain. Note these values for the HTTP Request node.
4. Open the Get data from SerpBear node in n8n. In the Credential to connect with menu, click Create new credential, then follow the on screen instructions to connect your SerpBear instance. Use header based auth if your instance requires a token.
5. In the SerpBear node, set the URL to your instance endpoint, for example https://your-serpbear-url/api/keyword?id=YOUR_SITE_ID and add a query parameter named domain with your domain value.
6. Click Execute node on the SerpBear node to verify you receive a keywords array. If empty, check the domain value and site id.
7. Open the Parse data from SerpBear Code node and run it once. Confirm the output includes a combined message ready for AI.
8. Open the Send data to A.I. node. Create a new Header Auth credential with key Authorization and value Bearer YOUR_OPENROUTER_API_KEY. Keep a space after Bearer.
9. Execute the AI node. In the output, confirm choices[0].message.content returns a summary. If not, shorten the prompt or try a different model supported by your OpenRouter plan.
10. In Baserow, create a table with fields named Date, Note, and Blog. Copy the database id and table id.
11. Open the Save data to Baserow node. Create a new Baserow credential with your personal API token. Set the database id and table id. Map Date to today’s date, Note to the AI response, and Blog to your site name.
12. Run the full workflow using the manual trigger. Confirm a new row appears in Baserow with the right values. Then set the Schedule Trigger to run weekly and activate the workflow.