Gsc Assistant

GSC Assistant Skill

Purpose

This skill helps manage Google Search Console indexing status by maintaining two markdown tracking files:

1. indexed.md - All indexed pages in two tables:

   • "Indexed Public" - URLs confirmed in GSC export data
   • "Indexed With Lag" - URLs confirmed via URL Inspection (not yet in export)

2. to-index.md - Pages awaiting indexing:

   • Difference between sitemap and total indexed URLs
   • Prioritized by categories (configurable)
   • Tracks submission dates

When to Use This Skill

• User asks about "indexing status" or "GSC indexing"
• User wants to "compare sitemap with indexed pages"
• User mentions "URL inspection" or "false positives"
• User needs to "track submissions" or "indexing progress"
• User asks to "move indexed pages" or "update indexing status"
• User wants to "generate indexing report"

Key Concepts

GSC Data Lag

Google Search Console export data has approximately 2 weeks lag. Pages that show as indexed in URL Inspection may not appear in the export yet. These are tracked separately as "Indexed With Lag".

False Positives

When checking to-index pages via URL Inspection:

• If indexed: Mark as "false positive - indexed" in Submitted column
• Pre-processing moves these to indexed.md (Indexed With Lag table)
• The "Detected" date is inferred from when the entry was added to to-index

Priority Categories

to-index.md organizes pages by priority:

• Priority 1: High-value content series
• Priority 2: Recent content (current/previous year)
• Priority 3: Specific content collections
• Lower priorities: Archive pages, pagination, etc.

File Schemas

indexed.md

# Indexed Pages

## Indexed Public (GSC Export)

*Last updated: YYYY-MM-DD*
*Source: gsc-export.csv*

| # | URL | Last Crawled |
|---|-----|--------------|
| 1 | https://example.com/page-1/ | 2025-12-01 |
| 2 | https://example.com/page-2/ | 2025-12-02 |

## Indexed With Lag (URL Inspection Confirmed)

*Pages confirmed indexed via URL Inspection but not yet in GSC export*

| # | URL | Detected | Confirmed |
|---|-----|----------|-----------|
| 1 | https://example.com/new-page/ | 12 Dec 2025 | 12 Dec 2025 |

to-index.md

# Pages To Index

*Generated: YYYY-MM-DD*
*Total: X pages*

## Priority 1: [Category Name]

| # | URL | Submitted |
|---|-----|-----------|
| 1 | https://example.com/important-page/ | 12 Dec |
| 2 | https://example.com/another-page/ | - |

## Priority 2: [Category Name]

| # | URL | Submitted |
|---|-----|-----------|
| 1 | https://example.com/recent-post/ | - |

Workflow

Initial Setup

1. Import GSC export CSV to create indexed.md (Indexed Public table)
2. Extract sitemap URLs
3. Calculate difference (sitemap - indexed = to-index)
4. Categorize to-index pages by priority
5. Generate to-index.md

Regular Updates

1. Pre-processing: Scan to-index.md for "false positive - indexed" entries
2. Move false positives to indexed.md (Indexed With Lag table)
3. Set "Detected" date from when entry was in to-index
4. Set "Confirmed" date to current date
5. Remove from to-index.md
6. Update counts and statistics

Manual Operations

• Mark submissions: Update "Submitted" column with date
• Check status: Use URL Inspection, mark result
• Refresh data: Import new GSC export, recalculate

Configuration

Create working files in project directory:

project/
├── gsc-export.csv          # GSC indexed pages export
├── sitemap.xml             # Site sitemap (or use dist/sitemap.xml)
├── indexed.md              # Tracking file (generated)
└── to-index.md             # Tracking file (generated)

Commands

Generate Initial Files

"Generate indexing tracking files from GSC export and sitemap"

Pre-process False Positives

"Process false positives and update indexed list"

Update Submission Status

"Mark [URL] as submitted on [date]"

Refresh From New Export

"Update indexed list from new GSC export"

Generate Statistics

"Show indexing progress statistics"

Statistics Output

INDEXING STATUS SUMMARY
=======================

Indexed Public (GSC):     789 pages
Indexed With Lag:          12 pages
Total Indexed:            801 pages

Sitemap Total:          2,054 pages
To Index:               1,253 pages

Progress:                 39.0%

By Priority:
- Priority 1: 55 remaining (4 false positives moved)
- Priority 2: 7 remaining
- Priority 3: 290 remaining

Example Usage

User: "I just checked some URLs in GSC URL Inspection and marked them as false positive - indexed. Process those and update the tracking files."

Claude will:

1. Scan to-index.md for entries with "false positive - indexed"
2. Extract those URLs and their original detection dates
3. Add them to indexed.md Indexed With Lag table
4. Remove them from to-index.md
5. Update row numbers and counts
6. Report changes made