Tool · Google Sheets

AI search visibility tracker.

Track how AI models respond to your target queries over time. Monitor brand mentions, citation frequency, and competitive visibility across ChatGPT, Claude, Gemini, and Perplexity. Input your prompts once, automate tracking, and get daily dashboards showing exactly where you appear in AI-powered search results.

Charlie Morley-Harman·Head of SEO & AI Search
You’ll need
  • +Target prompts/queries to track
  • +A Google Doc with your prompts (setup instructions below)
  • +An Open Router API key (allows querying all AI models at once)

Make a copy of the template to your own Google Drive before beginning.

Step-by-step guide

Step 1

Configure your Setup tab

Navigate to the Setup tab in your copied template.

  • +Primary Brand Names: Replace the example brand names with your own. The script will track mentions of these brands across all AI responses.
  • +Toggle AI Models: Turn specific models on or off depending on what you want to track. Want ChatGPT responses only? Toggle the others off. Tracking everything? Leave all enabled.
Step 2

Create your prompts document

In Google Docs:

  • +Create a new document with your target prompts (one per line or paragraph)
  • +Copy the Document ID from the URL — docs.google.com/document/d/[THIS-IS-THE-ID]/edit
  • +Paste this ID into the Prompt ID field in your Setup tab

You can also paste prompts directly into the designated area in the Setup tab if you prefer to manage them there instead.

Step 3

Set up your API key

Get your Open Router API key (setup guide included in the template) and paste it into the API key field in the Setup tab.

Why Open Router? It allows you to query all AI models (ChatGPT, Claude, Gemini, Perplexity) simultaneously from a single API. No need for separate keys per model.

Need help with API setup? Reach out — we're happy to assist.

Step 4

Test your configuration

Before running a full batch:

  • +Navigate to the menu: AI Search Tracker → Test Google Doc
  • +Verify the setup is working correctly
  • +Check for any error messages

Fix any issues before proceeding to the full analysis.

Step 5

Process your prompts

When ready:

  • +Go to AI Search Tracker → Process All Prompts
  • +The script begins querying AI models with your prompts
  • +Monitor progress in the Progress tab (shows how many prompts are processing)

Processing time depends on the number of prompts and models enabled.

Step 6

Review your results

The script automatically generates:

Daily Tabs: One tab per day showing all AI responses for that date. Track changes over time by comparing daily tabs.

Reporting & Dashboard Tab: A consolidated view with:

  • +Brand mention frequency
  • +Citation rates per model
  • +Competitive visibility
  • +Trends over time
  • +Visual charts for quick scanning
What’s next

Run this weekly or monthly to build trend data. AI model responses evolve — track how your visibility changes over time.

Compare results across models. Some may cite you frequently while others don't. Understanding model-specific patterns helps prioritize optimization efforts.

Use insights to inform content strategy. If certain prompts never return your brand, that's a content gap worth addressing.

The Next Quarter

Get better visibility.

Find what's working and fix what's not. We're here to help you navigate the changing landscape of search.

Get in touch