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 an HTML report. It does not convert a live MCP app report directly; if only an MCP app report exists, build a separate HTML delivery from the same canonical artifact evidence with $build-report's portable builder first.
Workflow
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.
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
Inspect local outputs.
Required outputs:
deck.pptx: editable local PowerPoint filemanifest.json: parsed source inventory and coverage countsdeck_plan.json: slide-by-slide plan with named elementspreflight_checks.json: local quality checks and pass/fail statusassets/: rendered chart images
Do not import the PPTX until preflight_checks.json has status: "passed".
Then run unzip -t <out-dir>/deck.pptx.
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.
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.
Hand off the deck.
Return the Google Slides URL and, when useful, the local PPTX path or source HTML path. Keep routine check, preflight, thumbnail-inspection, and import-check details in support artifacts. Do not list internal checks in the user-facing handoff unless a check failed, was unavailable, or produced a user-relevant caveat.
Standards
- Preserve the report's decision-critical information: headline claim,
executive summary, major findings, metric definitions, material charts,
decision-critical tables, recommendations, implications, caveats,
assumptions, freshness notes, and source/provenance notes.
- Translate report prose into slide-native communication. Lead with the takeaway, use one main idea per slide, and put supporting detail in concise callouts, bullets, tables, chart annotations, or speaker notes.
- Tighten copy before shrinking fonts.
- Keep gross metric reads, net/incremental reads, causal claims, and caveats visibly separated when the source report distinguishes those lenses.
- Use editable text and native PPTX tables wherever practical. Use native PPTX bullets; do not fake bullets with typed dashes.
- Preserve source charts as evidence images. Do not screenshot the whole HTML report or paste whole report sections.
- Support self-contained portable-builder reports whose native charts and builder-generated semantic chart-data representations remain available to the conversion helper; the helper renders faithful local chart evidence images before building the deck.
- Use one chart per evidence slide unless the report has a stronger grouped comparison.
- Keep table slides legible. If a full table is too dense, keep the main comparison in the deck and move extra detail to speaker notes or source slides.
- Source notes should be visible but quiet.
Visual System
The helper derives colors and hierarchy from the HTML report CSS and chart palette, then applies a restrained analytics deck layout. It does not follow external deck files or company-specific branding.
1---2name: report-to-google-slides3description: Narrow conversion skill. Invoke only when the user explicitly asks to convert an existing HTML analytics report into a native Google Slides deck.4---5
6# Report To Google Slides
7
8Use 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,
9caveats, and recommended follow-up without opening the source report.
10
11This skill consumes an HTML report. It does not convert a live MCP app report directly; if only an MCP app report exists, build a separate HTML delivery from the same canonical artifact evidence with `$build-report`'s portable builder first.
12
13## Workflow
14
151. Resolve the local HTML report.
16
17 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,
18 or very small stub, stop and obtain the real report before continuing.
19
202. Run the helper.
21
22 ```bash
23 python3 <REPORT_TO_GOOGLE_SLIDES_SKILL_DIR>/scripts/report_to_google_slides.py \
24 <LOCAL_HTML_REPORT_PATH> \
25 --out-dir /tmp/report_to_google_slides
26 ```
27
283. Inspect local outputs.
29
30 Required outputs:
31
32 - `deck.pptx`: editable local PowerPoint file
33 - `manifest.json`: parsed source inventory and coverage counts
34 - `deck_plan.json`: slide-by-slide plan with named elements
35 - `preflight_checks.json`: local quality checks and pass/fail status
36 - `assets/`: rendered chart images
37
38 Do not import the PPTX until `preflight_checks.json` has `status: "passed"`.
39 Then run `unzip -t <out-dir>/deck.pptx`.
40
414. Import and verify in Google Slides.
42
43 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,
44 and the caveats/sources slides.
45
465. Repair before handoff.
47
48 If thumbnails show clipped text, missing charts, low contrast, blank images,
49 or awkward sizing, revise the helper output or source assumptions and regenerate before handing off the deck URL.
50
516. Hand off the deck.
52
53 Return the Google Slides URL and, when useful, the local PPTX path or source HTML path. Keep routine check, preflight, thumbnail-inspection, and import-check details in support artifacts. Do not list internal checks in the user-facing handoff unless a check failed, was unavailable, or produced a user-relevant caveat.
54
55## Standards
56
57- Preserve the report's decision-critical information: headline claim,
58 executive summary, major findings, metric definitions, material charts,
59 decision-critical tables, recommendations, implications, caveats,
60 assumptions, freshness notes, and source/provenance notes.
61- Translate report prose into slide-native communication. Lead with the takeaway, use one main idea per slide, and put supporting detail in concise callouts, bullets, tables, chart annotations, or speaker notes.
62- Tighten copy before shrinking fonts.
63- Keep gross metric reads, net/incremental reads, causal claims, and caveats visibly separated when the source report distinguishes those lenses.
64- Use editable text and native PPTX tables wherever practical. Use native PPTX bullets; do not fake bullets with typed dashes.
65- Preserve source charts as evidence images. Do not screenshot the whole HTML report or paste whole report sections.
66- Support self-contained portable-builder reports whose native charts and builder-generated semantic chart-data representations remain available to the conversion helper; the helper renders faithful local chart evidence images before building the deck.
67- Use one chart per evidence slide unless the report has a stronger grouped comparison.
68- Keep table slides legible. If a full table is too dense, keep the main comparison in the deck and move extra detail to speaker notes or source slides.
69- Source notes should be visible but quiet.
70
71## Visual System
72
73The helper derives colors and hierarchy from the HTML report CSS and chart palette, then applies a restrained analytics deck layout. It does not follow external deck files or company-specific branding.
ahang1598