Skip to main content

From a Google Sheet to a Google Slides infographic

The Fused Google Drive integration lets a UDF reach straight into your Drive — read any file, list any folder, write back, all with one OAuth grant. This example uses it to take a CSV sitting in Drive, render it as an editorial infographic with an AI image model, and drop the result as a new slide into an existing Google Slides deck. The same pattern works for any Drive file: Sheets, Docs, PDFs, images — once you're connected, it's all one filesystem.

Try it out​

Open the Fused Canvas →

Make a copy first

The Canvas references your own Google Drive and your own OpenRouter key, so fork it into your workspace before running: open the Canvas → click ⋮ → Make a copy, then work in your copy.

Two things to set up before you run
  • Connect Google Drive — Workbench → Integrations & Secrets → Google Drive → Connect, then use the Picker to grant access to the spreadsheet folder you want to read and the Slides decks you want to publish into. With the drive.file scope, Fused only sees files you explicitly grant — a deck won't appear in the picker on the last node until you've added it via the Picker.
  • Add an OpenRouter API key — get one from OpenRouter, then Workbench → Integrations & Secrets and add it as openrouter_api_key.

How the Canvas is organized​

The Canvas is organized in three parts, end-to-end: take the airline travel CSV sitting in Drive, turn it into an editorial infographic with an image model, and insert it as a new slide in your deck. Each part is a self-contained piece of the pipeline with its own widget — you walk through them top-to-bottom and the parameters flow forward automatically.

Part 1 · Pick data from Google Drive​

Lists every CSV / XLSX you've granted Drive access to and lets you pick one — the file streams straight into a pandas DataFrame, no intermediate copy. Built from a dropdown and a sql-table widget.

Part 2 · Generate the infographic​

Pick a style reference, type a title, click Generate. An image model on OpenRouter renders the chart in that style and the PNG is saved to your Drive. Built from a gallery-input for the style picker and a form so the generator only fires on submit.

Part 3 · Publish into a Google Slides deck​

Pick a deck, set the insert position, click Publish. A new slide lands in the deck with the title from Part 2 and the infographic as a full-bleed image, then an embedded preview renders right below the form. Built from a dropdown, a number-input, and a form.

"I don't see my deck in the dropdown"

Slides decks only appear in the picker once they've been explicitly granted via the Drive Picker. Open Integrations & Secrets → Google Drive → Picker and add the deck you want before refreshing the Part 3 widget.

Let Part 2 finish before clicking Publish

Part 2 sets a canvas parameter once the infographic preview renders. If you click Publish before the preview shows up, that parameter is still empty and the slide will land with just a title and no image. Wait for the infographic to appear, then publish.

Why Fused​

Wiring Drive, OpenRouter, and the Slides API together yourself usually means a separate script (probably a few of them), OAuth dance per service, somewhere to host it, and somewhere to host the generated PNG. On Fused, the three integrations are already connected, the UDFs run in the same managed environment, and the widgets give you the UI for free — no separate frontend, no intermediate storage, no glue server. Fork the Canvas, point it at your file, and you have a working tool.

See also​