📊 Track play store app rankings with SerpApi, Baserow & Slack alerts

⚡ 121 views · 📊 Market Research & Insights

Description

Automatically track your Android app’s keyword rankings on Google Play. This workflow checks ranks via SerpApi, updates a Baserow table, and posts a heads-up in Slack so your team can review changes quickly.

💡 Perfect for

• ASO teams tracking daily keyword positions

• Growth & marketing standups that want quick rank visibility

• Lightweight historical logging without a full BI stack

🧠 What it does

• Runs on a schedule (e.g., weekly)

• Queries SerpApi for each keyword’s Play Store ranking

• Saves results to Baserow: Current Rank, Previous Rank, Last modified

• Sends a Slack alert: “Ranks updated — review in Baserow”

⚡ Requirements

• SerpApi account & API key

• Baserow account + API token

• Slack connection (bot/app or credential in n8n)

⚙️ Setup Instructions

1. Create a Baserow table

Create a new table (any name). Add user-field names exactly:

• Keywords (text)

• Current Rank (number)

• Previous Rank (number)

• Last modified (date/time)

Optional fields you can add later: Notes, Locale, Store Country, App Package ID.

2. Connect credentials in n8n

• Baserow: add your API token and select your Database and Table in the Baserow nodes.

• Slack: connect your Slack account/workspace in the Slack node.

• SerpApi: open the HTTP Request node and put your API key under Query Parameters → api_key = YOUR_KEY.

3. Verify field mapping

• In the Baserow (Update Row) node, map:

• Row ID → {{$json.id}}

• Current Rank → {{$json[“Current Rank”]}}

• Previous Rank → your code node should set this (the template copies the old “Current Rank” into “Previous Rank” before writing the new one)

• Last modified → {{$now}} (or the timestamp you compute)

🛟 Notes & Tips

If you prefer a single daily Slack summary instead of multiple pings, add a Code node after updates to aggregate lines and send one message.

Treat 0 or missing ranks as “not found” and flag them in Slack if helpful.

For multi-country tracking, include hl/gl (locale/country) in your SerpApi query params and store them as columns.

🤝 Need a hand?

I’m happy to help you get this running smoothly—or tailor it to your brand.

Reach out to me via email: imarunavadas@gmail.com

🔗 Nodes Used

HTTP Request, Slack, Baserow, Schedule Trigger

📥 Import

Download workflow.json and import into n8n: Workflow menu → Import from File

📖 Importing guide · 🔑 Credential setup