DEV Community: Dylan Parker

Automating Google Search Console reporting with Python

Dylan Parker — Sat, 30 May 2026 09:00:52 +0000

I’ve been trying to automate more of my SEO reporting workflow lately, especially repetitive Google Search Console exports. Instead of manually downloading query data every week, I put together a small Python script that pulls top search queries directly from the Search Console API.

Here’s a simplified version:

from datetime import datetime, timedelta
from google.oauth2 import service_account
from googleapiclient.discovery import build

SCOPES = ['https://www.googleapis.com/auth/webmasters.readonly']
SERVICE_ACCOUNT_FILE = 'path/to/service-account.json'

def get_top_queries(site_url, days=30):
credentials = service_account.Credentials.from_service_account_file(
SERVICE_ACCOUNT_FILE,
scopes=SCOPES
)

service = build('searchconsole', 'v1', credentials=credentials)

request = {

    'startDate': (

        datetime.now() - timedelta(days=days)

    ).strftime('%Y-%m-%d'),

'endDate': datetime.now().strftime('%Y-%m-%d'),

'dimensions': ['query'],
'rowLimit': 10



}

response = service.searchanalytics().query(

    siteUrl=site_url,

    body=request

).execute()

return response.get('rows', [])

Example usage

queries = get_top_queries('https://example.com')

for row in queries:
print(
f"Query: {row['keys'][0]}, "
f"Clicks: {row['clicks']}, "
f"Impressions: {row['impressions']}"
)

This has been useful for:

automated SEO dashboards
weekly reporting
tracking query trends over time
identifying declining pages earlier

Sometimes I also cross-reference GSC data with live SERP tracking tools for comparison, but GSC alone already provides a surprisingly solid base for automation.

Curious what APIs or datasets other developers are using for SEO automation:

Google Search Console?
GA4?
server logs?
SERP APIs?
custom crawlers?

Would love to hear other workflows or reporting setups people are building.

I needed to generate hundreds of meta descriptions for a client's e-commerce site.

Dylan Parker — Mon, 25 May 2026 08:39:43 +0000

Instead of writing them manually, I wrote a Python script that uses a simple keyword extraction method to pull key terms from product descriptions and combine them into a template. Here's a snippet:

python
import re
from collections import Counter

def extract_keywords(text, top_n=5):
words = re.findall(r'\b[a-z]{3,}\b', text.lower())
return [word for word, _ in Counter(words).most_common(top_n)]

def generate_meta(description):
keywords = extract_keywords(description)
return f"Shop our {', '.join(keywords[:3])} collection. {description[:100]}..."

It's not perfect, but it saves a ton of time. For more complex SEO tasks, I've been using a tool that automates keyword research and meta tag generation. What's your workflow for bulk meta descriptions?

Built a small script to automate SEO reports using SerpSpur's API.

Dylan Parker — Sat, 23 May 2026 07:16:13 +0000

The data quality is comparable to major paid tools. If you're a dev looking for an SEO data source, check it out.serpspur.com