Monthly SEO report from Search Console

Name: Monthly SEO report from Search Console
Availability: InStock
Author: i2Business

Generate a monthly SEO report in Google Docs from Google Search Console: clicks, impressions, CTR, position, top 10 keywords and pages, indexing and trends.

2 downloadsGoogle Search Console · Google Docs report · Monthly KPIs · Month-over-month trends

Download for free See related section

Free download via formNo account needed: fill in the form below to receive the download link.

Description

Generate a monthly SEO report in Google Docs from Google Search Console: clicks, impressions, CTR, position, top 10 keywords and pages, indexing and trends.

This resource is maintained by i2Business consultants and updated whenever the systems it covers change. It works with the other building blocks in the catalog and can be tailored to your context as part of a support engagement.

Content preview

Skill excerpt: the steps of the report generated each month. SKILL.md

1. Google authentication (read scopes for Search Console + Google Docs)
2. Previous full month + the month before for comparison
3. KPIs: clicks, impressions, CTR, average position
4. Top 10 keywords, top 10 pages, indexing (sitemaps)
5. Automatic analysis: positives, points of attention, areas for improvement
6. Creation of the formatted Google Doc

Included files

Skill1

Python script1

How to use it

Install the skillUnzip the archive and add the seo-rapport-mensuel-gsc folder to your skills (Claude, Claude Code or Cowork).

Set up Google accessIn Google Cloud, enable the Search Console and Google Docs APIs, create an OAuth credential and save client_secret.json next to the script.

Specify your siteRun the script with your Search Console property address, or set the GSC_SITE_URL variable. The Google sign-in only opens once.

Generate the reportAsk "generate this month's SEO report": the script fetches the previous full month and compares it with the month before.

Review the Google DocThe document opens with KPIs, top 10 keywords and pages, indexing, positives and points of attention; fill in the improvement areas.

Details

TypeSkills

AccessVia form

Version1.0

Updated31 October 2026

Works with Claude