chart-to-drive

Skill: Chart-to-Drive Uploader

Purpose

Standardized workflow for uploading local chart PNGs to Google Drive and making them available for insertion into Google Docs and Slides. One standard flow for upload, permissions, and URL construction, with no public file hosts involved.

When to Apply

Automatically whenever:

• Chart PNGs need to be inserted into Google Docs or Google Slides
• The google-doc-creator or google-slides-creator agent needs chart URLs
• User asks to "upload charts" or "add images to the doc/slides"
• User encounters "permission denied" or "image URL not accessible" errors when building Google Workspace documents — this usually means charts weren't uploaded to Drive first

When NOT to use this skill:

• For single-image uploads where you just need one Drive URL (use mcp__google-docs__upload_image_to_drive directly)
• When building Google Docs via the python-docx → upload workflow (that embeds images in the .docx file, no Drive URLs needed)

---

Workflow

Step 1: Collect chart files

Identify all chart PNGs that need uploading. Standard location: outputs/charts/.

import os
chart_dir = "outputs/charts"
charts = [(f, os.path.join(chart_dir, f)) for f in sorted(os.listdir(chart_dir)) if f.endswith('.png')]

Step 2: Upload each chart to Drive directly

Use the Google Docs MCP upload_image_to_drive tool with the LOCAL file path. It uploads straight to the user's Drive and sets just enough link access for the Docs/Slides APIs to fetch the image. No public file host is involved at any point; never route charts through one (the analysis may contain confidential numbers).

for each (filename, filepath) in charts:
    mcp__google-docs__upload_image_to_drive(image_path=filepath)
    # Returns the Drive file ID; record it in the chart map

If that tool is unavailable, upload with the Drive API from Python using local credentials (files().create with MediaFileUpload), then set reader link access.