gi-pipeline-utils

name	gi-pipeline-utils
description	Utility automations for The Great Inversion asset pipeline. Use when Tim says "advance to approved," "move to review," "mark as published," "rename files," "fix filenames," "generate filename," "pipeline status," "weekly digest," "what needs attention," or wants tracker updates, naming convention enforcement, or a pipeline health summary. Handles stage transitions across all tracker tabs, auto-generates filenames from metadata, and produces weekly digests of pipeline state.
metadata	{"author":"Tim Dickey","version":"1.0","pipeline-step":"utility"}

GI Pipeline Utils

Three utility automations that support the entire GreatInvert Asset Pipeline.

When to Use This Skill

Use when Tim asks to:

• Move assets through stages (Draft, Review, Approved, Web-Ready, Published, Archived)
• Update the tracker after reviewing or approving assets
• Rename files to match the naming convention
• Generate a filename from metadata
• Check pipeline status or get a weekly digest
• Find out what needs attention this week

Automation 1: Tracker Updates (advance_stage.py)

Moves assets through pipeline stages and handles all side effects automatically.

Stage Transitions and Side Effects

Transition	What It Updates
Draft → Review	Sets Reviewer in Asset Register
Review → Approved	Sets QA_Status, validates filename
Approved → Web-Ready	Updates Stage (optimization done by gi-web-optimizer)
Web-Ready → Published	Sets Publish_Date, adds/updates Publishing Queue entry, sets status to Live
Published → Archived	Creates Archive/Learnings entry, marks queue as Archived

How to trigger

• Say: "Move AST-001 to Approved" or "Mark AST-005 as published"
• Say: "Advance AST-001,AST-002 to Review" with reviewer name

Usage

python scripts/advance_stage.py <tracker.xlsx> AST-001,AST-002 Approved \
  --reviewer "Tim" --qa-status "Pass" --alt-text "Hero image for homepage"

Options:

• --reviewer STR — Reviewer name
• --qa-status STR — Pass or Needs-Work
• --alt-text STR — Alt text for accessibility
• --url STR — Live URL (for Published stage)
• --notes STR — Add notes to the asset
• --dry-run — Preview without writing

Automation 2: Naming Convention Enforcement (build_filename.py)

Auto-generates filenames from asset metadata using the pattern: GI_[product]_[theme]_[type]_[channel]_[stage]_[yyyymmdd]_v01

How to trigger

• Say: "Fix filenames" or "Rename AST-003 to match the convention"
• Say: "Generate a filename for a playbook hero image"

Usage — from tracker metadata

python scripts/build_filename.py <tracker.xlsx> AST-001,AST-002  # preview
python scripts/build_filename.py <tracker.xlsx> AST-001,AST-002 --apply  # write

Usage — standalone generation

python scripts/build_filename.py --generate \
  --product playbook --theme ai-fluency --type hero \
  --channel home --stage approved

Validates against allowed values and warns on non-standard fields.

Automation 3: Weekly Digest (weekly_digest.py)

Scans the entire pipeline and produces a status summary.

What it checks

• Assets by stage (Draft, Review, Approved, Web-Ready, Published)
• Briefs pending approval
• Publishing Queue: scheduled vs live, overdue items, upcoming (14 days)
• Published assets due for performance review (7+ days live)
• Archive entries needing performance data

How to trigger

• Say: "Pipeline status" or "What needs attention?"
• Runs automatically every Monday morning as a scheduled task

Usage

python scripts/weekly_digest.py <tracker.xlsx>                    # print to stdout
python scripts/weekly_digest.py <tracker.xlsx> --output digest.md # save to file
python scripts/weekly_digest.py <tracker.xlsx> --json             # JSON output

Recurring Schedule

This skill includes a Monday morning recurring task that:

1. Downloads the latest tracker from Google Drive
2. Runs the digest scan
3. Sends Tim a notification with action items

Examples

Move assets through the pipeline:

"Move AST-003 and AST-004 to Approved — QA passed, reviewer is Tim"
"Mark AST-007 as published at https://greatinvert.com/blog/ai-fluency"

Fix filenames:

"Rename all draft assets to match the naming convention"
"Generate a filename for a playbook mockup for the product page"

Check pipeline:

"What's the pipeline status?"
"What needs attention this week?"