Recipe

How to Automate Your Google Search Console Report with Claude

A one-time, 45-minute build: Claude writes you a small script that reads your Google search numbers every week and tells you, in plain English, what moved and why it matters.

Google Search Console already knows which searches bring people to your website — most owners just never look, because the dashboard shows everything and explains nothing. This recipe fixes that once, for good: you paste one prompt into Claude, it writes a small script that pulls your last four weeks of search data, compares it to the four weeks before, and prints a plain-English report. You don't need to know how to code. Claude writes it, Claude fixes it when something errors, you just run it on Mondays with your coffee. (This is the exact loop we run on our own site every week.)

Total time

45 minutes, once

Difficulty

Medium

Makes

A weekly search report that runs itself

Tool

Claude + a free Google account

Ingredients

A website you own, verified in Google Search Console (if you can see your site at search.google.com/search-console, you're in)
The Claude desktop app
45 minutes, one time — after that it's 5 minutes a week
A willingness to copy-paste things you don't fully understand (that's allowed)

The prompt

You're going to help me, a non-technical business owner, build a small Python script that automatically pulls my Google Search Console data and turns it into a weekly plain-English report. My website is [YOUR SITE]. Walk me through this step by step, one step at a time, and wait for me to confirm each one: 1) checking that Python is installed on my computer, 2) setting up Google's Search Console API access (assume I've never used Google Cloud — tell me exactly what to click), 3) writing the script. The script should: pull my last 28 days of search queries and pages, compare them to the 28 days before that, and print a short report in plain English — which searches and pages gained or lost clicks, where my ranking moved by more than one position, and three specific suggestions based on what changed. When I hit an error, I'll paste it here and you fix the script. Start with step 1.

The method

Google Search Console is the free report card Google keeps on your business — every search that showed your site, every click, your average position. Most owners look at it twice: the day someone sets it up, and the day something breaks. Not because they don't care — because the dashboard shows ten thousand rows and zero opinions.

So put Claude on it. This is a one-time build, and you don't write a line of code — Claude does, and Claude fixes it when it errors. Tested in our own kitchen: this is the same loop we run on getexpo.com every Monday morning.

Open Search Console and confirm you can see your site. If your web person set it up years ago and you've never logged in, do that first — everything else depends on it.
Open a new Claude chat, paste the prompt above, and put your actual website address in. The key phrase in the prompt is "one step at a time" — Claude will walk you through Google's API setup the way a patient IT person would, waiting for you to confirm each click.
Follow along and copy-paste. The Google Cloud part feels intimidating and isn't — it's about six clicks, free at this volume, and Claude tells you exactly which buttons. When anything throws an error, paste the whole error message back into the chat. Fixing those is Claude's job, not yours.
Run the finished script once and read your first report. You'll see which searches actually bring people in — usually a surprise — and where you moved up or down.
Make it a Monday ritual: run the script, read two paragraphs, done. If the report flags something — a page losing clicks, a search you suddenly rank for — paste it back into Claude and ask "what should I do about this?"

This is one move from the Expo recipe library — short, specific guides for business owners learning to use AI without anyone selling them something. It pairs well with How to Have Claude Read Your P&L Like a CFO, and there's more on the small business shelf.

On the plate

The good draft

Your site appeared in 2,140 searches in the last 4 weeks, up 9%. "emergency plumber dayton" moved from position 7 to 4 — it brought 31 clicks, your best gainer. Your /water-heaters page lost about a third of its clicks; the ranking is steady, so the search itself may be seasonal. Three suggestions: add your service area to the page title on /repairs; the query "tankless water heater cost" shows you on page 2 — a price-range section could move it; nothing else changed enough to act on.

The bad draft

Your SEO is looking great this week! Impressions are an important metric that shows how often you appear in search. Keep creating high-quality, relevant content and engaging with your audience to maintain momentum!

Notes from the kitchen

Do I need to know how to code?

No. Claude writes the script, explains it if you're curious, and debugs it when it errors. Your job is copy-paste and clicking the buttons it names. Thousands of non-technical owners run little scripts like this now — that's the quiet revolution.

Doesn't Google Search Console already show me this?

It shows you everything, which is the problem. The win here isn't the data — it's the comparison and the opinion: what changed since last month, in two paragraphs, with suggestions. That's the part the dashboard will never do.

Does this cost anything?

No. Search Console is free, its API is free, and the data volumes of a small-business site are nowhere near Google Cloud's paid tiers. Your only cost is the 45-minute setup.

What about showing up in AI answers, not just Google?

Search Console only sees Google — but it's still your best free signal. One tip: queries phrased as full questions ("who does same-day alterations in mesa") are a preview of what people ask AI assistants. If those are growing, make sure your site answers them in plain sentences.

Open Search Console and confirm you can see your site. If your web person set it up years ago and you've never logged in, do that first — everything else depends on it.
Open a new Claude chat, paste the prompt above, and put your actual website address in. The key phrase in the prompt is "one step at a time" — Claude will walk you through Google's API setup the way a patient IT person would, waiting for you to confirm each click.
Follow along and copy-paste. The Google Cloud part feels intimidating and isn't — it's about six clicks, free at this volume, and Claude tells you exactly which buttons. When anything throws an error, paste the whole error message back into the chat. Fixing those is Claude's job, not yours.
Run the finished script once and read your first report. You'll see which searches actually bring people in — usually a surprise — and where you moved up or down.
Make it a Monday ritual: run the script, read two paragraphs, done. If the report flags something — a page losing clicks, a search you suddenly rank for — paste it back into Claude and ask "what should I do about this?"

About the author

By the Expo Team. AI Confidential is Expo's plain-English guide to using AI in your business — written by operators, for operators. Browse more recipes and guides.