Back to Tools

GSC Question Finder

Use cases

Identifying FAQ content opportunities from existing rankings Finding question queries where you already have visibility Building content briefs from real user questions Prioritising informational content by impression volume

Filters GSC queries using two regex strategies: a strict pattern matching 50+ question indicators (who, what, when, where, why, how, installing, cost, vs, regulations) and a loose pattern for auxiliary verbs (can, could, will, would, do, does, did).

Deduplicates entries keeping the highest-impression variant and removes punctuation while preserving word boundaries.

Streamlit App GSC Data

Platform

Browser-based (no installation required)

Input

Google OAuth credentials

GSC property URL

Output

CSV with question queries and metrics

Launch App View Source

Features

  • Two regex patterns: strict (50+ terms) and loose (auxiliary verbs)
  • Extracts queries containing question marks
  • Deduplication keeping highest-impression variant
  • Configurable lookback period (default 360 days)
  • Results sorted by impressions descending

How to use

  1. 1 Set up OAuth credentials in Google Cloud Console
  2. 2 Configure DOMAIN and DAYS variables in script
  3. 3 Choose QUESTION_PATTERN (strict or loose)
  4. 4 Run script and authenticate via browser
  5. 5 Export filtered questions to CSV

Let's work together

Monthly retainers or one-off projects. No lengthy reports that sit in a drawer.

Let's Talk