Pull Google Search Console Data with Claude Code

2 min read

Exporting CSVs from Google Search Console is tedious. You click around the UI, filter, export, open in a spreadsheet, repeat. It's slow and annoying.

With Claude Code + the social-tools MCP server, you can query GSC directly from the terminal. Ask questions in plain English, get answers immediately.

Setup

Add social-tools to your Claude Code MCP config (~/.claude/settings.json):

{
  "mcpServers": {
    "social-tools": {
      "command": "npx",
      "args": ["-y", "@neonwatty/social-tools"]
    }
  }
}

Then authenticate (opens browser for OAuth):

# In Claude Code, just say: "authenticate with google search console"

Real Examples

Here's what I ran on my own site this morning.

"Show me my top queries by clicks"

Query                            Clicks  Impressions  CTR     Position
----------------------------------------------------------------------
youtube to gif no watermark      2       67           3.0%    6.7
claude code in ci                1       7            14.3%   6.7
ytgify                           1       33           3.0%    5.4

Immediately useful. "youtube to gif no watermark" is getting clicks at position 6.7—worth pushing to top 3. "claude code in ci" has a 14.3% CTR, which means the snippet is working.

"Which pages are these ranking on?"

Query                            Page                                                    Position
-------------------------------------------------------------------------------------------------
youtube to gif no watermark      neonwatty.com/posts/ytgify-launch/                      6.7
claude code in ci                neonwatty.com/posts/claude-code-ci-babysitter/          6.7

Now I know exactly which posts to optimize for which keywords.

Why This Beats the GSC UI

  • No clicking around - just ask what you want
  • Instant follow-ups - "now filter to just queries with position 5-20"
  • Combine with other tools - Claude Code can read your blog posts and cross-reference with GSC data
  • No CSV exports - data stays in your terminal

The Commands Under the Hood

Claude Code calls these MCP tools:

  • gsc_auth - authenticate with Google
  • gsc_sites - list your verified properties
  • gsc_query - pull the actual data (dimensions, date ranges, filters, sorting)

You don't need to remember the syntax. Just describe what you want.


That's it. Install the MCP server, authenticate once, then query your search data with plain English. Beats clicking around the GSC UI every time.