report-to-google-slides

Report To Google Slides

Use this skill only when the user explicitly has an existing HTML analytics report and wants a Google Slides deliverable. The output should be a deck, not a pasted report. A stakeholder skimming the slides should understand the answer, evidence, caveats, and recommended follow-up without opening the source report.

This skill consumes a local portable report, preferably self-contained HTML. If another format is the only source, first create an equivalent local HTML or structured report from the same evidence.

Workflow

1. Resolve the local HTML report.

   Use an absolute file path. If the user provides a remote report, retrieve it outside this skill first. If the local file is a sign-in page, redirect page, or very small stub, stop and obtain the real report before continuing.

2. Run the helper.

   python3 <REPORT_TO_GOOGLE_SLIDES_SKILL_DIR>/scripts/report_to_google_slides.py \
     <LOCAL_HTML_REPORT_PATH> \
     --out-dir /tmp/report_to_google_slides
   

3. Inspect local outputs.

   Required outputs:

   • deck.pptx: editable local PowerPoint file
   • manifest.json: parsed source inventory and coverage counts
   • deck_plan.json: slide-by-slide plan with named elements
   • preflight_checks.json: local quality checks and pass/fail status
   • assets/: rendered chart images

   Do not import the PPTX until preflight_checks.json has status: "passed". Then run unzip -t <out-dir>/deck.pptx.

4. Import and verify in Google Slides.

   Import deck.pptx with mcp__codex_apps__google_drive._import_presentation using upload_mode="native_google_slides". Verify the imported deck with _get_presentation_outline and _get_slide_thumbnail for every slide when possible. At minimum, inspect the cover, one chart slide, one table slide, and the caveats/sources slides.

5. Repair before handoff.

   If thumbnails show clipped text, missing charts, low contrast, blank images, or awkward sizing, revise the helper output or source assumptions and regenerate before handing off the deck URL.