How to build an SEO tracker in Bubble

Go to console.cloud.google.com. Create a new project or select an existing one. Navigate to APIs & Services → Library, search for Google Search Console API, and click Enable. Then go to APIs & Services → Credentials → Create Credentials → OAuth 2.0 Client ID. Select Web application. Add your Bubble OAuth redirect URI: https://yourapp.bubbleapps.io/api/1.1/oauth_redirect. Copy the Client ID and Client Secret.

In the Plugins tab, open the API Connector. Add a new API called Google Search Console. Set Authentication to OAuth2 User-Agent Flow. Enter the Client ID, Client Secret, Scope (https://www.googleapis.com/auth/webmasters.readonly), Authorization URL (https://accounts.google.com/o/oauth2/auth), and Token URL (https://oauth2.googleapis.com/token). Add an API call named Get Search Analytics. Method: POST. URL: https://www.googleapis.com/webmasters/v3/sites/[site_url]/searchAnalytics/query. Set the body to request search data with dimensions for query, page, and date.

1POST https://www.googleapis.com/webmasters/v3/sites/[site_url]/searchAnalytics/query
2
3Body:
4{
5  "startDate": "[start_date]",
6  "endDate": "[end_date]",
7  "dimensions": ["query", "date"],
8  "rowLimit": 100
9}
10
11Response:
12{
13  "rows": [
14    {
15      "keys": ["keyword", "2026-03-27"],
16      "clicks": 45,
17      "impressions": 1200,
18      "ctr": 0.0375,
19      "position": 3.2
20    }
21  ]
22}

Go to the Data tab and create these Data Types. TrackedSite: url (text), name (text), owner (User). KeywordData: site (TrackedSite), keyword (text), date (date), clicks (number), impressions (number), ctr (number), position (number). RankingAlert: site (TrackedSite), keyword (text), old_position (number), new_position (number), change (number), alert_date (date), is_read (yes/no). These types let you store daily snapshots and detect changes over time.

Create a page called seo-dashboard. Add a site selector Dropdown at the top. Below it, create a summary row showing total clicks, total impressions, average position, and average CTR for the selected date range (use Do a search for KeywordData with :each item's clicks :sum etc.). Add a line chart (using the Bubble Chart plugin or Chart.js plugin) showing clicks and impressions over time. Add a Repeating Group below showing the top keywords sorted by clicks descending, with columns for keyword, clicks, impressions, CTR, and average position.

Create a backend workflow called fetch-daily-seo-data. This workflow calls the Google Search Console API for each TrackedSite, requesting data for yesterday's date. For each row in the response, create a KeywordData record. Before creating, check if a record for that keyword and date already exists to prevent duplicates. Schedule this workflow to run daily at a fixed time (e.g., 6 AM). Enable backend workflows in Settings → API tab. Set up the initial schedule by triggering it once from a button on the admin page.

In the daily fetch workflow, after storing new data, compare each keyword's current position with its position from 7 days ago (Do a search for KeywordData where keyword = this keyword AND date = Current date - 7 days). If the position changed by more than 3 spots, create a RankingAlert record. On the dashboard, add a Notifications section showing recent alerts. Style position improvements in green and drops in red. Add email notifications for significant drops (position worsened by more than 5 spots) using the Send email action.