How to build an SEO tracker in Bubble

To build an SEO tracker in Bubble, you store keywords and URLs in your database, call an external SEO API (because Bubble cannot scrape Google directly), save the ranking results, and schedule backend workflows to refresh the data automatically. The core is: create data types for Keywords and Reports, use the API Connector to connect to a provider like SERPAPI or DataForSEO, run a backend workflow on a recurring schedule, store each result, and show them in repeating groups.

Core Structure

You need three main parts: a database structure to store keywords and ranking results, an API Connector call to an SEO data provider, and backend workflows to fetch rankings on a schedule (daily/weekly). Bubble cannot query Google directly, so you must use a legal SERP API service.

• Keyword: fields like "phrase" (text), "target\_url" (text).
• Keyword Report: fields like "keyword" (Keyword), "position" (number), "fetched_at" (date), "raw_response" (text).

API Setup

Use Bubble’s API Connector plugin to call a provider. Example with SERPAPI (works and is simple):

{
  "engine": "google",
  "q": "<keyword>",
  "location": "United States",
  "api_key": "YOUR_SERPAPI_KEY"
}

In the API Connector:

• Set method to GET.
• Use URL: https://serpapi.com/search.json
• Add query params like q, engine, and api\_key.

Backend Workflow

Create a backend workflow called update_keyword_rank that takes a Keyword as a parameter. Inside it, run the API call, then Create a new Keyword Report storing the ranking position. For SERPAPI, ranking position is typically inside the "organic\_results" list.

// pseudo Bubble JSON structure output example
"organic_results": [
  {
    "position": 3,
    "link": "https://example.com"
  }
]

Scheduling

Create another backend workflow that loops through all Keywords and schedules update_keyword_rank for each. Then attach this runner to a Recurring Event (daily or weekly) using Bubble’s built-in Recurring Events.

Displaying the Data

On the page, use a Repeating Group to show each Keyword, and inside it another Repeating Group filtered by Keyword Reports sorted by "fetched\_at". This gives a trend history chart. You can add a line chart using Bubble’s Chart element by feeding it the Keyword Reports.

Privacy Rules

Create rules ensuring users can only see their own Keywords and Keyword Reports (using Created By = Current User or similar constraints).